Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
X PART A The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 111.625 (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 Year Seasonal Year 1 Year 3 Average N Index Quarter 100 101 8 96.75 0.8667 Quarter 197 173 200 192 190.5 1.7066 N Quarter 83.00 0.7436 Quarter 76.25 0.6831 PART BPART B Suppose actual quarterly sales (in thousands) for Year 5 are 78, 202, 94, and 67 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = 8 x thousand Quarter 2 forecast = 345 x thousand Quarter 3 forecast = thousand Quarter 4 forecast = x 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 = 35.33 X Question Help: Message instructor Submit

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

Precalculus A Right Triangle Approach

Authors: Jogindar Ratti, Marcus S McWaters

2nd Edition

0321899814, 9780321899811

More Books

Students also viewed these Mathematics questions

Question

explain how psychosocial risks can be prevented or managed;

Answered: 1 week ago

Question

An action plan is prepared.

Answered: 1 week ago