# supply chain management simulation exercise

Submit the solutions to each of the following 3 problem assignments in one MS Word document.

Assignment # 1

A ski repair shop at a resort in Colorado sells replacement poles each season. The shop needs to develop a forecast of next season’s sales so that they can place an order for poles with their supplier well in advance of the beginning of the season. Sales data for the past five years are shown below. Compare the forecasts given by the following models.

Year: 1 2 3 4 5

Sales (units): 350 375 355 375 390

Develop forecasts using:

1.

a. A 5 year moving average.

b. A weighted moving average model with weights of 0.2, 0.2, 0.1, 0.3, and 0.2 for years 1 through 5 respectively.

c. An exponential smoothing model with year 1 forecast of 380 and α= 0.3.

Assignment # 2

Togo makes riding lawn mowers and tractors. The company’s expected quarterly demand is given below in the chart. The company will have 300 mowers in inventory at the beginning of the month and desires to maintain at least that number at the end of each month. Below is other critical data:

Production cost per unit = \$225

Inventory Carrying cost per quarter per unit = \$50 (based on ending inventory)

Hiring Cost per worker = \$450

Firing cost per worker = \$800

Beginning # of workers = 50

Each worker can produce 110 units per quarter

Complete the tables and calculate the cost of the two plans

LEVEL Plan

Quarter

Demand

Regular Production

Ending Inventory

Workers Required

Hire

Fire

1

5000

2

9000

3

7000

4

9000

Total

30,000

3

CHASE PLAN

Quarter

Demand

Regular Production

Ending Inventory

Workers Required

Hire

Fire

1

5000

2

9000

3

7000

4

9000

Total

30,000

Assignment 3

Calculate the processing load, available capacity, and develop the load profile for the stereo speaker subassembly. Two employees work the assembly process for 40 hours each.

b. Prepare a load profile chart from this data.

c. As the planner, what concerns do you have and what changes would you make if any?

Part Name: Stereo speaker

Processing Time = 20 minutes

Week

Week

Week

Week

Week

Week

Week

Week

1

2

3

4

5

6

7

8

Planned Order Releases

220

190

210

270

210

190

240

200