Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FabricSpace Manufacturing has the following data for their sales. Use the following data to answer the Questions in ONE SHEET: Copy these two columns for

FabricSpace Manufacturing has the following data for their sales.
Use the following data to answer the Questions in ONE SHEET: Copy these two columns for every answer (for Q 1 to 5) in a vertical format for me to verify
QUESTIONS ::: ALL answers to 3 Decimal places
2015 Actual 1 Use the Naiive method to forecast for FEB to Aug for 2016
JAN 1452 2 Calculate a 2-period moving average forecast
FEB 2075 3 Calulate a weighted forecast for 2016 with 0.5, 0.3, 0.2
MARC 2345 4 Calculate all the Forecast for 2016 with a smoothing constant = 0.32 and the Forecast for Feb = 2150
APRIL 1500 5 Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts
MAY 2701 6 On the next sheet, Comment in a medium paragraph on the usefulness of these measures and in another medium paragraph as to how the company can benefit by sticking to these forecasts.
JUNE 3000
JULY 3016

CAN I PLEASE GET ANSWER IN AN ECXEL SHEET.

THANK YOU

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

Transportation A Global Supply Chain Perspective

Authors: Robert A. Novack, Brian Gibson, Yoshinori Suzuki, John J. Coyle

9th Edition

1337406643, 9781337406642

Students also viewed these General Management questions

Question

=+What are bottlenecks in human information processing?

Answered: 1 week ago

Question

=+How many windows are in your house?

Answered: 1 week ago