hw4 - Homework#4 Due Chapter 9 Note Round all forecasts to...

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: 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 : fi.’ 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:,‘befiflxfi=.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 Benefits $ 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)? Ififiwvrce : ‘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, benefits 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‘JJafi‘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 fir 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 firm 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 firm 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 firm’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

{[ 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