作业帮 > 综合 > 作业

用excel画图Cut Throat Airlines are considering providing a new

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/11/08 10:57:27
用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(>_
这个不难啊, 我作出来了. 需要的话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个的时候,是否亏损   答案 是亏损的,从图表中可以看出亏损额 图表如图