Question: please answer this question using the moving average method. when using excel can you show each equation that you used within the excel sheet. Look

please answer this question using the moving average method. when using excel can you show each equation that you used within the excel sheet.

Look at the data listed 3B on the Excel document titled "Demand for Product Delta". You want to generate forecast for the monthly demand of product Delta using the 4-month moving average method. You must use at least 4 decimal places in your calculation and answer. answer the following questions: The forecasted demand for month 8 is 101.5000 units. The forecasted demand for month 12 is 114.5000 units. The forecasted demand for month 16 is 108.0000 units. The value of MAD is 18.8392 X units. The value of MAPE is 18.7089 X units. The value of RMSE is 22.6342 DATA 3B DATA 3C The demand for product Delta (in units) in the past 18 months are shown below Month Demand 101 2 3 103 130 101 90 4 S 6 7 8 9 10 12 13 14 15 16 17 18 102 113 128 71 126 133 72 112 115 133 139 127 121

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

please help me with these questions thank you QUESTION 1 In conjunction with the housing foreclosure crisis of 2009, many economists expressed increasing concern about the level of credit card debt...

University of Derby Derby Business School In-course Assignment Specification Module Code and Title: 7LO510 Supply Chain Analysis and System Modelling Assignment No. and Title: Coursework Assessment...

The Schonlind Company has gathered information regarding past sales: Year Sales 1999 $300,000 2000 225,000 2001 325,000 2002 650,000 2003 540,000 2004 675,000 2005 825,000 Required: 1. Predict the...

I am really needing help with parts 5-9. All relevant information and data has been provided. SCENARIO: SALES FORECASTING The Gregory Corporation has gathered information regarding past sales of...

I am needing help with this. All relevant information and data is also included.... SCENARIO: SALES FORECASTING The Gregory Corporation has gathered information regarding past sales of plastic...

please help 1-4 The Simpson Corporation has gathered information regarding past sales of custom t-shirts Year Sales 2013 $225,000 2014 $193.000 2015 $248,000 2016 $350.000 2017 $340,000 2018 $295.000...

SCENARIO: SALES FORECASTING The Gregory Corporation has gathered information regarding past sales of plastic silverware. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6...

The Gregory Corporation has gathered information regarding past sales of plastic silverware. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6 $680,000 20X7 $590,000 20X8...

Scenario: Sales Forecasting The Simpson Corporation has gathered information regarding past sales of custom t-shirts....

Please answer this question in excel and show the steps. For the following problems, show your work by hand (scan or photo your handwritten work) or by typing out all the values in Microsoft Word....

How has deregulation of the financial services industry affected the makeup of financial 1intermediaries? How do you think intermediaries characteristics will change in the future?

On August 1, 2014, the following were the account balances of D&D Repair Services. During August, the following summary transactions were completed. Aug. 5 Received $1,200 cash from customers in...

Calculate the coordinates of the midpoint of each side of this triangle. E y 40- 30- 20 10- D 4-3-2-1123 2 3 4 x 10- -20- -30- F 40-

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...