Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring...

Transcribed Image Text:

Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique, patented, semiconductors chips, supplied from China. As sales grew, ABC added the necessary manpower to keep pace with demand. The data is summarized below: 2017 2018 2019 2020 2021 2022 ABC Corporation Sales History/Forecast Sales (D) Fcst (f) (Millions) (Millions) $30 $25 $35 $33 $55 $45 $70 $60 A B Manpower Fcst (f) 60 70 80 100 M1 M 55 65 74 85 Updated Data to include previous forecast values Part A - 10 Points - To be done using Excel a. Given the data given above, develop a forecast for variable A and B using the exponential smoothing with an alpha value of 0.5. What is the forecasted value of 2021(A)_ ? 2022 (B) Please round to a whole number. No decimals required. b. Using the same method, but with an alpha value of 0.2, forecast the anticipated manpower. What is the forecasted value of ? 2022 (M)__ 2021 (M) _? Please round to a whole number. No decimals required. c. On your spreadsheet, calculate the % change for each variable. ? Part A (Continued) d. Create a "line" graph for each data set in the same Excel spreadsheet. The graph must be able to automatically reflect any changes in data....in other words, I want a working graph, not a picture. I will test the graphs capability. e. Comparing the data, is the plant more or less efficient in 2020 Vs 2017? Explain Your Reasoning: Input your answer in this space. Part B. (10 Points) The forecast data calculated above, once approved by management, is automatically loaded into the company's ERP system and will automatically release orders to each raw material and component supplier giving them a 6 months lead time to procure raw materials, fabricate components or sub- assembly's, and ship the products to arrive at your Toronto, ON., location one (1) week prior to your shipment to your customer. However, January 2020, Covid 19 rapidly spreads across the globe wth devastating effects on manufacturing, particularly related to manpower and delivery lead times. Six (6) month lead times quickly become 12 months lead times. The impact to global manufacturing effectiveness is as follows: Global Mfg. Effectiveness Output 2017 2018 2019 2020 2021 2022 98% 100% 110% 50% Covid 19 Outbreak 65% 80% Based on your limited knowledge of Operations Management and Supply Chain Management, how do you think this situation would impact your company? Input your answer in this space. How does it affect your customer? Input your answer in this space. What if anything would suggest you might do? Input your answer in this space. Please submit this document with your Excel spreadsheet attached to the submission. Please make sure the names of each participant who worked on this assignment is included in the document. Submit one document per team. Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique, patented, semiconductors chips, supplied from China. As sales grew, ABC added the necessary manpower to keep pace with demand. The data is summarized below: 2017 2018 2019 2020 2021 2022 ABC Corporation Sales History/Forecast Sales (D) Fcst (f) (Millions) (Millions) $30 $25 $35 $33 $55 $45 $70 $60 A B Manpower Fcst (f) 60 70 80 100 M1 M 55 65 74 85 Updated Data to include previous forecast values Part A - 10 Points - To be done using Excel a. Given the data given above, develop a forecast for variable A and B using the exponential smoothing with an alpha value of 0.5. What is the forecasted value of 2021(A)_ ? 2022 (B) Please round to a whole number. No decimals required. b. Using the same method, but with an alpha value of 0.2, forecast the anticipated manpower. What is the forecasted value of ? 2022 (M)__ 2021 (M) _? Please round to a whole number. No decimals required. c. On your spreadsheet, calculate the % change for each variable. ? Part A (Continued) d. Create a "line" graph for each data set in the same Excel spreadsheet. The graph must be able to automatically reflect any changes in data....in other words, I want a working graph, not a picture. I will test the graphs capability. e. Comparing the data, is the plant more or less efficient in 2020 Vs 2017? Explain Your Reasoning: Input your answer in this space. Part B. (10 Points) The forecast data calculated above, once approved by management, is automatically loaded into the company's ERP system and will automatically release orders to each raw material and component supplier giving them a 6 months lead time to procure raw materials, fabricate components or sub- assembly's, and ship the products to arrive at your Toronto, ON., location one (1) week prior to your shipment to your customer. However, January 2020, Covid 19 rapidly spreads across the globe wth devastating effects on manufacturing, particularly related to manpower and delivery lead times. Six (6) month lead times quickly become 12 months lead times. The impact to global manufacturing effectiveness is as follows: Global Mfg. Effectiveness Output 2017 2018 2019 2020 2021 2022 98% 100% 110% 50% Covid 19 Outbreak 65% 80% Based on your limited knowledge of Operations Management and Supply Chain Management, how do you think this situation would impact your company? Input your answer in this space. How does it affect your customer? Input your answer in this space. What if anything would suggest you might do? Input your answer in this space. Please submit this document with your Excel spreadsheet attached to the submission. Please make sure the names of each participant who worked on this assignment is included in the document. Submit one document per team.

Answer rating: 100% (QA)

Based on the provided images it appears that you are dealing with an assignment related to forecasting for a company named ABC Corporation which invol... View the full answer