BSBMGT517 Assessment

profileHONORE
BSBMGT517FinancialStatementsandStats.xlsx
Home>Business & Finance homework help>Management homework help>BSBMGT517 Assessment

NCT Sales & Staff History

2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
Sales $4,756,302 $4,933,098 $5,209,894 $4,956,302 $4,833,098 $4,909,894 $5,186,690 $5,363,486 $5,040,282 $4,817,078 $4,425,610
Gross Margin $1,950,084 $1,874,577 $2,031,859 $1,932,958 $2,029,901 $2,160,353 $2,282,144 $2,520,838 $2,469,738 $2,553,051 $2,242,121
Gross Margin % of Sales 41.0% 38.0% 39.0% 39.0% 42.0% 44.0% 44.0% 47.0% 49.0% 53.0% 50.7%
Operating Expenses $689,076 $633,275 $702,474 $838,202 $804,936 $823,869 $904,140 $1,009,046 $1,362,487 $1,637,807 $1,590,148
Operating expenses % of sales 14.5% 12.8% 13.5% 16.9% 16.7% 16.8% 17.4% 18.8% 27.0% 34.0% 35.9%
EBITDA $1,261,008 $1,241,303 $1,329,385 $1,094,756 $1,224,965 $1,336,484 $1,378,004 $1,511,793 $1,107,251 $915,245 $651,973
EBITDA % of sales 26.5% 25.2% 25.5% 22.1% 25.3% 27.2% 26.6% 28.2% 22.0% 19.0% 14.7%
Camper Trailers (RRP ave) $15,854 $16,389 $17,251 $18,357 $18,953 $20,458 $23,052 $25,540 $25,848 $26,762 $29,504
Camper Trailers (No) 300 301 302 270 255 240 225 210 195 180 150
Staff Structure and Manpower Report Ave resigned past years
Finance, HR and WHS
Staff No's 3 3 3 3 3 4 4 5 5 6 9
New employees 0 0 0 0 1 0 1 0 1 2 1
Employees resigned * 0 0 0 0 0 0 0 0 0 -1 0
Total at end of Year 3 3 3 3 4 4 5 5 6 9 10
% resigned in the year 0% 0% 0% 0% 25% 0% 20% 0% 17% 11% 10% 8%
Factory Manufacturing
Staff No's 8 8 9 10 10 10 10 10 9 8 9
New employees 0 1 1 0 0 0 0 0 1 1 1
Employees resigned * 0 0 0 0 0 0 0 1 2 0 0
Total at end of Year 8 9 10 10 10 10 10 9 8 9 10
% resigned in the year 0% 11% 10% 0% 0% 0% 0% 11% 38% 11% 10% 8%
Assembly & Fitout
Staff No's 18 15 16 13 15 17 12 15 15 14 15
New employees 0 1 1 2 2 0 3 5 6 9 10
Employees resigned * 3 0 4 0 0 5 0 5 7 8 8
Total at end of Year 15 16 13 15 17 12 15 15 14 15 17
% resigned in the year 20% 6% 38% 13% 12% 42% 20% 67% 93% 113% 106% 48%
Sales & Marketing
Staff No's 7 8 9 9 9 9 7 9 8 9 10
New employees 1 1 0 0 0 0 2 0 2 1 0
Employees resigned * 0 0 0 0 0 2 0 1 1 0 0
Total at end of Year 8 9 9 9 9 7 9 8 9 10 10
% resigned in the year 13% 11% 0% 0% 0% 29% 22% 13% 33% 10% 0% 12%
Total Staff
Staff No's 36 34 37 35 37 40 33 39 37 37 43
New employees 1 3 2 2 3 0 6 5 10 13 12
Employees resigned * 3 0 4 0 0 7 0 7 10 7 8
Total at end of Year 40 37 35 37 40 33 39 37 37 43 47
% resigned in the year 8% 8% 17% 5% 8% 21% 15% 32% 54% 47% 43% 23%
Employees resigned * Includes, resigned, terminations and redundancies
Staff numbers do not include contractors, part time workers have been pro rated to a full time equivalent (FTE)

National Camper Trailers - 10 Year Sales & Financials

