Question: Solve the following problem. Please only use excel and show work. Month Actual Demand January 2000 February 1450 March 1950 April 1975 May 2100 June

Solve the following problem. Please only use excel and show work.

Solve the following problem. Please only use

Month	Actual Demand
January	2000
February	1450
March	1950
April	1975
May	2100
June	1750
July	1550
August	1400
September	2200
October	2770
November	2350
December	2200

= = C25 XV fx A B C D E F G H 1 J K L M 1 Problem #2 2 3 4 5 6 7 8 Baltimore County Home Depot sales for refrigerators is given in the table for a 12 month period. a. Forecast Using a three month moving average b. Forecast Using simple exponential smoothing with Alpha = 0.3 c. Show a plot of Demand and Forecasts on the same graph. Interpret. d. Calculate 3 accuracy measures-MAD,MSE, MAPE e. Which model do you recommend? Why? 9 10 11 Actual Month 12 Demand 13 January 2000 14 February 1450 15 March 1950 16 April 1975 17 May 2100 18 June 1750 19 July 1550 20 August 1400 21 September 2200 22 October 2770 23 November 2350 24 December 2200 25 26 27 28 29 30 31 32

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!

show with excel steps please!! Baltimore County Home Depot sales for refrigerators is given in the table for a 12 month period. a. Forecast Using a three month moving average b. Forecast Using simple...

Problem 1: (5.pts.-> 3+2: Brian Adams, the manager of the company Design-Plus is upgrading his ERP software. The high-performance software (ORACLE) can be rented for $3.000 per month per computer...

A retailer purchases an item called XYZ at $ 10 per unit from its supplier. The demand is steady at 100 units per week. This retailer has 50 working weeks per year. The supplier decides to offer...

Answer ALL Questions Question 1 (25 marks) Metal Company is a manufacturer of knives and forks. For several months this company has kept a record of the demand for knives. To help schedule...

wrong). Weights Days Package 1 Package 2 Package 3 Package 4 Monday 21 22 20 24 Tuesday 23 21 19 21 Wednesday 20 19 20 21 Thursday 18 19 20 19 Friday 18 20 22 20 Q.3.A. What is the sample size (n) in...

What is the standard cost of an assembled balancing mount according to the new plan? Need calculation with formula also? What is the conclusion for this case? SAGE SAGE Business Cases Craig Seidelson...

Please, I need answers with step by step explanation. Thank you. Second Practice Midterm ACC3200, Spring 2017 Ex. No. Instructions: 1 You must write your name on this sheet as well as the scantron...

Could you please answer this question ? ACC 309: EXCEL Project: THE DAILY GRIND CASE Spring 2016: Due April 21 This case is designed to enhance your ability to use EXCEL in a consulting environment....

please show work or formulas used, thank you! M Problem 5 - Use the data below to calculate two Exponetial Smoothed Forecasts. The first should use an alpha of 33 and the second should use an alpha...

Please utilize Excel for this problem, and show all of the steps that were used to find the solutions (including the Solver properties used in Excel). Thank you! Q4. (40pt) Skycell, a major European...

Which of the following statements is incorrect. Multiple Choice O An unadjusted trial balance is a list of accounts and balances prepared before adjustments are recorded. An adjusted trial balance is...

Determining and interpreting fixed cost variances Smitter Manufacturing Company established a predetermined fixed overhead cost rate of $200 per unit of product. The company planned to make 19,000...

What is the expected Salary [ in thousands ] of a manager who has 2 0 years of experience? 4 5 . 5 1 6 8 . 8 4 3 6 . 5 9 7 4 4 3 5 7 . 8 4

What is an example of constructive feedback? provide reference