BSBMGT517 Assessment

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)

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