This** preview**
has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*
This** preview**
has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*
This** preview**
has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*
**Unformatted text preview: **Homework #4 - Due 03/24/09 Chapter 9 Note: Round all forecasts to the nearest whole number 1. For Periods 4-6, calculate a 2 period moving average forecast Period Demand Forecast
1 68
2 75
W
LPN”
W
M
It
F : ﬁ.’ btrl-‘ giD‘l-L D3"'D~., _ 7I+7§-
f f ‘ 1 4 L F : 2 ,. ). , 7 3
h ‘l 2 2'
79+7i- _7§+‘)‘i _
F5 3 I r 7 S- E ’ 7' ’ 7 7
2. For Periods 4-6, calculate a 3 period weighted moving average forecast with Wt = .50,
Wp] = .30, W14 : .20
Period Demand Forecast
1 68
2 75
3 71
4 79 '11
5 75 ‘19
s 78 '7 § EL“: EMH'iXDf”: E7: ~§0x7l+.3X7§+,QxLX:7Q
Fe". - §"7§*'3"7q*.2¥7i: '75 3. For Periods 2-6, calculate an exponential smoothing forecast with or = .3 Period Demand Forecast
1 68 7o
2 75 M
3 71 '7 I
4 79 ‘l I
5 75 7 3
6 78 7" I Exebulvaa Fl:,‘beﬁﬂxﬁ=.3~é?+.‘7~7o:é9(
"3"7gi'7'6q17’ 5=.3»71+.7~71=7I *3
F5. , 3. 74+-‘7"7",73 FL: . 3 *7“ 7:73: 7‘/ Period Demand Forecast Trend Adiusted Forecast 1 68 70 + 2 ‘I a
2 75 (Li) 0 (a ‘l
3 71 ‘u (I? 71::
4 79 '7. l
5 75 73 ‘ 7"
6 78 ‘N l 7 g .7»(w—7o)+,2x2= 0 T3: .7(71-M)+.3xorl
T: .7(—7l'7l)+'3x(: 0 T5: .‘I(73~7I3* 3"" ’ ’ Tb: amt/Ink .3»: =I + (, grew”
5. For the following data, calculate MAD and MFE /' AC uw
Period Demand Forecast FE “ l FEL l
1 68 65 3 3
2 75 72 3 3
3 71 76 —§ 5
4 79 82 ‘ 3 3
5 75 75 0 D
6 78 8‘1 - 3 3 L
-ZFE;= - I7 =‘2IFE;
L ‘3! (3‘
5 FE; - s
M F6 5 “ A : : —, 33 6. You are trying to determine an appropriate number of pizzas to order depending on
the size of the student group. You tracked the number students as well as the number of
pizzas eaten at the last 6 events. Use the following data to create a linear regression
forecasting model to predict the number of pizzas needed. Express your answer as: y = a +bx. X Y
t
#of Students #of Pizzas X x Y X
16 6 qé use
28 11 303 757:,
18 7 '36 32v
23 8 ‘84 :24
4‘ 18 “:2:
11 3
—— ———- ._———-""" W: i 7v-
2x: :37 2,: S? [lqurziky 3mg X
éxiy x
4:; {XY. h ‘ IVZS- 123—6—2—3- IL/zS—IZIO.7. - 48S-
; J" 5" ' v v , : - - .
’5’“ 3: 367g - :3: 34?; 3mm
" 3 - 122.- _ = _ 23'
a- $1,“? :%—,—-,4sz 4, .332 MM 4
Q ' n y: ~2.)‘I+,L/85 X Using your linear regression forecasting model, predict the number of pizzas needed for a
gatherlng of 33 students. )( =- 3 3 5* V“? W k y— —2.1v + .939: = 1:37 vat/59:33: IL/Plzz4s ’ Chapter 10 Use the following information for questions 7-9. Your company has decided to analyze whether to continue managing and operating the
cafeteria, or whether to outsource it to CafeteriaCo. CafeteriaCo will charge you an
annual management fee of $300,000 plus charge you $6 per meal served. Your internal
costs to operate the cafeteria on a yearly basis are listed below (assuming 100,000 meals): Operating Expenses Direct Labor $ 320,000
Beneﬁts $ 75,000
Food $ 175,000
Indirect Labor $ 50,000
Equipment Depreciation $ 150,000
Overhead § 200,QQQ
Total Cost $ 970,000 7. If you expect to serve 100,000 meals next year, would you insource or outsource
(show your work)? Iﬁﬁwvrce : ‘7\7()/ 00 0
4‘
DV+$VV" Ga : i300,000 4‘ ié/weul x IOQO§OMalS3 ?00,000 C LLOOR 0v+ {wt/17,6, 0K Outsoux be, 3 “7,00 PW Meat IMoV/ca 3 :qJO/MctJ
8. If you expect to serve 150,000 meals next year (for insource: direct labor increases by $150,000, beneﬁts increase by $35,000 and food by $100,000), would you insource or
outsource (show your work)? 4 1 5 _
In swat : 470,000 + ((0/00) + ZQOW t Woo/000 : *1, 2%, 00 u
or (3.37/mz4l 1
vacourpa : 4' 300,000 + é/mwl“150000 mad: I <1 200’ 00 a
’ I or 33/4.te Clam: sa 0 u+5wr¢¢_ 9. Would operating a cafeteria typically be considered a “core competency” for a
company? No, “0+ 4 Col: Lomp¢+€néy Use the following information for question 10:
Summary Data for 3 possible suppliers Performance Dimension Supplier A Supplier B Supplier C Price I $550/unit 3 $350/unit 1 $420/unit
Quality 3 1% defects \ 8% defects )— 3% defects
Delivery 1 14 weeks 1 12 weeks 3 7 weeks
Rating Values 1 2 3
Price >$500/unit $400-500/unit <$400/unit
Quality >5% defects 2-5% defects <2% defects
Delivery >12 weeks 8-12 weeks <8 weeks
Wei ts Price Quality Delivery
.2 .5 .3 10. Use the weighted-point evaluation system to calculate the weighted average
performance for each supplier. Choose which supplier wins. 5vpflfer A: ’2” r.§x3 +.3’°l= 1.0 Chapter 11 Your company is purchasing 10,000 pounds of steel from both Supplier 1 and Supplier 2
this year. Each late delivery costs your company $500 and each pound of defective
material costs your company $100. Basic information on the two suppliers is provided below:
Supplier Supplier
Cost Category 1 2
Price per pound $4 $3
Defect Rate 1/200 1/30
Late
Deliveries/yr. 6 12 11. What is the Total Cost of Ownership for the year for Supplier 1 and Supplier 2? 4 4 '
Téoss. : ‘V/ILx/0,000 ”>5 ” 29.2 *10l00c9’bc**loo ‘fé* Sou3 (715,000 T60 = ‘Z/Hs’r/o 009 lbs! ‘3’: “Mono/(>5 “/00 + lir‘foo L‘é? 333
57- / I / I S Sk’le-L'i’s V (ONSI‘JJaﬁ‘oA ———->
(no: -.:> m
‘5 // Chapter 12 I g 5 k v‘l’ W:
Use the following information for questions 12-14: Every week, BosssMustang of Oakland, California, receives 15 individual shipments
from 15 different suppliers in the Los Angeles area. Each shipment weighs about 250
pounds. A Los Angeles 3 PL provider has offered to run a consolidation warehousing operation
for BosssMustang. The 3PL provider would pick up the shipments form each supplier,
process them and put them on a single truck bound for Oakland. The pickup fee would
be $100 per supplier, and the warehousing cost would be $60 per hundred-weight (per
hundred pounds). A direct truck shipment from Los Angeles to Oakland costs $ 500. 12. How much does BosssMustang’s current transportation solution cost per week? 'gSLL:fWS ‘5 :5-00 /$th\/er+: ¢7I§00 13. How much does the 3 PL provider’s transportation solution cost per week? PchV/J " (onsplfdw‘i‘fem 4' gin): men/4" . , é'
Woo>d§ +‘Igglngi§")§0/Ls+i”{S‘90: 9).,2S0 14. Which solution would you choose? How much money would you save? - : f ' ' a ‘t ' 2 4' 25,0
um, 3n «we: “mm 9.209 3. R0 4v9‘t, SK‘YM ﬁr th‘k
m __—————_.—-—-§{..,11 A /""'\i gthle A /f61:54’ 1'_ Use the following information for questions 15—17: Astro Industries of Minneapolis, Minnesota, makes weekly shipments to 20 customers in
the Dallas area. Each customer’s order weighs, on average, 200 pounds. A direct
shipment from Minneapolis to Dallas costs $1,300. A Dallas based warehousing ﬁrm has offered to run a break-bulk warehousing operation
for Astro at the cost of $95 per hundred-weight. Local deliveries to each customer would
cost $100 per customer. Astro would make 1 break-bulk shipment to the Dallas based
warehousing ﬁrm each week. 15. How much does Astro Industries’ current transportation solution cost per week? lox‘l,?oo 3 4JL'000 16. How much does the Dallas based warehousing ﬁrm’s transportation solution cost per
week? §b~¥W + Bme bv(k + LOCa/I DZ/tiuel‘scs (at ”($1,300 +m*2o*loalks‘lox*loo: {(300 + 43,300+ ‘2,Doo 3 {7,100 17. Which solution would you choose? How much money would you save? Chaos“: Dal/4S‘Laeej LVH FIT/L. <4v-k75 3 *l‘MZWJ ’ at7,!00 ; 4”IQ/9&0 ...

View
Full Document

- Spring '08
- Favre