用excel画图Cut Throat Airlines are considering providing a new daily service between two cities.The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passengers.In addition

用excel画图Cut Throat Airlines are considering providing a new daily service between two cities.The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passengers.In addition
用excel画图
Cut Throat Airlines are considering providing a new daily service between two cities.The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passengers.In addition,a cost is also incurred of $75 per passenger to cover such things as catering,booking,baggage handling.
The company is thinking of charging $225 per ticket.
• How many passengers will the airline need on each flight to break even?
• Find the break-even point algebraically
• Illustrate it using an EXCEL graph.Attach the printout or copy your EXCEL graph into your assignment submission.
• Based on your analysis,will Cut Throat realise a profit or a loss if 160 seats are sold for a particular flight?Explain briefly.
EXCEL Instructions:Ensure your chart range for passengers is from 0 to 200 in increments of 25.Make sure that your graph has been labeled appropriately (i.e.title,axis labels,legend).
明天就要交assignment了.能帮忙的留下Q号吧万分感谢
同志们.我还有半个小时熄灯.教我怎么做不直接给我答案也行啊.明天10点以前啊啊~o(>_

用excel画图Cut Throat Airlines are considering providing a new daily service between two cities.The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passengers.In addition

这个不难啊, 我作出来了. 需要的话HI我, 不比初中的难啊

成本 y=27000+75x

收入 y=225x       只不过要  在excel上 以25为单位  填写数据,

in increments of 25

另外 注意标题   说明  坐标轴 等等.Make sure that your graph has been labeled appropriately (i.e. title, axis labels, legend).

5分钟的事情 

然后分析 160个的时候,是否亏损   答案 是亏损的,从图表中可以看出亏损额 

图表如图