個案總覽

Student spreadsheet for case W17648.

In October 2010, Ira Pittelman, lead producer of the Broadway musical American Idiot, had to evaluate one week's grosses from when star musician, Billie Joe Armstrong, was put into the show in New York City. The rock star had been enthusiastic about filling in for an actor in the musical based on an album by his band, Green Day. Audiences had also been enthusiastic, and revenues for the play were up. The producer had to determine whether Armstrong was the source of the increased revenue and, if so, how much his performance had contributed. He needed to determine how to respond should Armstrong offer to act in the musical again. Should he accept such an offer? How much compensation should he offer the star?

Instructor Spreadsheet to accompany product 8B17E013.

In October 2010, Ira Pittelman, lead producer of the Broadway musical American Idiot, had to evaluate one week's grosses from when star musician, Billie Joe Armstrong, was put into the show in New York City. The rock star had been enthusiastic about filling in for an actor in the musical based on an album by his band, Green Day. Audiences had also been enthusiastic, and revenues for the play were up. The producer had to determine whether Armstrong was the source of the increased revenue and, if so, how much his performance had contributed. He needed to determine how to respond should Armstrong offer to act in the musical again. Should he accept such an offer? How much compensation should he offer the star?

Student Spreadsheet to accompany product 9B17E013.

Spreadsheet to accompany product 8B17E001.

In early December 2016, the owner of the Asian Grill restaurant in Henderson, Nevada, noticed that the restaurant had busy nights where customers left due to long wait times, yet there were empty seats due to small groups occupying large tables. She had a proposed new table layout before her and had to evaluate whether this would allow the restaurant to seat more customers on her busiest nights (Thursday to Saturday), or whether a different table layout would be even better.

In early December 2016, the owner of the Asian Grill restaurant in Henderson, Nevada, noticed that the restaurant had busy nights where customers left due to long wait times, yet there were empty seats due to small groups occupying large tables. She had a proposed new table layout before her and had to evaluate whether this would allow the restaurant to seat more customers on her busiest nights (Thursday to Saturday), or whether a different table layout would be even better.

The purpose of this note is to illustrate the use of Data Tables in Microsoft Excel. Data Tables are commonly used for performing sensitivity analyses, sometimes called "What If?" analyses, and for preparing data for graphs. Data Tables can also be used to enable a Monte Carlo simulation in a spreadsheet in more advanced models. The technical note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Histograms are graphs that provide a large amount of useful information for all types of data and display the frequency of observations in a data set. The purpose of this note is to introduce histograms for several types of data, provide examples of insights that can be gained and calculations that can be performed using histograms, and demonstrate how to build histograms in Microsoft Excel. In addition, this note reviews the Normal distribution, which can be used to approximate many empirical distributions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16405.

The purpose of this technical note is to introduce and illustrate the use of Microsoft Excel's built-in advanced logic functions. Excel's advanced logic functions add logical capabilities to normal descriptive statistics functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Spreadsheet to accompany product 9B16E011.

Spreadsheet to accompany product 9B16E018.

This teaching note provides step-by-step illustrations and practice problems to assist students in learning how to use basic mathematical functions in Microsoft Excel. These functions are the necessary building blocks for many spreadsheet models. This teaching note includes practice exercises, answers, and a supporting Excel workbook for students.

The purpose of this note is to illustrate how to use cell references in Microsoft Excel. References are necessary when using functions and building models. This teaching note provides students with practice exercises and a supporting Excel workbook.

The purpose of this note is to illustrate the use of good modelling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.

The purpose of this note is to introduce the concept of logical statements in Microsoft Excel and to illustrate the use of Excel’s built-in logic functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

The purpose of this note is to illustrate the use of Microsoft Excel functions for generating descriptive statistics for continuous data. These functions are common when analyzing data to provide insights for decision making. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Histograms are graphs that provide a large amount of useful information for all types of data and display the frequency of observations in a data set. The purpose of this note is to introduce histograms for several types of data, provide examples of insights that can be gained and calculations that can be performed using histograms, and demonstrate how to build histograms in Microsoft Excel. In addition, this note reviews the Normal distribution, which can be used to approximate many empirical distributions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.