The document is a test for a quantitative methods course containing 6 multiple choice questions. The questions refer to exhibits providing data on sales forecasting using techniques like moving averages, Holt's method, and Winter's method. Students are asked to interpret the data, exhibits, and formulas to select the correct multiple choice answer for each question.
The document is a test for a quantitative methods course containing 6 multiple choice questions. The questions refer to exhibits providing data on sales forecasting using techniques like moving averages, Holt's method, and Winter's method. Students are asked to interpret the data, exhibits, and formulas to select the correct multiple choice answer for each question.
The document is a test for a quantitative methods course containing 6 multiple choice questions. The questions refer to exhibits providing data on sales forecasting using techniques like moving averages, Holt's method, and Winter's method. Students are asked to interpret the data, exhibits, and formulas to select the correct multiple choice answer for each question.
The document is a test for a quantitative methods course containing 6 multiple choice questions. The questions refer to exhibits providing data on sales forecasting using techniques like moving averages, Holt's method, and Winter's method. Students are asked to interpret the data, exhibits, and formulas to select the correct multiple choice answer for each question.
H Content Module 6 Applications 3 Take Test: Chapters 11 & 13 Individual Quiz ?
TSQUANTI R02: Quantitative
Take Test: Chapters 11 & 13 Individual Quiz
Methods for Managers Term 5 19- Test Information 20 Description Instructions Timed Test This test has a time limit of 1 hour.You will be notified when time expires, and you may continue or submit. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Multiple Not allowed. This test can only be taken once. Attempts Force Once started, this test must be completed in one sitting. Do not leave the test before Completion clicking Save and Submit. Your answers are saved automatically.
Remaining Time: 27 minutes, 33 seconds.
Question Completion Status:
QUESTION 1 2 points Saved
Exhibit 11.1
The following questions use the data below.
Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages.
A B C
1 Number of 4-Month
2 Time Period Cars Sold Moving Avg.
3 1 70
4 2 80
5 3 66 6 4 74
7 5 64
8 6 76 71.00
9 7 72 70.00
10 8 82 71.50 Click Save 11 and Submit to9 save and submit. 82 Click Save All Answers to save all answers. 73.50
12 10 76 78.00
13 11 84 78.00
14 12 80 81.00
15 13
16 14
17
18 MSE 40.59
Refer to Exhibit 11.1. What formula should be entered in cell C13 to compute the 4-month moving average forecast for month 11? a. =AVERAGE(A9:A12) b. =AVERAGE(B9:B12)/4 c. =AVERAGE(B7+B10) d. =AVERAGE(B9:B12)
QUESTION 2 2 points Saved
Exhibit 11.1
The following questions use the data below.
Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages.
A B C
1 Number of 4-Month
2 Time Period Cars Sold Moving Avg.
3 1 70
4 2 80
5 3 66
6 4 74
7 5 64
8 6 76 71.00 9 7 72 70.00
10 8 82 71.50
11 9 82 73.50
12 10 76 78.00
13 11 84 78.00
14 12 80 81.00
15 13
16 14
17
18 MSE 40.59
Refer to Exhibit 11.1. What Excel function will compute the mean squared error in cell C18 of the spreadsheet? a. =SUMXMY2(B7:B14,C7:C14)/COUNT(C7:C14) b. =SUMXMY2(B7:B14,C7:C14) c. =SUMPRODUCT(B7:B14,C7:C14)/COUNT(C7:C14) d. =SUMXMY2(B3:B14,C3:C14)/COUNT(C3:C14)
QUESTION 3 2 points Saved
Exhibit 11.1
The following questions use the data below.
Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages.
A B C
1 Number of 4-Month
2 Time Period Cars Sold Moving Avg.
3 1 70
4 2 80
5 3 66
6 4 74
7 5 64
8 6 76 71.00
9 7 72 70.00
10 8 82 71.50
11 9 82 73.50 12 10 76 78.00
13 11 84 78.00
14 12 80 81.00
15 13
16 14
17
18 MSE 40.59
Refer to Exhibit 11.1. What would be the forecasted values for time periods 13 and 14? a. 81.00 and 79.50. b. 78.00 and 78.00. c. 80.50 and 80.00. d. 80.50 and 80.13.
QUESTION 4 2 points Saved
Exhibit 11.7
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data.
A B C D E F G H I J
1 Time Actual Base Predicted
2 Year Qtr Period Sales Level Trend Sales
3 1 1 1 284 alpha 0.5
4 2 2 184 beta 0.5
5 3 3 365 287.0 14.0 209.0
6 4 4 492 396.5 61.8 301.0
7 2 1 5 485 471.6 68.4 458.3
8 2 6 277 408.5 2.7 540.1
9 3 7 606 508.6 51.4 411.2
10 4 8 722 641.0 91.9 560.0
11 3 1 9 763 747.9 99.4 732.9
12 2 10 593 720.2 35.8 847.3
13 3 11 912 834.0 74.8 756.0
14 4 12 1145 1026.9 133.9 908.8
15
16 31877.0
Refer to Exhibit 11.7. What formula should be entered in cell E4 to compute
the base level when using Holt's method? a. =$J$3*D4+(1-$J$3)*(E3+F3) b. =$J$4*(E4-E3)+(1-$J$4)*F3 c. =$J$3*G4+(1-$J$3)*(E3+F3) d. =$J$4*D4+(1-$J$4)*(E3+F3)
QUESTION 5 2 points Saved
Exhibit 11.8
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data.
A B C D E F G H
1 Time Actual Base Seasonal Predicted
2 Year Qtr Period Sales Level Trend Factor Sales
3 1 1 1 284
4 2 2 184
5 3 3 365
6 4 4 492
7 2 1 5 485
8 2 6 277 413.5 20.5 0.567 217.9
9 3 7 606 457.2 27.4 1.124 478.2
10 4 8 722 484.9 27.5 1.486 719.7
11 3 1 9 763 579.5 47.6 0.942 461.1
12 2 10 593 710.9 72.8 0.594 355.5
13 3 11 912 789.2 74.4 1.127 881.0
14 4 12 1145 845.0 68.8 1.473 1283.0
15
16 MSE 28,474.73
17 alpha 0.2
18 beta 0.3
19 gamma 0.1 20
Refer to Exhibit 11.8. What formula should be entered in cell G3 to compute
the seasonal factor for year 1 Quarter 1? a. =D3/AVERAGE($D$3:$D$14) b. =D3/SUM($D$3:$D$6) c. =D3/AVERAGE($D$3:$D$6) d. =D3/COUNTIF($D$3:$D$6)
QUESTION 6 2 points Saved
Joe's Copy Center has 10 copiers. They break down and require service quite often. Time between breakdowns follows an exponential distribution for each copier. The repair person services machines as quickly as possible, but the service time follows an exponential distribution. What type of system is it? a. M/M/1 with Finite Population b. M/M/1 c. M/M/10 d. M/M/1 with Finite Queue
QUESTION 7 2 points Saved
The M/D/1 model results can be derived from which of the following systems? a. M/M/2 with finite queue length. b. M/G/1 with μ = 0 c. M/M/1 with λ = 0 d. M/G/1 with σ = 0
QUESTION 8 2 points Saved
The customer service desk at Joe's Discount Electronics store receives 2 customers per hour on average. On average, each customer requires 15minutes for service. The customer service desk is staffed by a single person. What is the average time a customer spends in the customer service area if modeled as an M/M/1 queuing system? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Arial 3 (12pt)
The average time a customer spends in the customer service area is 15 minutes.
Path: p Words:14 QUESTION 9 2 points Saved
The customer service desk at Joe's Discount Electronics store receives 2 customers per hour on average. On average, each customer requires 15minutes for service. The customer service desk is staffed by a single person. What is the average number of customers in the customer service area, if modeled as an M/M/1 queuing system? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Arial 3 (12pt)
The average number of customers in the customer service area is 1.
Path: p Words:12
QUESTION 10 2 points Saved
What is the mean arrival rate based on the following 8 arrival rate observations?
Number of arrivals per hour: 6, 5, 3, 4, 7, 6, 4, 5
