View the step-by-step solution to:

Page 705, problem 1 You need to use Excel or QM for these problems.

Page 705, problem 1  
You need to use Excel  or QM for these problems.  
If you use Excel for both, put them in one file (in one sheet or two sheets)
If you use QM for windows, you can copy it to Word document.  
Please write your name at the top of each of your file.
1. THE SAKI MOTORCYCLE DEALER IN THE MINNEAPOLIS- ST PAUL AREA WANTS TO MSKE AN ACCURATE FORECAST OF DEMAND FOR THE SAKI SUPER TXII MOTORCYCLE DURING THE NEXT MONTH. BECAUSE THE MANUFACTURER IS IN JAPAN, IT IS DIFFICULT TO SEND MOTORCYCLES BACK OR REORDER IF THE PROPER NUMBER IS NOT ORDERED A MONTH AHEAD. FROM SALES RECORDS, THE DEALER HAS ACCUMULATED THE FOLLOWING DATA FOR THE PAST YEAR:
MONTH                   MOTORCYCLE SALES
JANUARY                      9
FEB                          7
MAR                          10
APR                          8
MAY                          7
JUNE                         12
JUL                           10
AUG                          11
SEPT                         12
OCT                          10
NOV                           14
DEC                           16
A. COMPUTE A MONTH MOVING AVERAGE FORECAST OF DEMAND FOR APRIL THROUGH JANUARY (OF THE NEXT YEAR)
B.COMPUTE A 5-MONTH MOVING AVERAGE FORECAST FOR JUNE THROUGH JANUARY.
C. COMPARE THE TWO FORECASTS COMPUTED IN (A) ZND IN (B) USING MAD. WHICH ONE SHOULD THE DEALER USE FOR JANUARY OF THE NEXT YEAR.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question