Question: Please help with part B. Excel formulas would be appreciated. Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past

Please help with part B. Excel formulas would be appreciated.

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 4 Week 1 Demand 20 2 23 3 29 5 25 6 29 7 35 8 20 9 25 10 29 36 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 2 3 5 8 10 Demand 20 23 29 36 25 29 35 20 25 29 Forecast 20.0 20 21.50 25.25 30.63 27.81 28.41 31.70 25.85 25.43 1 4 6 7 9 sales (round your response to two decimal b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 20.0), the MAD = places)

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!

Need help solving on with excel. Formulas would be appreciated! Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below:...

Please include excel formula table if possible Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 21...

Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its...

MAD please Score: 0 of 1 pt 4 of 4 (3 complete) HW Score: 70.83%, 2.83 of 4 pts Problem 4.59 Question Help Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the...

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Part 2 a) The forecast for weeks 2 through 10 using exponential...

Homework: Mod4 HW 2 Question 3, Problem 4.59 Part 1 of 3 HW Score: 44.34%, 13.3 of 30 points Points: 0.64 of 7 Save Question content area Part 1 Sales of tablet computers at Ted Glickman's...

Q1 : The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Find September 28th, October 5th and October 12th Q2: Sales of tablet computers at...

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 28 38 25 28 36 24 26 30...

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 20 27 38 24 30 37 20 24 30...

Would you have the QBP president or an appointed planning executive do the planning for the new warehouse? Why?

This exercise is an introduction to the Big Four accounting firms, all of which are partnerships. Addresses Deloitte & Touche www.deloitte.com/ Ernst & Young www.ey.com/ KPMG www.us.kpmg.com/...

On January 1 , 2 0 2 0 , Parent acquired a 7 0 % interest in Sub for a purchase price that was $ 2 4 0 , 0 0 0 over the book value of the Sub s Stockholders Equity on the acquisition date. Parent...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...