Case C - Increasing profit from the clubhouse bar sport organisation runs a bar in its clubhouse which is open for business for 3 hours in the evening on Friday, Saturday and Sunday (a total of 9 hours per week). The amount of sales per our is generally $500 per hour except on Saturday evening when sales rise to $600 per hour. Over the last one year, according to financial accounting records, the Gross Profit on bar sales is generally 36%% Keeping the bar open requires one bartender paid at the rate of $25.00 per hour nd it is also estimated that electricity costs $5.00 per hour. The management committee want to find more profit from the bar, and is trying to decide between wo options. Option 1: Open one more hour on Saturday evening on the basis that the extra hour achieves the fame sales per hour as other hours on Saturday ($600/hr). There would be no attempt to change par prices to increase Gross Profit. Option 2: Keep the same opening hours for the three evenings but increase prices a small amount o achieve a Gross Profit of 40%. Prepare three spreadsheets that show the gross profit and net profit in the bar for (e) the existing cenario (b) the extra hour on Saturday scenario and (c) the increase in Gross Profit percentage rom 36% to 40%