Question: hi, may I have some help attempting this question? this is an Excel document. I was not sure the best way to put it on

hi,

may I have some help attempting this question?

this is an Excel document. I was not sure the best way to put it on here but if you would like a picture of the excel please let me know. it is the exact same column and order just in Cells.

thanks

hi, may I have some help attempting this question? this is

an Excel document. I was not sure the best way to put

it on here but if you would like a picture of the

excel please let me know. it is the exact same column and

$order just in Cells. thanks Year5Year6123456789101112123456789101112565895116887652280266563521598986346823063205898944486089800796681236546765965006279645971349654 Year7Year8123456789101112123456789101112531881389162975357957551926875425850961163419315848150037716840682506977606064567119763281867517 Year9Year10123456789101112123456789101112799753518909714293025013752668926416848477268043759391976608604751458118888086246599681896117687 \begin{tabular}{ccr} & Month &$

$\multicolumn{2}{c}{ Actual } & Demand \\ & 1 & 6202 \\ &$

Year5Year6123456789101112123456789101112565895116887652280266563521598986346823063205898944486089800796681236546765965006279645971349654 Year7Year8123456789101112123456789101112531881389162975357957551926875425850961163419315848150037716840682506977606064567119763281867517 Year9Year10123456789101112123456789101112799753518909714293025013752668926416848477268043759391976608604751458118888086246599681896117687 \begin{tabular}{ccr} & Month & \multicolumn{2}{c}{ Actual } & Demand \\ & 1 & 6202 \\ & 2 & 6882 \\ & 3 & 5427 \\ & 4 & 6191 \\ Year 1 & 5 & 9787 \\ & 6 & 9487 \\ & 7 & 7689 \\ & 8 & 6979 \\ & 9 & 7474 \\ & 10 & 6080 \\ & 11 & 9559 \\ & 12 & 6007 \\ & 1 & 7740 \\ & 2 & 7549 \\ & 3 & 8309 \\ & 4 & 9810 \\ & 4 & 7612 \\ & 5 & 5364 \\ & 6 & 7428 \\ & 6 & 7409 \\ & 6 & 8478 \\ & 7 & 9299 \\ & 8 & 9094 \\ & 9 & 7846 \end{tabular} Forecast the demand for year 12 based on following forecasting approaches. Which one do you recommend? (Note: Use MSE approach to compare them) a) Exponential Smoothing with Trends (Alpha =0.3, Delta =0.4)(F1=5000,T1=400) b) Forecast by considering additive Seasonality approach Year3Year4123456789101112123456789101112571153936933657563628837533192756721505268636810517283579009707973695921536652558242595694617205

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

SMG Sound Co. must select a manufacturing process for its new speaker sets, SM-5, from two different process alternatives ( X and Y ). Each speaker set will be sold for $120. The following cost data...

If anyone would be able to help with chapter 5 Smithville that would be great. attached is a copy of the guidelines. The journal entries and such in an excel document would be best way to get this to...

Need help with Management Accounting assignment (need excel part completed)!!! AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND...

Hi I am in desperate need of help for my assignment. I have finished everything on the assignment except for Part B (1) on page 6. They are only looking for concise answers. The headings for the...

Looking for accounting tutor to complete this assignment. Need and A grade for reasonable price given easy deadline. AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER...

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

Could you answer part these questions based on the excel file you completed? You can look at the PDF for part B instructions QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of...

look into the transcription of the videos that we coded for the Dominance project and identify if there are any errors (grammar and spelling and etc): Baseline 266 Baseline266 Yeah. Hello. My name is...

look into the transcription of the videos that we coded for the Dominance project and identify if there are any errors (grammar and spelling and etc): 1673015005057.mp4 Baseline 181 Baseline181 Hi,...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

1 WILMINGTON UNIVERSITY LIBRARY Business Continuity Plan (BCP) and Disaster Recovery Plan (DRP) 2 WILMU LIBRARY SERVICES 20,000 student population served 13 physical locations of access to university...

1) Research paper should contain information of RFID standards and its details in construction industry 2) Paper must contain an introduction general description of the industry that the RFID...

Explain each of the following FOUR (4) considerations when investing surplus cash: Risk, Maturity, Liquidity, Return. 2 What are the advantages of investing in the common stock rather than the...

Walker Cruising Co . operates a pontoon boat rental business. Assume he boat rert tor 5 0 5 per 1 un inver What is the contribution margin ratio? A . 1 4 % B . 8 6 % C . 5 % D . 7 0 %

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...