From this information I was able to estimate the total number of students that would visit the stall.
=0.63 x (125 x 4)
= 315
I multiplied the percentage interested in the idea by the year size. Upon multiplying this figure by four, I was left with the total number of students in years 7, 8, 9 and 10 that were interested in buying products from the stall.
Now that I knew the number of students that would visit, I analysed the figures that showed the number of times that they would visit, both in one day and in a week.
Note: in the Total row I have estimated the number in the entire year, not just the people taking the questionnaire.
Having established how many times people would be willing to visit in one day, I then went on to question the audience about how many days, in one week, they would be willing to visit the stall.
The average number of days of visiting was calculated by multiplying total of each column by the number of days, and adding them together. This was then divided by the total number of people that answered the question (63).
To work out the total number of visits in the week I used the following equation:
Average number of daily visits x average number of days visited
= 750 x 4.33
= 3226
To establish the average number of visits per day over the course of five days, not just over 4.3 days, the total number of visits was divided by 5:
Total number of visits ÷ Number of days
= 3226 ÷ 5
= 645 visits per day
Price and Revenue
Having estimated the number of visits that I would get, both in one day and in the entire week, I can now determine a suitable value for the price of the sweets.
The variable and fixed costs of the project must first be worked out before I can argue a price for the product.
The cost of the sweets
In the local shop, they sell 1000 sweets for £6.00. If one bag contains 25 sweets, and there are 645 bags to be sold, then:
= 645 x 25
= 16,125 sweets per day
To determine the price of the sweets, we must first discover how many times £6.00 has to be multiplied by.
= 16,125 ÷ 1000
= 16.125
= 16.125 x £6.00
= £96.75
The bags
Obviously, we cannot merely give the sweets away without packaging them. It is for this reason that we decided to put them in paper bags. These have a cost of 1p each; therefore calculating the cost was simple:
Total cost of bags = Cost of one bag x no. of bags required per day
=£0.01 x 645
= £6.45
The rent
The cost of renting the premises had to be calculated as a fixed cost.
The cost was in half-hour slots, £5.00 for 30 minutes. That meant one slot for break-time and two for lunch-time.
Cost of half hour slot x no. of half hour slots required
£5.00 x 3
= £15.00
The Loan
To pay back the initial loan, payments of £20.00 will be made every day, to make up to the original £100.00. This is considered a fixed cost. I will talk about the loan later.
Determining the Price – Break-even charts
I shall now determine the price for the product by examining two different prices: 25p and 20p per bag.
20p
Working out the exact number of units that had to be sold to break-even, left me with the figure of 875. This presents me with a margin of safety of -230. In other words, we would have to sell 230 more bags of sweets than we would need, in order to break even. This would be impossible as we would only have access to enough bags and sweets to sell 645 bags.
25p
Working out the number of units that had to be sold to break-even at 25p, however, left me with the figure 389. The margin of safety at 25p is considerably more: 256. What this means is that I could sell 256 units less than expected and not still break even.
Profit and Loss
Having established a price, determined the costs, and decided on a number of visits, I am ready to start predicting the profit for charity.
If everything went according to plan, I would be able to make £215.15 for charity.
Source of Funds
The start-up cost of the project is the variable costs (the fixed are payed at the end of the day, by which time we will have had time to raise money). This is equal to the cost of the sweets + the cost of the bags.
= £96.75 + £6.45
= £103.20
A grant received from the Parents Association of £100.00 will cover almost all of the start-up cost. The rest will be funded from an internal source (probably our parents). The grant must be paid off in £20.00 instalments at the end of every day. I have already included this cost in both the break-even charts and profit and loss account. The following is the cash-flow chart for the week in business:
Without the loan, the profit remains the same, due to the lack of interest the PA are charging. However, it is only until Day 4 that we can actually buy the products at the beginning of the day. It is for this reason that we need a loan. We are very capable of paying it back; we just need an injection of money to initiate the process.
From this table, you are able to see that from the loan + retained profit; we are able to buy all of the products at the beginning of the day, instead of relying on profit at the end of the day.
Conclusion
Contrary to my original beliefs that this business idea would not work, it seems that the questionnaire revealed some interesting figures. With clever ‘bargain’ hunting for the best price for sweets and paper bags, coupled with a tax-free loan and you are left with an intelligent business idea, capable of raising more than enough money to cover all the costs and raise £100.00 for charity.
If allowed to go ahead with this plan, I propose to raise approximately £215.25. Obviously, this figure could be far less or far more, as a result of poor reception and lack of advertising leading up to the crucial first day, but, having analysed the findings from the questionnaire and by introducing the product at a reasonable price, I am left with the conclusion that we will raise £215.25 for charity.