Response to the following Problems:
1. Suppose a manufacturing company makes a certain item. The time to produce each item is normally distributed around a mean of 157 minutes with a standard deviation of 46 minutes.
(a) What proportion of the items will take more than 2 hours to make?
(b) What proportion of the items will take between 160 and 200 minutes to make?
2. The average prices for a product in 12 stores in a city are shown below.
$2.99, $2.15, $3.25, $3.55, $3.00, $2.99, $2.66, $3.50, $3.20, $2.15, $3.75, $3.85
Test the hypothesis that the average price is higher than $2.57. Use level of significance α = 0.05.
3. A store wishes to predict net profit as a function of sales for the next year. The following table gives the years 1998 to 2005.
|
Year
|
Sales
(thousands of dollars)
|
Net Profit
|
|
1998
|
51
|
7
|
|
1999
|
55
|
9.2
|
|
2000
|
65
|
9.6
|
|
2001
|
82
|
-3
|
|
2002
|
75
|
2.5
|
|
2003
|
71
|
3.2
|
|
2004
|
82
|
-2.3
|
|
2005
|
81
|
-2.6
|
(a) Graph the points from 1998 through 2005 on a scatter diagram using Sales as the independent variable and Net Profit as the dependent variable.
(b) Draw the regression line on the graph you constructed in Part (a).
(c) What is the value of the coefficient of determination for this regression model? Comment on the strength of the regression line for this model.
(d) What is the predicted net profit for 2006 if sales are expected to be 105?
4. Last week's sales of iMac computers at an Apple Store in Oklahoma City, OK, are shown in the following table:
|
Day
|
Sales (Dollars)
|
|
1
|
160
|
|
2
|
150
|
|
3
|
200
|
|
4
|
215
|
|
5
|
195
|
|
6
|
205
|
|
7
|
220
|
(a) Use the exponential smoothing with α = 0.25 to predict the most immediate future sales.
(b) Use the 3-day weighted moving average method for forecasting days 4-7. Use Weight 1 day ago = 3, Weight 2 days ago = 5, and Weight 3 days ago = 2.
(c) Compare the techniques using the mean absolute deviation (MAD).
5. The following table shows six years of average annual cost-of-living index data:
|
Year
|
Annual Cost of Living Index
|
|
2008
|
102.8
|
|
2009
|
101.4
|
|
2010
|
111.9
|
|
2011
|
124.3
|
|
2012
|
138.6
|
|
2013
|
135.2
|
(a) Forecast the average annual food price index for all years from 2008 to 2013. Use a 3-year weighted moving average with weights of 0.6, 0.3, and 0.1. Use the largest weight with the most recent data.
(b) Forecast the average annual food price index using exponential smoothing with α = 0.4 for all years from 2008 to 2014. Use the rate for 2008 as the starting forecast for 2008.
(c) Which of the methods in parts (a) and (b) produces better forecasts for the 3 years from 2011 to 2013? Answer on the basis of mean square error (MAD).
6. A company manufactures two products, Product A and Product B. The wholesale price and manufacturing cost of each product are shown below.
|
Item
|
Price
|
Cost
|
Assembly Times (hr)
|
|
A
|
$70
|
$10
|
10
|
|
B
|
$70
|
$20
|
5
|
The company will produce a minimum of 2,000 units of type A and 5000 units of type B. Suppose the company has a budget of $200,000 and 80,000 hours of assembly time available.
(a) How many of each item should it produce in order to maximize profits while meeting all necessary constraints? Give the LP model and use the graphical method to find the optimal solution.
Number of units of item A: __
Number of units of item B: ___
The Maximum Profit: ___
(b) Solve the problem by using the Excel Solver. Then without solving the problem again, use the Excel reports to answer the following question. You must state exactly what portion of the Excel reports you have used.
If an additional 4000 hours are added to the assembly line, how much will the optimal profit increase as a consequence?
7. A commercial real estate company is evaluating a proposed warehouse. The proposed site is near a rail terminal, but the state government may extend the highway to the area. In addition, the federal government is considering rebuilding the local port facilities. Below is the payoff table in monthly profit depending upon what government actions are taken. Based on the following criteria, what are the correct choices for terminal rental?
(a) Equally likely or principle of insufficient reason criterion
(b) Minimax Regret criterion
(c) Find the EVPI (The expected value of perfect information). Use equal probabilities for the states.
|
Warehouse size (ft2)
|
Development projects
|
|
Rail terminal only
|
Highway expansion
|
Port rehabilitation
|
All
|
|
15000
|
10
|
25
|
35
|
40
|
|
30000
|
15
|
25
|
40
|
50
|
|
60000
|
20
|
30
|
45
|
75
|
|
100000
|
15
|
20
|
40
|
90
|