Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Study 1: The AusCandy Demand (10 marks) The following table shows the historical demand data for product A in AusCandy Co. Answer the
Case Study 1: The AusCandy Demand (10 marks) The following table shows the historical demand data for product A in AusCandy Co. Answer the following questions. Actual Actual Period demand Period demand 123 1 77.00 13 57.37 2 45.28 14 80.65 3 48.03 15 52.95 4 47.87 16 61.49 5 78.88 17 46.26 6 51.85 18 71.23 53.51 19 56.90 8 58.54 20 72.99 9 49.73 21 57.68 10 61.00 11 50.55 22 22 45.76 23 45.93 12 50.85 a. Forecast for period 24 using the following three methods: Exponential smoothing with alpha = 0.25; Moving average with n= 5; and Linear trend (2.5 marks) b. Using MAD, what is the best forecast method in Part a? (2.5 marks) c. Based on your answer in Part b, use a tracking signal to see whether there is any bias in error over time. In case of any bias in error what would be your recommendation? (5 marks) For tracking signal please: Important note: Calculate tracking signal from period 15 onwards. Use limits of 5 and a = 0.20 Use MAD for error calculations Brief explanation is required for each question. Case Study 2: UFE Clubs Case Study, (10 marks) UFE Clubs produces ball bearings. The diameter of the ball bearings is very important for the quality purposes. The following tables shows the diameters of 17 randomly selected samples in centimetres. Each sample contains four observations. Use control charts and run tests to see whether or not the process is under control. For run test z = 1. Sample Observation 1 Observation 2 Observation 3 Observation 4 1 31.22 24.01 31.75 22.49 2 31.67 32.43 29.78 27.54 3 27.83 25.37 26.49 25.83 4 31.48 28.02 30.21 31.86 5 28.27 30.99 28.62 25.46 6 28.23 24.44 32.56 32.41 7 24.58 26.89 27.11 32.36 8 28.16 29.47 22.32 30.78 9 28.21 29 32.88 24.69 10 32.15 29.18 24.84 31.29 11 23.91 24.65 29.29 22.32 12 23.20 29.23 29.31 26.36 13 23.54 31.11 31.81 26.56 14 30.64 26.94 29.23 32.29 15 31.87 32.48 24.56 25.51 16 29.33 23.36 23.36 25 17 27.02 23.05 31.19 28.44
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To determine whether the process is under control using control charts and run tests we will follow ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started