Work through the problems in Excel. Enter your answers in the following attachment labeled week 2 questions 1-11. Attach your Word file or Excel spreadsheet where indicated. YOU MUST SUBMIT YOUR EXCEL
Work through the problems in Excel. Enter your answers in the following areas below. Attach your Word file and Excel spreadsheet where indicated. YOU MUST SUBMIT YOUR EXCEL SPREADSHEET OR OTHER WORK IN ORDER TO RECEIVE CREDIT FOR THE ASSIGNMENT. FAILURE TO SUBMIT THE EXCEL SPREADSHEET OR OTHER WORK WILL RESULT IN A GRADE OF 0.
You will only have access to the problems once. Therefore, complete all of the problems in Excel, and word doc then enter your answers and upload your Excel file.
Top of Form
Flag this Question
Question 1 2 pts
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows.
Month | Sales (000) |
Feb | 19 |
Mar | 18 |
Apr | 15 |
May | 20 |
Jun | 18 |
Jul | 22 |
Aug | 20 |
a. Plot the monthly data in Excel. Copy your graph from Excel and paste it in the space below.
HTML Editor Keyboard Shortcuts
Bottom of Form
0 words
Flag this Question
Question 2 6 pts
b. Forecast September sales volume using each of the following. Round all answers to two decimal places.
1. the naive approach
2. a five-month moving average
3. a weighted average using 0.60 for August, 0.30 for July, and 0.10 for June
4. exponential smoothing with a smoothing constant equal to 0.20, assuming a March forecast of 19(000)
5. a linear trend equation (Use Excel to generate the equation of the trendline and then calculate the forecast.)
Flag this Question
Question 3 2 pts
c. Which method seems least appropriate? Why?
d. What does the use of the term "sales" rather than "demand" presume?
Provide answers to both of these questions in the space below.
HTML Editor Keyboard Shortcuts
0 words
Flag this Question
Question 4 10 pts
A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 88% of capacity; actual usage was 89.6% of capacity. A smoothing constant of 0.1 is used. Round all answers to two decimal places.
a. Prepare a forecast for September.
b.. Assuming actual September usage of 92%, prepare a forecast October usage.
Flag this Question
Question 5 10 pts
An electrical contractor's records during the last five weeks indicate the number of job requests:
Week | |||||
Requests | 20 | 22 | 18 | 21 | 22 |
Predict the number of requests for week 6 using each of these methods. Round all answers to two decimal places.
a. naive
b. a four-month moving average
c. exponential smoothing with alpha=0.30; use 20 for week 2 forecast.
Flag this Question
Question 6 3 pts
Air travel on Mountain Airlines for the past 18 weeks was:
10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |||||||||
405 | 410 | 420 | 415 | 412 | 420 | 424 | 433 | 438 | 440 | 446 | 451 | 455 | 464 | 466 | 474 | 476 | 482 |
a. Explain why an averaging technique would not be appropriate for forecasting.
HTML Editor Keyboard Shortcuts
0 words
Flag this Question
Question 7 7 pts
b. Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. Explain your rationale as well as provide your forecasts.
HTML Editor Keyboard Shortcuts
0 words
Flag this Question
Question 8 20 pts
Download the file Unit 2 - Individual Assignment - Linear Regression, Follow the directions, and submit when complete. Document is also located in Files on the Student View folder. Use the data analysis toolpak function within Excel to generate the equation of the line.
a. linear equation of trendline y = x + (Round to three decimal places.)
b. forecast for June of year 2 (Round to two decimal places.)
c. number of customer service representatives needed for June of year 2
Flag this Question
Question 9 0 pts
Upload your Excel spreadsheet and any other supporting documents for this assignment. Failure to submit your work will result in a grade of 0 for this entire assignment.
Upload
Flag this Question
Question 10 0 pts
Upload your Word file for the linear regression problem.
Upload
Flag this Question
Question 11 0 pts
If your Excel work for the linear regression problem is in a separate Excel file from the other problems, then upload the second Excel file here.
Upload