Can someone help me solve this?
Langer Company produces plastic items, including plastic housings for humidifiers. Each housing requires about 15 ounces of plastic costing $0.08 per ounce. Langer molds the plastic into the proper shape. Langer has budgeted production of the housings for the next 4 months as follows:
| Units | |
| July | 3,500 |
| August | 4,400 |
| September | 4,900 |
| October | 6,300 |
Inventory policy requires that sufficient plastic be in ending monthly inventory to satisfy 30% of the following month's production needs. The inventory of plastic at the beginning of July equals exactly the amount needed to satisfy the inventory policy.
Required:
Prepare a direct materials purchases budget for July, August, and September, showing purchases in units and in dollars for each month and in total. If required, round the total purchase cost to nearest whole value.
| Langer Company | ||||
| Direct Materials Purchases Budget | ||||
| For July, August and September | ||||
| July | August | September | Total | |
| Units to be produced | ||||
| Direct materials per unit (ounces) | ||||
| Production needs | ||||
| Desired ending inventory (ounces) | ||||
| Total needs | ||||
| Less: Beginning inventory | ||||
| Direct materials to be purchased (ounces) | ||||
| Cost per ounce | $0.08 | $0.08 | $0.08 | $0.08 |
| Total purchase cost | $ | $ | $ | $ |
Answer
|
Langer Company |
|||||
|
Direct Materials Purchases Budget |
|||||
|
For July, August and September |
|||||
|
July |
August |
September |
Total |
||
|
A |
Units to be produced |
3,500 |
4,400 |
4,900 |
12,800 |
|
B |
Direct materials per unit (ounces) |
15 |
15 |
15 |
15 |
|
C = A x B |
Production needs |
52,500 |
66,000 |
73,500 |
192,000 |
|
D = 30% of next month's 'C' |
Desired ending inventory (ounces) |
19,800 |
22,050 |
28,350 [6300 x 15 x 30%] |
28,350 |
|
E = C+D |
Total needs |
72,300 |
88,050 |
101,850 |
220,350 |
|
F |
Less: Beginning inventory |
15,750 [52500 x 30%] |
19,800 |
22,050 |
15,750 |
|
G = E - F |
Direct materials to be purchased (ounces) |
56,550 |
68,250 |
79,800 |
204,600 |
|
H |
Cost per ounce |
$0.08 |
$0.08 |
$0.08 |
$0.08 |
|
I = G x H |
Total purchase cost |
$4,524 |
$5,460 |
$6,384 |
$16,368 |
Can someone help me solve this? Langer Company produces plastic items, including plastic housings for humidifiers....
Direct Materials Purchases Budget Langer Company produces plastic items, including plastic housings for humidifiers. Each housing requires about 21 ounces of plastic costing $0.08 per ounce Langer molds the plastic into the proper shape. Langer has budgeted production of the housings for the next 4 months as follows: Units July 3,500 August 4,400 September 4,900 October 6,300 Inventory policy requires that sufficient plastic be in ending monthly inventory to satisfy 30% of the following month's production needs. The inventory of...
Direct Materials Purchases Budget: Direct Labor Budget Crescent Company produces stuffed toy animals; one of these is "Arabeau the Cow." Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs $3.50 per yard and polyfiberfill is $0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows Units 42,000 90,000 50,000 40,000 October November December anuary Inventory policy requires that sufficient fabric be in ending monthly...
Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 40,000 72,000 February 45,000 81,000 March 60,000 108,000 April 42,000 75,600 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is...
Production Budget and Direct Materials Purchases Budgets Peanut-Fresh Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 48,000 100,800 February 46,000 96,600 March 55,000 121,000 April 58,000 125,200 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is 14,500...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,200, 12,000, 14,000, and 15,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
Please help finding:
d. Direct materials purchases budget for July (in pounds).
e. Direct materials purchases budget for July (in dollars).
Thank you!
Hansell Company's management wants to prepare budgets for one of its products, Duraflex, for July 2019. The firm sells the product for $93 per unit and has the following expected sales (In units) for these months in 2019: Apr May 6,709 May June 6.8ee June July August 9,608 August September September 3,700 8 ,608 The production process...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,200, 12,000, 14,000, and 15,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
Managerial Accounting
Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products, Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. b. The finished goods...
Answer in excel
Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
The Bakery on the Riverbank produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $3.00 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four months: E(Click the icon to view the units to be produced.) The bakery has a policy that it will have 20% of the following month's flour needs...