Question: Please find the solution in excel Last month, Startup Manufacturing sold 5 5 cars of Type X for a price of $ 2 5 ,

Please find the solution in excel
Last month, Startup Manufacturing sold 55 cars of Type X for a price of $25,000 each, 30 cars of Type Y for a price of $35,000 each, and 12 cars of Type Z for a price of $50,000 each. The factory had 50 workers working 150 hours each and used a total of 70 tons of steel to manufacture both car types. The cost of labor was $25 per hour and the cost of steel was $650 per ton. a) What was the total revenue at Startup Manufacturing last month? b) Calculate the productivity of the labor input last month. c) Calculate the productivity of the steel input last month. d) Calculate the overall (multi-factor) productivity of both labor and steel at Startup Manufacturing last month. This month, Startup Manufacturing sold 58 cars of Type X for a price of $27,000 each, 45 cars of Type Y for a price of $33,000 each, and 15 cars of Type Z for a price of $53,000 each. The factory had 45 workers working 180 hours each and used a total of 100 tons of steel to manufacture both car types. This month, the cost of labor was $30 per hour and the cost of steel was $680 per ton. e) Calculate the overall (multi-factor) productivity of both labor and steel at Startup Manufacturing for this month. f) Find the percentage change in overall productivity at Startup Manufacturing.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!