tep 5: Budget
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 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,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.
Categories: