Your 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 BudgetApril 20X8Production-Units of MiniY3,000Components cost (variable)24,000,000Labor cost (variable)13,500,000Rent (fixed)6,000,000Depreciation (fixed)6,000,000Other (fixed)2,000,000Total$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.

Before starting your calculations, review materials on integrating accounting and financial information.

Submit your Production Cost Budget Report and Calculations to the dropbox below. Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of company.