xam Fall 2020 i Saved Help Save & Exit We analyzed joint formulae to incentivize accurate sales forecasts. The model appears below: The bonus, B, paid to a company's franchise managers is based on the following formula: B = bqY + b2(Y - Y), for Y ZY B = bqY - b3 (Y - Y), for Y > Y Required. Use the downloadable template to provide your answers to the following questions: a) Based on the spreadsheet data and using the actual cell locations below, write an efficient and effective IF-THEN statement in Excel form to do the calculation to calculate Ruth's bonus. C D E F G H 19 2020 2020 by b2 b3 Sales Actual 20 Forecast Sales 0.05 0.03 0.04 Ruth 21 Ginsburg $1,089,783 $1,173,245 ) Will the values for the bsubscript parameters provided above be effective in generating accurate sales forecasts in a real setting? Please explain. upload a response file (15MB max) download reference file Choose File No file chosen XLS Problem 7 on Bonus Forecast save accuracy xlsx