. Use the budget assumptions, along with Excel formulas, to populate the Master Budget column. Note: Your formulas must work such that if ANY of the budget assumptions change, the new assumptions ripple through the entire budget. Part of your grade will be based on whether you correctly formulated the cells. Except for the \"Actual\" column, Do NOT TYPE A NUMBER IN ANY CELL!!! . Use a formula to calculate the \"variance\" in cell H7: (Actual Budget). Copy and paste the formula to the rest of the cells in the column. Leave as positive or negative, rather than abso- lute values. . Use a formula to calculate the \"Variance percentage\". NOTE: The percentage is the variance as a percent of the Master Budget. Copy and paste the formula to the rest of the cells in the col- umn . Format cells appropriately (dollar signs using the accounting or currency format, underlines, double underlines, zero decimal places for dollar amounts, etc.,). . Use the \"If\" statement function to show the variances as U or F. The \"If\" statement can be found under \"Formulas, Logical\". Example: =IF(H7>=0,"F","U"). This formula means \"If cell H7>0 or H7=0, then mark as \"F\". If not greater than or equal to 0, mark as \"U\". Be care- ful with revenues and expense variances since you'll want them to be opposite of one an- other. Any variance of \"0\" should be shown as \"F\" since it meets budget expectations. . Check your answers using the following check figures: Budgeted CM: $301,000; Budgeted Op Inc. = $211,000; Variance for Commissions = $8,685; Variance percentage for Commis- sions = 17.4 %, Unfavorable