Sales 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 4756302 4933098 5209894 4956302 4833098 4909894 5186690 5363486 5040282 4817078 4425610 Gross Margin 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 1950083.8199999998 1874577.24 2031858.6600000001 1932957.78 2029901.16 2160353.36 2282143.6 2520838.42 2469738.1800000002 2553051.3400000003 2242121 Gross Margin % of Sales 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 0.41 0.38 0.39 0.39 0.42 0.43999999999999995 0.44 0.47 0.49000000000000005 0.53 0.50662417158312645 Operating Expenses 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 689075.5 633274.5 702473.5 838201.54 804936.46 823869.26 904140.1 1009045.8 1362487.42 1637806.52 1590148.44 Operating expenses % of sales 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 0.14487631357302375 0.12837257642155092 0.13483450910901451 0.16911833459704434 0.16654668703179615 0.16779776915754191 0.17431928648135903 0.18813245713701873 0.27031968052581185 0.34 0.35930604820578405 EBITDA 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 1261008.3199999998 1241302.74 1329385.1600000001 1094756.24 1224964.7 1336484.0999999999 1378003.5 1511792.6199999999 1107250.7600000002 915244.8200000003 651972.56000000006 EBITDA % of sales 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 0.2651236864269762 0.25162742357844908 0.2551654908909855 0.22088166540295567 0.25345331296820384 0.27220223084245809 0.26568071351864098 0.28186754286298127 0.2196803194741882 0.19000000000000006 0.14731812337734235

3 Year P&L with Budget

2013 2014 2015 2016 2012
Sales $5,040,282 $4,817,078 $4,425,610 $4,720,000 $5,363,486
Gross Margin $2,469,738 $2,553,051 $2,242,121 $2,311,000 $2,520,838
Gross Margin % of Sales 49.0% 53.0% 50.7% 49.0% 47.0%
Operating Expenses $1,362,487 $1,637,807 $1,590,148 $1,553,800 $1,009,046
Operating expenses % of sales 27.0% 34.0% 35.9% 35.9% 18.8%
EBITDA $1,107,251 $915,245 $651,973 $757,200 $1,511,793
EBITDA % of sales 22.0% 19.0% 14.7% 13.4% 28.2%
Camper Trailers (RRP ave) $25,848 $26,762 $29,504 $29,504 ($357,566)
Camper Trailers (No) 195 180 150 160 -15
Staff at end of Year 37 43 47 47
Expenses
Advertising $30,000 $221,710 $180,000 $220,000
Travel & Accomodation $115,185 $122,540 $125,600 $95,000
Office Staff $531,259 $542,100 $560,100 $558,000
Communications $52,400 $54,400 $56,000 $46,000
Vehicle expenses $44,500 $44,000 $46,000 $41,000
Depreciation $210,010 $224,200 $234,333 $235,000
Insurance $78,495 $85,157 $78,415 $46,000
Operating supplies $3,200 $13,200 $3,200 $1,800
Rent $271,420 $285,000 $275,000 $275,000
Office costs $8,500 $10,500 $10,500 $12,000
Computer Expenses $17,518 $35,000 $21,000 $24,000
Operating Expenses $1,362,487 $1,637,807 $1,590,148 $1,553,800
2013 2014 2015 2016
Sales Growth -6.03% -4.43% -8.13% 6.65%
Percent of Total Assets
Total Current Assets 44.00% 46.00% 52.00% 54.00%
Long-term Assets 56.00% 54.00% 48.00% 46.00%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 11.00% 12.00% 7.40% 9.50%
Long-term Liabilities 23.00% 22.00% 21.10% 20.00%
Total Liabilities 34.00% 34.00% 28.50% 29.50%
Net Worth 66.00% 66.00% 71.50% 70.50%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 49.00% 53.00% 50.66% 48.96%
Selling & Administrative Expenses 27.03% 34.00% 35.93% 35.93%
Profit Before Interest and Taxes 21.97% 19.00% 14.73% 13.41%

Sheet2

NCT B-Sheet 30 June 2015

