Cash budgeting - Company A Number of sales by sales department: ActivesportswearFootwearAccessoriesLicencedmerchandiseSportsequipmentEquipmentrepairsAveragesalesspendpersale:ActivesportswearFootwearAccessoriesLicencedmerchandiseSportsequipment225351321110508724315351644$80$180$90$200$70$140 Forecast total sales by sales department: Active sportswear Footwear Accessories Licenced merchandise Sports equipment Equipment repairs Total projected sales revenue for sales departments: \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} New service forecasting New service: Sports tourism Marketing forecasts [optimistic) Number of travel sales Average predicted sales value (per sale) Optimistic sales revenue from service Revised analytics for sports tourism Probability of achieving forecast bootcamp enrolments Probability of 25% forecast 7% Probability of 50\% forecast 24% Probability of 75% forecast 28% Probability of 100% of forecast 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 Footwear Accessories Licenced merchandise Sports equipment Equipment repairs 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) 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 2% Licenced merchandise 0% 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) 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 Average full time staff wage per week Total full time staff wage costs Number of casual sales staff hours Average casual hourly rate Total annual casual staff costs Other staff costs: Management salaries Administrative staff wages and salaries Total staff wage and salary costs: Staff training (\% Sales) Staff training (\$) Local advertising and marketing (\% Sales) 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 Utilities \{Electricity/Gas etc\} Sundry business costs 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 $180,576 Rental costs $451,441 Security services $90,288 IT Support and systems $270,865 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 4% Head office administration charge \{\% Sales } 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 6.00% Increase in utilities costs 20.00% Increase in sundry business costs 6.00% Wages are expected to increase as follows: a) Management salaries 5.00% b) Administrative salaries 6.00% c) Increase for all sales staff (full time and casual\} 6.00%