Q1 (3 points). What problems does the company face? Q2. Develop the forceasting models and find the forecasting accuracy. Q2-1 (3 points). Develop one exponential smoothing model ( 0.4 ) for FB378 (week 1-week 26) and GS131 (week 11-week 267). (Keep two decimals) 22-2 (4 pointy). Calculate FE, MAD, and tracking dqnals for the exponential smoothing model (a-0.4) for FB378 (week 2-week 26) and GS131 (week 12-wrek 26). Keep twe decimab) Q3. Amwer nveral quavises (orlow) Q3-1 (3 points) Determine if there is eptrend or downtrend from the actual demand of FR378 (week 1-26) and the actual demand of GS131. (Show a scatter plot with a linear line for the relationship between weeks and the actual demand of FB378 and weeks and the acutal demand of GS131.) A scatier plot (Fa378) A scatter plot (GS|3!) 24-2 (2 pointi). Hased on your numbers that yeu have calculated from Q4-1, what is the order quantity to minimire the total inveatofy eost for Fay7s and ES1312 What is their inveatory level at ahich their stack needi to be replealhed for FR378 and C5131? CASESTUDY Northcutt Bikes: The Service Department wo terial nore indors ditind as track bown and comp te by the thi in imratory; the farainity ondern were fouchonlerol. Habe wrre aoc avathille finues Northcuer Bites. What trelly hum ous when thore buninesses sumetion exncried that crrise cenler foe purts and placed in with soufier purs supplien. The obricica condevon was the while torm ancwar noe ocly becasse a larke eniours axs afredy teas beld tur alio bowas stae spact in the warchouse fouit lo: after it mond in to its prescet eritization of over 953 . Mile deoded to neart his analyuis and deviloponern af solitioes on the two itenat for which. Ant had alfraby pre: vided uemund history. Hif frit that if he could andyte ard arr rett any problens with those two garts, he could cxund are amalyis to nose of the oehert. The twiv items on which he had hiveory and coocentraed his inirial analysis were the P17? Fender bracket and the CS131 Cour Sprocket. Noethcuat Biles purchases the FB37s froen a Brazilian iource. The lead arre has remaincd constant, at thiree weckh, and the otima to kat of a purchase onder for these parts is given at 515 per crict. Currerth Northoult Blies uses an order lof vize of 120 fir to. 7E378 and buy the inema for 55 apicce. The CS13t gart, on the orther hand. Is a newer protat only recenily being offered. A machine shop in Naitrife: Teanewer, probuces the part for Northcurt Biken, and it give Northcuin Eikes a feirly retable six werk lead timec. The coot of placing an order wilh the mach ine shop is oaly about Sif, and. currently Nocthcunt Biken orders 850 parts at a time. Nart cuet Bakes besys the irem for $10.75. Following is the demund informarion that Att jues ar Mike od his fine dry for the FB 378 and the CNI3I: the situation as a cripes bocaus," wrife trat vind at the weans 935 or berter nerice level without bacic orden. yet ore nocd to be alle to do that whth a net fedocboon in tctal ifructoory What. doyou think, Mike? Can eredotorae? questions: 1. Use the avalable data to deviop inverstory poidcies iceder Guantities and recorder pointri far the Fibls and (ns1 31. Assume that the holding cost is 2 ofs of mit price. 2. Compare the ievrnbory conts auoctated wish youar suk Bciued order quantities wilh thoic of the curfrit oeter quantitici. What oan youl conctude? 3. Doyouthink the lost customet sales shoold be indiaded as a cont of ifwentiocy? Horv woyld suah an inchusion inpost tire orderiftg policies you cerabiuhed in quedide th REFERENCES APrCS, 2016). explosion-gasolime-price-spikce/. Magrretan, b. The fower of Virtunl integration An lntervies with Dell Computer's Mhakach Deth, Hused Besirecs Rnier 76 no. 20 March Anril 1985 .7. 284. Q1 (3 points). What problems does the company face? Q2. Develop the forceasting models and find the forecasting accuracy. Q2-1 (3 points). Develop one exponential smoothing model ( 0.4 ) for FB378 (week 1-week 26) and GS131 (week 11-week 267). (Keep two decimals) 22-2 (4 pointy). Calculate FE, MAD, and tracking dqnals for the exponential smoothing model (a-0.4) for FB378 (week 2-week 26) and GS131 (week 12-wrek 26). Keep twe decimab) Q3. Amwer nveral quavises (orlow) Q3-1 (3 points) Determine if there is eptrend or downtrend from the actual demand of FR378 (week 1-26) and the actual demand of GS131. (Show a scatter plot with a linear line for the relationship between weeks and the actual demand of FB378 and weeks and the acutal demand of GS131.) A scatier plot (Fa378) A scatter plot (GS|3!) 24-2 (2 pointi). Hased on your numbers that yeu have calculated from Q4-1, what is the order quantity to minimire the total inveatofy eost for Fay7s and ES1312 What is their inveatory level at ahich their stack needi to be replealhed for FR378 and C5131? CASESTUDY Northcutt Bikes: The Service Department wo terial nore indors ditind as track bown and comp te by the thi in imratory; the farainity ondern were fouchonlerol. Habe wrre aoc avathille finues Northcuer Bites. What trelly hum ous when thore buninesses sumetion exncried that crrise cenler foe purts and placed in with soufier purs supplien. The obricica condevon was the while torm ancwar noe ocly becasse a larke eniours axs afredy teas beld tur alio bowas stae spact in the warchouse fouit lo: after it mond in to its prescet eritization of over 953 . Mile deoded to neart his analyuis and deviloponern af solitioes on the two itenat for which. Ant had alfraby pre: vided uemund history. Hif frit that if he could andyte ard arr rett any problens with those two garts, he could cxund are amalyis to nose of the oehert. The twiv items on which he had hiveory and coocentraed his inirial analysis were the P17? Fender bracket and the CS131 Cour Sprocket. Noethcuat Biles purchases the FB37s froen a Brazilian iource. The lead arre has remaincd constant, at thiree weckh, and the otima to kat of a purchase onder for these parts is given at 515 per crict. Currerth Northoult Blies uses an order lof vize of 120 fir to. 7E378 and buy the inema for 55 apicce. The CS13t gart, on the orther hand. Is a newer protat only recenily being offered. A machine shop in Naitrife: Teanewer, probuces the part for Northcurt Biken, and it give Northcuin Eikes a feirly retable six werk lead timec. The coot of placing an order wilh the mach ine shop is oaly about Sif, and. currently Nocthcunt Biken orders 850 parts at a time. Nart cuet Bakes besys the irem for $10.75. Following is the demund informarion that Att jues ar Mike od his fine dry for the FB 378 and the CNI3I: the situation as a cripes bocaus," wrife trat vind at the weans 935 or berter nerice level without bacic orden. yet ore nocd to be alle to do that whth a net fedocboon in tctal ifructoory What. doyou think, Mike? Can eredotorae? questions: 1. Use the avalable data to deviop inverstory poidcies iceder Guantities and recorder pointri far the Fibls and (ns1 31. Assume that the holding cost is 2 ofs of mit price. 2. Compare the ievrnbory conts auoctated wish youar suk Bciued order quantities wilh thoic of the curfrit oeter quantitici. What oan youl conctude? 3. Doyouthink the lost customet sales shoold be indiaded as a cont of ifwentiocy? Horv woyld suah an inchusion inpost tire orderiftg policies you cerabiuhed in quedide th REFERENCES APrCS, 2016). explosion-gasolime-price-spikce/. Magrretan, b. The fower of Virtunl integration An lntervies with Dell Computer's Mhakach Deth, Hused Besirecs Rnier 76 no. 20 March Anril 1985 .7. 284