our CEO has asked you to prepare a production cost budget for the MiniY for May 20X8. The actual costs in April 20X8 were:

MiniY: Production Cost Budget
April 20X8
ProductionUnits of MiniY	3,000
Components cost (variable)	24,000,000
Labor cost (variable)	13,500,000
Rent (fixed)	6,000,000
Depreciation (fixed)	6,000,000
Other (fixed)	2,000,000
Total	$51,500,000

For the month of May, the number of MiniY produced will increase to 3,200, reflecting an anticipated sales increase related to a new marketing campaign.

Question 5: Using the above information, prepare a budget for May 20X8 stating the total cost. Use a spreadsheet to display your data and calculations.