Question

In: Accounting

Production Budget Palmgren Company produces consumer products. The sales budget for four months of the year...

Production Budget

Palmgren Company produces consumer products. The sales budget for four months of the year is presented below.

Unit Sales   Dollar Sales
July   31,000     $970,000
August   34,500     1,063,300
September   41,000     1,197,000
October   35,500     1,142,700
Company policy requires that ending inventories for each month be 25 percent of next month’s sales. At the beginning of July, the beginning inventory of consumer products met that policy.

Required:

Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.

Palmgren Company
Production Budget
For the Third Quarter
July   August   September   Total
Unit sales   fill in the blank 1
fill in the blank 2
fill in the blank 3
fill in the blank 4

fill in the blank 6
fill in the blank 7
fill in the blank 8
fill in the blank 9
Total needed   fill in the blank 10
fill in the blank 11
fill in the blank 12
fill in the blank 13

fill in the blank 15
fill in the blank 16
fill in the blank 17
fill in the blank 18
Units produced   fill in the blank 19
fill in the blank 20
fill in the blank 21
fill in the blank 22


Solutions

Expert Solution

ANSWER:

As per the company polcy the ending inventory for each month is 25% of next month's sale

So as ending inventory of june is the same as begining inventory of july

July sales units = 31000 units

July begining inventory = 31000 units*25% = 7750 units

July ending inventory = August sales units*25% = 34500 units*25% = 8625 units

So Required production units for july = July sales units+July ending inventory = 31000 units+8625 units = 39625 units

  • So units to be produced for july = Required production units for july-July begining inventory = 39625 units-7750 units = 31875 units

July ending inventory is the same as august begining inventory

August sales units = 34500 units

August begining inventory = 8625 units

August ending inventory = September sales units*25% = 41000 units*25% = 10250 units

So Required production units for August = August sales units+August ending inventory = 34500 units+10250 units = 44750 units

  • So units to be produced for August = Required production units forAugust-August begining inventory = 44750 units-8625 units = 36125 units

August ending inventory is the same as September begining inventory

September sales units = 41000 units

September begining inventory = 10250 units

September ending inventory = October sales units*25% =35500 units*25% = 8875 units

So Required production units for September = September sales units+September ending inventory = 41000 units+8875 units = 49875 units

  • So units to be produced for September = Required production units for September-September begining inventory = 49875 units-10250 units = 39625 units

Total units to be produced for the quarter = units to be produced for September+units to be produced for August+units to be produced for july = 39625 units+36125 units+31875 units = 107625 units

Production budget for palmgren company
JULY    August    September    3rd QUARTER
A Sales units 31000 34500 41000 106500
B Ending inventory units 8625 10250 8875
C Required production units(A+B) 39625 44750 49875
D Begining inventory 7750 8625 10250
E Units to be produced(C-D) 31875 36125 39625 107625

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

1) A) Marlow Company produces hand tools. A production budget for the next four months is...
1) A) Marlow Company produces hand tools. A production budget for the next four months is as follows: March 10,900 units, April 14,065, May 16,800, and June 21,200. Marlow Company’s ending finished goods inventory policy is 15% of the following month’s sales. Marlow plans to sell 16,700 units in May. What is budgeted ending inventory for March? 2,110 1,635 2,520 2,040 B) Jared Inc. produces leather handbags. The sales budget for the next four months is: July 5,500 units, August...
26. Kenner Company produces two products: SR200 and TX500. Budgeted sales for four months are as...
26. Kenner Company produces two products: SR200 and TX500. Budgeted sales for four months are as follows: ​ SR200 TX500 May 8,000 20,000 June 13,000 32,000 July 11,000 39,000 August 18,000 46,000 ​ Kenner's ending inventory policy is that SR200 should have 15% of next month's sales in ending inventory and TX500 should have 40% of next month's sales in ending inventory. On May 1, there were 1,200 units of SR200 and 9,000 units of TX500. TX500 requires 6 units...
Jaybird Inc. produces leather handbags. The sales budget for the next four months is: July 5,600...
Jaybird Inc. produces leather handbags. The sales budget for the next four months is: July 5,600 units, August 7,800, September 8,300, October 8,100. Jaybird Inc.’s ending finished goods inventory policy is 10% of the following month’s sales. Each handbag requires 1.6 hours of unskilled labor (paid $15 per hour) and 2.2 hours of skilled labor (paid $22 per hour). What will be the total labor cost for the month of August? Multiple Choice $568,340 $29,830 $566,170 $488,050
Jaybird Inc. produces leather handbags. The sales budget for the next four months is: July 5,600...
Jaybird Inc. produces leather handbags. The sales budget for the next four months is: July 5,600 units, August 7,800, September 8,300, October 8,100. Jaybird Inc.’s ending finished goods inventory policy is 10% of the following month’s sales. Each handbag requires 1.6 hours of unskilled labor (paid $15 per hour) and 2.2 hours of skilled labor (paid $22 per hour). What will be the total labor cost for the month of August? $488,050 $568,340 $29,830 $566,170
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
The controller of X Company estimates sales and production for the first four months of 2016...
The controller of X Company estimates sales and production for the first four months of 2016 as follows: January February March April Sales $30,200 $39,000 $55,000 $25,900 Production in units 1,010 1,670 2,140 2,510 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct material to produce a finished unit, and...
Varney Company makes rolling suitcases. Its sales budget for four months is: Sales Month                           &nbs
Varney Company makes rolling suitcases. Its sales budget for four months is: Sales Month                                                                  R March                                                              15,000 April                                                                20,000 May                                                                40,000 June                                                               60,000 Varney's policy is that ending inventory of finished suitcases should equal 30% of the next month's sales. Beginning inventory (March 1) is 5,300 suitcases. Each suitcase required 1.5 meters of ballistic nylon. The ending inventory policy for nylon is that 20% of the following month's production needs must be on hand. On March 1, Varney had 10,450...
Varney Company makes rolling suitcases. Its sales budget for four months is:                              &nb
Varney Company makes rolling suitcases. Its sales budget for four months is:                                                                      Sales                      Month                                                                        R                       March                                         15,000                       April                                         20,000                        May                                          40,000                       June                                          60,000 Varney's policy is that ending inventory of finished suitcases should equal 30% of the next month's sales. Beginning inventory (March 1) is 5,300 suitcases. Each suitcase required 1.5 meters of ballistic nylon. The ending inventory policy for nylon is that 20% of the following month's production needs must be on...
Question 33 The controller of Harrington Company estimates sales and production for the first four months...
Question 33 The controller of Harrington Company estimates sales and production for the first four months of 2020 as follows: January February March April Sales $29,300 $38,600 $54,400 $24,200 Production in units 1,100 1,600 2,000 2,700 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct materials to produce a finished...
 National Beverage Company produces its products two months in advance of anticipated sales and ships to...
 National Beverage Company produces its products two months in advance of anticipated sales and ships to warehouse centers the month before sale. The inventory safety stock is 12 % of the anticipated​ month's sale. Beginning inventory in October 2014 was 269,252 units. Each unit costs ​$0.29 to make. The average selling price is $ 0.71 per unit. The cost is made up of 43 % ​labor, 49 % ​materials, and 8 % shipping​ (to the​ warehouse). The company pays for...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT