Store bonuses: If store sales are $80,000 or more, store bonus is $3000 If store sales are $90,000 or more, store bonus is $4000 If store sales are $100,000 or more, store bonus is $5000 If store sales are $110,000 or more, store bonus is $6000   Employee bonuses: If percent of increase is 3% or more, employee bonus is $40 If percent of increase is 4% or more, employee bonus is $50 If percent of increase is 5% or more, employee bonus is $75   Step 2:  Modify the empBonus module to write a nested if else statement to set the new bonus levels.  Complete the missing lines.  (Reference: The if-then-else Statement, page 140).    //MODULE 4 //this module will determine what the bonus levels are Module empBonus (Real salesIncrease, Real Ref empAmount) If salesIncrease >= .05 Then      Set empAmount = 75 Else If salesIncrease >= ______________ Then      Set empAmount = ___________________ Else if salesIncrease >= ______________ Then      Set empAmount = ___________________ Else      Set empAmount = 0 End If­­­­­­­­ End Module

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 4.4CP
icon
Related questions
Question

Store bonuses:

If store sales are $80,000 or more, store bonus is $3000

If store sales are $90,000 or more, store bonus is $4000

If store sales are $100,000 or more, store bonus is $5000

If store sales are $110,000 or more, store bonus is $6000

 

Employee bonuses:

If percent of increase is 3% or more, employee bonus is $40

If percent of increase is 4% or more, employee bonus is $50

If percent of increase is 5% or more, employee bonus is $75

 

Step 2:  Modify the empBonus module to write a nested if else statement to set the new bonus levels.  Complete the missing lines.  (Reference: The if-then-else Statement, page 140). 

 

//MODULE 4

//this module will determine what the bonus levels are

Module empBonus (Real salesIncrease, Real Ref empAmount)

If salesIncrease >= .05 Then

     Set empAmount = 75

Else If salesIncrease >= ______________ Then

     Set empAmount = ___________________

Else if salesIncrease >= ______________ Then

     Set empAmount = ___________________

Else

     Set empAmount = 0

End If­­­­­­­­

End Module

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning