Question: 1) 2) A B C D E F G H 1 B) Calculate the Tracking signal values for the data. Do you recommend that they

1) 2) A B C D E F G H 1 B) Calculate the Tracking

A B C D E F G H 1 B) Calculate the Tracking signal values for the data. Do you recommend that they continue to use this forecasting method? Explain your position 3 4 1 5 Actual 6 Day Demand Forecast Monday 975 1075 8 2 Tuesday 1225 1300 9 3 Wednesday 1145 1188 10 4 Thursday 1750 1407 115 Friday 2160 1700 12 6 Monday 2000 2091 13 7 Tuesday 750 1589 14 8 Wednesday 895 876 15 9 Thursday 1500 892 16 10 Friday 1600 1409 17 11 Monday 1300 1440 18 12 Tuesday 850 1087 19 13 Wednesday 850 716 20 14 Thursday 980 830 21 15 Friday 1500 957 22 16 Monday 1418 23 17 Tuesday 650 850 24 18 Wednesday 985 680 25 19 Thursday 1200 940 26 20 Friday 1460 1161 27 28 29 30 31 750 Problem 5: Below is 4 weeks of sales data for a restaurant that is open 5 days a week (Tuesday-Saturday). a. Develop an Exponential Smoothing forecast. Use an alpha of 85 and assume the initial forecast for January is 975 b. Calculate the MAD for this forecast. 3 4 5 7 Day Tuesday Wednesday 6 Thursday Friday 8 Saturday 9 Tuesday 10 Wednesday 11 Thursday 12 Friday 13 Saturday 14 Tuesday 15 Wednesday 16 Thursday 17 Friday 18 Saturday Tuesday 20 Wednesday 21 Thursday 22 Friday 23 Saturday Demand 975 1225 1445 1750 2160 1500 750 895 1500 1445 1025 650 850 980 1500 750 650 985 1200 1460 19

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!

Financial Model (Excel homework) - Eng. Economics (EGN 3615) Sneakers For All, LLC. is having success selling casual sneaker shoes for everyday use. The company is looking to grow the annual sales...

Question LongLife, LLC manufactures rechargeable batteries for the personal and recreational drone industry. The company signed a contract with Best Buy electronics to produce three different...

Required information The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Download the Applying Excel form and enter formulas in all...

Crash cost (slope), maximum crash time, normal time, and normal cost are provided below. The indirect costs for each project duration are: $550 (20 time units), $400 (19), $350 (18), $100 (17), and...

HHEC HAPPY HOME Environmental Cleaning 1 2 A B C D E F G H K L M N P Q R S Task 3: After you've completed the trial balance, Sophia tells you that a number of internal business transactions occurred...

1. JX A B C D E F G H L 1 Calculate the variances to budget and to last year. 2 Find both dollar and percentages. Budget Actual Last year 5 Sales $ 100,000 S 95,000 $ 85,000 6 Expenses S 75,000 S...

This is for requirement 2 A B C D E F G H - J L M N Name: G#: 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 20,000 units $60...

Need answers of Q.1- a), b) and Q.2- a), b), c), d), e), f), g), h). Retail Store Investigation b) Is the percentage of customers that use either check or cash at this retail store predictable from...

MS&E 252 Decision Analysis I Handout 29 11/18/2016 Homework Assignment #7 Due on Thursday December 1st 11:59 pm Homework Submission Logistics: You can access the MS&E 252 homework submission site at...

Is the difference column right? Is it asking for the difference between month 1 and month 2 or the difference between my budget and month 2? A B C D E F G H K L Month 2 Flows for both Month 1 Month 2...

The Stokes Company uses a voucher system and records invoices at gross. Record the following transactions in the voucher register and/or check register as appropriate: 201X Dec. 1 Voucher no. 300 was...

Table 1 MACRS Half-Year Convention Depreciation Rate for Recovery Period 3-Year 5-Year 7-Year 10-Year 15-Year 20-Year Year 1 Year 2 33.33% 20.00% 14.29% 10.00% 5.00% 3.750% 44.45 32.00 24.49 18.00...

Which procedure is an auditor most likely to use to detect a check outstanding at year - end that was not listed as an outstanding check in the bank account reconciliation? Question 5 options:...

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