Amid the disrupting economy, Manager Chris Channing of Fabric Mills, Inc., has to redevelop the aggregate planning. He has updated demand forecast and available regular capacity for regular fabric in Table 1. Demand for regular fabric is expected to drop significantly due to a huge sales drop in the apparel sector. Available normal capacity also dropped due to the temporal workforce shrinkage, reduced working hours and plant closures.

Table 1: Demand Forecast and Capacity for Regular Fabric (in Hundreds of Bolts)

Month	5	6	7	8	9	10	11
Forecast	140	140	180	180	180	200	200
Regular Capacity	140	190	250	250	250	250	250

He has also updated cost information shown in the table below. The subcontract cost has increased by 10% due to the increase in logistics costs. The cost of carrying inventory has doubled due to the increased risk of obsolescence. That is, carrying large inventory when demand is rapidly shrinking slows down the movement of inventory and thus increases the risk of product obsolescence.

Regular output	$40 per hundred bolts
Overtime	$60 per hundred bolts
Subcontract	$55 per hundred bolts
Inventory carrying cost	$4 per hundred bolts

Now Chris is ready to develop aggregate planning. Given the highly uncertain environment, he is going to try a number of different scenarios for aggregate planning. Chris is certain that workers can be assigned to other jobs if production is less than normal.

QUESTION 1

Although it may be a little too optimistic, Chris first assumes that all bolts of regular fabric produced in Month 4 will be sold. That is, the ending inventory at the end of Month 4 will be zero. For simplicity, he also assumes that backlog at the end of Month 4 will be zero. Under this scenario, develop a chase plan. Backlog is not allowed. How much is the total cost?

Hints:

• Use the Aggregate Planning worksheet
• Enter 0 in Cell D9 and Cell D11 in the Aggregate Planning worksheet.
• In a chase plan, you can reduce regular output if available regular output exceeds demand.

1. $48,800
2. $52.080
3. $67,640
4. $81,820

QUESTION 2

Under the scenario in QUESTION 1, now develop a level plan. Backlog is not allowed. How much is the total cost?

Hint:

• In a level plan, you cannot reduce regular outputs. You need to use all available regular outputs.

1. $48,800
2. $52.080
3. $67,640
4. $81,820

QUESTION 3

In the level plan developed in QUESTION 2, how many bolts will be carried over to Month 12?

1. 0 bolts
2. 310(00) bolts
3. 360(00) bolts
4. 1,110(00) bolts

QUESTION 4

Chris next considers a more realistic scenario. Given the weak demand, he is afraid that a significant amount of regular fabric will remain unsold. He estimates that the amount of unsold regular fabric at the end of Month 4 to be 200(00) bolts. The positive ending inventory implies that backlog will be zero at the end of Month 4. Under this scenario, develop a chase plan. Backlog is not allowed. How many bolts of regular outputs are required in Month 6?

Hints:

• Enter 200 in Cell D9 and 0 in Cell D11 in the Aggregate Planning worksheet.
• Use the ending inventory from the previous period, if any, to satisfy the current demand and adjust regular outputs accordingly.
  • If the ending inventory from the previous period exceeds the current demand, regular outputs are not required in the current period.
  • If the ending inventory falls short of the current demand, use regular outputs to fill the gap.

1. 0 bolt
2. 80(00) bolts
3. 140(00) bolts
4. 190(00) bolts

QUESTION 5

In the chase plan developed in QUESTION 4, how much is the total cost?

1. $38,240
2. $41,440
3. $42,240
4. $46,000

