Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

if you can show this in excel that would be great! thanks in advance! A food truck selling mac and cheese wants to prepare forecasts

if you can show this in excel that would be great! thanks in advance!

image text in transcribed
A food truck selling mac and cheese wants to prepare forecasts of demand for their popular mac and cheese entree. They are considering a simple exponential smoothing forecast with alpha = 0.4. The following shows the demand and forecasts for the last 5 weeks. Week Actual Sales Exponential Smoothing Forecast alpha = 0.4 295 349 295 W N 339 317 356 326 325 338 a. What is the exponential smoothing forecast for Week 6? b. If the actual sales turns out to be 350, then what is the forecast error for Week 6

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

Step: 3

blur-text-image

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

A First Course In Differential Equations

Authors: Kumari Vandana

1st Edition

9353147123, 9789353147129

More Books

Students also viewed these Mathematics questions