Section B 11 B1 1 B2 1 B3 1 B4 B5 The following are to be completed in the Fixed Costs sheet: This sheet contains details a breakdown of fixed costs by quarter. In row 9 calculate the total costs for each quarter. In B11 add up the quarterly totals to calculate the total fixed costs for the year. In column F4 calculate the average quarterly Rent. Copy the formula down to F7. Widen column F so the values can be seen properly. In column G4 calculate what percentage of total costs was made up by Rent costs. Copy the formula down to G7. In B13 calculate the highest quarterly admin cost. In B14 calculate the average monthly rent. Apply a normal rounding calculation to round to the nearest hundred. (i.e. 150 will become 200, 149 will become 100). In B15 calculate the percentage by which the rent went up from Quarter 2 to Quarter 3. Change the number format in B15 to Percentage with one decimal place. 1 2 B6 B7 1 2 B8 1 B9 1 B D E F G H Fixed Costs % of Total Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Quarter 1 31,700.00 $ 3,570.00 $ 6,975.00 $ 2,790.00 $ Quarter 2 31,700.00 $ 3,570.00 $ 7,180.00 $ 3,090.00 $ Quarter 3 32,904.60S 3,570.00 $ 6,980.00 $ 2,790.00 $ Quarter 4 Quarterly Average 32,904.60 $ 32,302.30 3,570.00 $ 3,570.00 6,980.00 $ 7,028.75 3,090.00 $ 2,940.00 Quarterly Totals $ 45,035.00 $ 45,540.00 $ 46,244.60 $ 46,544.60 Total Fixed Costs $ 183,364.20 Highest Quarterly Admin Costs: Average Monthly Rent: Rent % Increase