Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve it AutoSav Review View Draw Page Layout Formulas Data Home Insert ab General V 12 A A E x Delete v Calibri

Please solve it

image text in transcribed
AutoSav Review View Draw Page Layout Formulas Data Home Insert ab General V 12 " A" A E x Delete v Calibri (Body) Conditional Format Cell $ ~ % 9 68 98 Formatting as Table Styles Format v Paste BIU V LAV TextBox 2 x v fx K M N C D E F G H 1 J 2 student Name: By submitting this assignment you acknowledge you will not give or receive any unauthorized help, and that all work will be your own. 3 student Number: The college's definition of cheating is: obtaining or attempting to obtain, or aiding another to obtain, credit for work or improvement in evaluation of 4 In order to get graded for this work, you must use formulas performance, by dishonest or deceptive means. 5 for all of your calculations. Insert your answers in the You agree to abide by Seneca's Academic Integrity Policy and you shaded areas indicated. understand any violations of academic integrity will be subject to the 6 C 8 9 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 10 experimenting with some time series analysis. Using this previous weekly demand, calculate the following 11 forecasts for each period possible. A) Two - Period Simple moving average B) 3 Period Weighted moving 12 average using weights of .5, .3,.2, C) Four-period weighted moving average with weights of .4,.3,.2,.1 and 13 D) Exponential Smoothing forecast using an Alpha of .15 and a Week 1 forecast of 2100 units. Round all 14 forecasts to whole numbers. | 15 16 Week Demand SMA WMA WMA EXP Sm .15 17 2160 2 Period .5, .3, .2 4,.3,.2,.1 2100 18 2 2240 19 2365 20 2210 21 5 2180 22 6 2155 23 2260 24 8 2240 25 9 2205 26 10 2380 27 11 2340 28 2310 29 30 Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, 31 Mean Squared Error and Mean Absolute Percent Error. 32 33 Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. Round each answer to one decimal place. 34 35 MAD MSE MAPE 4 Assignment 1 + Ready JUN 11 city

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

Business Writing For Hospitality

Authors: Peter Nyhiem, Vivienne J Wildes

1st Edition

0131715712, 9780131715714

More Books

Students also viewed these General Management questions

Question

The feeling of boredom.

Answered: 1 week ago