****BONUS**** CULN1405 Culinary Mangement Concepts Basic Cashflow Worksheet
January February March April May June July August Sept October November December
Cash Inflow
Number of units sold 275 350 600 600 600 600 600 700 770 600 810 810
Price /unit $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 22.00 $ 19.80 $ 19.80
Revenue/Sales $ 6,050.00 $ 7,700.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 15,400.00 $ 16,940.00 $ 13,200.00 $ 16,038.00 $ 16,038.00
Accounts Payable $ 500.00
Accounts Paid/received $ 500.00
Cash Received from sales $ 5,550.00 $ 8,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 15,400.00 $ 16,940.00 $ 13,200.00 $ 16,038.00 $ 16,038.00
Injections
Loans $ 100,000.00
Investments - (owner) $ 5,000.00 $10,000
Total Cash Inflow $ 110,550.00 $ 8,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 13,200.00 $ 15,400.00 $ 16,940.00 $ 13,200.00 $ 16,038.00 $ 16,038.00
Cash Outflow
Opening Expenses - One time $ 100,000.00
Cost of sales $ 1,815.00 $ 2,310.00 $ 3,960.00 $ 3,960.00 $ 3,960.00 $ 3,960.00 $ 3,960.00 $ 4,620.00 $ 6,776.00 $ 5,280.00 $ 6,415.20 $ 6,415.20
Marketing $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 1,000.00 $ 1,000.00 $ 500.00 $ 500.00 $ 500.00
Operating expenses $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00
Wages $ 2,117.50 $ 2,695.00 $ 4,620.00 $ 4,620.00 $ 4,620.00 $ 4,620.00 $ 4,620.00 $ 5,390.00 $ 5,929.00 $ 4,620.00 $ 5,613.30 $ 5,613.30
Loan re-payments $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00
Equipment and repairs $10,000
Owner pay-out $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 1,000.00 $ 1,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ - $ -
Other expenses
Total Cash Outflow $ 107,932.50 $ 9,005.00 $ 12,580.00 $ 12,580.00 $ 12,580.00 $ 13,580.00 $ 13,580.00 $ 16,510.00 $ 19,205.00 $ 15,900.00 $ 16,028.50 $ 16,028.50
Net Cash $ 2,617.50 $ (805.00) $ 620.00 $ 620.00 $ 620.00 $ (380.00) $ (380.00) $ (1,110.00) $ (2,265.00) $ (2,700.00) $ 9.50 $ 9.50
Cash from previous Month $ - $ 2,617.50 $ 1,812.50 $ 2,432.50 $ 3,052.50 $ 3,672.50 $ 3,292.50 $ 2,912.50 $ 1,802.50 $ (462.50) $ (3,162.50) $ (3,153.00)
Cumulative cash flow $ 2,617.50 $ 1,812.50 $ 2,432.50 $ 3,052.50 $ 3,672.50 $ 3,292.50 $ 2,912.50 $ 1,802.50 $ (462.50) $ (3,162.50) $ (3,153.00) $ (3,143.50)
As a result of increased marketing spending in August and September - September sees an increase of 10% to the number of units sold.
The Bank of Canada raised interest rates again, this causes fear in consumerism and a sharp decline to unit sales occurs in October of 170 units less than the previous month
The price per unit is discounted by $2.20 in November and continues in December
The price discount in November and December drives a 35% increase from October.
Inflation has finally caught up with us and in September the cost of sales increased by 10% and stayed at that level until the end of the year, (December)
A previously planned wage increase of 2% beginning in November is cancelled and the previos percentage cost of wages should stay the same for the rest of the y
In May the owner invests $10,000 to pay for additional equipment purchased for the business, and decided to double the loan re-payments for the remainder of
The owner understands there is a shortage of cash and decides not draw any money from the company for Nov and Dec