NATIONAL CAMPER TRAILERS - BALANCE SHEET
Balance Sheet 30/Jun/14 30/Jun/15
Current Assets
Cash $850,015 $650,578
Accounts Recieveable $802,846 $1,185,725
Provision for Doubtful Debts -$40,140 $762,706 -$39,620 $1,146,105
Spare parts $119,800 $98,002
Campers WIP $659,234 $990,528
Other Debtors $85,000 $78,520
Total Current Assets $2,476,755 $2,963,733
Non Current Assets
Expo Truck & Vehicles $200,000 $200,000
Less: Accumulated depreciation -$33,333 $166,667 -$58,333 $141,667
Manufacturing Equipment $850,000 $850,000
Less: Accumulated depreciation -$170,000 $680,000 -$255,000 $595,000
Land & Buildings at cost $2,900,000 $2,900,000
Less: Accumulated depreciation -$812,000 $2,088,000 -$928,000 $1,972,000
Total Non Current Assets $2,934,667 $2,708,667
Tortal Assets $5,411,422 $5,672,400
Current Liabilities
Accounts payable $285,000 $243,800
Accrued wages $95,000 $13,500
Accrued compensation $70,000 $70,000
Income taxes payable $123,216 $73,000
Payroll taxes payable $21,000 $21,000
Total Current Liabilities $594,216 $421,300
Long-Term Liabilities
Long-term loan payable $1,200,000 $1,200,000
Total Liabilities $1,794,216 $1,621,300
Stockholders' Equity
Share Capital $750,000 $750,000
Accumulated retained earnings $2,226,535 $2,867,206
Current net profit (loss) $640,671 $433,894
Less: Dividend $0 $0
Total Capital $3,617,206 $4,051,100
Total Liabillities & Equity $5,411,422 $5,672,400
$0 $0

NCT Trial Balance June 2015

NATIONAL CAMPER TRAILERS - TRIAL BALANCE
Debits Credits
Balance Sheet 30/Jun/15
Cash $643,763
Petty Cash $500
Accounts Recieveable $1,385,184
Provision for Doubtful Debts $39,620
Prepaid insurance $6,315
Spare parts $98,102
Campers WIP $1,249,020
Other Debtors $79,018
Expo Truck & Vehicles $200,000
Less: Accumulated depreciation $58,333
Manufacturing Equipment $850,000
Less: Accumulated depreciation $255,000
Land & Buildings at cost $2,900,000
Less: Accumulated depreciation $928,000
Accounts payable $342,800
Accrued wages $95,000
Accrued compensation $70,000
Income taxes payable $133,000
Payroll taxes payable $21,000
Long-term loan payable $1,200,000
Stockholders' Equity
Share Capital $750,000
Accumulated retained earnings $2,867,206
Sales Revenue $4,252,610
Spare parts & services $201,500
Gain (loss) on sale of assets $22,000
Cost of goods sold - Materials & Fittings $463,700
Cost of goods sold - Labour $1,161,160
Cost of goods sold - Other costs $318,161
Advertising $180,000
Freight $85,600
Bad debt written off $35,000
Bank charges $1,400
Office Staff $580,160
Payroll taxes $21,000
Vehicle expenses $44,000
Depreciation $234,333
Dues and subscriptions $17,500
Entertainment $2,300
Insurance $79,000
Interest expense $4,027
Maintenance $51,000
Miscellaneous $52,111
Office expense $9,000
Operating supplies $3,700
Permits and licenses $2,600
Postage $1,500
Professional fees $2,000
Property taxes $2,100
Rent $275,000
Repairs $2,000
Telephone $21,000
Travel $56,100
Utilities $21,000
Income taxes $53,715
$11,214,069.00 $11,214,069.00

Deprecaition Schedule

DEPRECIATION WORK SHEET 30/06/2015
Description of Property Date Purchased Cost Price Investment Use % Basis for Depreciation Amortization Period (Years) Period Already used (in Yrs) Depreciation Rate % (per Year) Depreciation (per Year) Cumulated Depreciation If dispsposed in the current year enter (Y) Total Cost of Disposal Net Value
Expo Truck & Vehicles 09/01/2013 $ 200,000.00 100% Prime cost 6 1.75 17% $ 33,333.33 $ 58,333.33 - $ 141,666.67
Land & Building 01/07/2006 $ 2,900,000.00 100% Prime Cost 25 8.00 4% $ 116,000.00 $ 928,000.00 $ 1,972,000.00
Manufacturing Equipment 01/07/2012 $ 850,000.00 100% Prime Cost 10 3.00 10% $ 85,000.00 $ 255,000.00 $ 595,000.00
Total $ 3,950,000.00 $ 3.00 $ - 0 $ 41.00 $ 12.75 $ 0.31 $ 234,333.33 $ 1,241,333.33 $ - 0 $ - 0 $ 2,708,666.67

NCT Budget

