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 method Henry argued that the shop would get a better forecast with 3 a Using F1 100 and the data from problem 3, which of the two managers is right b Graph the two forecasts and the original data using Excel What does the graph reveal c Maybe the forecast accuracy could be improved even more Try additional values of 2, 4, and 5 to see if better accuracy is achieved

Question: 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

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 method. Henry argued that the shop would get a better forecast with α = .3.
a. Using F1 = 100 and the data from problem 3, which of the two managers is right?
b. Graph the two forecasts and the original data using Excel. What does the graph reveal?
c. Maybe the forecast accuracy could be improved even more. Try additional values of α = .2, .4, and .5 to see if better accuracy is achieved.

Step by Step Solution

★★★★★

3.25 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a NAME SEC 6Aug07 ALPHA 01 Tracking Absolute CumSum Day Demand Forecast Error MAD Signal Error Error ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

555-B-M-L-S-C-M (3552).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

Only a portion of the following table for exponential smoothing has been completed. Complete the missing entries using = .1. Tracking Period FMAD Signal 20 300 290 280 309

Management of the ABC Floral Shop feels that its sales are seasonal in nature with a monthly seasonal pattern and no trend. The demand data and seasonal ratios for the past three years are given as...

A school district has forecast student enrollment for several years into the future and predicts excess capacity for 2000 students. The school board has said that the only alternative is to close a...

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

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

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

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

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

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

2-d Lists Write a function called find_max that takes a two dimensional list as a parameter and returns the number of the row that sums to the greatest value. For example if you had the following...

Let U = {2,5,7, 10, 15, 21, 28, 32, 37,51}, A = {2,7,15, 37}, B = {7,15, 21, 28, 37,51}, and C = {5, 15, 21, 32,51}. () Find (AUB)NC. (b) Find AN(BNC). (c) Find (AUC)N(BUC).

The AICPA Principles Governing an Audit include which of the following categories that guide the condoct of an audir? Purpose of an audit and premise upon which an audit is conducted....

Is the current privacy protection for employee e-mail, internet, and social media use sufficient? Why or why not?

What do you think the most pressing global logistics problem is? Why?

Describe several global logistics intermediaries. Could they also be considered 3PLs?

What are foreign trade zones? What benefits do they provide?

Problem 12-6 Calculating Cost of Debt [LO 2] ICU Window, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with seven years to maturity that is quoted at 112...

Suppose you just turned 30 years old, expect to retire in 35 years at age 65, and then to live for 20 more years until age 85. Your pre-tax salary this year is $100,000 (paid at the end of this year)...

Mills Mining is considering an expansion project. The proposed project has the following features. The project has an initial cost of $607--this is also the amount which can be depreciated using the...