Arizona State University - SCM 300

Forecasting and Line Balancing Exercise

SALES DATA

DEMAND FORECASTING - PROBLEMS

1)What is the 4-Period Simple Moving Average Forecast for Period 13?

2. What is the 4-Period Weighted Moving Average Forecast for Period 13? Use weights of 0.10, 0.20,0.30, and 0.40 for periods 9 through 12, respectively.

3. Since the demand seems to be fairly stable over the 12 month period, according to your lecture notes, which of your two Period 13 forecasts would you use?
   1. Simple moving average
   2. Weighted moving average

4. If we assume an average of 22 working days per month in the factory, how many calculators will need to be produced per day in the factory if we use 4-Period Simple Moving Average Forecast for Period 13?

LINE BALANCING - PROBLEMS

5. What is the Cycle Time that ensures the desired output rate? (Note: NEVER round up your cycle time!!! You should be able to figure out why this should never be done. Think about it, what would happen if you rounded up?)

Use the number you round down to in all the calculations that follow.

6. What is the theoretical minimum number of workstations? (ALWAYS round up workstations. Again, from the lecture you should know why.)

7. As you know, you should always round up your theoretical minimum number of workstations. Nonetheless, the calculated theoretical minimum number of workstations is not always attainable. Based on your calculation to the previous question, which of the following seems most plausible?

8. If someone were to create an assembly line that had 8 workstations, what would the efficiency of that assembly line be?

9. If someone were to create an assembly line that had 10 workstations, what would the efficiency of that assembly line be?

10. If someone were to create an assembly line that had 8 workstations, what would the total amount of idle (in seconds) in that assembly line?

11. If someone were to create an assembly line that had 10 workstations, what would the total amount of idle (in seconds) in that assembly line?

12. Using the precedence diagram on page 2 of this document, we have created four layouts below. Which of these four layouts is NOT valid?

13. Use the correct answer to #12 to answer this question. Why is that particular layout not valid?

14. Assume all four layouts listed in #12 were possible, what is the effective cycle time of each layout?