Nationl Camper Trailers - Budget July 2015 to June 2016
Sales of Trailers
Forecast Nos Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16
Dandenong 80 8 8 8 8 8 4 3 8 9 9 9 9 91
Caboolture 24 2 2 2 2 2 2 2 2 2 2 2 2 24
Expo Truck 48 4 4 4 4 4 3 2 4 4 4 4 4 45
14 14 14 14 14 9 7 14 15 15 15 15 160
Ave sale price $29,500 $413,000 $413,000 $413,000 $413,000 $413,000 $265,500 $206,500 $413,000 $442,500 $442,500 $442,500 $442,500 $4,720,000
Factory Manufacturing Ave Factory Cost Per Trailer $3,400
Raw materials 23% $14,168 $14,168 $14,168 $14,168 $14,168 $9,108 $7,084 $14,168 $15,180 $15,180 $15,180 $15,180 $161,920
Labour 61% $37,576 $37,576 $37,576 $37,576 $37,576 $24,156 $18,788 $37,576 $40,260 $40,260 $40,260 $40,260 $429,440
Factory costs * 7% $4,312 $4,312 $4,312 $4,312 $4,312 $2,772 $2,156 $4,312 $4,620 $4,620 $4,620 $4,620 $49,280
Repairs & Maintence 9% $5,544 $5,544 $5,544 $5,544 $5,544 $3,564 $2,772 $5,544 $5,940 $5,940 $5,940 $5,940 $63,360
$4,400 Factory COG's $61,600 $61,600 $61,600 $61,600 $61,600 $39,600 $30,800 $61,600 $66,000 $66,000 $66,000 $66,000 $704,000
Assembly & Fitout Ave Assembly Cost Per Trailer $9,200
Accessories 23% $26,404 $26,404 $26,404 $26,404 $26,404 $16,974 $13,202 $26,404 $28,290 $28,290 $28,290 $28,290 $301,760
Labour 56% $64,288 $64,288 $64,288 $64,288 $64,288 $41,328 $32,144 $64,288 $68,880 $68,880 $68,880 $68,880 $734,720
Factory costs * 8% $9,184 $9,184 $9,184 $9,184 $9,184 $5,904 $4,592 $9,184 $9,840 $9,840 $9,840 $9,840 $104,960
Repairs & Maintence 8% $9,184 $9,184 $9,184 $9,184 $9,184 $5,904 $4,592 $9,184 $9,840 $9,840 $9,840 $9,840 $104,960
Finishing costs 5% $5,740 $5,740 $5,740 $5,740 $5,740 $3,690 $2,870 $5,740 $6,150 $6,150 $6,150 $6,150 $65,600
$8,200 Assembly COG's $114,800 $114,800 $114,800 $114,800 $114,800 $73,800 $57,400 $114,800 $123,000 $123,000 $123,000 $123,000 $1,312,000
Average Trailers completed per month
Cost of the Expo Truck
Expenses
Staff Expenditure $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $192,000
Accomodation $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $96,000
Meal and entertainment $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000
Cost of Trailer Transport $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $54,000
Trailer transport insurance $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $9,000
Costs of Expo Truck $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $32,750 $393,000
Gross Margin $203,850 $203,850 $203,850 $203,850 $203,850 $119,350 $85,550 $203,850 $220,750 $220,750 $220,750 $220,750 $2,311,000
49% 49% 49% 49% 49% 45% 41% 49% 50% 50% 50% 50% 49%
Selling & administration Expenses
Advertising $18,000 $19,000 $21,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $220,000
Travel & Accomodation $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $7,000 $8,000 $8,000 $8,000 $8,000 $8,000 $95,000
Office Staff $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $46,500 $558,000
Communications $4,000 $4,000 $4,000 $4,000 $4,000 $3,000 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $46,000
Vehicle expenses $4,000 $4,000 $4,000 $4,000 $4,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $41,000
Depreciation $18,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $20,000 $20,000 $21,000 $21,000 $21,000 $235,000
Insurance $4,000 $4,000 $4,000 $4,000 $4,000 $3,000 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $46,000
Operating supplies $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800
Rent $22,910 $22,910 $22,910 $22,910 $22,910 $22,910 $22,910 $22,910 $22,910 $22,990 $22,910 $22,910 $275,000
Office costs $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000
Computer Expenses $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000
Operating Expenses $128,560 $130,560 $132,560 $129,560 $129,560 $126,560 $125,560 $129,560 $129,560 $130,640 $130,560 $130,560 $1,553,800
Earnings before Interest, Tax & Dividends EBITDA $75,290 $73,290 $71,290 $74,290 $74,290 -$7,210 -$40,010 $74,290 $91,190 $90,110 $90,190 $90,190 $757,200

