1. Use excel solver to solve for different scenarios shown by the questions at the end of the case. 2. You need to submit your work as a report addressing the questions. Criteria Weight Assessment C., C, C+ F D-, D, D+ B-B, B+ AA Score Numerical values: 0-59 Numerical Numerical Numerical Numerical values: values: values: values: 60-62, 63-65, 66-70-72, 73-75, 76-80-82, 83-85, 86-90-94, 95-100 79 89 Quality of the 25% report (structure, grammar and syntax). Ideas are clearly expressed Use appropriate 25% methods and/or tools to solve the problems. Carry out a proper 25% analysis of the case including answering all questions. Low quality, not Marginal quality; Average quality Superior quality, Essentially free at a level one the report does but several very few errors. of errors and would expect in not inspire any improvements ideas clearly this course. confidence in the are in order. communicated. results. The methods The methods The methods The methods The methods used are used have a used are correct used are correct used are correct essentially limited number but have a large but have a small their execution is incorrect. of elements that number of errors, number of errors. free of errors. are correctly executed. The analysis The analysis is the analysis is the analysis is the analysis is lacks any logic. vague and not general in nature specific in nature specific and takes entirely coherent and exhibits and coherent into account all as many facts are some coherence with most facts the facts. ignored but certain facts taken into are ignored account. The conclusions The conclusions Some valid The conclusions The conclusions and conclusions and and and recommendations recommendations recommendations recommendations recommendations are inconsistent are rather vague are provided and are clear and are very clear with the facts of and/or are not somewhat justified by the and strongly the case and/or well supported justified by the analysis. They justified by the the analysis. by the analysis. analysis, though also reveal some analysis. They they do not (though not all) reveal some deep convey any insights. insights, insights Final Score Conclusions and 25% Recommendations and fe planning purpose. Demand from each customer was shows in Table S-15 Sanjay estimated that the they would rowth of the paper year after which demand would CASE STUDY Managing Growth at SportStuff.com In December 2008, Say Gupta cam were buy i ng the performance Sport Stall.com over the previon ycar. Demand had grown by 50 percent. This w a s a g The capitalists supporting the company w very pleased with the growth in sales and the moving ut clearly that co nter than S demanded to grow and the apply chain w was to designed. They decided to analyze the perfor mance of the como te how designed to best cope with the growth and pated over the three year SportStuff.com Sanjay Gupta founded SportStuff.com in 2004 with The Network Options isw a that they wap e with the mic e d growth Optiwa toka www Langwa and wi t h thgh the war er ho w idenied in De the shipped allocations for Sche, Atlanta w equipment for their children. Per complained about all about 100.000 ) large 200000 having to deve se ja and Salware hade food up to 2 million shoes the children w the rapidly Sanjay's was per year, who are wan d handle a initial plan was for the company to purchased equip flow of up to millions per year. The comm e jackets from aroun d in St. Louis The sound from mature and in and then over the womand large was in diffoloca Internet. The idea was w r ivod in the marketplace are shown in the 5-16 demand prompidly and by the end of 2001, the Sanjay estimated that the y holding costs pary had also By this time, a variety of at a warchone (cluding warehouse expone) was now and wood products were being sold, and the co w bout $600 VF, where is the number of flowing In June 2004. Sanjay losed of warchose in bed the theoretical observation that the inventory the skin of St. Louis to manage the large of held a facility in cross the work is proportional product being sold Supplies the product to the other root of the throw through the facility warehouse Customer orden we packed and shipped As a rating throughput the ha few facili by UPS from there. As demand prew. SportSuff.comties reduces the increas e d with a leased mee space within the warehouse By 2001, pregating throughout through many facilities. Thus, a Sport Sufl.com the warehouse and orders w e handlingi milionis per year in were being shipped to customers allow the United o ry holding out of 0 in the course of the States Management divided the United States into year. If your of Excel has problems wing the TABLE 15 Regional Demanda Sport.com for 2007 TASS Feed Cool Who Flasi Variabile Cou Variable och charges we had both the sand the destina hips from supplier w ay to unchanged man who wacheco Study Ortom W ww facility. T h is is moto As per andere woor de TARLES 12 UPS Charges per Shipment Four Units Northwest Shwe M L M 1. Use excel solver to solve for different scenarios shown by the questions at the end of the case. 2. You need to submit your work as a report addressing the questions. Criteria Weight Assessment C., C, C+ F D-, D, D+ B-B, B+ AA Score Numerical values: 0-59 Numerical Numerical Numerical Numerical values: values: values: values: 60-62, 63-65, 66-70-72, 73-75, 76-80-82, 83-85, 86-90-94, 95-100 79 89 Quality of the 25% report (structure, grammar and syntax). Ideas are clearly expressed Use appropriate 25% methods and/or tools to solve the problems. Carry out a proper 25% analysis of the case including answering all questions. Low quality, not Marginal quality; Average quality Superior quality, Essentially free at a level one the report does but several very few errors. of errors and would expect in not inspire any improvements ideas clearly this course. confidence in the are in order. communicated. results. The methods The methods The methods The methods The methods used are used have a used are correct used are correct used are correct essentially limited number but have a large but have a small their execution is incorrect. of elements that number of errors, number of errors. free of errors. are correctly executed. The analysis The analysis is the analysis is the analysis is the analysis is lacks any logic. vague and not general in nature specific in nature specific and takes entirely coherent and exhibits and coherent into account all as many facts are some coherence with most facts the facts. ignored but certain facts taken into are ignored account. The conclusions The conclusions Some valid The conclusions The conclusions and conclusions and and and recommendations recommendations recommendations recommendations recommendations are inconsistent are rather vague are provided and are clear and are very clear with the facts of and/or are not somewhat justified by the and strongly the case and/or well supported justified by the analysis. They justified by the the analysis. by the analysis. analysis, though also reveal some analysis. They they do not (though not all) reveal some deep convey any insights. insights, insights Final Score Conclusions and 25% Recommendations and fe planning purpose. Demand from each customer was shows in Table S-15 Sanjay estimated that the they would rowth of the paper year after which demand would CASE STUDY Managing Growth at SportStuff.com In December 2008, Say Gupta cam were buy i ng the performance Sport Stall.com over the previon ycar. Demand had grown by 50 percent. This w a s a g The capitalists supporting the company w very pleased with the growth in sales and the moving ut clearly that co nter than S demanded to grow and the apply chain w was to designed. They decided to analyze the perfor mance of the como te how designed to best cope with the growth and pated over the three year SportStuff.com Sanjay Gupta founded SportStuff.com in 2004 with The Network Options isw a that they wap e with the mic e d growth Optiwa toka www Langwa and wi t h thgh the war er ho w idenied in De the shipped allocations for Sche, Atlanta w equipment for their children. Per complained about all about 100.000 ) large 200000 having to deve se ja and Salware hade food up to 2 million shoes the children w the rapidly Sanjay's was per year, who are wan d handle a initial plan was for the company to purchased equip flow of up to millions per year. The comm e jackets from aroun d in St. Louis The sound from mature and in and then over the womand large was in diffoloca Internet. The idea was w r ivod in the marketplace are shown in the 5-16 demand prompidly and by the end of 2001, the Sanjay estimated that the y holding costs pary had also By this time, a variety of at a warchone (cluding warehouse expone) was now and wood products were being sold, and the co w bout $600 VF, where is the number of flowing In June 2004. Sanjay losed of warchose in bed the theoretical observation that the inventory the skin of St. Louis to manage the large of held a facility in cross the work is proportional product being sold Supplies the product to the other root of the throw through the facility warehouse Customer orden we packed and shipped As a rating throughput the ha few facili by UPS from there. As demand prew. SportSuff.comties reduces the increas e d with a leased mee space within the warehouse By 2001, pregating throughout through many facilities. Thus, a Sport Sufl.com the warehouse and orders w e handlingi milionis per year in were being shipped to customers allow the United o ry holding out of 0 in the course of the States Management divided the United States into year. If your of Excel has problems wing the TABLE 15 Regional Demanda Sport.com for 2007 TASS Feed Cool Who Flasi Variabile Cou Variable och charges we had both the sand the destina hips from supplier w ay to unchanged man who wacheco Study Ortom W ww facility. T h is is moto As per andere woor de TARLES 12 UPS Charges per Shipment Four Units Northwest Shwe M L M 1. Use excel solver to solve for different scenarios shown by the questions at the end of the case. 2. You need to submit your work as a report addressing the questions. Criteria Weight Assessment C., C, C+ F D-, D, D+ B-B, B+ AA Score Numerical values: 0-59 Numerical Numerical Numerical Numerical values: values: values: values: 60-62, 63-65, 66-70-72, 73-75, 76-80-82, 83-85, 86-90-94, 95-100 79 89 Quality of the 25% report (structure, grammar and syntax). Ideas are clearly expressed Use appropriate 25% methods and/or tools to solve the problems. Carry out a proper 25% analysis of the case including answering all questions. Low quality, not Marginal quality; Average quality Superior quality, Essentially free at a level one the report does but several very few errors. of errors and would expect in not inspire any improvements ideas clearly this course. confidence in the are in order. communicated. results. The methods The methods The methods The methods The methods used are used have a used are correct used are correct used are correct essentially limited number but have a large but have a small their execution is incorrect. of elements that number of errors, number of errors. free of errors. are correctly executed. The analysis The analysis is the analysis is the analysis is the analysis is lacks any logic. vague and not general in nature specific in nature specific and takes entirely coherent and exhibits and coherent into account all as many facts are some coherence with most facts the facts. ignored but certain facts taken into are ignored account. The conclusions The conclusions Some valid The conclusions The conclusions and conclusions and and and recommendations recommendations recommendations recommendations recommendations are inconsistent are rather vague are provided and are clear and are very clear with the facts of and/or are not somewhat justified by the and strongly the case and/or well supported justified by the analysis. They justified by the the analysis. by the analysis. analysis, though also reveal some analysis. They they do not (though not all) reveal some deep convey any insights. insights, insights Final Score Conclusions and 25% Recommendations and fe planning purpose. Demand from each customer was shows in Table S-15 Sanjay estimated that the they would rowth of the paper year after which demand would CASE STUDY Managing Growth at SportStuff.com In December 2008, Say Gupta cam were buy i ng the performance Sport Stall.com over the previon ycar. Demand had grown by 50 percent. This w a s a g The capitalists supporting the company w very pleased with the growth in sales and the moving ut clearly that co nter than S demanded to grow and the apply chain w was to designed. They decided to analyze the perfor mance of the como te how designed to best cope with the growth and pated over the three year SportStuff.com Sanjay Gupta founded SportStuff.com in 2004 with The Network Options isw a that they wap e with the mic e d growth Optiwa toka www Langwa and wi t h thgh the war er ho w idenied in De the shipped allocations for Sche, Atlanta w equipment for their children. Per complained about all about 100.000 ) large 200000 having to deve se ja and Salware hade food up to 2 million shoes the children w the rapidly Sanjay's was per year, who are wan d handle a initial plan was for the company to purchased equip flow of up to millions per year. The comm e jackets from aroun d in St. Louis The sound from mature and in and then over the womand large was in diffoloca Internet. The idea was w r ivod in the marketplace are shown in the 5-16 demand prompidly and by the end of 2001, the Sanjay estimated that the y holding costs pary had also By this time, a variety of at a warchone (cluding warehouse expone) was now and wood products were being sold, and the co w bout $600 VF, where is the number of flowing In June 2004. Sanjay losed of warchose in bed the theoretical observation that the inventory the skin of St. Louis to manage the large of held a facility in cross the work is proportional product being sold Supplies the product to the other root of the throw through the facility warehouse Customer orden we packed and shipped As a rating throughput the ha few facili by UPS from there. As demand prew. SportSuff.comties reduces the increas e d with a leased mee space within the warehouse By 2001, pregating throughout through many facilities. Thus, a Sport Sufl.com the warehouse and orders w e handlingi milionis per year in were being shipped to customers allow the United o ry holding out of 0 in the course of the States Management divided the United States into year. If your of Excel has problems wing the TABLE 15 Regional Demanda Sport.com for 2007 TASS Feed Cool Who Flasi Variabile Cou Variable och charges we had both the sand the destina hips from supplier w ay to unchanged man who wacheco Study Ortom W ww facility. T h is is moto As per andere woor de TARLES 12 UPS Charges per Shipment Four Units Northwest Shwe M L M 1. Use excel solver to solve for different scenarios shown by the questions at the end of the case. 2. You need to submit your work as a report addressing the questions. Criteria Weight Assessment C., C, C+ F D-, D, D+ B-B, B+ AA Score Numerical values: 0-59 Numerical Numerical Numerical Numerical values: values: values: values: 60-62, 63-65, 66-70-72, 73-75, 76-80-82, 83-85, 86-90-94, 95-100 79 89 Quality of the 25% report (structure, grammar and syntax). Ideas are clearly expressed Use appropriate 25% methods and/or tools to solve the problems. Carry out a proper 25% analysis of the case including answering all questions. Low quality, not Marginal quality; Average quality Superior quality, Essentially free at a level one the report does but several very few errors. of errors and would expect in not inspire any improvements ideas clearly this course. confidence in the are in order. communicated. results. The methods The methods The methods The methods The methods used are used have a used are correct used are correct used are correct essentially limited number but have a large but have a small their execution is incorrect. of elements that number of errors, number of errors. free of errors. are correctly executed. The analysis The analysis is the analysis is the analysis is the analysis is lacks any logic. vague and not general in nature specific in nature specific and takes entirely coherent and exhibits and coherent into account all as many facts are some coherence with most facts the facts. ignored but certain facts taken into are ignored account. The conclusions The conclusions Some valid The conclusions The conclusions and conclusions and and and recommendations recommendations recommendations recommendations recommendations are inconsistent are rather vague are provided and are clear and are very clear with the facts of and/or are not somewhat justified by the and strongly the case and/or well supported justified by the analysis. They justified by the the analysis. by the analysis. analysis, though also reveal some analysis. They they do not (though not all) reveal some deep convey any insights. insights, insights Final Score Conclusions and 25% Recommendations and fe planning purpose. Demand from each customer was shows in Table S-15 Sanjay estimated that the they would rowth of the paper year after which demand would CASE STUDY Managing Growth at SportStuff.com In December 2008, Say Gupta cam were buy i ng the performance Sport Stall.com over the previon ycar. Demand had grown by 50 percent. This w a s a g The capitalists supporting the company w very pleased with the growth in sales and the moving ut clearly that co nter than S demanded to grow and the apply chain w was to designed. They decided to analyze the perfor mance of the como te how designed to best cope with the growth and pated over the three year SportStuff.com Sanjay Gupta founded SportStuff.com in 2004 with The Network Options isw a that they wap e with the mic e d growth Optiwa toka www Langwa and wi t h thgh the war er ho w idenied in De the shipped allocations for Sche, Atlanta w equipment for their children. Per complained about all about 100.000 ) large 200000 having to deve se ja and Salware hade food up to 2 million shoes the children w the rapidly Sanjay's was per year, who are wan d handle a initial plan was for the company to purchased equip flow of up to millions per year. The comm e jackets from aroun d in St. Louis The sound from mature and in and then over the womand large was in diffoloca Internet. The idea was w r ivod in the marketplace are shown in the 5-16 demand prompidly and by the end of 2001, the Sanjay estimated that the y holding costs pary had also By this time, a variety of at a warchone (cluding warehouse expone) was now and wood products were being sold, and the co w bout $600 VF, where is the number of flowing In June 2004. Sanjay losed of warchose in bed the theoretical observation that the inventory the skin of St. Louis to manage the large of held a facility in cross the work is proportional product being sold Supplies the product to the other root of the throw through the facility warehouse Customer orden we packed and shipped As a rating throughput the ha few facili by UPS from there. As demand prew. SportSuff.comties reduces the increas e d with a leased mee space within the warehouse By 2001, pregating throughout through many facilities. Thus, a Sport Sufl.com the warehouse and orders w e handlingi milionis per year in were being shipped to customers allow the United o ry holding out of 0 in the course of the States Management divided the United States into year. If your of Excel has problems wing the TABLE 15 Regional Demanda Sport.com for 2007 TASS Feed Cool Who Flasi Variabile Cou Variable och charges we had both the sand the destina hips from supplier w ay to unchanged man who wacheco Study Ortom W ww facility. T h is is moto As per andere woor de TARLES 12 UPS Charges per Shipment Four Units Northwest Shwe M L M