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
   289   290   291   292   293   294   295   296   297   298   299