In: Accounting
Blue DevilCorporation manufactures and sells wireless keyboards. Expected sales of keyboardsfor upcoming months are as follows:March50,000April55,000May60,000June52,000July58,000November37,000December39,000Management likes to maintain a finished goods inventory equal to 20% of the next month's estimated sales.Required:Prepare the company'sproduction budget for the secondquarter of this year. Include a column for each month and a total column for the entire quarter.
CALUCLATION OF PRODUCTION BUDGET | |||||||
Units | March | April | May | June | July | Total of April , May & June | |
Sales in Units | Units | $ 50,000 | $ 55,000 | $ 60,000 | $ 52,000 | $ 58,000 | $ 1,67,000 |
Add : Fininshed Goods Inventory to be maintain 20% of next month Sales | Units | $ 11,000 | $ 12,000 | $ 10,400 | $ 11,600 | $ 34,000 | |
Less: Opening Stock | $ 11,000 | $ 12,000 | $ 10,400 | $ 33,400 | |||
PRODUCTION BUDGETS FOR APR , MAY & JUNE | $ 56,000 | $ 58,400 | $ 53,200 | $ 1,67,600 | |||