Business plan. | страница 70

70 71 200 Blogger clothing endorsement UNITS 0 Virtual run pop up shop access 0 24,495 Average of 50 a sale after 15% off (£) Total sales (£) Pop up shop gross sales 12,000 Average of 60 a sale after 10% off (£) Endorsement Gross sales 12,495 500 Alice 27,744 2,500 50 9,000 150 16,244 650 Chessie Jun ‘17 22909.14 19620.64 May ‘17 4834.36 20 150 20 150 4874.36 20 180 0 240 £24.99 per subscription (£) App Subsription Gross Sales App Subsription UNITS SALES FORECAST Total Expenses/ overheads Total net profit 3916.66 287.70 3916.66 287.70 100% 45 15 200 100% Gross profit margin (%) 27743.5 0 27743.5 Jun ‘17 £ 45 15 200 24495 Gross profit Expenses/ overheads Telephone Stationary Marketing/ Advertising Wages Equipment hire (3 x Laptops) Travel card Blogger percentage Insurance Blogger outfits 0 24495 Revenue Cost of sales May ‘17 £ Month 4746.81 20 150 0 112.45 3916.66 287.70 45 15 200 100% 15618.75 0 15618.75 Aug ‘17 £ Faya Jul ‘17 24,495 0 0 12,000 200 12,495 500 15413.14 4834.36 20 150 20 180 3916.66 287.70 45 15 200 100% 20247.5 0 20247.5 Sep ‘17 £ 45 15 300 100% 4249 0 4249 Nov ‘17 £ 20 150 0 60 9624.64 (545.36) 4874.36 4794.36 20 150 0 240 3916.66 3916.66 287.70 287.70 45 15 200 100% 14499 0 14499 Oct ‘17 £ 4585.44 4914.36 20 150 0 180 3916.66 287.70 45 15 300 100% 9499.8 0 9499.8 Dec ‘17 £ 15,618.75 0 0 5,622.75 225 9,996 400 Hazel Aug ‘17 20,247.50 5,000 100 9,000 150 6,247.50 250 Tally Sep ‘17 14,499 0 0 12,000 200 2,499.00 100 Lottie Oct ‘17 4,249.00 0 0 3,000 50 1,249.50 50 Grace Nov ‘17 YEAR ONE 19620.64 10871.94 4874.36 20 150 0 240 3916.66 287.70 45 15 200 100% 24495 0 24495 Jul ‘17 £ Feb ‘18 £ Mar ‘18 £ Apr ‘18 £ Total £ 9,499.80 0 0 9,000 150 499.80 20 Emily Dec ‘17 7225.54 5024.36 20 150 0 240 3916.66 287.70 45 15 350 100% 12249.9 0 45 15 200 100% 9249.9 0 20 150 0 180 12,000 0 0 12,000 200 249.90 10 Twice the Health Jan ‘18 14,000 5,000 100 9,000 150 249.90 10 Steph 9,000 0 0 9,000 150 249.90 10 Victoria Zanna Apr ‘18 30,000 0 0 30,000 500 624.75 25 143567.23 58654.77 240 1800 60 2632.45 46999.92 3452.40 540 180 2750 0 202222 0 Mar ‘18 25390.39 5234.36 20 150 0 600 3916.66 287.70 45 15 200 100% 30624.75 0 Feb ‘18 4415.54 4435.54 4834.36 4814.36 20 150 20 180 3916.66 3916.66 287.70 287.70 45 15 200 100% 9249.9 0 12,249.90 9,249.90 9,249.90 30,624.75 202222 Jan ‘18 £ PROFIT & LOSS 205847.55 12500 250 131,623 2325 63,099.75 2525 TOTAL