Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- BSTA 320: ASSIGNMENT #3 [Seasonality Weight 15%} PART A The following table shows quarterly sales {in thousand units} for a product over 5 years.

image text in transcribed
image text in transcribed
- BSTA 320: ASSIGNMENT #3 [Seasonality Weight 15%} 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 109.85 [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 Year Seasonal Guilder 115 115 1o:f 110 I I II 1.023? quid\" 1'? 1:3 69 65 70 II I I Quaaner 11? 109 114 II 11a II 1.0323 an?\" 135 138 15? 13? 144 II II PART B Suppose actual quarterly sales [in thousands} for Year 6 are 11?, 64, 110, and 160 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 6. Use seasonal indexes [rounded to 4 decimal plaoes} from Part A. Report forecast answers as integers accurate to the nearestthousand. Quarter 1 forecast = I I thousand Quarter 2 forecast = I I thousand Quarter 3 forecast = III-=I thousand Quarter 4 forecast = I=I thousand Calculate the mean absolute percent error [MAPE] for the four forecasts. Use the integer forecast values you reported above. Report MARE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE = I I % Question Help: En Message inst'ucm

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

Elementary & Intermediate Algebra Functions And Authentic Applications

Authors: Jay Lehmann

2nd Edition

0321923456, 9780321923455

More Books

Students also viewed these Mathematics questions

Question

Behaviour: What am I doing?

Answered: 1 week ago