Question

In: Finance

Production and Purchases Budgets At the beginning of October, Comfy Cushions had 2,000 cushions and 12,500...

Production and Purchases Budgets
At the beginning of October, Comfy Cushions had 2,000 cushions and 12,500 pounds of raw materials on hand. Budgeted sales for the next three months are:

Month Sales
October 10,000 cushions
November 12,000 cushions
December 15,000 cushions

Comfy Cushions wants to have sufficient raw materials on hand at the end of each month to meet 25 percent of the following month's production requirements and sufficient cushions on hand at the end of each month to meet 20 percent of the following month's budgeted sales. Five pounds of raw materials, at a standard cost of $0.90 per pound, are required to produce each cushion.

Required
a. Prepare a production budget for October and November.
Do not use a negative sign with your answers.

Comfy Cushions
Production Budget
For the Months of October and November
October November December
Unit Sales Answer Answer Answer
Desired ending inventory Answer Answer
Finished goods requirements Answer Answer
Less beginning inventory Answer Answer
Production requirements Answer Answer

b. Prepare a purchases budget for raw materials in units and dollars for October.
Do not use a negative sign with your answers.

Comfy Cushions
Purchases Budget
For the Month of October
October November
Production requirements Answer Answer
Desired ending inventory Answer
Raw materials requirements Answer
Less beginning inventory Answer
Purchase requirements (units) Answer
Purchase requirements (in dollars) Answer

Solutions

Expert Solution

Comfy Cushions
Production Budget
For the Months of October and November
October November December
Unit Sales         10,000         12,000        15,000
Desired ending inventory           2,400           3,000
Finished goods requirements         12,400         15,000
Less beginning inventory           2,000           2,400
Production requirements         10,400         12,600

Comfy Cushions

Purchases Budget
For the Month of October
October November
Production requirements         52,000         63,000
Desired ending inventory         15,750
Raw materials requirements         67,750
Less beginning inventory         12,500
Purchase requirements (units)         55,250
Purchase requirements (in dollars)         49,725

Related Solutions

Production and Purchases Budgets in Units At the end of business on June 30, 2009, the...
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...
Department G had 2,160 units 25% completed at the beginning of the period, 12,500 units were...
Department G had 2,160 units 25% completed at the beginning of the period, 12,500 units were completed during the period, 1,800 units were 20% completed at the end of the period, and the following manufacturing costs debited to the departmental work in process account during the period: Work in process, beginning of period $27,200 Costs added during period:    Direct materials (12,140 units at $9) 109,260    Direct labor 76,200    Factory overhead 25,400 All direct materials are placed in process at the...
Department G had 2,040 units 25% completed at the beginning of the period, 12,500 units were...
Department G had 2,040 units 25% completed at the beginning of the period, 12,500 units were completed during the period, 1,700 units were 20% completed at the end of the period, and the following manufacturing costs debited to the departmental work in process account during the period: Work in process, beginning of period $30,300 Costs added during period:   Direct materials (12,160 units at $8) 97,280   Direct labor 78,600   Factory overhead 26,200 All direct materials are placed in process at the...
Department G had 2,280 units 25% completed at the beginning of the period, 12,500 units were...
Department G had 2,280 units 25% completed at the beginning of the period, 12,500 units were completed during the period, 1,900 units were 20% completed at the end of the period, and the following manufacturing costs debited to the departmental work in process account during the period: Work in process, beginning of period $31,400 Costs added during period: Direct materials (12,120 units at $9) 109,080 Direct labor 75,000 Factory overhead 25,000 All direct materials are placed in process at the...
Department G had 2,040 units 25% completed at the beginning of the period, 12,500 units were...
Department G had 2,040 units 25% completed at the beginning of the period, 12,500 units were completed during the period, 1,700 units were 20% completed at the end of the period, and the following manufacturing costs debited to the departmental work in process account during the period: Work in process, beginning of period $34,900 Costs added during period: Direct materials (12,160 units at $9) 109,440 Direct labor 72,000 Factory overhead 24,000 All direct materials are placed in process at the...
Sales, production, purchases, and cash budgets Freese, Inc., is in the process of preparing the fourth...
Sales, production, purchases, and cash budgets Freese, Inc., is in the process of preparing the fourth quarter budget for 2013, and the following data have been assembled: Problem 14.23 LO 4, 5, 8 The company sells a single product at a price of $60 per unit. The estimated sales volume for the next six months is as follows: September ................................................................13,000 units October .....................................................................12,000 units November...................................................................14,000 units December...................................................................20,000 units January........................................................................9,000 units February.....................................................................10,000 units All sales are on account. The company's collection...
Sales, production purchases, and cash budgets Freese, Inc., is in the process of preparing the fourth...
Sales, production purchases, and cash budgets Freese, Inc., is in the process of preparing the fourth quarter budget for 2013, and the following data have been assembled: • The company sells a single product at a price of $60 per unit. The estimated sales volume for the next six months is as follows: Problem 14.24 LO 4, 5, 8 September. ..................................13,000 units October. ..................................12,000 units November. ..................................14,000 units December. ..................................20,000 units January. ..................................9,000 units February. ..................................10,000 uhits All sales are...
Production of Product B has been budgeted at 2,000, 1,800, 1,600, and 1,700 units for October,...
Production of Product B has been budgeted at 2,000, 1,800, 1,600, and 1,700 units for October, November, December, and January, respectively. One unit of Product B requires 2 pounds of raw material at $5 per pound. Required ending inventory for raw materials is 25% of the next month's demand. Raw material inventory at 9/30 is 1,000 pounds. 70% of material purchases is paid in the month of purchase, with the remaining 30% paid in the month after purchase. The A/P...
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $245,000 and...
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $210,000 July $ 126,000 June 224,000 August 112,000 September 140,000 October 168,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...
Purchases and Cash Budgets On July 1, ABC Wholesalers had a cash balance of $87,500 and...
Purchases and Cash Budgets On July 1, ABC Wholesalers had a cash balance of $87,500 and accounts payable of $49,500. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales May $75000 June 80,000 Month Budgeted Sales July $45,000 August 40,000 September 50,000 October 60,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT