Homework 4 Answers - KEV Homework#4 — Due Chapter 9 Note...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

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/wwllvflwé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 : fl“(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 Benefits $ 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, benefits 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 firm 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 firm 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 firm’s transportation solution cost per week? ékéym‘Vl/f‘ + greqltbv’k ‘l' L0ca( Dciiflrfit’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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern