Butterfly Inc is making a 6month plan for the workforce leve

Butterfly, Inc. is making a 6-month plan for the workforce levels at their plant in Indiana.

This plant produces two different excavators: XC1 and XC2. The demand for each model over the next six months is shown below

Month

XC1

XC2

1

180

90

2

160

70

3

190

100

4

240

130

5

200

150

6

200

190

It takes 5 worker days to produce one XC1 and 8 worker days to produce one XC2. Each worker will work for 20 days per month. The initial inventory levels are expected to be 40 units of XC1 and 30 units off SC2. Butterfly wants to have 30 units of XC1 and 70 units of XC2 at the end of month.

(a) Find the aggregate demand (measured in worker days) for each of the next six months. (The aggregate demand should reflect the desired ending inventory levels.)

(b) Butterfly decided to use a mixed strategy to plan the workforce levels. They will follow a

constant workforce plan in the first three months, and they will switch to a zero inventory plan for the last three months. Find appropriate workforce schedule for month 1 through 3, month 4, month 5 and month 6.

(c) At the end of the month 6, what is the actual (i.e., true, physical) ending inventory level, measured in terms of workers days? (The desired ending inventory should be included in the consideration).

Month

XC1

XC2

1

180

90

2

160

70

3

190

100

4

240

130

5

200

150

6

200

190

Solution

A.

B.

A B C=B+D-A D E F=E*C G=F/20
XC1 Month Opening Inventory Demand Production Closing Req Work days Total work days Workers
1 40 180 170 30 5 850 43
2 30 160 160 30 5 800 40
3 30 190 190 30 5 950 48
4 30 240 240 30 5 1200 60
5 30 200 200 30 5 1000 50
6 30 200 200 30 5 1000 50
Butterfly, Inc. is making a 6-month plan for the workforce levels at their plant in Indiana. This plant produces two different excavators: XC1 and XC2. The dema
Butterfly, Inc. is making a 6-month plan for the workforce levels at their plant in Indiana. This plant produces two different excavators: XC1 and XC2. The dema

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site