Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated

Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. Part A (Continued) d. Create a "line" graph for each data set in the same Excel spreadsheet. The graph must Based on your limited knowledge of Operations Management and Supply Chain Management, how do you think this

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.

Step by Step Solution

3.46 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Art and Science of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Ingrid B. Splettstoesser

12th Canadian edition

133098230, 978-0132791564, 132791560, 978-0133098235

More Books

Students also viewed these General Management questions