NCT 8 Mth P&L

Nationl Camper Trailers - 8 month Profit and Loss (July -15 to Feb - 16) Budget for (Mar to June 16) Forecast Year End
Sales of Trailers
Forecast No. of Trailers Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 YTD Actual YTD Budget Variance Mar-16 Apr-16 May-16 Jun-16 30/Jun/16
Dandenong 80 6 11 3 3 7 2 6 8 46 55 (9) 9 9 9 9 82
Caboolture 24 2 3 2 1 2 1 1 3 15 16 (1) 2 2 2 2 23
Expo Truck 48 5 5 3 2 1 1 2 2 21 29 (8) 4 4 4 4 37
13 19 8 6 10 4 9 13 82 100 (18) 15 15 15 15 142
Ave sale price $29,500 $383,500 $560,500 $236,000 $177,000 $295,000 $118,000 $265,500 $383,500 $2,419,000 $2,950,000 -$531,000 $442,500 $442,500 $442,500 $442,500 $4,189,000
Factory Manufacturing Ave Factory Cost Per Trailer $3,400
Raw materials $13,156 $19,228 $8,096 $6,072 $10,120 $4,048 $9,108 $13,156 $82,984 $101,200 -$18,216 $15,180 $15,180 $15,180 $15,180 $143,704
Labour $36,300 $36,250 $36,250 $36,000 $35,150 $34,200 $33,100 $35,830 $283,080 $268,400 $14,680 $40,260 $40,260 $40,260 $40,260 $444,120
Factory costs * $4,004 $5,852 $2,464 $1,848 $3,080 $1,232 $2,772 $4,004 $25,256 $30,800 -$5,544 $4,620 $4,620 $4,620 $4,620 $43,736
Repairs & Maintence $5,148 $7,524 $3,168 $2,376 $3,960 $1,584 $3,564 $5,148 $32,472 $39,600 -$7,128 $5,940 $5,940 $5,940 $5,940 $56,232
Factory COG's $58,608 $68,854 $49,978 $46,296 $52,310 $41,064 $48,544 $58,138 $423,792 $440,000 -$16,208 $66,000 $66,000 $66,000 $66,000 $687,792
Assembly & Fitout Ave Assembly Cost Per Trailer $9,200
Accessories 23% $24,518 $35,834 $15,088 $11,316 $18,860 $7,544 $16,974 $24,518 $154,652 $188,600 -$33,948 $28,290 $28,290 $28,290 $28,290 $267,812
Labour 56% $59,696 $87,248 $36,736 $27,552 $45,920 $18,368 $41,328 $59,696 $376,544 $459,200 -$82,656 $68,880 $68,880 $68,880 $68,880 $652,064
Factory costs * 8% $8,528 $12,464 $5,248 $3,936 $6,560 $2,624 $5,904 $8,528 $53,792 $65,600 -$11,808 $9,840 $9,840 $9,840 $9,840 $93,152
Repairs & Maintence 8% $8,528 $12,464 $5,248 $3,936 $6,560 $2,624 $5,904 $8,528 $53,792 $65,600 -$11,808 $9,840 $9,840 $9,840 $9,840 $93,152
Finishing costs 5% $5,330 $7,790 $3,280 $2,460 $4,100 $1,640 $3,690 $5,330 $33,620 $41,000 -$7,380 $6,150 $6,150 $6,150 $6,150 $58,220
$8,200 Assembly COG's $106,600 $155,800 $65,600 $49,200 $82,000 $32,800 $73,800 $106,600 $672,400 $820,000 -$147,600 $123,000 $123,000 $123,000 $123,000 $1,164,400
Average Trailers completed per month
Cost of the Expo Truck
Expenses
Staff Expenditure $16,500 $16,200 $15,890 $16,199 $15,100 $16,200 $16,000 $16,350 $128,439 $145,000 -$16,561 $17,000 $17,000 $17,000 $17,000 $196,439
Accomodation $8,528 $12,464 $5,248 $3,936 $6,560 $2,624 $5,904 $8,528 $53,792 $75,000 -$21,208 $8,000 $8,000 $8,000 $8,000 $85,792
Meal and entertainment $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $28,000 $30,000 -$2,000 $3,300 $3,300 $3,300 $3,300 $41,200
Cost of Trailer Transport $4,500 $4,400 $4,300 $4,610 $4,500 $4,500 $4,400 $4,500 $35,710 $33,000 $2,710 $4,500 $4,500 $4,500 $4,500 $53,710
Trailer transport insurance $750 $750 $750 $750 $750 $750 $750 $750 $6,000 $6,000 $0 $750 $750 $750 $750 $9,000
Costs of Expo Truck $33,778 $37,314 $29,688 $28,995 $30,410 $27,574 $30,554 $33,628 $251,941 $289,000 -$37,059 $33,550 $33,550 $33,550 $33,550 $386,141
Gross Margin $184,514 $298,532 $90,734 $52,509 $130,280 $16,562 $112,602 $185,134 $1,070,867 $1,428,000 -$357,133 $219,950 $219,950 $219,950 $219,950 $1,950,667
48% 53% 38% 30% 44% 14% 42% 48% 44% 48% 50% 50% 50% 50% 47%
Selling & administartion Expenses
Advertising $16,500 $16,200 $15,890 $16,199 $15,100 $16,200 $16,000 $16,350 128,439 120,000 $8,439 $18,000 $18,000 $18,000 $18,000 $200,439
Travel & Accomodation $6,500 $6,200 $5,890 $6,199 $5,100 $6,200 $6,000 $6,350 48,439 55,000 -$6,561 $6,500 $6,500 $6,500 $6,500 $74,439
Office Staff $36,300 $36,250 $36,250 $37,000 $41,250 $41,250 $41,250 $42,500 312,050 280,000 $32,050 $46,500 $46,500 $46,500 $46,500 $498,050
Communications $5,330 $7,790 $3,280 $2,460 $4,100 $1,640 $3,690 $5,330 33,620 30,100 $3,520 $3,800 $3,800 $3,800 $3,800 $48,820
Vehicle expenses $3,512 $3,200 $3,819 $3,199 $3,100 $3,200 $3,416 $3,148 26,594 27,500 -$906 $3,400 $3,400 $3,400 $3,400 $40,194
Depreciation $19,583 $19,583 $19,583 $19,583 $19,583 $19,583 $19,583 $19,583 156,664 156,664 $0 $19,583 $19,583 $19,583 $19,583 $234,996
Insurance $3,512 $3,200 $3,819 $3,199 $3,819 $3,199 $3,100 $3,200 27,048 27,500 -$452 $3,400 $3,400 $3,400 $3,400 $40,648
Operating supplies $120 $130 $10 $300 $228 $122 $130 $140 1,180 1,200 -$20 $150 $150 $150 $150 $1,780
Rent $22,916 $22,916 $22,916 $22,916 $22,916 $22,916 $22,916 $22,916 183,328 183,350 -$22 $22,916 $22,916 $22,916 $22,916 $274,992
Office costs $950 $980 $1,521 $1,200 $650 $600 $1,250 $989 8,140 8,000 $140 $1,000 $1,000 $1,000 $1,000 $12,140
Computer Expenses $2,100 $1,950 $1,980 $2,300 $2,450 $2,100 $1,800 $900 15,580 16,000 -$420 $2,000 $2,000 $2,000 $2,000 $23,580
$117,323 $118,399 $114,958 $114,555 $118,296 $117,010 $119,135 $121,406 $941,082 $905,314 $35,768 $127,249 $127,249 $127,249 $127,249 $1,450,078
Net Profit Before Taxes $67,191 $180,133 -$24,224 -$62,046 $11,984 -$100,448 -$6,533 $63,728 $129,785 $522,686 -$392,901 $92,701 $92,701 $92,701 $92,701 $500,589

