Question

At the beginning of September, L Company had 1,600 finished goods units. Budgeted sales for October,...

At the beginning of September, L Company had 1,600 finished goods units. Budgeted sales for October, November, December, and January are 8,400 units and 10,200 units and 13,600 units and 7,400 units respectively. L Company wants to have sufficient units on hand at the end of each month to meet 20 percent of the following month’s budgeted sales. Prepare a Production Budget with columns for October, November, December and Total 4th Quarter.

Homework Answers

Answer #1
PRODUCTION BUDGET
Particulars October November December Total
Sales (A) 8,400 10,200 13,600 32,200
Planning ending units (B) 2,040 2,720 1,480 6,240
Total production required (A+B) 10,440 12,920 15,080 38,440
Beginning inventory (C) ( $ 1,600) ( $ 2,040) ( $ 2,720) ( $ 6,360)
Units to be produced(A+B-C) $ 8,840 $ 10,880 $ 12,360 $ 32,080

Here, the ending units of December is got by multiplying sales units of January with 20%.

Ending units of December = 7,400 x 20%

Ending units of December = 1,480.

SUMMARY:

All requirements have been provided.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,800 units;...
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,800 units; October, 4,000 units; November, 6,800 units; and December, 7,800 units. The company’s policy is to maintain finished goods inventory equal to 70% of the next month’s sales. At the end of August, the company had 2,300 finished units on hand. Prepare a production budget for each of the months of September, October, and November.
Lea Company produces hand tools. Budgeted sales for March are 10,600 units. Beginning finished goods inventory...
Lea Company produces hand tools. Budgeted sales for March are 10,600 units. Beginning finished goods inventory in March is budgeted to be 1,700 units, and ending finished goods inventory is budgeted to be 1,600 units. How many units will be produced in March? 10,700 10,600 10,500 13,900
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000...
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000 units October 60,000 units November 40,000 units December 75,000 units The company wishes to have 10% of the next month’s sales on hand at the end of each month. How much is budgeted production for November? A) 43,500 units B) 40,000 units C) 47,500 units D) 36,000 units 2) SalaRita’s sales are 32% cash and 68% credit. Of the credit sales, 40% of credit...
Production and Purchases Budgets At the beginning of October, Comfy Cushions had 2,200 cushions and 13,500...
Production and Purchases Budgets At the beginning of October, Comfy Cushions had 2,200 cushions and 13,500 pounds of raw materials on hand. Budgeted sales for the next three months are: Month Sales October 11,000 Cushions November 13,000 Cushions December 16,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...
Production and Purchases Budgets At the beginning of October, Comfy Cushions had 2,200 cushions and 13,500...
Production and Purchases Budgets At the beginning of October, Comfy Cushions had 2,200 cushions and 13,500 pounds of raw materials on hand. Budgeted sales for the next three months are: Month Sales October 11,000 cushions November 13,000 cushions December 16,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...
Exercise 20-10 Manufacturing: Production budget LO P1 Blue Wave Co. predicts the following unit sales for...
Exercise 20-10 Manufacturing: Production budget LO P1 Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,000 units; October, 4,200 units; November, 6,400 units; and December, 8,300 units. The company’s policy is to maintain finished goods inventory equal to 60% of the next month’s sales. At the end of August, the company had 2,400 finished units on hand. Prepare a production budget for each of the months of September, October, and November.
Bear Corp. sells its product for $100. Forecasted sales are 1,500 units in October, 1,600 in...
Bear Corp. sells its product for $100. Forecasted sales are 1,500 units in October, 1,600 in November, and 1,600 in December. Variable costs are based on sales, and consist of commissions (5% of sales), advertising (4%) and shipping (4%). Fixed costs per month are $3,900 sales salaries, $3,100 office salaries, $2,200 depreciation, $2,300 office rent, $1,000 insurance and $1,000 utilities. Required: Prepare Bear Corp’s selling and administrative expense budget for the period October through December. Present monthly totals as well...
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October...
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October 400,000 November 350,000 December 410,000 Historically, the cash collection of sales have been as follows: 65 percent in month of sale 25 percent in month following sale 8 percent in second month following sale 2 percent uncollectible The company allows a 2 percent cash discount for payments made by customers during the month of the sale. July and August sales were $405,000 and $275,000,...
A company manufactures product X. The company requires 8 pounds of raw material to produce each...
A company manufactures product X. The company requires 8 pounds of raw material to produce each unit of X. The company expects sales as follows: October 15,000 units, November 28,000 units, December 49,000 units, January 9,000 units, and February 7,000 units. The company has 4,200 pounds of raw materials and 4,000 units of finished goods on hand at the end of September. The company’s accounting policies require the company to have 10% of the next month’s sales and 25% of...
has budgeted sales and production over the next quarter as follows: July August September Sales in...
has budgeted sales and production over the next quarter as follows: July August September Sales in units 46,000 58,000 ? Production in units 46,600 58,300 62,650 The company has 5,200 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 77,500 units. Budgeted sales for September would be (in units): Multiple Choice 68,450 61,000 70,000 70,400