QSO/510 QSO510 QSO 510 Final Exam Quantitative Analysis for Decision Making

QSO/510 QSO510 QSO 510 Final Exam Quantitative Analysis for Decision Making

QSO 510 Quantitative Analysis for Decision Making
Final Exam - Instructor: Thanarerk Thanakijsombat
Instructions
1. Answer all questions in the context of the problem. General answers are not expected. Type or paste your answers in this document.
2. The final exam will be due on Saturday 06/16 by 11.59 PM EST. Submit the exam via the Final Exam link.
3. You must show all steps including formulas used and all calculations done to arrive at the final answers. Incomplete solutions will receive partial credit.
4. Use at least four significant digits at all intermediate steps. Round off the final answers appropriately. Note: 0.0042 is only two significant digits as leading zeros are not considered significant. 0.004200 is four significant digits as trailing zeros are considered significant.
5. Use the rules of rounding correctly at all steps including the final answers. Note: 0.12340 through 0.12344 are rounded down to 0.1234, whereas 0.12345 through 0.12349 are rounded up to 0.1235.
6. You are welcome to ask any questions you have on the problems. Please do not ask any questions relating to the solution of the problem.
7. Use your own textbook, notes, and calculator.

(For Instructor’s use)
Problem Points
1 30
2 30
3 30
4 30
Total (four problems)








Problem 1: Module 4 (30 points)
The personnel manager for a large corporation feels that there may be a relationship between absenteeism and the age of workers. The manager would like to use the age of a worker to develop a model to predict the number of days absent during a calendar year. A random sample of 5 workers was selected with the results presented below:

Worker Age in years (X) Days absent (Y)


1 27 15
2 61 6
3 37 10
4 23 18
5 46 9
=
=
SSXX = SSYY = SS XY =

a) Compute , , SSXX , SSYY , SS XY in the table above.
b) Determine the sample correlation coefficient between age and number of days absent.
c) Determine the regression equation using number of days absent as the dependent variable.
d) Compute the standard error of the estimate se.














Problem 2: Module 6 (30 points)
The Italian General’s Pizza Parlour is a small restaurant catering to patrons with a taste for European pizza. One of its specialties is Italian Prize pizza. The manager must forecast weekly demand for these special pizzas so that he can order pizza shells weekly. Recently, the demand has been as follows:

Week Number of Pizzas Sold
June 2-8 48
June 9-15 62
June 16-22 49
June 23-29 55
June 30-July 6 51
July 7-13 59


a) Forecast the demand for pizzas for all weeks from June 23 to July 20. Use a three-month weighted moving average with weights of 0.2, 0.3, and 0.5. Note: Show all calculations. Use the largest weight with the most recent data.

Week Number of Pizzas Sold Forecast
June 2-8 48
June 9-15 62
June 16-22 49
June 23-29 55
June 30-July 6 51
July 7-13 59
July 14-20

b) Forecast the demand using exponential smoothing with alpha = 0.2 for all weeks from June 16 to July 20. Use the sales for the week June 2-8 as the starting forecast for the week June 9-15 as given. Note: Show all calculations.
Week Number of Pizzas Sold Forecast
June 2-8 48
June 9-15 62 48
June 16-22 49
June 23-29 55
June 30-July 6 51
July 7-13 59
July 14-20
c) Which of the methods in parts (a) and (b) produces better forecasts for the weeks 4-6? Answer on the basis of a measure of mean absolute deviation (MAD).

Week Number of Pizzas Sold
June 23-29 55
June 30-July 6 51
July 7-13 59




Problem 3: Module 9 (30 points)
Adele Weiss manages the campus flower shop. Flowers must be ordered three days in advance from her supplier in Mexico. Advance sales are so small that Weiss has no way to estimate the demand for the red roses. She buys roses for $15 per dozen and sells them for $40 per dozen. Pay-off table for the problem is given below. Apply each of the criteria given below to determine the decision Weiss should make.
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing 0 0 0
Order 25 dozen 625 625 625
Order 60 dozen 100 1500 1500
Order 130 dozen -950 450 3250

a) Optimistic or Maximax Criterion
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing 0 0 0
Order 25 dozen 625 625 625
Order 60 dozen 100 1500 1500
Order 130 dozen -950 450 3250
Decision:

b) Pessimistic or Maximin Criterion
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing 0 0 0
Order 25 dozen 625 625 625
Order 60 dozen 100 1500 1500
Order 130 dozen -950 450 3250
Decision:

c) Equally likely or Principle of Insufficient Reason Criterion
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing 0 0 0
Order 25 dozen 625 625 625
Order 60 dozen 100 1500 1500
Order 130 dozen -950 450 3250
Decision:

d) Criterion of realism with coefficient of realism = 0.6
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing 0 0 0
Order 25 dozen 625 625 625
Order 60 dozen 100 1500 1500
Order 130 dozen -950 450 3250
Decision:

e) Minimax Regret Approach
Demand for Red Roses
Alternative Low (25 dozen) Medium (60 dozen) High (130 dozen)
Do nothing
Order 25 dozen
Order 60 dozen
Order 130 dozen
Decision:




Problem 4: Module 8 (30 points)
The Exeter Company produces two basic types of dog toys. Two resources are crucial to the output of the toys: assembling hours and packaging hours. Further, only a limited quantity of type 1 toy can be sold. The linear programming model given below was formulated to represent next week’s situation.
Let, X1 = Amount of type A dog toy to be produced next week
X2 = Amount of type B dog toy to be produced next week
Maximize total contribution Z = 35 X1 + 40 X2
Subject to
Assembling hours: 4 X1 + 6 X2  48
Packaging hours: 2 X1 + 2 X2  18
Sales Potential: X1 < 6
Non-negativity: X1  0, X2  0
Use Excel Solver OR graphical method to find the optimal solution of the problem. If you use Excel Solver, please paste your output here.
Note 1: Place X1 along the horizontal axis and X2 along the vertical axi.
Note 2: Clearly mark the feasible region on the graph.
Note 3: Find the points of intersection points algebraically.
Note 4: Clearly show all steps to find the optimal solution by the graphical method.