The following inventory pattern has been observed in the Zahm Corporation over 12 months Month Inventory Month Inventory Apr 16 1,544 Oct 16 1,208 May 16 1,913 Nov 16 2,467 Jun 16 2,028 Dec 16 2,101 Jul 16 1,178 Jan 17 1,662 Aug 16 1,554 Feb 17 2,432 Sep 16 1,910 Mar 17 2,443 Use both three month and five month moving average models to forecast the inventory for the next January Use mean absolute percentage error (MAPE) to evaluate these two forecasts

Question: The following inventory pattern has been observed in the Zahm Corporation over 12 months: Month Inventory Month Inventory Apr-16 1,544 Oct-16 1,208 May-16 1,913 Nov-16

The following inventory pattern has been observed in the Zahm Corporation over 12 months:

Month	Inventory	Month	Inventory
Apr-16	1,544	Oct-16	1,208
May-16	1,913	Nov-16	2,467
Jun-16	2,028	Dec-16	2,101
Jul-16	1,178	Jan-17	1,662
Aug-16	1,554	Feb-17	2,432
Sep-16	1,910	Mar-17	2,443

Use both three-month and five-month moving-average models to forecast the inventory for the next January. Use mean absolute percentage error (MAPE) to evaluate these two forecasts.

Step by Step Solution

★★★★★

3.36 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Month Inventory MA3 MA3 Forecast MA5 MA5 Forecast Apr16 1544 May16 1913 Jun16 2028 182833 Jul16 1178 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Forecasting Predictive Analytics Questions!

The law firm of Spade & Associates hired Dylan Sayers to review the audit of the 2014 financial statements that Hammer & Wimsey, CPAs, had completed for Golden Sound and Records Company....

Aubrey Marblehead is conducting tests of controls on the control that quantities on Rocks receiving reports are appropriately verified. In so doing, Marblehead has inquired of Rocks receiving...

A rare decay mode has been observed in which 222Ra emits a 14C nucleus. (a) The decay equation is 222Ra A X + 14 C. Identify the nuclide AX. (b) Find the energy emitted in the decay. The mass of...

he following inventory pattern has been observed in the Zahm Corporation over 1 2 months: Month Inventory Month Inventory Apr - 1 6 1 , 5 4 4 Oct - 1 6 1 , 2 0 8 May - 1 6 1 , 9 1 3 Nov - 1 6 2 , 4 6...

Question 5. The Niagara Workforce Planning Board wants to compare the employment and wages in the 15 to 24 age group in the Services-Producing sector for both full-time and parttime workers for the...

Can someone help me for these 3 questions and show the working out step by step if possible COURSEWORK QUESTIONS 1) [15 marks] In the Excel dataset file column B contains gross monthly percentage...

CASE STUDY 1 (15%) A wealthy investor, David, approaches your consulting firm seeking for investment advices. David plans to invest his RM1 million in the following 16 stocks traded on Bursa...

Based on your estimated regression model, what is the predicted value of the excess return on the portfolio of stocks when the excess return on the market portfolio is 2.1%. Show your...

] In the Excel dataset file column B contains gross monthly percentage returns on a portfolio of US stocks (denoted by rp ), column C contains gross monthly returns on the market portfolio (denoted...

MGMT 484 Fall2020 Project Instructions 1.Download "Project Data.xlsx" file from Canvas. 2.In the "Past Demand Data" worksheet, you will find past demand data of your product for the past 54 months....

Re-create the S&OP spread sheet used in Table 10.10 and Example 10.11. (You do not have to build in the optimization model using the Solver function.) While your formatting may differ, your answers...

Write a paper in which you examine how learning theories can be used to understand persisting behavior, as well as how an understanding of these theories can help change behavior. First, select a bad...

61. In Preferred number the R-10 series will have the value of 'r' , common ratio = (a) Fifth root of 10, ( ) (b) Tenth root of 10, ( c) Fifth root of Five, ( ) ( d) Tenth root of five.

Design a web site Design an e-retail web site for a specialist retailer serving a niche market, for example a specialist health product retailer (see Figure 10.2). Use the four key factors identified...

Briefly describe your own beliefs about the potential value of low-energy compact fluorescent lightbulbs, your attitude toward them, and your intention about buying one the next time you need to...

Give an example of a recent purchase experience in which you were dissatisfied because a firms marketing mix did not meet your expectations. Indicate how the purchase fell short of your expectations...

Explain psychographics and lifestyle analysis. Explain how they might be useful for planning marketing strategies to reach college students, as opposed to average consumers.

In 2018, the article below, published by the journal Clinical Nutrition, reported the results from a study involving the caffeine intake among college students in the U.S. A representative sample of...

16-13. (Ratio analysis) Assuming a 360-day year, calculate what the average investment in inventory would be for a firm, given the following information in each case. a. The firm has sales of...

Implement the following circuit using only Multiplexer ( with negative edge trigger ) and write the Data flow modelling for your answer with the instantiation.