Q1. (3 marks) Using the demand data supplied in the below table, please calculate the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q1. (3 marks) Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective. Please use Excel to calculate your forecasting answers, so behind the cells in Excel, there has to be formulas for answering the below questions. Your company wants to forecast the demand for their product, based on the data below. a) Calculate the simple four-week moving average for weeks 5 through 12 b) Calculate the weighted three-week moving average using weights of 0.40, 0.40, and 0.20 for weeks 4 through 12 c) Calculate the exponential smoothing forecast for weeks 2 through 12 using an initial forecast of 4400 units and an alpha of 0.30 d) Calculate the exponential smoothing forecast plus trend for week2 through 12 using an alpha of 0.10, delta of 0.20, a previous forecast including trend of 4600 units, a previous trend of 120 units e) Calculate the MAD and MAPE for all four of the forecasting models. Which forecast method do you recommend and why? Week 1 2 3 4 5 6 7 8 9 10 11 12 Demand 4500 4750 5400 5800 6250 6500 7000 7500 7920 8200 8500 8800 Q1. (3 marks) Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective. Please use Excel to calculate your forecasting answers, so behind the cells in Excel, there has to be formulas for answering the below questions. Your company wants to forecast the demand for their product, based on the data below. a) Calculate the simple four-week moving average for weeks 5 through 12 b) Calculate the weighted three-week moving average using weights of 0.40, 0.40, and 0.20 for weeks 4 through 12 c) Calculate the exponential smoothing forecast for weeks 2 through 12 using an initial forecast of 4400 units and an alpha of 0.30 d) Calculate the exponential smoothing forecast plus trend for week2 through 12 using an alpha of 0.10, delta of 0.20, a previous forecast including trend of 4600 units, a previous trend of 120 units e) Calculate the MAD and MAPE for all four of the forecasting models. Which forecast method do you recommend and why? Week 1 2 3 4 5 6 7 8 9 10 11 12 Demand 4500 4750 5400 5800 6250 6500 7000 7500 7920 8200 8500 8800
Expert Answer:
Answer rating: 100% (QA)
Ans 51 c TX 7x axvo cos Xo Solution vxv sin in 27x ax a... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
A company uses exponential smoothing with trend to forecast monthly sales of its product, which show a trend pattern. At the end of week 5, the company wants to forecast sales for week 6. The trend...
-
The famous Widget Company uses simple exponential smoothing to forecast the demand for its best-selling widgets. The company is considering whether it should use α = .1 or...
-
Calculate a 3-period simple moving average forecast for periods 4-8. Demand (units) Period 22 16 25 4 27 19 28 22 2. 3. 6.
-
Congratulations! Your portfolio returned 11% last year, 2% better than the market return of 9%. Your portfolio had a standard deviation of earnings equal to 18%, and the risk-free rate is equal to...
-
What is the Gramm-Leach-Bliley Act? How does it apply to investigators?
-
Calabrese City allocates some indirect or overhead costs to each of its police stations. The city charges each station for common services such as the city food ser-vice and for administrative...
-
Explain the six-legged stool of the financial reporting process.
-
The planning department of an electronics firm has set up the activities for developing and production of a new MP3 Player. Given the information below, develop a project network using Microsoft...
-
Myra Svensson was first a higher education publishing representative, and then a district sales representative for John Wiley & Sons, Inc., one of the top textbook providers in the EU. Overall, My...
-
Company A is a global company based in the United States that operates in the financial industry. Company A serves its customers with financial products, such as checking accounts, bank cards, and...
-
At the end of 2021, ACME Corporation faced increasing competition leading to a build up of inventory and declining profitability and liquidity. In an effort to generate more revenue and improve the...
-
Hiatt Hurricane Preparedness Corporation accounts for its inventory using LIFO and is applies the LCM rule. The company has compiled the following information regarding the cost, replacement cost,...
-
The architecture firm of Dream Design Company uses a job order cost system in pricing the home blueprints it designs for its clients. The company s predetermined overhead rate is 1 3 0 % of direct...
-
The financial statements of Inland Engineering are provided below. The firm has 100 million shares outstanding at the end of 2020 and the stock price was $10. The firm plans to increase its fixed...
-
Walte Company just starting business had the following transactions in May: Purchase Sale Purchase Purchase Sale Purchase June 1 June 5 June 10 June 15 130 units 100 units @ 8.00 200 units @ 5.60 200...
-
A particle was moving in a straight line with a constant acceleration. If the particle covered 17 m in the 2nd second and 46 m in the 9th and 10th seconds, calculate its acceleration a and its...
-
Draft a complete legal rule for Fair Use. You may use more than one sentence. Although, it is not required. Be sure to list all the elements. However, you do not need to define each element. For...
-
Explain what is meant by vicarious liability and when it is available?
-
Janie graduates from high school in 2012 and enrolls in college in the fall. Her parents pay $4,000 for her tuition and fees. a. Assuming Janie's parents have AGI of $170,000, what is the American...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
Which would not be a detective control? a. Drug testing b. Reconciliations c. Surprise cash counts d. Counting inventory e. Reviews
-
Which fraud scheme did Sunbeam not do? a. Cookie-jar reserves b. Accelerated revenues from leasing equipment c. Channel stuffing d. Guaranteed sales e. Improper bill and hold
-
Which would be a corrective control? a. Process redesign b. Drug testing c. Using document control numbers d. Job rotation e. Event notifications
Study smarter with the SolutionInn App