LAB EXERCISE

Form groups of two students to work on the following problem:

The GMC production planner has forecasted the firm's aggregate demand

requirements over the next $8$ months are as follows:

The operations managers, a group of manufacturing and industrial engineering

technology students, are considering a new plan, which begins in January with $200$ units

on hand and ends with $200$ units of inventory. There are $20$ production days available

each month. The following information also applies:

Develop a excel spreadsheet $($see D$2$L$)$ for costing:

a$)$ a level strategy with no overtime and subcontracting

b$)$ a mixed strategy with a level workforce set in accordance with the lowest

demand month with overtime and subcontracting as required. Overtime is

limited to $200$ units$/$month$.$