Question

In: Accounting

Exercise 10-7 Lawn Industrial has estimated that production for the next five quarters will be: Production...

Exercise 10-7

Lawn Industrial has estimated that production for the next five quarters will be:

Production Information
1st quarter, 2017 42,000 units
2nd quarter, 2017 38,000 units
3rd quarter, 2017 45,000 units
4th quarter, 2017 37,000 units
1st quarter, 2018 44,000 units


Finished units of production require 6 pounds of raw material per unit. The raw material cost is $5 per pound. There is $214,200 of raw material on hand at the beginning of the first quarter, 2017. Lawn desires to have 17 percent of next quarter's material requirements on hand at the end of each quarter.

Prepare quarterly direct materials purchases budgets for Lawn Industrial for 2017.

Lawn Industrial
Direct Materials Purchases Budget
For the Year Ending December 31, 2017

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Year

Total material neededCost of raw material needed for productionUnits to be producedCost of raw material per unitDesired ending inventory of raw materialBeginning inventory of raw materialRequired raw material purchases

Cost of raw material needed for productionDesired ending inventory of raw materialCost of raw material per unitTotal material neededBeginning inventory of raw materialRequired raw material purchasesUnits to be produced

$ $ $ $ $

Cost of raw material needed for productionCost of raw material per unitDesired ending inventory of raw materialUnits to be producedTotal material neededBeginning inventory of raw materialRequired raw material purchases

AddLess

:

Desired ending inventory of raw materialRequired raw material purchasesTotal material neededBeginning inventory of raw materialCost of raw material per unitCost of raw material needed for productionUnits to be produced

Total material neededCost of raw material per unitDesired ending inventory of raw materialUnits to be producedBeginning inventory of raw materialRequired raw material purchasesCost of raw material needed for production

AddLess

:

Cost of raw material per unitCost of raw material needed for productionBeginning inventory of raw materialTotal material neededRequired raw material purchasesUnits to be producedDesired ending inventory of raw material

Beginning inventory of raw materialCost of raw material needed for productionRequired raw material purchasesUnits to be producedCost of raw material per unitDesired ending inventory of raw materialTotal material needed

$ $ $ $ $

Solutions

Expert Solution


Related Solutions

Marshall Industrial has estimated that production for the next 5 quarters will be: Production Information Quarter...
Marshall Industrial has estimated that production for the next 5 quarters will be: Production Information Quarter 1, 2017-------------------------------------------- 51,000 units Quarter 2, 2017-------------------------------------------- 46,000 Quarter 3, 2017-------------------------------------------- 55,000 Quarter 4, 2017-------------------------------------------- 43,000 Quarter 1, 2018-------------------------------------------- 53,000 Finished units of production require 7 lbs of raw material per unit. The raw material cost is $8.00 per lb. There is $428,400 of raw material on hand at the beginning of the first quarter, 2017. Marshall desires to have 15 percent of next...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 190 $ 210 $ 230 $ 260 Sales for the first quarter of the year after this one are projected at $205 million. Accounts receivable at the beginning of the year were $81 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 145 $ 165 $ 185 $ 215    Sales for the first quarter of the year after this one are projected at $160 million. Accounts receivable at the beginning of the year were $63 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecasted sales, and...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 105 $ 125 $ 145 $ 175 Sales for the first quarter of the following year are projected at $120 million. Accounts receivable at the beginning of the year were $47 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers are normally...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 180 $ 200 $ 220 $ 250 Sales for the first quarter of the year after this one are projected at $195 million. Accounts receivable at the beginning of the year were $77 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecasted sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 175 $ 195 $ 215 $ 245 Sales for the first quarter of the year after this one are projected at $190 million. Accounts receivable at the beginning of the year were $75 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 170 $ 190 $ 210 $ 240    Sales for the first quarter of the year after this one are projected at $185 million. Accounts receivable at the beginning of the year were $73 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecasted sales, and...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 100 $ 120 $ 140 $ 170 Sales for the first quarter of the year after this one are projected at $115 million. Accounts receivable at the beginning of the year were $45 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 40 percent of the next quarter’s forecast sales, and suppliers...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters as follows: (40 ptos) Q1 Q2 Q3 Q4 Sales $105 $90 $122 $140 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $34 million. Wiggles, has a 45-day collection period. Wiggle’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales,...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 170 $ 185 $ 200 $ 225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT