Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART A The following table shows quarterly sales (in thousand units) for a product over 5 years. The overall sales average for the entire 5

PART A The following table shows quarterly sales (in thousand units) for a product over 5 years. The overall sales average for the entire 5 years is 91.15 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer.

Year 1 Year 2 Year 3 Year 4 Year 5 Average Seasonal Index
Quarter 1 72 69 67 69 64 68.2 0.7482
Quarter 2 146 136 147 140 144 142.60 1.5645
Quarter 3 66 75 69 76 71 71.4 0.7833
Quarter 4 86 84 83 81 78 82.4 0.904

PART B Suppose actual quarterly sales (in thousands) for Year 6 are 88, 161, 87, and 92 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 6. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = thousand Quarter 2 forecast = thousand Quarter 3 forecast = thousand Quarter 4 forecast = thousand Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE = %

I want to know the answer to PartB and how to calculate it. Quarter 1 Forecast =65 and Quarter 2 Forecast =251 are both incorrect.

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_2

Step: 3

blur-text-image_3

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

Crypto Spotlight Series Polkadot

Authors: Nott U.r. Keys

1st Edition

979-8854241342

More Books

Students also viewed these Finance questions

Question

Is Jacks dream a social venture opportunity or merely a dream?

Answered: 1 week ago