Ops management and & Technology
Name ;
1. Mark Price the marketing manager for Speakers needs to find which variable most affects the demand for a line of speakers. He is uncertain whether the price of speakers of the advertising expenditures drive the sale of speakers. He plans to use the regression analysis to determine the relative impact price an advertising. He used 12 years of data which is given below. The output from his regression analysis also give:
|
Sales (000) |
Price Per Unit |
Advertising ($000) |
|
400 |
280 |
600 |
|
700 |
215 |
835 |
|
900 |
211 |
1100 |
|
1300 |
210 |
1400 |
|
1150 |
215 |
1200 |
|
1200 |
200 |
1300 |
|
900 |
225 |
900 |
|
1100 |
207 |
1100 |
|
980 |
220 |
700 |
|
1234 |
211 |
900 |
|
925 |
227 |
700 |
|
800 |
245 |
690 |
|
Regression Statistics |
|
|
|
|
|
|
Multiple R |
0.8550 |
|
|
|
|
|
R Square |
0.7310 |
|
|
|
|
|
Adjusted R Square |
0.6712 |
|
|
|
|
|
Standard Error |
146.6234 |
|
|
|
|
|
Observations |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
Regression |
2 |
525718.3339 |
262859.1669 |
12.2269 |
0.0027 |
|
Residual |
9 |
193485.9161 |
21498.4351 |
|
|
|
Total |
11 |
719204.2500 |
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
|
Intercept |
2191.34 |
826.08 |
2.65 |
0.03 |
322.61 |
|
Price |
-6.91 |
2.92 |
-2.37 |
0.04 |
-13.51 |
|
Advertising |
0.33 |
0.24 |
1.36 |
0.21 |
-0.21 |
a. Interpret the output from the regression analysis given above – is this a good regression model to forecast sales
b. Evaluate the regression model. Also, comment on the sample size (observations)
c. Write the regression equation showing the relationship between Sales versus Advertising and Price
d. Determine whether Price or Advertising has more impact on the forecast of Sales
e. Predict average yearly speaker sales the price was $300 per unit and Mark is planning to spend $900 thousand in Advertising.
2. Assume the network and data as follows:
a. Construct the network diagram
b. Indicate the critical path when normal activity times are used
c. Explain the procedure you would use to crash this project if you had a penalty cost per week above 15 weeks as well you had indirect costs per week
3. Ace Steel Mill estimates the Demand for steel in millions of tons per year as follows
|
Millions of t tons |
Probability |
|
10 |
10 |
|
12 |
25 |
|
14 |
30 |
|
16 |
20 |
|
18 |
15 |
a. If capacity is set at 18 Million tons what is the capacity cushion
b. What is the probability of Idle capacity
c. What is the average utilization of the plant at 18 million ton capacity
d. If it costs $8 million per ton of lost business and $80 million to build a million ton of capacity how much capacity should be built to minimize the total cost
4. Explain the reasons for
a. Carrying large levels of inventories
b. Carrying Small Levels of Inventories
5. We discussed in class how MRP (Materials Planning System) works we examined an example of the a Table with four legs and a leg assembly. We discussed the following charts.
Please explain how the Bill of Materials Explosion takes place in these charts
6.
7. Explain the following as discussed in class
Thompson manufacturing produces industrial scales for the electronics industry. Management is considering outsourcing the shipping operation to a logistics provider experienced in the electronics industry.
a. Thompson’s annual fixed costs of the shipping operation are $1,650,000, which includes costs of the equipment and infrastructure for the operation. The estimated variable cost of shipping the scales with the in-house operation is $4.70 per ton-mile.
b. If Thompson outsourced the operation to Carter Trucking, the annual fixed costs of the infrastructure and management time needed to manage the contract would be $560,000. Carter would charge $8.50 per ton-mile.
c. Currently Thompson shipped 255,000 ton-miles this year and his shipments in the last five years have increased at the rate of 18,000 ton-miles a year.
What would you recommend Thompson to do and why?
2