Page 294 - TP_IT_V1.0_C10_flipbpookl
P. 294
21 st #Initiative
CLASS ACTIVITY Century #Critical Thinking
Skills
What-If Analysis in Spreadsheets
Objective:
To understand and apply What-If analysis techniques to make data-driven decisions.
Activity Instructions:
1. Introduction:
Question: What is the purpose of What-If analysis in spreadsheets, and how can it help in decision-making?
2. Group Formation:
Instruction: Form groups of 3-4 students.
3. Task Assignment:
Dataset: A sample business dataset with columns for Sales Price, Quantity Sold, and Revenue.
Sales Price Quantity Sold Revenue Cost Profit
50 200 10,000 6,000 4,000
55 180 9,900 5,500 4,400
60 160 9,600 5,000 4,600
a. One-Input What-If Analysis: If the sales price increases by 10%, how will it affect the total revenue? Use the What-If
analysis tools in your spreadsheet software to perform this calculation.
Question: How does changing the sales price by 10% impact the total revenue? Provide the new revenue figure.
b. Two-Input What-If Analysis: Analyze how changes in both sales price and quantity sold affect the total profit. Create a
data table to show different combinations of sales price and quantity.
Question: How do variations in both sales price and quantity sold impact the total profit? Show the results in a data
table.
4. Activity Execution:
Instructions: Perform the What-If analyses as described and prepare your findings.
5. Presentation and Discussion:
a. One-Input Analysis: What did you discover about the relationship between sales price and revenue? How did the 10%
price increase affect the revenue?
b. Two-Input Analysis: What patterns or insights did you find from analysing the impact of sales price and quantity on
profit? Which combination of variables yields the highest profit?
CAREER HERE
This chapter is vital for careers in data analysis, financial analysis, and business intelligence.
292 Trackpad Information Technology (Ver. 1.0)-X

