Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Auditing The Art and Science of Assurance Engagements
ISBN: 978-0133098235
12th Canadian edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Ingrid B. Splettstoesser
Posted Date:
Students also viewed these general management questions
-
Consider how Kyler Valley Spring Park Lodge could use capital budgeting to decide whether the $12,000,000 Spring Park Lodge expansion would be a good investment. Assume Kyler Valley's managers...
-
Ghana Water Company Limited (GWCL) Profile Ghana Water Company Limited (GWCL) is a utility company, fully owned by the State. The company is responsible for potable water supply to all urban...
-
As we discussed at the beginning of the chapter, Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the stores might appear to be very similar, they...
-
A ball of mass 0.440 kg moving east( + x direction) with a speed of 3.30m/s collides head-on with a 0.220-kg ball at rest. If the collision is perfectly elastic, what will be the speed and direction...
-
a. Financial slack means having cash in the bank or ready access to the debt markets. b. Financial slack is most valuable to firms with few investment opportunities. c. Managers with excessive...
-
An investment project has annual cash flows of $4,200, $5,300, $6,100 and $7,400, and a discount rate of 14%. What is the discount payback period for these cash flows if the initial cost is $7,000?...
-
Instead of assuming that \(c_{1}^{\prime} y_{1}+c_{2}^{\prime} y_{2}=0\) in the derivation of the solution using Variation of Parameters, assume that \(c_{1}^{\prime} y_{1}+c_{2}^{\prime}...
-
Piedmont Manufacturing produces metal products with the following standard quantity and cost information: Overhead rates were based on normal monthly capacity of 6,000 machine hours. During November,...
-
If $1,088,000 of 7% bonds are issued at 102 3/4, the amount ofcash received from the sale isa. $1,117,920b. $1,164,160c. $816,000d. $1,088,000 2 answers
-
Distinguish between primary, secondary, and tertiary data sources as used in research work. (10 marks) b) You wish to undertake research on how the city of Gqeberha has changed over the years until...
-
First, you have decided to divide the nation into two regions with a regional sales manager in charge of each. According to industry sources, a regional sales manager's average sales is $120,000....
-
Acme Company s production budget for August is 1 8 , 9 0 0 units and includes the following component unit costs: direct materials, $ 7 . 2 0 ; direct labor, $ 1 1 . 4 0 ; variable overhead, $ 5 . 4...
-
Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 31 Sales (10,700 units at $300 each) Variable...
-
Situation 1 2 3 4 Lease term (years) Asset's fair value be exercised? 4 4 4 4 Asset's useful life (years) 6 $44,000 Purchase option that is reasonably certain to No Annual lease payments Beginning of...
-
A manufacturing company operates two processes. Output from Process 1 is transferred as input to Process 2. Output from Process 2 is the finished product. Data for the two processes in January are as...
-
What are the key principles of project management, and how do they contribute to successful project execution?
-
How can you tell from the vertex form y = a(x - h) 2 + k whether a quadratic function has no real zeros?
-
Explain what is meant by determining the degree of correspondence between information and established criteria. What are the information and established criteria for the audit of Glickle Ltd.s tax...
-
Each of the following scenarios involves a possible violation of the rules of conduct. Indicate whether each is a violation and explain why you think it is or is not. a. John Brown is an PA, but not...
-
In the audit of Whirland Chemical Company, a large publicly traded company, you have been assigned the responsibility for obtaining background information for the audit. Your firm is auditing the...
-
Search the Internet for the company MAX- IMA Group. List the main consequences of corporate fraud.
-
Using Google, determine the number of hits for these terms: a. Forensic accounting. b. Fraud auditing. c. Forensic auditing. d. Fraud examination.
-
Search the Internet: Is plagiarism fraud?
Study smarter with the SolutionInn App