What-if analysis: Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations. Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis. If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed. Since spread sheet is dynamic, it is used to perform the what-if analysis.

Question

Want to see the full answer?

Answer 1

Question

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Question

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Answer 6

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Answer 7

Chapter 12, Problem 38E

Program Plan Intro

What-if analysis:

Spreadsheet is dynamic in nature. Since any change in the data modify the appropriate calculations.

Spreadsheets accept the assumed values and the values can be modified to observe how it affect the other data related with it. This analysis is called as what-if analysis.

If there are changes in a value it does not only affects its own data but also the other values related to that data gets changed.

Since spread sheet is dynamic, it is used to perform the what-if analysis.

Answer 8

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Answer 9

Explanation of Solution

Setting up a spreadsheet to help the above questions:

Create a spreadsheet named “Book1.xsl”

Screenshot of the spreadsheet

What would be the gain if the selling price (SP) of all the products for a year increased by 20%?

Screenshot of the spreadsheet

In the above spreadsheet, if the value of selling price for all the products increased by 20%, then the profit or loss column gets changed. The updated sheet is given above.

What would be the gain if the selling price (SP) of the products “product1”, and “product 3” increased by $100?

Screenshot of the spreadsheet

Answer 10

Expert Solution & Answer

Answer 11

Expert Solution & Answer

Answer 12

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 13

Ch. 12 - Prob. 1E Ch. 12 - Prob. 2E Ch. 12 - Prob. 3E Ch. 12 - Prob. 4E Ch. 12 - Prob. 5E Ch. 12 - Prob. 6E Ch. 12 - Prob. 7E Ch. 12 - Prob. 8E Ch. 12 - Prob. 9E Ch. 12 - Prob. 10E

Concept explainers

Explanation of Solution

Want to see the full answer?

Chapter 12 Solutions