Expo Truck Analysis

Expo Truck Budget & Actuals Year Ending 2016
Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Year to Date Actual Budget Varinace Mar-16 Apr-16 May-16 Jun-16 Forecast Year End Original Budget Variance with Forecast
No of Trailers 4 2 3 3 2 2 1 2 19 28 (9) 4 4 4 4 35 48 (13) 73
Revenue
Sales generated from Expo's $118,000 $60,000 $91,000 $88,500 $66,000 $59,000 $30,000 $63,000 $575,500 $826,000 -$250,500 $118,000 $118,000 $118,000 $118,000 $1,047,500 $1,416,000 -$368,500
Less Cost of Sales -$50,000 -$25,000 -$37,800 -$37,500 -$25,600 -$25,000 -$11,000 -$23,000 -$234,900 -$350,000 $115,100 -$50,000 -$50,000 -$50,000 -$50,000 -$434,900 -$600,000 $165,100
Gross Margin $68,000 $35,000 $53,200 $51,000 $40,400 $34,000 $19,000 $40,000 $340,600 $476,000 -$135,400 $68,000 $68,000 $68,000 $68,000 $612,600 $816,000 -$203,400
Gross Margin % 58% 58% 58% 58% 61% 58% 63% 63% 59% 58% 58% 58% 58% 58% 58% 58%
Expenses
Staff Expenditure $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $128,000 $145,000 -$17,000 $17,000 $17,000 $17,000 $17,000 $196,000 $204,000 -$8,000
Accomodation $8,000 $7,500 $9,000 $12,000 $11,200 $15,000 $6,500 $8,200 $77,400 $75,000 $2,400 $6,500 $6,500 $6,500 $6,500 $103,400 $78,000 $25,400
Meal and entertainment $3,500 $3,000 $4,500 $3,500 $3,800 $4,100 $3,300 $3,200 $28,900 $30,000 -$1,100 $3,300 $3,300 $3,300 $3,300 $42,100 $39,600 $2,500
Cost of Trailer Transport $4,500 $2,500 $7,000 $4,000 $8,500 $4,500 $2,600 $3,000 $36,600 $33,000 $3,600 $2,600 $2,600 $2,600 $2,600 $47,000 $31,200 $15,800
Trailer transport insurance $750 $900 $800 $800 $750 $750 $750 $750 $6,250 $6,000 $250 $750 $750 $750 $750 $9,250 $9,000 $250
Total Expenses $32,750 $29,900 $37,300 $36,300 $40,250 $40,350 $29,150 $31,150 $277,150 $289,000 -$11,850 $30,150 $30,150 $30,150 $30,150 $397,750 $361,800 $35,950
Net Profit From Exhibitions $35,250 $5,100 $15,900 $14,700 $150 -$6,350 -$10,150 $8,850 $63,450 $187,000 -$123,550 $37,850 $37,850 $37,850 $37,850 $214,850 $454,200 -$239,350
Additional Information
Ave Sale Price per Trailer $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500
Avarage Cost Per Trailer -$12,500 -$12,500 -$12,600 -$12,500 -$12,800 -$12,500 -$11,000 -$11,500 -$12,500 -$12,500 -$12,500 -$12,500 -$12,500 -$12,500
Staff Nos 3 3 3 3 3 3 3 3 3 3 3 3 3
Trailers sold in the year 4 2 3 3 2 2 1 2 28 4 4 4 4 48
No of leads 120 140 90 132 300 310 265 240 180 120 150 121

