Ben Hogan Links is a golfing center. You have been asked by the head greens keeper to help the course understand their cost structure as recently their budgeted income has differed from the realized income for the number of golfers they are receiving. They have determined that their costs are typically driven by two main drivers: Rounds Played and Golf Carts Rented. The cost structure is as such: Cost per Fixed Cost Cost per Cart Rental per Month S8,025 Round Played S5.75 S 4.15 Landscaping Gas for Carts Depreciation on Carts Utilities Administration Miscellaneous $ 2.45 $0.45 $ 450 S 6,450 $3,650 $1,10:5 $1.35 $0.75 $1.15 0.15 In June, the company budgeted for 5,200 golfers at an average greens fee (selling price) of $45, 70% of whom rent carts. In reality the company found that only 4,867 golfers came through and 76% of them rented carts. Expense information for June was as follows: Revenue Landscaping Gas for Carts Depreciation on Carts Utilities Administration Miscellaneous $225,420 $ 53,325 $ 7,280 2,280 S 15,984 S 6,409 S 7,655 Create a flexible budget which can compare the actual costs with the budgeted costs for Hogan and use conditional formatting to highlight which line item was the most beneficial and which was the most detrimental to their bottom line