Create three new scenarios for the same three levels of hours usage but with a 3.5% increase in the wage rate. Create and name these three scenarios (in this order) as Min Hours w/Raises, Avg Hours w/Raises, and Max Hours w/Raises.
Added by Michaela E.
Step 1
Let's think step by step. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Paradise RESORT&SPA Expenses Average Part-time hours: 210600 Average Hourly Rate Benefit %: $10.30 28.00% Total PT Wage Expense: 2776550
Akash M.
SCENARIO 4: Can you predict the amount of income of a person based on their years of employment? Data is provided in the table below: Years of Employment Income in US Dollars 1 56400 2 39800 3 54200 2 42650 10 62200 4 72200 2 26530 2 36500 2 40000 4 41200 6 50000
T. L.
Madhu has also created two scenarios in the Income Analysis worksheet. The Current scenario assumes the current values for units sold, price, and fixed expenses (salaries and benefits, distribution, and miscellaneous). The Lower Price scenario assumes more units sold at a lower price. She also wants to create a scenario that assumes fewer units sold at a higher price. Create a scenario using the data shown in bold in Table 1 without applying any scenarios. Table 1: Income Analysis Scenario Values Scenario name Changing cells Units sold (C5) Price per unit (C6) Salaries and benefits (C18) Distribution (C19) Miscellaneous (C20) Raise Price C5:C6, C18:C20 4500 1239 800000 510000 300000
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD