To calculate the Bonuses for January (row 17), you will use the IF function to compare the January Sales (B7) to the Target for Bonus amount (B29) under Assumptions. ? If the January Sales meets or exceeds the Target, then they will get a % of the sales as indicated under Assumptions (multiply the % for Bonuses (B30) by the Sales (B7)). If they don't meet the sales amount, then they get $0. Use Absolute and Relative Referencing. Note: It is possible for some of these results to be $0

5 X XI H 6 . 2. Mina_Gad_L3_Titan_Profit_Loss_Projections - Excel (Product Activation Failed) hadi nassar * FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calculation EX AutoSum . As d Cut General Paste JEB Copy . 11 - A" A Normal Bad Good Calibri Wrap Text Neutral Fill Input nsert Delete Format Sort & Find & $ ~ % " $68 508 Conditional Format as Check Cell Explanatory ... Followed Hy... Hyperlink 41 4 Clear Filter Select Format Painter BIU . . A. BEE EE Merge & Center . Formatting * Table Cells Editing Clipboard F Font Alignment Number Styles E32 : X V fx G H K L M N O P Q R S T U V w X B C D E Titan Off Campus Shops Profit and Loss Projections January 1, 2017 to December 31, 2017 Today's Date: November December Total January February March April May June July August September October Income 36198 35001 45690 44321 23894 38645 29411 38382 25401 31895 409381 Sales 28444 32099 838 890 976 901 899 964 942 1021 10960! Interest 795 892 991 801 16578 45211 39546 39346 420341. 29239 37189 32916 Total Income 32991 35802 24870 30310 26343 10 11 Expenses 7676.4 5080.2 6379 Product 5688.8 6419.8 7239.6 7000.2 9138 8864.2 4778.8 7729 5882.2 Administrative 4266.6 4814.85 5429.7 5250.15 5853.5 6648.15 3584.1 5796.75 4411.65 5757.3 3810.15 4784.25 Sales Force 2844.4 3209.9 3619.8 3500. 4569 4432.1 2389.4 3864.5 2941.1 3838.2 2540.1 3189.5 1266.6 4814.85 5429.7 5250.15 6853.5 6648.15 3584.1 5796.75 4411.65 5757.3 3810.15 4784.25 Rent & Utilities Advertising 2844.4 3209.9 3619.8 3500.1 4569 4432.1 2389.4 3864.5 2941.1 3838.2 2540.1 3189.5 Bonuses 18 Total Expenses 19 20 21 22 23 Assumptions 24 Product 20% 25 Administrative 15% 6 Sales Force 10% 27 Rent & Utilities 15% Advertising 10% 29 Target for Bonus $35,000 30 Bonus % 1% 31 32 Option 1: Advertising 15% 34 Total Expenses 35 Profit/Loss 36 Option 2: Sales Force 18% Profit & Loss + AVERAGE: 18895.57934 COUNT: 144 SUM: 2002931.41 8 0 0 -- 100% Select destination and press ENTER or choose Paste 6:20 PM ~ x (4 4>9/15/2019 Type here to search 9