Reference no: EM13303598
Cash Flow Plan
Please submit completed model including:
- Start up and working capital
- Investment costs per store
- Estimated operating costs & sales projections
For the Cost per Store, Please provide charts showing start up cost for 6 stores.
Two of the 6 stores will take the higher totals and the other 4 will take the lower totals.
Label the two stores as Flagship stores and the other 4 stores as Inline stores.
Chart displaying operating cost and 2 charts displaying sales revenue for the first two locations.
After your finished with those two charts, please do an analysis of operating cost to sales revenue.
Investment Tables:
Initial Investment
Standard Restaurant:
|
Name of Fee
|
Low
|
High
|
|
Initial Franchise Fee
|
$0
|
$25,000
|
|
Real Estate Brokerage Fees
|
$0
|
$10,000
|
|
Professional Fees
|
$500
|
$12,000
|
|
Construction/Leasehold Improvements
|
$40,000
|
$200,000
|
|
Furniture, Fixtures and Equipment
|
$37,000
|
$120,500
|
|
Information System
|
$15,000
|
$30,000
|
|
On-Site Support Fee
|
$0
|
$2,500
|
|
On-Site Installation and Support Fee
|
$0
|
$3,000
|
|
Help Desk Service Fee
|
$0
|
$1,000
|
|
Software Enhancement Fee
|
$123
|
$123
|
|
Signage
|
$3,000
|
$15,000
|
|
First Month's Rent
|
$1,200
|
$5,000
|
|
Security Deposit and Other Deposits, Insurance Premium
|
$1,000
|
$8,400
|
|
Opening Inventory and Supplies
|
$3,000
|
$10,000
|
|
Grand Opening Advertising
|
$3,000
|
$10,000
|
|
Training Expenses
|
$1,000
|
$12,000
|
|
Miscellaneous Opening Costs
|
$2,500
|
$20,000
|
|
Additional Funds - 3 months
|
$15,000
|
$50,000
|
|
TOTAL ESTIMATED INITIAL INVESTMENT
|
$122,323
|
$534,523
|
Operating cost information.
Payroll
Average wages - $50USD per week, $200 USD per Month
Supervisor wages - $87.50 per week. $350USD per Month
Store Manager - $169 per week. $679 per month
Shift system - 8 employees on a shift, 16 in total for first and second location.
Delivery - usually paid for by the consumer. Not a cost assumed by the company.
Rent - 5000 USD Per month
Electricity Cost - 1700-3500 USD per Month
Water Cost - $50 per month
Value Added Tax - 16 % of Monthly sales
Sales Projections
First Location
Assuming that we follow current market prices
Small Pizza - $8
Medium $12
Large $18
Chicken Tenders - $ 3.89
Wings - $ 3.40
Pasta - $5
Bread sticks - 3.91
We predict 550-700 daily customers
There will be more individual pizza purchases in this area (Small) which will result in a lower average check.
65 percent of the purchases in this area will be from Chicken Tenders, Wings, Pasta, and Breadsticks
35 percent will be of pizza.
Calculate the dollar figures from the percentages given and display into chart showing average check and weekly and monthly sales
Second Location
220-280 in total patrons from Monday - Thursday
280-350 from Friday - Sunday
Purchases
Medium pizza purchases - 35%
Small Pizza Purchases - 10%
Large Pizza Purchases - 15 %
Wings, Tenders , Pasta , Breadsticks - 40 %
Calculate the dollar figures from the percentages given and display into chart showing average check and weeklyand monthly sales. Third Location
290-380 in total patrons from Monday - Thursday
370- 440 from Friday - Sunday
Purchases
Medium pizza purchases - 30%
Small Pizza Purchases - 7%
Large Pizza Purchases - 25 %
Wings, Tenders, Pasta, Breadsticks - 38 %
Calculate the dollar figures from the percentages given and display into chart showing average check and weekly and monthly sales.