Question: Using the dress data above, calculate the following 1. Using the above data forecast year 3 using a simple 3 period moving average 2. Using

Using the dress data above, calculate the following 1. Using the above data forecast year 3 using a simple 3 period moving average 2. Using years 1 and 2 data forecast year 3, using weighted moving average, with weights of 0.6, 0.25, and 0.15 from the most recent the oldest period. 3. Using the above data forecast year 3 Calculate a forecast using the exponential smoothing method. Assume a = 0.20 4. (a) Using the information you have for years 1 & 2, calculate a monthly index. And then (b) using year 1 and 2 data Determine the slope and intercept of line equation using linear regression. Then calculate the new annual demand and forecast the monthly demand 5. Using the actual Year-3 numbers to check your forecast accuracy, by using the forecasting error to calculate CFE. MSE. MAD. MAPE 6. Determine which forecasting method is best for this problem. Using the actual Year-3 numbers to check your forecast accuracy. Please show work and accurate answers.

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!

Matthew, Inc., owns 3 0 percent of the outstanding stock of Lindman Company and has the ability to significantly influence the investee s operations and decision making. On January 1 , 2 0 2 1 , the...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

During year three, Pricilla starting collecting data on why people were buying dresses. She and the people working in the store would ask whether the purchase was for an event (homecoming, party,...

01 9 10 11 12 13 14 15 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this previous...

Can you do the part E only? please shoe step taken Data Set 1 Period Actual 200 200 600 300 100 400 600 600 400 10 470 11 430 12 440 Noc vooAWN- Using data set 1, next sheet titled HW1, calculate the...

Please solve it 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...

las must be used for den Q1 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this...

give solutions and excel formulas 8 Q1 9 10 11 12 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series...

I attached the answer key please show me the formulas to find the answer IN EXCEL please!!! Using the numbers in the chart below, calculate the following: 1. Three-porlod moving average for Porlod 8....

Find the critical points of: f(x, y) = eV Select one: O None 0 (-1,1) & (1, =1) O (t, t) : teR O (t,-t) : te R

Ware houzer owns a renewable forest land for growing pine trees. Trees can fall into one of four categories depending on their age: baby (0-5 years), young (5-10 years), mature (11-15 years), and old...

Find the most general antiderivative of the function. ( Check your answer by differentiabon. Use C for Bre constant of th f ( x ) = 9 x 2 8 c o s x

Would you expect the elastic modulus computed from a bending test to be exactly the same as that found from a tension test? Discuss.

A BP A and B represent a section of a line in 3d space. (So a line goes through them.) P is on an imaginary plane, which is perpendicular to the line which goes through on A and B. (So the A-B vector...

A physics student is sitting in a parked car just off a busy roadway. She measures the traffic noise and finds that shutting the car windows reduces the intensity of the traffic sound to 1.0% of what...

Find The Glancing Angle Of The Sylvine Crystal In Which A Neutron Beam Of Kinetic Energy 0.04 EV Is Diffracted At The Plane Of (100). Here, The Observed Spectrum Bragg's First Order And The Distance...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

CASE 16 Explain and interpret the major business activitiesnamely, planning, financing, investing, and operating. Aim your report at a general audience such as shareholders and employees. Include...

CASE 17 As controller of Tallman Company, you are responsible for keeping the board of directors informed about the companys financial activities. At the recent board meeting, you presented the...

CASE 14 Jose Sanchez owns and operates Western Gear, a small merchandiser in outdoor recreational equipment. You are hired to review the three most recent years of operations for Western Gear. Your...