Cash Flow PlanPlease 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.
I need a 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 InvestmentStandard 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 – XXXXXXXXXXUSD per Month
Water Cost – $50 per month
Value Added Tax – 16 % of Monthly sales
_____________________________________________________________________________________________
Sales ProjectionsFirst LocationAssuming 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 XXXXXXXXXXdaily 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 salesSecond Location XXXXXXXXXXin total patrons from Monday – Thursday
XXXXXXXXXXfrom 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 XXXXXXXXXXin total patrons from Monday – Thursday
XXXXXXXXXXfrom 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.