個案總覽

One of the most significant challenges in tackling the COVID-19 pandemic in the United States was the shortage of test capability. At the beginning of April 2020, fewer than 200,000 tests per day were being performed, much less than public health experts had recommended. Also, in many cases, it often took several days or even weeks for a person to receive the test result. Many experts believed the testing turnaround time was one of the most significant failure points to contain COVID-19. Heading into fall 2020 and winter of 2021, U.S. healthcare experts continued to cite testing capability (and fast results) as the first necessary condition of getting back to everyday life. One solution to increase the testing capacity was called a pooled test. In this case, the government of Ann Arbor is considering whether the city should use pooled COVID-19 testing and, if so, how the test should be designed since there are several different versions. Students are asked to apply probability theory and develop Excel models that can help decision makers.

Spreadsheet Supplement for Case W13C61

Spreadsheet supplement for case W92C52. GoodBelly is trying to boost its sales at grocery stores like Whole Foods Market. As a small start-up, GoodBelly must optimize the allocation of its limited marketing budget. It currently promotes through in-person demonstrations in stores, but management is concerned that these demonstrations are not effective enough to justify the cost. It is up to GoodBelly's student intern, Caroline Dickerson, to evaluate its promotional programs using statistical evidence. Dickerson will need to apply regression analysis to a GoodBelly- Excel Spreadsheet (WDI Publishing 1-429-273) to determine whether or not the company should continue its promotional programs.

GoodBelly is trying to boost its sales at grocery stores like Whole Foods Market. As a small start-up, GoodBelly must optimize the allocation of its limited marketing budget. It currently promotes through in-person demonstrations in stores, but management is concerned that these demonstrations are not effective enough to justify the cost. It is up to GoodBelly's student intern, Caroline Dickerson, to evaluate its promotional programs using statistical evidence. Dickerson will need to apply regression analysis to a GoodBelly- Excel Spreadsheet (WDI Publishing 1-429-273) to determine whether or not the company should continue its promotional programs.