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: **KEV Homework #4 — Due 10/28/08 Chapter 9 Note: Round all forecasts to the nearest whole number 1. For Periods 4-6, calculate a 3 period moving average forecast Period Demand M
1 68
2 75
3 73
4 79 77'
5 78 76 h s 85 77 2 D . 2 D F 7; 1=l 604-. . F : 1:, ‘I-i _ D3lbz+bl _. 73*7S1’ é? : 7L
H M Y 3 ’ 3 ' 3
74+ 72+7f _ M 78+79+73
p : 3 - 797 a 74 E: 3 : 747: 77 2. For Periods 4-6, calculate a 3 period weighted moving average forecast with Wt = .45,
Wpl = .3, W14 = .25 Period Demand Forecast
1 68
2 75
3 73
4 79
5
6 72.
78 7é
85 '77
A
l: : é w+,,_; x DH” F7: .qu73+.3»7f+,1§x(,z: “71.3057;
tn Pg 7 ”I; k W + '3b73“ "Y ‘73,: 74'1”” F9: .vrvm m)“ .1073 :77 3. For Periods 2-6, calculate an exponential smoothing forecast with or = .4 Period Demand Forecast
1 68 65
2 75 6e
3 73 70
4 79 ‘H
5 78 74
6 85 '7é F =otD.+(i'°‘)F¢ F:.L/wwllvﬂwéVP‘LWi’éL 4. For Periods 1-6, calculate AFN, an exponential s orecast with Trend with
on = .4 and B = .6 (HINT: You can use the Foreca from problem 3 you only need to
calculate Trend and add it to Forecast to get AF —— Fo Em mm M 1:33;!
1 68 65 3
2 75 Lt, 1.8 (98
3 73 '19 3.”. ‘13
4 79 "H LBS ‘13
5 78 74 1.59 ‘17
6 85 79 1.11 ‘78
AF+‘: Eu‘f-TJLH AH: F,+T|; éS+3;ég 7,”, : Wat.- F34 Mm: 898(58» (2-1237:.4-(44«4;)4,y,7=,.,
AF}: 4414.37. Q3
73 : ﬂ“(FrF»l‘(/’/E)B 3 'é(70'éé)t.‘/ $7.3: l.‘7’+,*n '; 3.12 T», -, .4 (—17-7887: 311%”
79., ,mepymzr: 1,95
7n: .4, Wm)» 8 ~st = 1-71 ' ' t 9 ’-
5. For the following data, calculate MAD and MFE / Itch“ For w
Mpg Demand Forggast F E; l Fe 3
1 68 65 3
2 75 72 3 3
3 73 76 r 3 3
4 79 82 ' 3 7
5 78 75 3 7.,
6 85 81 ‘1 _,.
7 H 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 y X”
mm #QfPizzas X" __..
14 6 8‘! ML
28 11 308 “18‘!
18 7 imb 37.41
21 8 [£8 '4‘“
45 18 Rio 101$
_§_ _3_ 1% H
{xr IZ‘I fy: g3 {Ivy-4610 EFT—333"
__..r<" < 0%”
6H” m Iglo " _'T " ' Iglo-IIY—S‘l7 L/a
- ______________'____ _ :
1 ‘ 1 ' _ n37” , l, .
4" El“ “3327 4, S"! 3 Using your linear regression forecasting model, predict the number of pizzas needed for a
gathering of 40 students. y: —-,I+.‘/xt/a: [5‘7 ’5 /é P1524; 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 $150,000 plus charge you $5 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 $ 220,000
Beneﬁts $ 75,000
Food $ 175,000
Indirect Labor $ 50,000
Equipment Depreciation $ 150,000
Overhead § 209,000
Total Cost $ 870,000 7. If you expect to serve 100,000 meals next year, would you insource or outsource
(show your work)? - 5 ‘3 300
Off“ {panic : ‘ l§0,000 + {S x (00/000 ’ LYO’IOQO VS. 8 ’00 12(ng y a u . §v+$our (-a 8. If you expect to serve 150,000 meals next year (for insource: direct labor increases by
$50,000, beneﬁts increase by $25,000 and food by $50,000), would you insource or
outsource (show your work)? i» t , S
TnjdVrl—C ; (8701000 + $01009 I. ’lr/DU‘) 1L f0/ 000 - 66" {I 000 V5‘ f { _ 3'7
Outsouru " [$01000 * g ”IS-0,000 I 001000 I . . (ju'l'SOquc 9. Would operating a cafeteria typically be considered a “core competency” for a
company? Na, A01“ (1 Con1 COM/”("123“‘7 Use the following information for question
Summary Data for 3 possible suppliers 10: Performance Dimension Supplier A Supplier B Supplier C
Price 3 $350/unit I $550/unit 2 $410/unit
Quality i 7.5% defects} 1% defects 1 3% defects
Delivery \ 14 week 3 6 weeks 2— 10 weeks
Rating Values 1 2 3
Price >$500lunit $400-SOO/unit <$400/unit
Quality >5% defects 2-5% defects <2% defects
Delivery >12 weeks 8-12 weeks <8 weeks
Wei ts Price Quality Deliveg
.4 .3 .3 10. Use the weighted—point evaluation system to calculate the weighted average performance for each supplier. A: .‘lr‘34—3v‘l " ,3"! 3
Bi .v~/+,Zx3+ 3&3: C? .‘fxl+.3~1*,3xz Chapter 11 L87 2.1 Ufnacf ‘ 1,0 Your company is purchasing 8000 pounds of steel from both Supplier 1 and Supplier 2
this year. Each late delivery costs your company $300 and each pound of defective
material costs your company $800. Basic information on the two suppliers is provided below: CostCategory Supplier1 Supplier2 Price per pound $4 $3
Defect Rate 1/500 1/50
Late Deliveries/yr. 3 15 11. What is the Total Cost of Ownership for the year for Supplier 1 and Supplier 2? TC051 d'$‘///i§ ‘C30001!» 7‘ *L‘#
50 T605}? 43/”) h 3000 ”>9“ .L... x 8000”); x s800+ 3:300: $45,700 $00 8000 38700 + I5’x’300 1‘ «lgélfoo 2 5' sup W5 .33, 69 -—> \““‘°“’”*""
__.—- 1§Mg\@ 4,‘ (e +,.,¢L OAK
Chapter 12 5V»)? /’ Use the following information for questions 12-14: Every week, BosssMustang of Oakland, California, receives 25 individual shipments
from 25 different suppliers in the Los Angeles area. Each shipment weighs about 300
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 $120 per supplier, and the warehousing cost would be $80 per hundred-weight (per
hundred pounds). A direct truck shipment from Los Angeles to Oakland costs $ 750. 12. How much does BosssMustang’s current transportation solution cost per week? lSk37§0 Z $(3,7371 13. How much does the 3 PL provider’s transportation solution cost per week? Victor 'l' [aonIM/rd’f'n'f éL‘OQW ‘ .-
#110*2§+m—%€Ek2§x3oo\15 + \r‘7fo-
_¢ £3,000 4’ {@000 f K7YO ’ 7173/0 14. Which solution would you chose? How much money would you save? , x , s ,0 : f 9 .000
Chow; 3PL “”9" ”(7:0 9'73 1 Use the following information for questions 15-17: Astro Industries of Minneapolis, Minnesota, makes weekly shipments to 15 customers in
the Dallas area. Each customer’s order weighs, on average, 400 pounds. A direct
shipment from Minneapolis to Dallas costs $1,500. A Dallas based warehousing ﬁrm has offered to run a break-bulk warehousing operation
for Astro at the cost of $75 per hundred-weight. Local deliveries to each customer would cost $110 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? (C k *I’YUO ~—. {111(00 16. How much does the Dallas based warehousing ﬁrm’s transportation solution cost per
week? ékéym‘Vl/f‘ + greqltbv’k ‘l' L0ca( Dciiﬂrﬁt’f 47$ __
l“)§ao + mm; "1§‘<°/00+ IYxfllo -— ”.5790 F “1,500 + ‘/,£S’0 : {7,é3’0 17. Which solution would you choose? How much money would you save? Dam; in“ ”H Firm {ax/«9;: I I I ...

View
Full Document

- Spring '09
- Favre