Honeywell Bakery has been offering a new vegan cupcake and wants to know the demand in...

90.2K

Verified Solution

Question

Advance Math

Honeywell Bakery has been offering a new vegan cupcake and wantsto know the demand in the future. For the past six weeks, thedemand has been 60 cupcakes, 55 cupcakes, 75 cupcakes, 60 cupcakes,80 cupcakes, and 75 cupcakes respectively. 1. a) Using a simplefour-week moving average, calculate a forecast for next week. (4points) b) If the forecast for week 6 was 85 cupcakes, then usingsingle exponential smoothing with ?=0.2, calculate a forecast fornext week. (4 points) 2. a) Using simple linear regression,calculate the trend line for the historical data. X- Axis shouldrepresent the period (e.g. week 1 = 1, week 2 = 2, and so on),while the ? axis is demand. (12 points) b) Calculate a forecast fornext week. Is this forecast different from the ones calculated in1a and 1b? If so, please explain the difference. (10 points)

Answer & Explanation Solved by verified expert

3.8 Ratings (507 Votes)

Answer1a SImple FourWeek Moving Average Forecast Demand for the Next 7th Week Sum of Actual Demandfor Week 3 to 6 4 75 60 80 75 4 290 4 7250 CupcakesAnswer See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member