Assignment
For
Financial Management Analysis
School Business and Law
Submitted by: Abdul Waheed Ahmad
Student ID: 0024KDSA1109
Submitted to: Mr. S A Palan
Background:
Drinks and Snacks are within daily need of people. Many people like to grab a bottle of cold drink and crisps in their lunch break or when they go to attend an event. Especially in summer demand of cold drink increases to double. With the upcoming event of London Olympics 2012 there are huge opportunities to start and establish a new business within this sector. Olympics will start in summer and due to high temperature people require quick snacks and drinks. Following business proposal has been written after research of local market and taste of local people.
1.1 General Survey:
A general survey was done for 5 different super stores and following out comes were noted for the products chosen:
Sainsbury | Tesco | Marks and Spencer | Iceland | Nisa Super Market | |
Coke Cola 330ml / 500ml | 55p/110p | 55p/105p | 59p/119p | 55p/115p | 49p/105p |
Tango 330ml / 500ml | 55p/110p | 55p/105p | 59p/119p | 55p/115p | 49p/105p |
Sprite 330ml / 500ml | 55p/110p | 55p/105p | 59p/119p | 55p/115p | 49p/105p |
Walkers Small / Large | 45p/65p | 40p/70p | 45p/70p | 40p/69p | 39p/59p |
Wotsits Small / Large | 35p/55p | 35p/60p | 40p/65p | 39p/60p | 35p/55p |
McCoy's Small / Large | 55p/75p | 50p/75p | 50p/79p | 49p/75p | 45p/70p |
Sneakers Small / Large | 40p/65p | 40p/69p | 45p/70p | 35p/55p | 39p/60p |
Kit Kat Small / Large | 40p/69p | 40p/65p | 35p/55p | 35p/55p | 39p/60p |
Dairy Milk Small / Large | 40p/69p | 40p/65p | 35p/55p | 40p/69p | 39p/60p |
Above table shows that different super markets have different prices for same products, but the difference is not huge due to competition in place.
Following table shows Low and High prices for the different products.
Low End Price | Medium Price | High Price | |
Coke Cola 330ml / 500ml | 49p /105p | 55p / 112.5p | 59p / 119p |
Tango 330ml / 500ml | 49p / 105p | 55p / 112.5p | 59p / 119p |
Sprite 330ml / 500ml | 49p / 105p | 55p / 112.5p | 59p / 119p |
Walkers Small / Large | 39p / 70p | 40p / 67p | 45p / 70p |
Wotsits Small / Large | 35p / 55p | 39p / 60p | 40p / 60p |
McCoy's Small / Large | 45p / 70p | 49.5p / 75p | 55p / 79p |
Sneakers Small / Large | 35p / 55p | 39.5p / 67.5p | 45p / 70p |
Kit Kat Small / Large | 35p / 55p | 39p / 62.5p | 40p / 69p |
Dairy Milk Small / Large | 35p / 55p | 39p / 62.5 p | 40p / 69p |
2.0 Street Survey:
A short questionnaire** was distributed among 100 different people at several places. A short analysis is shown below:
Q1. Which of the following Cold Drinks / Crisps / Chocolate you like the most?
Q2. What size of drink / Crisps / Chocolate you normally buy?
Q4. What Price you like to pay for your selected drink?
I got many funny answers for this question, Most of the times answers were near to zero mean people don't want to pay anything or very less. I managed to get few reasonable answers. Below table shows the average price*** that people wants to pay for the product.
Product | Average Price*** |
Coke Cola 330ml / 500ml | 40p/85p |
Tango 330ml / 500ml | 40p/85p |
Sprite 330ml / 500ml | 40p/85p |
Walkers Small / Large | 35p/55p |
Wotsits Small / Large | 30p/50p |
McCoy's Small / Large | 40p/60p |
Sneakers Small / Large | 30p/55p |
Kit Kat Small / Large | 30p/55p |
Dairy Milk Small / Large | 35p/55p |
*** Prices stated less than 20p were neglected while calculating average price for the products
After evaluating whole data following products were selected for the business plan in three different categories:
Coke Cola Small Pack (Cold Drinks)
Walkers Large Pack (Crisps)
Sneakers Large ( Chocolate)
3.0 Sales Budget:
A Sales Budget is comprehensive plan that shows expected sales for the budgeted period. Sales Budget is shown in terms of No. of units and the unit value.
After the analysis of street survey and detailed study of compotators, following prices were selected. And volumes of sales were estimated according to the local market.
Sales Budget
Coke Cola | Walkers | Sneakers | All Products Total | |
Budgeted Sales | 20000 | 25000 | 30000 | 75000 |
Selling Price per unit | 0.45 | 0.6 | 0.6 | |
Total Sales | 9000 | 15000 | 18000 | 42000 |
4.0 Purchases Budget:
A Purchases Budget is a budget to purchase direct material for the production of goods.
In this case we will buy goods from Major cash and carries. A visit to two major cash and carries in London revealed the following purchase prices.
Coke Cola | Walkers | Sneakers | |
Best Way | 20p | 25p | 21p |
Dhamecha | 22p | 25p | 23p |
Lowest value Selected | 20p | 25p | 21p |
Purchases Budget
Coke Cola | Walkers | Sneakers | All Products Total | |
No of units | 20000 | 25000 | 30000 | 75000 |
Purchase Price per unit | 0.20 | 0.25 | 0.21 | |
Total | 4000 | 6250 | 6300 | 16550 |
5.0: Labour Budget
A Labour Budget is a labour cost for the production of goods. It's normally expressed in No of hours involved to produce one unit and hourly rate.
In this case we assume that shop is opened for 12 hours daily. We require 12 hours of labour every day plus 4 hours of extra labour after every two weeks to purchase goods from Cash and Carry to the shop.
Labour Budget
Daily | Twice a week | yearly | ||
No. of labour hours 1st Man | 8 | 2920 | ||
No of Labour hours 2nd Man | 4 | 416 | ||
Total No of Hours | 3336 | |||
Hourly Rate | 3.25 | |||
Total Labour Cost | 10842 |
6.0 Expenses Budget
A Expenses Budget is administrative cost to sell the product. Often expressed in per unit and also includes fixed cost to run the business.
Expenses Budget
Total Budget Sales | 75000 | ||
Variable Selling and Administrative expenses* | 0.03 | ||
Budget Variable Expenses | 2250 | ||
Fixed Selling and Admin expenses | |||
Rent | 1500 | ||
Advertisement | 500 | ||
Insurance | 550 | ||
Deprecation** | 200 | ||
Total Budget Selling and Admin Expenses | 4800 |
*Includes utility and business rates
**Deprecation for Fridge and cash Register total value of ã1000.00
7.0: Initial Investment:
A total Initial Investment of ã 10600.00 is required. Initial Investment will be made from the following sources:
Personal Saving = 3000.00
Family and Friend = 2000.00
Trade Credit (with Cash and Carry) = 600.00
Bank Loan Required = 5000.00
Total Investment Required = 10600.00
8.0 Investment Appraisal
7 Year Investment Appraisal
Jan-12 | Jan-13 | Jan-14 | Jan-15 | Jan-16 | Jan-17 | Jan-18 | |
Sales | 42000 | 44100 | 46305 | 48620 | 51051 | 53604 | |
Purchases | 16550 | 17047 | 17558 | 18085 | 18627 | 19186 | |
Labour | 10842 | 11167 | 11502 | 11847 | 12203 | 12569 | |
Variable Costs | 4800 | 4944 | 5092 | 5245 | 5402 | 5565 | |
Net Trading Inflows | 0 | 9808 | 10942 | 12153 | 13443 | 14819 | 16284 |
Initial Investment | -10600 | ||||||
Net Cash Flows | -10600 | 9808 | 10942 | 12153 | 13443 | 14819 | 16284 |
DF @ 10 % | 1 | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 | 0.564 |
PV | -10600.00 | 8916.36 | 9043.17 | 9130.36 | 9181.87 | 9201.36 | 9192.16 |
NVP | 44065.29 |
Payback Period | |||
Years | Net cash Flows | Cumulative cash flows | |
01/01/2012 | -10600.00 | -10600.00 | |
01/01/2013 | 8916.36 | -1683.64 | |
01/01/2014* | 9043.17 | 7359.54 | |
01/01/2015 | 9130.36 | 16489.90 | |
01/01/2016 | 9181.87 | ||
01/01/2017 | 9201.36 | ||
01/01/2018 | 9192.16 | ||
*Pay back is in 2014 |
Following Assumptions are made while doing calculations
Sales Figures - 5% increase per year |
Costs Figures - 3% increase per year |
Tax factor not considered |
Sales Units are fixed for all the periods |
9.0 Recommendations:
Extra Stock should be managed during busy periods like Events, Summer Time etc.
Sales Units should be revised according to period i.e. For Olympics 2012 extra stocks and cash flow needed.
Extra Labour required for busy periods like weekends.
10.0 Information about Suppliers
Please see 4.0 Purchase Budget and 11.0 Learning Experience.
11.0 Learning Experience:
First of all I want to thanks my respected teacher Mr. S A Palan, who gave me opportunity to work on such project. During this project I learnt many new things and got opportunity to work with different people.
Overall it was a good experience to work on this report. When I started this report I was bit confused about the starting point but with the help of co fellows I cleared my few doubts and proceed with the report.
It was wonderful experience to go to local super market and get data from there. During my visit I introduced myself as student and explained the purpose of my visit to the manager. Most of the time they welcomed with smile and helped to get required data but on couple of times I was turned down due to busy time of the store.
Next step was to conduct the street survey, which I completed in 4 days. I have been to Underground stations, High streets and Bus stops to conduct this survey. I enjoyed this part the most, while talking to different people of different language. I explained the purpose of my survey and tried to get people's opinion. The response was not too bad, but many teenagers refused to fill the form.
After I visited two Cash and Carries in Park Royal and Wembley Park. I knew the managers of both cash and carries with the references of my friends who work there. It was not too difficult to collect data there. It took half a day to collect the data.
After collecting all relevant data I proceeded with report and completed in 2 days. I consulted few books, lecture notes and websites to help within the report.
Appendices
12.1 Street Survey used to gather data.
Drink and Snacks (Street Survey)
Instructor: | Mr. S A Palan | Name: | |
Class: | BABM-4 | Date: | |
Period: | FMA | Results: |
Instructions
Thanks for participating in the short survey. Please read through the questions and select more appropriate option of your choice.
Part I: Cold Drink
1) | Which of the following Cold Drinks you like the most? | |
a. | Coke Cola | |
b. | Tango Orange | |
c. | Sprite |
2) | What size of drink you normally buy when you feel thirsty? | |
a. | 330 ml Can | |
b. | 500ml Bottle |
3) | What Price you like to pay for your selected drink? ( In Pounds Sterling) | |
ã________________ |
Part II: Chirps
1) | Which of the following Crisp you like the most? | |
a. | Walkers | |
b. | Wotsits | |
c. | McCoy's | |
2) | What size of Crisp you normally buy when you feel hungry? | |
a. | Small Packet | |
b. | Large Packet |
3) | What Price you like to pay for your selected Crisp? ( In Pounds Sterling) | |
ã________________ |
Part III: Chocolate
1) | Which of the following Chocolate you like the most? | |
a. | Sneakers | |
b. | Kit Kat | |
c. | Dairy Milk |
2) | What size of chocolate you normally buy? | |
a. | Small Size | |
b. | Large Size |
3) | What Price you like to pay for your selected drink? ( In Pounds Sterling) | |
ã________________ |
Data Collection from Supermarket
Drink and Snacks (Supermarket)
Instructor: | Mr. S A Palan | Name: | |
Class: | BABM-4 | Branch: | |
Period: | FMA | Date: |
Product | Price |
Coke Cola 330ml / 500ml | |
Tango 330ml / 500ml | |
Sprite 330ml / 500ml | |
Walkers Small / Large | |
Wotsits Small / Large | |
McCoy's Small / Large | |
Sneakers Small / Large | |
Kit Kat Small / Large | |
Dairy Milk Small / Large |
Data Collection from Cash and Carry
Drink and Snacks (Cash and Carry)
Instructor: | Mr. S A Palan | Name: | |
Class: | BABM-4 | Branch: | |
Period: | FMA | Date: |
Product | Pack Price | No of Units in Pack | Unit Price |
Coke Cola (330ml) | |||
Walkers (Large) | |||
Sneakers (Large) |
13.0 Bibliography:
Sales Budget. Accounting For Management .Defination and Explaination. [Online] (é 2009) Available at: http://www.accountingformanagement.com/sales_budget.htm /[Accessed 17th June 2010].
_1346754198.xls
Chart1
45 | 20 | 35 |
40 | 25 | 35 |
60 | 15 | 25 |
Sheet1
Coke Cola / Walkers / Sneakers | Tango / Wotsits / Kit Kat | Sprite / McCoy's / Dairy Milk | |
Cold Drink | 45 | 20 | 35 |
Crisps | 40 | 25 | 35 |
Chocolate | 60 | 15 | 25 |
To resize chart data range, drag lower right corner of range. |
_1346754205.xls
Chart1
65 | 35 |
70 | 30 |
55 | 45 |
35 | 65 |
40 | 60 |
42 | 58 |
35 | 65 |
39.5 | 61.5 |
55 | 45 |
Sheet1
Small | Large | |
Coke Cola | 65 | 35 |
Tango | 70 | 30 |
Sprite | 55 | 45 |
Walkers | 35 | 65 |
Wotsits | 40 | 60 |
McCoy's | 42 | 58 |
Sneakers | 35 | 65 |
Kit Kat | 39.5 | 61.5 |
Dairy Milk | 55 | 45 |