Question
Solve the below using Winters Mathematical Modelling. Dont use CHATGPT or AI. Show me calculations: South West Electronics (SWE) Ltd produces electronic security devices for
Solve the below using Winters Mathematical Modelling. Dont use CHATGPT or AI. Show me calculations:
South West Electronics (SWE) Ltd produces electronic security devices for buildings. The demands history is shown in table-1. You are required by the executive to write a report on the future demand of the product, which should provide the following information.
Table-1.1 Sales History
Sales | 2015 | 2016 | 2017 | 2018 | 2019 |
Jan | 3,000 | 3,000 | 4,000 | 5,000 | 5,000 |
Feb | 3,000 | 4,000 | 5,000 | 4,000 | 3,000 |
Mar | 4,000 | 4,000 | 6,000 | 5,000 | 4,000 |
Apr | 4,000 | 5,000 | 4,000 | 3,000 | 3,000 |
May | 5,000 | 5,000 | 4,000 | 6,000 | 7,000 |
Jun | 6,000 | 8,000 | 6,000 | 7,000 | 6,000 |
Jul | 7,000 | 5,000 | 7,000 | 10,000 | 8,000 |
Aug | 7,000 | 8,000 | 10,000 | 14,000 | 11,000 |
Sep | 10,000 | 12,000 | 15,000 | 16,000 | 20,000 |
Oct | 12,000 | 13,000 | 15,000 | 17,000 | 20,000 |
Nov | 14,000 | 16,000 | 18,000 | 20,000 | 22,000 |
Dec | 8,000 | 10,000 | 9,000 | 12,000 | 8,000 |
Total | 83,000 | 93,000 | 103,000 | 119,000 | 117,000 |
Using the historical data shown in Table-1.1,
- Recommend an appropriate demand forecasting method for SWE. Please make an explanation of why you choose this method.
Using the method that you recommend above, develop your forecast for the monthly demand of SWE in 2020 (smoothing constants can be set to 0.1 if needed). Please specify how you build your forecasting model with necessary in-progress calculation included and conclude your forecasting results.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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