Reference no: EM135290
Problem 1
The average prices for a product in twelve stores in a city are shown below.
$1.99, $1.85, $1.25, $2.55, $2.00, $1.99, $1.76, $2.50, $2.20, $1.85, $2.75, $2.85
Test the hypothesis that the average price is higher than $1.87. Use level of significance a = 0.05.
Problem 2
A store wants to predict net profit as a function of sales for next year. Historical data for 8 years is given in the table below.
Year

Sales
(thousands of dollars)

Net Profit

1

59

5.0

2

50

8.4

3

51

9.5

4

65

8.6

5

80

1.5

6

85

2.1

7

95

1.2

8

90

1.8

(a) Make a scatter diagram for the data, using Sales for the independent variable and Net Profit for the dependent variable. Insert the trend line and add the equation and R^{2} value to the diagram.
(b) Determine the correlation coefficient. Comment on the value of the correlation coefficient.
(c) Find the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.
(d) Construct an ANOVA table and attach the summary output.
Problem 3
Last week's sales of a product at a retail store are shown in the following table:
Day

Sales (Dollars)

1

200

2

250

3

180

4

190

5

175

6

170

7

180

(a) Use the 3day moving average method for forecasting days 47.
(b) Use the 3day weighted moving average method for forecasting days 47. Use Weight 1 day ago = 4, Weight 2 days ago = 3, and Weight 3 days ago = 2.
(c) Compare the techniques using the Mean Absolute Deviation.
Problem 4
The revenue and cost functions for producing and selling quantity x for a certain company are given below.
R(x) = 12x  x^{2}
C(x) = 21 + 2x
(a) Determine the profit function P(x).
(b) Compute the breakeven quantities.
(c) Determine the average cost at the breakeven quantities.
(d) Determine the marginal revenue R'(x).
(e) Determine the marginal cost C'(x).
(f) At what quantity is the profit maximized?
Problem 5
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

$20

$10

2

B

$45

$20

4

The company will produce a minimum of 10,000 of each item. Given the number of hours, the company can sell no more than 18,000 of Item A and 20,000 of Item B. Suppose the company has 100,000 hours of assembly time available, how many of each item should it produce in order to maximize profits while meeting all necessary constraints? Give the LP Model and use both the graphical method and Excel to find the optimal solution.
Problem 6
A company purchases its merchandise for $10 and sells for each item for $20. The payoff table for the problem is given below.

Demand for Item

Alternative

Low

Medium

High

Do nothing

0

0

0

Order Low

30,000

30,000

30,000

Order Medium

10,000

50,000

40,000

Order High

10,000

40,000

80,000

Probability

0.3

0.3

0.4

What is the decision based on each of the following criteria? Show work in making the decision for each criterion.
a) EMV approach
b) EOL approach