Question

In aggregate production planning, given the following:         BEGINNING     PLANNED       EXPECTED   ENDING MONTH   INVENTORY (units)...

In aggregate production planning, given the following:

        BEGINNING     PLANNED       EXPECTED   ENDING

MONTH   INVENTORY (units) PRODUCTION (units)     DEMAND (units)   INVENTORY (units)

Jan.    0    150 95

Feb.      150 175

Mar.        150    140

Based on these information, what is the ending inventory (in units) at the end of February?

Homework Answers

Answer #1

Beginning inventory for any period is the ending inventory for previous period

Ending inventory for any period can be calculated by following method

Ending inventory for the period = Beginning Inventory + Planned Production – expected demand

Month

Beginning Inventory (Units)

Planned Production (Units)

Expected Demand (Units)

Ending Inventory (units)

Jan

0

150

95

55

Feb

55

150

175

30

Mar

30

150

140

40

Therefore the ending inventory (in units) at the end of February is 30 units

Formulas used in Excel Calculation:

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
Given the following information: Beginning Inventory 1,400 Units Required Ending Inventory 1,700 Units Budgeted Production 2,600...
Given the following information: Beginning Inventory 1,400 Units Required Ending Inventory 1,700 Units Budgeted Production 2,600 Units What is the projected sales, in units?
What is aggregate planning? In the sample aggregate planning problem, change "for fudge for the next...
What is aggregate planning? In the sample aggregate planning problem, change "for fudge for the next four months is 120, 150, 100, and 70 pounds," to "130, 150, 110, and 60 pounds." Carry out the rest of the solution, with changed numbers, making sure, you follow the procedure used for "Level Strategy." The forecasted demand for fudge for the next four months is 120, 150, 100, and 70 pounds. a.     What is the recommended production rate if a level strategy...
Splash LLC Company has the following information for next month: Planned sales of 28,000 units and...
Splash LLC Company has the following information for next month: Planned sales of 28,000 units and planned production of 25,000 units which require 3 gallons of Material A each; beginning inventory of Material A of 4,400 gallons; desired ending inventory of Material A of 5,400 gallons. How much material A needs to be purchased? 76,000 gallons 85,000 gallons 74,000 gallons 75,000 gallons
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months...
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months is 13,400 units, and desired ending inventory level at the end of the 12th month is 1,000 units, what is the cost of production per month if a level strategy is used  and per unit cost of production is $32? (round to the nearest integer)
COST ACCOUNTING: (I) Maynard Inc. manufactures desks. The following data was given for production in February:...
COST ACCOUNTING: (I) Maynard Inc. manufactures desks. The following data was given for production in February: units, beginning work in process 0 units started 200 units completed ? units, ending work in process (30% complete) 50 What are the equivalent units? a) 170 b) 150 c) 180 d) 165 (II) Rina’s company has a sales budget for next month of $150,000. Cost of goods sold is expected to be 40% of sales. All goods are purchases in the month used...
Wormwood, LTD produces a variety of furniture products. The planning committee wants to produce an aggregate...
Wormwood, LTD produces a variety of furniture products. The planning committee wants to produce an aggregate plan for the next 6 months. Complete the spreadsheet cells colored in blue. Month 1 2 3 4 5 6 Demand 160 150 160 180 170 140 Demand Units Capacity Cost Per Unit Regular 150 150 150 150 160 160 Regular Units $50 Max Overtime 10 10 10 10 10 Overtime Units $75 Max Subcontract 10 10 10 10 10 10 Subcontract Units $80...
Calculate cost of goods sold and ending inventory under each of the following methods given the...
Calculate cost of goods sold and ending inventory under each of the following methods given the following information about purchases and sales during the year. Jan. 1           Beginning Inventory       300 units @ $3 Jan. 5           Sales                                      100 units Jan. 15        Purchases                           400 units @ $4 Jan. 20        Sales                                      200 units a. FIFO. b. LIFO.
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory,...
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, subcontracting and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 150 units per month. Overtime capacity and subcontracting capacity are 20 units per month each. Overtime cost is $30 per unit, subcontracting cost is 40 per unit, and backorder cost is $20 per unit, inventory holding cost is $5...
In aggregate production planning, a demand-chasing production plan a. Maximize both inventory-related costs and labor-related costs...
In aggregate production planning, a demand-chasing production plan a. Maximize both inventory-related costs and labor-related costs b. Minimize Inventory-related costs and maximize labor-related costs c. Minimize both inventory-related costs and labor-related costs d. Not enough information given to answer this question
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period...
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase 45,000 89.50 4,027,500 14 Sale...