Standard formats The following formats will be used when preparing Houzit budgets and variance reports. Sales and profit budgets PROFIT BUDGET 2011/12 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Revenue 0% 0% % % Sales X,XXX X,XXX X,XXX X,XXX X,XXX Cost of Goods Sold XXX'X XXX'X X, XXX X, XXX XXX'X Gross Profit Calculation Calculation Calculation Calculation Calculation Gross Profit % Calculation Calculation Calculation Calculation Calculation Expenses Accounting Fees X,XXX X,XXX X,XXX X,XXX X,XXX Interest Expense XXX'X X,XXX XXX'X X, XXX X,XXX Bank Charges X,XXX X,XXX X,XXX XXX'X X, XXX - Depreciation X,XXX X, XXX X, XXX X, XXX X,XXX - Insurance X,XXX X,XXX X, XXX X,XXX X,XXX - Store Supplies X, XXX X,XXX X,XXX XXX'X X, XXX Advertising X,XXX X,XXX X, XXX X,XXX X,XXX Cleaning X,XXX X,XXX XXX'X XXX'X X,XXX - Repairs & X,XXX X, XXX XXX'X X,XXX X,XXX Maintenance - Rent X,XXX X,XXX XXX'X X,XXX X,XXX - Telephone XXX'X XXX'X X,XXX X,XXX X,XXX Electricity Expense X, XXX X,XXX X,XXX XXX'X X, XXX Luxury Car Tax X,XXX X, XXX X,XXX XXX'X X,XXX - Fringe Benefits Tax X, XXX X,XXX X, XXX X,XXX XXX'X Superannuateon X,XXX X,XXX X,XXX X,XXX XXX'X - Wages & Salaries X,XXX X, XXX XXX'X X,XXX X,XXX - Payroll Tax X,XXX X,XXX X,XXX X,XXX X,XXX Workers' X,XXX X,XXX XXX'X XXX'X X,XXX Compensation Total Expenses Calculation Calculation Calculation Calculation Calculation Net Profit (Before Tax) Calculation Calculation Calculation Calculation Calculation Income Tax Calculation Calculation Calculation Calculation Calculation Net Profit Calculation Calculation Calculation Calculation Calculation GST Cash flow budget CASH FLOW ANALYSIS - GST 2011/12 Qtr 1 Qtr 2 Qtr 3 Qtr 4 GST Collected XXX'X XXX'X XXX'X X, XXX X,XXX Less GST Paid X,XXX X,XXX X, XXX X,XXX XXX'X BSBFIM601 Manage finances Assessment - Version: 1.0 (Created: 12/10/17; Printed: 3/06/18) This document is uncontrolled version when printed. 20