The bonus, B, paid to a company's franchise managers is based

on the following formulae:

B = b₁ + b₂(Y - ), for Y

B = b₁ - b₃ ( - Y), for > Y

Where:

= forecasted sales revenue

Y = actual sales revenue

b₁= 5%...or a percentage of your choosing

b₂ = 2%...or a percentage of your choosing

b₃ = 6%...or a percentage of your choosing

Model the formulae above in Excel...so that your "employees" can enter

their Forecasted Sales and their Actual Sales and have their bonuses

calculated (in ONE cell!).

Let Y and each have different values such that you have at least 5 iterations of the model's results reported...and include those results in another table within the Excel spreadsheet.