The ANALYTICS EXERCISE: INVENTORY MANAGEMENT AT BIG10SWEATERS.COM - the 10.000. Then - at it was only SEO could www the way of the them wewe ni mwa wanan the epitel.com 25 percent of our com pe before betinget ry wake You find them. The is niered on the West gaw You als in a potom of the the wych They were coming hephecole fall Widt Banyo we w And the end you for the pool on the time westers to my were lowed the whohin the Midwest of the United Starting Ohio State Univenty osu University of Michua (UM) Michi State Live (MSU). Pe University (PU, and toda Un (IU). These five tools to follo mind a boy be The time the woman the ownictory, the purchase them from supplier in China. The prices are great, bu savie is problem since ha 2) wok last time for each onder and the onder 500w The order in consistol and the different logo such 2.30 tot OSU, 1.500 ft Sinem cum UM. 750 MSU 500,250 for Winches bers Header of the bod best wododend the company to let people in the plier 30 percent X 50 percent lans, 20 cm med 10 percent smalled on its historical data che Com besed byde with the y pelelimano pen mm the Oohhh Ocean il pred the care het hy they de restere where Nallakantasala MIA She is a cha She 323 the The they own the www This is the year to you fly free fit w OSIM dewall of wwwwww am Mwm Sum ded. OSEL 1. MULPU OPE Shop de The was do the Not year your colometara w the doctet 12 sination for the e that such war, delivered to the waren podle the prin Here fo SONS. Din pice a we robowe 3.000 wees. The ne ofrecich of the fresco WER The applied 20 works pecete de soldered to be prel Apothe fotball During 513 for coch Show is paid tym when the ne sped Is with code, you me demand mation this Exhi. The exact for your Swoll retail price were sold 5120ch Sweeter the end of the wo 150cc Edw , HUH KHI NH H H Excel 10.04109 they OSU w tward the of the ay walance w Ating the week in prachwed year The placed in the program will These word very well in the wind the past the there may www teventie that meet Shehur me Let him to help Wentify the advertising out but has decided to wait a year to try something ferent Forecasting and is a major problem for the company You have med hinda and Steven pred they think sales with next year. You have the market archis apply their forcing Date on these casts are given in Exhibit 11.13. To potem statis tick you howevered the end calcioned the and deviation for each school and in total Based on advice from the malutarch, you have decided to use the agregate demand forecast and standani deviation for the grepe demand. The de demand was calculated by adding the average forecast for each item The great Mandard deviation was calculated by a ing the dead devion for eachem (this is the variance NAGEMENT AT 5.COM form he way. The fo mi mele w homas va ferante 5.000 The weder wachines We are the oppler med 20 www.the der weer de placed at Anille pihall Our og mer por we ping peil by the men who Bere to the demand inoma, The exacte festival Swast Butt retail price 5120ch S left the colore TO View when we predict way think wat heat you need the watch Tin topply for the ht Syed the calculate the dandos for each town Benver the water, you decided to the gender and division for the demand. The pregate demand was called by wing that were forecast for each wem The standard deviation was calculated by in the standard deviatice for each item this is the ancel Cost Information for the Big Ten Sweaters exhibit 11.12 Ma COM $3200 1050 25 Od an.com within SD TOO 195 2.68 150 300 acher and the 30 Frech oceano Duy Chine cost Monogram Labai Total subcontractor cost Total pur wd ROSSO 5.00 BA al $1300 5730 394 OPERATIONS AND SOMAGEMENT exhibit 11.12 Forecast Data for the Big Ten Sweaters AVERDE FOOTBALL Larius ACTUAL STANDARD DEVIATION 300 2.300 1468 890 Ohio State Michigan Purdue Michigan State Indiana Penn State Wisconsin STEVE FORECAST NO YA 2200 1.500 900 1.500 500 NEXTY 2.000 1.800 1.000 1.750 500 252 MAKE RESEARCH FORCATOR NEXY YUAN 2.300 2.000 1.100 2.800 450 2.500 1,767 1000 1512 517 100 125 76 TOS TOB3 50:45 74.741 41.83 10700 80,109 70.214 59.545 50,805 24.190 85.071 lowo Minots Minnesota Northwestern Nebraska Total 4658 7.550 6.500 7.950 7.400 430" 342 sweaters were sold through eBay for $50 eachectomers thing on all orders Calculated assuming the demand at each school is dependent 52 M with me for ching the oth The demand che the dead for Ohio State Michigan the others You will see weder so the individual choose the expected of an You did you may with and Save and they are ok why They wet the beach school was considered individually You are help with the data from the this called Big and you ready to do cellation bet package for the time was $30.000 Abstbewoche y his they made before nes let your? If they must make the payment the entire al firm and then pay so percent in e, what was their increase in cash istar 2. What was your reasoning behind using the demand for when determining the sire of your order rather than the individual school forecasts? Should you think this is there wound basis for doing it this way? Hou my sweaters should you order this year? Break down your order by individual school. Document your calculations in your spreadsheet Calculate this based on the great forecast and also the forecast by ind vidual school 4 What do you think they could make this year? They are paying you 510.000 and you expect your benefit pack age addition would be about $1.000 per year. Assume that they oder bused on the agregate forecast 5. How should the business be developed in the future Be specific and consider changes related to your sup plier, the monogramming subcontractor, target cus tomers, and products, Questions 1 You are create how much Rhode and Surve made in their business last year. You do not have all the but you know that most of their expenses relate to being the water and having them mond rammed You know they paid themselves 550.000 each and you know the rettilities, inance, and