Using Excel to perform the calculations, complete cells C7 - C11 on your own. Step 4: We need to calculate the Profit. Profit is Total Revenue minus the total Costs. We need to follow the order of operations and add all the costs together before we subtract. We can have Excel help us with this by putting the sum of the costs in parenthesis in our formula. In cell C12, type: =B13-( C6+C7+C8+C9+C10+C11) and press enter. Step 5: In an attempt to increase the profit from the initial budgeted profit, the manager will take the following measures to increase the total profit. Using the changes outlined below, recalculate each budgeted item to arrive at a new projected profit estimate and record the values in column D. Remember that all calculations must be done in Excel. • New advertisements developed will increase the additional customers by 10 per month. The average per customer ticket is $19.50. This will increase the total Revenue for the year to $1,717,340.00. Type this total revenue into your spreadsheet in cell D13. • Food Revenue and Beverage Revenues are 87.46% and 12.54% of the total Revenue respectively. • New suppliers have been found and the new