Budget
Your CEO has asked you tooduction cost budget for the MiniY for May 20X8. The actual costs in April 20X8 were:cacacalculate find
MiniY: Production Cost Budget April 20X8 Production-Units 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,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: Using the above information, make a budget for May 20X8 stating the total cost. Use a spreadsheet to display your data and calculations.