Question: I don't need excel solver. Can you please solve at the paper? Thank you A. Forecasting Wallace Garden Supply wants to forecast demand for its

I don't need excel solver. Can you please solve at the paper? Thank you

A. Forecasting Wallace Garden Supply wants to forecast demand for its Storage Shed. Please find below the actual demands for 8 weeks. Week Demand 190 125 144 2 3 6 156 185 145 114 187 7 8 1. Find the forecast for week 7 by using moving average methodology. The company use a three- week moving average (n = 3). 2. Find the forecast for week 5 by using weighted moving average methodology. The company use a four-week weighted moving average (n = 4). Weight application is as follows: Weight Application Period 4 3 Last week 2 weeks ago 3 weeks ago 4 weeks ago 2 1 3. Find the forecast for week 8 by using exponential smoothing methodology. Please accept a=0.1 and Forecast for Week 1=170 4. Use the values of actual demands and the values of forecasted demands obtained by using exponential smoothing for all weeks and find MAD (mean absolute deviation)

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!

1 A. Forecasting Wallace Garden Supply wants to forecast demand for its Storage Shed. Please find below the actual demands for 8 weeks. Week Demand 131 2 3 4 5 6 7 8 197 162 123 190 145 135 134 1....

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

I need help with d and e. Please show work and add notes if possible. I am very confused and would love the help. Thank you. 1) Data collected on the yearly demand for 50-pound bags of fertilizer at...

I want you to summerize these 7 items. !Please be different from other answers! !Please get a little quick! Thanks. You should summarize the 7 items in the photo. Max 125 words! reading 1....

M4 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign4.xls (where XX is your Group Name), and upload and submit to the instructor through Dropbox. Do not enter anything...

Section 1 - Production Planning One of the leading Pasta worldwide pasta manufacturing companies (DCC) established a production plant in Bedfordshire in 2009. The Logistics and Production Planning...

the questions and material to answer the questions are attached here.... thank you! Final Exam MBA604 Part A Period (month) Demand Northeast 1 2 3 4 5 6 7 8 9 10 11 12 13 1200 1300 1200 1400 1500...

I have attached the discussion board 6 questions,scenario. and lectures for yourreview and response. I will submit a students questions for a response when I receive one. Thank You MKT500 Discussion...

Question: Evaluate the two forecasting models described in the case for predicting daily check-in volume. What are the strengths and weaknesses of each one? Do you find any of the results surprising?...

please reas the instruction instructions are below the. write a report after reading the article only responsibilties of CEO CEO/President Job Title: CEO/President FLSA Status: EEO Code: Salary...

You are hired as an advertiser but you want more money for the launch of an advertisement write a dialogue in which you are convincing your Manager for more budget. While using communication...

A local not-for-profit organization that provides shelter for the homeless favors proposed legislation in the state that would facilitate converting an old hotel into a transitional living facility....

How far in the future can one typically predict information required for pro forma statements? O 1-6 years Submission UT years O 2-8 years O Up to 10 years O None of the above

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...