Question: P.S, I would apperciate if step by step how to do it on Excel, At the ABC Floral Shop, an argument developed between two of

P.S, I would apperciate if step by step how to do it on Excel,

At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with a = .1 would be the best method. Henry argued that the shop would get a better forecast with a =.3. Use Excel spread sheet for calculations and submit it with your work. Using F₁ =100 and the following data, which of the two managers is right? You must provide detailed reasoning to support your answer.

Day	Demand	Day	Demand
1	200	8	154
2	134	9	144
3	147	10	135
4	165	11	132
5	183	12	163
6	125	13	157
7	146	14	169

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 Answers and supply formulas used in Excel spreadsheet At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued...

At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with = .1 would be the best...

ans just 5 and 9 If sales this week full korecast for next week? The Man Yummy Ice Cream Company uses the exponential wwwthing method. Last week the forecast was 200 gallons of ice cream, and 90,000...

Problem 1(20 points) At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with a = 1...

Problem 1 (10 points) . A bank was getting several complaints from their clients about their accounts discrepancy. The bank management decided to use p-charts to monitor the process for account...

Problem 3 At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with a = .1 would be...

Problem 1: At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with a = .1 would be...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee....

For some years now, you've owned a small specialty bookshop in a college town. You sell some textbooks but mainly cater to a broader customer base. Your store always stocks the latest fiction,...

If a transaction gives the firm ownership of something that that has future value, the item would be reported in which section of the balance sheet? If a transaction creates an obligation to delivery...

Assume that, on 1/1/06, Matsui Co. paid $1,200,000 for its investment in 60,000 shares of Yankee Inc. Further, assume that Yankee has 200,000 total shares of stock issued. The book value and fair...

Dutput / linput Budget Vinyard Clinic has the following resource input information awailable for a routine physical eramination. Each exam noemally requires 1 . 2 5 hours of examining room time...

You wish to test the following claim (Ha) at a significance level of=0.05. Ho:=54.9 Ha:54.9 You believe the population is normally distributed and you know the standard deviation is=15.2. You obtain...