Cash budgeting - Australian Super Sports Limited Group 6 Number of sales by sales department: Active sportswear 24615 Footwear 8953 Accessories 7198 Licenced merchandise 7296 Sports equipment 2490 Equipment repairs 3110 Average sales spend per sale: Active sportswear $90 Footwear $160 Accessories $80 Licenced merchandise $130 Sports equipment $120 Equipment repairs $130 Forecast total sales by sales department: Active sportswear Footwear Accessories Licenced merchandise Sports equipment Equipment repairs Total projected sales revenue for sales departments: New service forecasting New service: Sports tourism Marketing forecasts (optimistic) Number of travel sales 2340 Average predicted sales value (per sale) $2,200 Optimistic sales revenue from service $5,148,00 0 Revised analytics for sports tourism Probability of achieving forecast bootcamp enrolments Probability of 25% forecast 6% Probability of 50% forecast 13% Probability of 75% forecast 36% Probability of 100% of forecast 45% Total overall probability of forecast? Total likely forecast (based on new analysis) for new sports tourism service Grand total of revenue budget: Costs budget Cost of sales (by sales department) Note: Calc. Cost % x Sales revenue Active sportswear 33% Footwear 54% Accessories 30% Licenced merchandise 61% Sports equipment 71% Equipment repairs 27% Estimated Cost of Sales (COS) $: Active sportswear Footwear Accessories Licenced merchandise Sports equipment Equipment repairs Total cost of sales (all departments) Sports tourism costs (percentage of budgeted sales) 62% Total cost of sales: Sports Tourism: Gross profit by sales department: Active sportswear Footwear Accessories Licenced merchandise Sports equipment Equipment repairs Sports tourism Gross profit from sales: Other costs attributable AND CONTROLLABLE by Profit Centre Manager: Returned merchandise written off (due to incorrect sales advice or fitting) (Percentage of sales returned shown) Active sportswear 3% Footwear 2% Accessories 1% Licenced merchandise 1% Sports equipment 2% Calculate cost of returned sales Note: These returned goods are due to poor sales advice given, not other customer returns Active sportswear Footwear Accessories Licenced merchandise Sports equipment Total cost of returned sales due to poor sales advice: Other controllable costs: Commissions paid to staff: Sales commissions paid to staff (% of GP on items) 7% Sales commissions paid: Rostered staff costs: (Note all amounts are at LAST YEAR'S Rate) See notes on expected wage and salary increases this year Number of full time sales staff 8 Average full time staff wage per week $75,174 Total full time staff wage costs Number of casual sales staff hours 2683 Average casual hourly rate $35.00 Total annual casual staff costs Other staff costs: Management salaries $107,162 Administrative staff wages and salaries $133,711 Total staff wage and salary costs: Staff training (% Sales) 4% Staff training ($) Local advertising and marketing (% Sales) 5% Total local advertising and marketing $ Total costs controllable by local manager: Gross profit controllable by local manager: Fixed costs attributable to local business unit: NOTE: All costs are shown at LAST YEAR's RATES - see notes on expected inflation of these costs Cleaning and general maintenance $11,293 Utilities (Electricity/Gas etc) $28,729 Sundry business costs $16,340 Other fixed costs controlled by others: NOTE: The all other fixed costs shown below are calculated at the expected costs and do NOT have to be adjusted for inflation Liability insurance $188,100 Rental costs $376,199 Security services $188,100 IT Support and systems $188,100 Total 'local' fixed costs controlled by others Fixed costs allocated to business unit by 'Head office': NOTE: The Head Office costs are imposed on the business unit as a percentage of sales revenue. Percentage shown is to be used to calculate the amount allocated National marketing and advertising budget costs 3% Head office administration charge (% Sales) 3% Total Head Office cost allocations: Net profit for this profit centre (Business Unit) Additional information NOTE: The following inflation expectations should be applied (where indicated) on the 'last year' amounts given above to budget for the coming year. Increase in all cleaning and maintenance costs 8.0% Increase in utilities costs 13.0% Increase in sundry business costs 10.0% Wages are expected to increase as follows: a) Management salaries 5.0% b) Administrative salaries 6.0% c) Increase for all sales staff (full time and casual) 4.0%

Can you please also send me the excel format separately if possible