CASH FLOW/PAYABLES PROJECTION
11/1/2014
650,000.00 Checking Balance
Bills Due 11/8/14 Bills Due 11/15/14
Bills ** (1,000.00) (3,000.00)
Payroll (15,000.00) -
Deposits expected to make Store 1 8,000.00 -
Store 2 7,000.00
Store 3 12,000.00
11/8/2014 11/15/2014
Bank Balance 650,000.00 532,000.00
Total deposits expected 27,000.00 -
Total Cash Available 677,000.00 532,000.00
Bills (45,000.00) (3,000.00)
Credit Card payment (37,190.88)
Rent Due 1/18/12 (not included with bills) (25,000.00)
Note payment Due 1/18/12 (not included with bills)
Payroll (75,000.00) -
Balance 532,000.00 491,809.12
SAMPLE
Weekly GP & LER Tracking
Week 1 Week 2
Revenue 75,000.00 85,000.00
Cost of Goods Sold 26,250.00 29,750.00
Gross Margin 48,750.00 55,250.00
as a % of sales 65% 65%
Direct Labor 22,500.00 25,000.00
Direct LER 2.17 2.21
Contribution Margin 26,250.00 30,250.00
as a % to sales 35% 36%
Target GM 50,000.00 50,000.00
Over / (Under) Target (1,250.00) 5,250.00
Rolling Over / Under GM Target (1,250.00) 4,000.00
Target LER 2.25 2.25
Target Direct Labor Spend 21,666.67 24,555.56
Actual Spend 22,500.00 25,000.00
Over / Under Target Spend 833.33 444.44
Rolling Over / Under Target Spend 833.33 1,277.78
Week 3
72,500.00
25,375.00
47,125.00
65%
20,500.00
2.30
26,625.00
37%
50,000.00
(2,875.00)
1,125.00
2.25
20,944.44
20,500.00
(444.44)
833.33