In: Accounting
Production and Purchases Budgets in Units
At the end of business on June 30, 2009, the Wooly Rug Company had
100,000 square yards of rugs and 400,000 pounds of raw materials on
hand. Budgeted sales for the third quarter of 2009 are:
Month | Sales |
---|---|
July | 220,000 sq. yards |
August | 160,000 sq. yards |
September | 150,000 sq. yards |
October | 160,000 sq. yards |
The Wooly Rug Company wants to have sufficient square yards of
finished product on hand at the end of each month to meet 40
percent of the following month's budgeted sales and sufficient
pounds of raw materials to meet 30 percent of the following month's
production requirements. Five pounds of raw materials are required
to produce one square yard of carpeting.
Prepare a production budget for the months of July, August, and
September and a purchases budget in units for the months of July
and August.
Wooly Rug
Company Production Budget For the Months of July, August, & September, 2009 |
|||
---|---|---|---|
July | August | September | |
Budgeted production - sq. yards | Answer | Answer | Answer |
Wooly Rug
Company Purchases Budget For the Months of July & August, 2009 |
||
---|---|---|
July | August | |
Purchases in pounds | Answer | Answer |
Wooly Rug Company | |||||||||
Production Budget | |||||||||
July | August | September | october | ||||||
budgeted sales | 220,000 | 160,000 | 150,000 | 160,000 | |||||
add:ending inventory | 64000 | 60000 | 64000 | ||||||
total needs | 284,000 | 220,000 | 214,000 | ||||||
less:Beginning inventory | 100,000 | 64,000 | 60,000 | ||||||
budgeted production -sq yards | 184,000 | 156,000 | 154,000 | answer | |||||
Purchase budget | |||||||||
July | August | September | |||||||
budgeted production-sq yards | 184,000 | 156,000 | 154,000 | ||||||
pounds required | 5 | 5 | 5 | ||||||
total pounds required | 920000 | 780000 | 770000 | ||||||
Add:Ending inventory | 234000 | 231000 | |||||||
total pounds required | 1154000 | 1011000 | |||||||
less:Beginning inventory | 400,000 | 234,000 | |||||||
purchases in pounds | 754,000 | 777,000 | answer | ||||||