Response to the following problem:
Generate the monthly cash-flow projection using the data sheet (below). You must use the annual cash-flow estimation in the workbook to determine the distribution of inflows and outflows during the months.
| Sales and expenses forecast |
|
|
|
| Sales |
2018 |
2019 |
2020 |
| Overnight care |
$200,000.00 |
$92,000.00 |
$113,000.00 |
| Day care |
$70,000.00 |
$110,300.00 |
$119,400.00 |
| Grooming |
$130,000.00 |
$119,400.00 |
$131,200.00 |
| Total Sales |
$400,000.00 |
$238,900.00 |
$261,900.00 |
| Direct cost of sales |
|
|
|
| Overnight care costs |
$41,000.00 |
$46,000.00 |
$51,000.00 |
| Day care |
$67,000.00 |
$71,000.00 |
$87,000.00 |
| Grooming costs |
$35,000.00 |
$3,900.00 |
$4,500.00 |
| Total costs |
$143,000.00 |
$120,900.00 |
$142,500.00 |