Sheet3

Expo Truck Budget June - Dec 2015
Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 June- Dec Budget June- Dec Actual
No of Trailers 4 2 3 3 2 2 16 13
Revenue
Sales generated from Expo's $118,000 $60,000 $91,000 $88,500 $66,000 $59,000 $482,500 $383,500
Less Cost of Sales -$50,000 -$25,000 -$37,800 -$37,500 -$25,600 -$25,000 -$200,900 -$162,500
Gross Margin $68,000 $35,000 $53,200 $51,000 $40,400 $34,000 $281,600 $221,000
Gross Margin % 58% 58% 58% 58% 61% 58% 58% 58%
Expenses
Staff Expenditure $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $96,000 $145,000
Accomodation $8,000 $7,500 $9,000 $12,000 $11,200 $15,000 $62,700 $75,000
Meal and entertainment $3,500 $3,000 $4,500 $3,500 $3,800 $4,100 $22,400 $30,000
Cost of Trailer Transport $4,500 $2,500 $7,000 $4,000 $8,500 $4,500 $31,000 $33,000
Trailer transport insurance $750 $900 $800 $800 $750 $750 $4,750 $6,000
Total Expenses $32,750 $29,900 $37,300 $36,300 $40,250 $40,350 $216,850 $289,000
Net Profit From Exhibitions $35,250 $5,100 $15,900 $14,700 $150 -$6,350 $64,750 -$68,000
Additional Information
Ave Sale Price per Trailer $29,500 $29,500 $29,500 $29,500 $29,500 $29,500 $29,500
Avarage Cost Per Trailer -$12,500 -$12,500 -$12,600 -$12,500 -$12,800 -$12,500 -$12,500