Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Leslie owns a bakery, and she has collected data on the last nine weeks of demand for her cupcakes. She uses three forecasting methods: a

Leslie owns a bakery, and she has collected data on the last nine weeks of demand for her cupcakes. She uses three forecasting methods: a 3-week moving average; a 2-week weighted moving average with wt =0.6 and wt-1=0.4; and exponential smoothing with alpha =0.5.
\table[[,A,B,C,D,E,F,G],[1,Week,Demand,\table[[3-Week Moving],[Average]],\table[[2-Week Weighted],[Moving Average]],\table[[Exponential],[Smoothing]],Constants],[2,1.,434.,,,434,,],[3,2,359,,,434,Wt-1,0.4],[4,3.,466,,B,396.50,Wt,0.6],[5,4.,550,419.67,423.20,431.25,,],[6,5.,601,458.33,516.40,490.63,Alpha,0.5],[7,6,456,539.00,580.60,545.81,,],[8,7.,444,535.67,514.00,500.91,,],[9,8,320,500.33,448.80,472.45,,],[10,9,519,406.67,369.60,+2,,],[1,10||,???,A,439.40,C,,]]
Page 5:
5
Page 6:
What is the value that should be in the cell labeled "A"?
419.50
453.50
480.89
406.67
427.67
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethics Theory and Contemporary Issues

Authors: Barbara MacKinnon, Andrew Fiala

8th edition

9781305162846, 1285196759, 1305162846, 978-1285196756

More Books

Students also viewed these General Management questions