Month Table 1: Demand Forecast and Capacity for Regular Fabric (in Hundreds of Bolts) 5 6 7 8 Forecast 140 140 180 180 Regular Capacity 140 190 250 250 9 180 250 10 200 250 11 200 250 300 Table 2: Demand Forecast and Capacity for Medical-Grade Fabric in Hundreds of Bolts) Month 9 Forecast 300 300 200 200 Regular Capacity 200 200 200 150 150 Overtime 40 40 40 30 30 Subcontract 50 50 50 50 10 100 150 30 50 100 150 30 50 50 SKU Table 3: Unit Price and Number of Units Sold in February Units Sold in SKU Unit Price February A2067 $35 A2133 $6 94 A2957 $11 1 46 A4142 $3 A6916 A7025 $33 A7428 S6 $11 147 $3 B1139 $5 $2 $8 $12 85 B1948 B2155 B4148 B4149 B4150 B4151 B5568 B7116 C2032 C5816 C7631 C86053 179 $11121 $1 $11 $1 S2 09814 F3300 S4 $1 199 94 $2112 7 $2 116 $3 $2 $20 $3 $7 25 $ 3 36 Table 4: Unit Price and Number of Units Sold in April Units Unit Sold in Price April A2067 $35 A2133 A2957 A4142 A6916 A7025 $33 A7428 $4 A7850 $55 B1139 $23 81948 B2155 B4148 B4149 $18 B4150 B4151 S12 B5568 $5 B7116 C2032 C5816 $4 C7631 C8605 $3 09323 $211 09814 F3300 F5430 S2 F6018 $20 | 79575 G5967 $7 T1192 T1801 T4470 TR594 T8994 T9039 S2 T9204 $1.041 T9800 $10 X1561 $1 X2661 $84 X9988 Y1247 $17 Y1645 $66 Y2133 $1 Y3118 14100 Y4587 Y4765 $48 Y6685 $10 Y8701 $41 Y8727 $116 Y9971 $ 2 262 LLLLLLLLLS $3 106 $3 $3 $17 F6018 F9575 G5967 T1192 T1801 T4470 T8594 T8994 T9039 T9204 T9800 $5 $1 $1,041 $10 $1 8 8 102 159 147 $1 190 $84 $1 $17 $66 $1 $1 162 137 X2661 X9988 Y1247 Y1645 Y2133 Y3118 Y4100 Y4587 Y4765 Y6685 Y8701 Y8727 Y9971 $1 $8 $2 $2 178 $48 $10 $41 $116 $ 2 187 Month 5 6 7 8 9 10 11 1 Total Forecast Output Regular TTTTTTTT Overtime Subcontract Output - Forecast | Inventor Beginning o 0001 Ending TT0| 01 Average Backlog Output Regular Hollopott a MOM @ Overtime @ Subcontract Inventor Backlog Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month Table 1: Demand Forecast and Capacity for Regular Fabric (in Hundreds of Bolts) 5 6 7 8 Forecast 140 140 180 180 Regular Capacity 140 190 250 250 9 180 250 10 200 250 11 200 250 300 Table 2: Demand Forecast and Capacity for Medical-Grade Fabric in Hundreds of Bolts) Month 9 Forecast 300 300 200 200 Regular Capacity 200 200 200 150 150 Overtime 40 40 40 30 30 Subcontract 50 50 50 50 10 100 150 30 50 100 150 30 50 50 SKU Table 3: Unit Price and Number of Units Sold in February Units Sold in SKU Unit Price February A2067 $35 A2133 $6 94 A2957 $11 1 46 A4142 $3 A6916 A7025 $33 A7428 S6 $11 147 $3 B1139 $5 $2 $8 $12 85 B1948 B2155 B4148 B4149 B4150 B4151 B5568 B7116 C2032 C5816 C7631 C86053 179 $11121 $1 $11 $1 S2 09814 F3300 S4 $1 199 94 $2112 7 $2 116 $3 $2 $20 $3 $7 25 $ 3 36 Table 4: Unit Price and Number of Units Sold in April Units Unit Sold in Price April A2067 $35 A2133 A2957 A4142 A6916 A7025 $33 A7428 $4 A7850 $55 B1139 $23 81948 B2155 B4148 B4149 $18 B4150 B4151 S12 B5568 $5 B7116 C2032 C5816 $4 C7631 C8605 $3 09323 $211 09814 F3300 F5430 S2 F6018 $20 | 79575 G5967 $7 T1192 T1801 T4470 TR594 T8994 T9039 S2 T9204 $1.041 T9800 $10 X1561 $1 X2661 $84 X9988 Y1247 $17 Y1645 $66 Y2133 $1 Y3118 14100 Y4587 Y4765 $48 Y6685 $10 Y8701 $41 Y8727 $116 Y9971 $ 2 262 LLLLLLLLLS $3 106 $3 $3 $17 F6018 F9575 G5967 T1192 T1801 T4470 T8594 T8994 T9039 T9204 T9800 $5 $1 $1,041 $10 $1 8 8 102 159 147 $1 190 $84 $1 $17 $66 $1 $1 162 137 X2661 X9988 Y1247 Y1645 Y2133 Y3118 Y4100 Y4587 Y4765 Y6685 Y8701 Y8727 Y9971 $1 $8 $2 $2 178 $48 $10 $41 $116 $ 2 187 Month 5 6 7 8 9 10 11 1 Total Forecast Output Regular TTTTTTTT Overtime Subcontract Output - Forecast | Inventor Beginning o 0001 Ending TT0| 01 Average Backlog Output Regular Hollopott a MOM @ Overtime @ Subcontract Inventor Backlog Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0