What is the purpose of a spreadsheet model and how can a spreadsheet model help the owners of the Terra Cotta Brew Coffee Shop make decisions about the renovation?

What will be an ideal response?


Spreadsheet models can serve multiple purposes. They can be used to describe a current situation such as past revenue, costs, and profits or they can be used to suggest what action to take. Prescriptive models offer methods to analyze the outcome of different scenarios by changing one or more variables. Two common analysis methods to use with prescriptive models are sensitivity analysis and scenario analysis. The owners of the Terra Cotta Brew Coffee Shop can use the spreadsheet model to evaluate various scenarios including a variety of growth rates, investment amounts, etc. in order to make a decision about the renovation.

Computer Science & Information Technology

You might also like to view...

What is the order of the half-open connection communication sequence?

What will be an ideal response?

Computer Science & Information Technology

Which is an input box with upward-pointing and downward-pointing arrows that enable you to move through a set of values by clicking?

A) Value B) Spin C) Number D) Text

Computer Science & Information Technology

The ____ property determines how the browser should handle content that doesn't fit within the specified size of its containing element.

A. fit B. float C. location D. overflow

Computer Science & Information Technology

Social media includes online tools used to communicate ideas, share links, contribute personal commentary, share photos, and interact online with other web users in various ways.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology