instructions:Marketing FinancialsBased on our objectives, presented in table 5 is the financial expenditure of the marketing action plan over a 6 months period. At this point in time the outlet in Egham is not generating any revenues and is out of service.
The total marketing expenditure is of 10400£ for the first 6 months of operation. The first month will be the most capital intensive making up for 47% of our total budget. We are following a burst strategy putting most of our funds at the start. The reason behind this decision comes from the fact that we have a relatively small budget and we believe this will make a bigger impact on the market than if we spread the costs over 6 months. We will however still be incurring monthly costs for the flyers, radio ads and Facebook likes of 900£ per month as well as 2000£ agency fees which we will be collecting in months 1 and 3.
We took five possible scenarios which vary from the most optimistic to the most pessimistic forecast possibilities. We have made these categories based on the amount of customers attracted to our outlet coming from the marketing action plan. We believe that we can expect 3.50£ per customer purchase (price of one scoop of ice cream).
Table 1 illustrates the amount of monthly sales which will come in from our marketing efforts in months 2 to 6 where marketing spending is the same. Table 2 shows the amount of customers and sales generated on the first month of our campaign which is the most capital intensive. Table 3 exposes the return on investment made from our marketing strategy.
These scenarios range from 100% to 10% success rate of people making a single and recuring purchase which are coming from our marketing efforts. We believe 20% of people that have been targeted by our marketing plan will be making a purchase.
As we can see from table 2 the first month of our marketing plan will be the busiest coming from the spending in various marketing channels. We are expecting to have 1040 purchases made. This will amounts to 3,640£ in sales.
Table 3 illustrates a positive return on investment even in the pessimistic scenario section of 10% if we increased that period to a year. We believe that realistically 20% of people that have been targeted by our action plan will make a purchase. The ROI for 20% purchase rate is of 230% generating a total of 19,390£ sales coming from 5540 customers making a single purchase after 6 months.
In order to understand in more details the financial process over the next 6 months of operation we carried out a payback period forecast. The payback period is the time by when the marketing budget will be paid back for. Since we are expecting an average spending of 3.50£ per customer, we will need to attract a minimum of 2400 customers in order to cover our marketing investment. As we can see from table 4, at a marketing performance of 20%, we will be able to pay our marketing budget back in 4 months of operations.
We strongly believe that we could get to the 30% mark however we want to be very conservative in our calculations.

Appendix

Yellow color exposes an optimistic scenario.
Purple color exposes a realistic scenario.
Green color exposes a pessimistic scenario.
Table 1 month revenue forecast (all monghts)
Amount of monthly customers Amount of monthly sales response rate

per month 4500 £15,750 100%
per month 2250 £7,875 50%
per month 1350 £4,825 30%
per month 900 £3,150 20%
per month 450 £1,675 10%
first month customers first month sales response rate
first month 5200 £18,200 100%
first month 2600 £9,100 50%
first month 1560 £5,045 30%
first month 1040 £3,640 20%
first month 520 £1,820 10%
Table 2 First month revenue forecast
Table 3 Aggregate 6 month revenue forecast
Total Amount of customers Total Sales Response rate ROI on marketing expense
all months 27700 £96,950 100% response rate 1155%
all months 13850 £48,775 50% response rate 580%
all months 8310 £29,085 30% response rate 346%
all months 5540 £19,390 20% response rate 230%
all months 2770 £10,195 10% response rate 98%
Table 4 payback period
Response Rate (%) month 1 month 2 month 3 month 4 month 5 month 6
100% 18,200 33,950 49,700 65,450 81,200 96,950
50% 9,100 16,975 24,850 32,725 40,600 48,475
30% 5,045 9,870 14,695 19,520 24,345 29,170
20% 3,640 6,790 9,940 13,090 16,240 19,390
10% 1,820 3,495 5,170 6,845 8,520 10,195
marketing expenditure 5,900 6,800 7,700 8,600 9,500 10,400
Total market 10,400

Blue color shows the payback period and the total marketing expenditure.
Table 5 marketing budget

Item Month 1 (£) Month 2 (£) Month 3 (£) Month 4 (£) Month 5 (£) Month 6 (£)
FCBK Likes 500 500 500 500 500 500
Flyer 200 200 200 200 200 200
Radio 200 200 200 200 200 200
SEO 400
FCBK Page 100
Trailer 1500
Grand Opening 1000
Agency fees 1000 1000
Total Per Month 5900 900 900 1900 900 900
Total 10400