Please answer this problem step by step, in excel preferably

10. MODUCHOUBO proming to upgrade to machinery to reduce in maternitur con committee has studied the costs and benefits of the upgradation. The following information is available for its are structure of revenue and costs. No of units produced & Sold: 40000 units, selling price is $350 per unit Direct Material cost: $80 per unit Direct Labor cost: 40 workers; each worker works for 2700 hours per year; rate per hour is $21 Marketing Costs: $3.25million per year Administration Costs: $0.80 million per year The following information is related to the upgradation of machinery a) reduce the material cost per unit by 10% b) reduce the number of workers to 33 c) reduce the labour hours by 15% d) reduce the labour cost per hour by 15% e) Proposed Technology upgradation costs: $170,000 which is to be expensed in the same financial year f) The firms Needs the services of a consultant to install the machinery, which costs $20,000 Required: Present a report showing the costs and benefits of upgradation. (15) Q1b.Ease My Flying offers to airline ticketing services through its portal Easemyflying.com. It books passengers on De Airlines at $1500 per round-trip ticket Delta paid Ease my Flying a commission of 20% of the ticket price pf Chat No passenger. This commission was only source of revenue for Ease My Flying. It's fixed costs are $60,000 pe salaries, rent, and so on), and its variable costs, such as sales commissions and bonuses, are $32 per ticket purchas