Question: You have this initial data for a project: Expense and cost forecasts - Variable or production costs: $ 3.90 per liter (malt, hops, filtered plates,
You have this initial data for a project:
Expense and cost forecasts - Variable or production costs: $ 3.90 per liter (malt, hops, filtered plates, water, gas) - Fixed or production costs: electricity of $ 10,000 per month, warehouse rent of $ 26,000 per month, depreciation of the corresponding assets, salaries (includes IMSS, benefits, etc.) that in the first 6 months are destined for an employer and an accountant part-time with a monthly salary of $15,000 and that from the month, another person is added as general manager with a monthly salary of $16,000. -Fixed or sales costs: Depreciation of delivery equipment, telephone of $5,000 per month, salary of a salesperson of $15,000 per month.
Obtain the cash flows of the following three scenarios considering all the above information:
| Sales forecasts: Barrels (of 30 liters) sold monthly | ||||||
| Sales forecast $ 510 per 30-liter barrel plus VAT | ||||||
| 30 liter barrels sold monthly | ||||||
| Scenario | 1-6 months | 7-12 months | 12-18 months | 19-24 months | 25-48 months | 49-72 months |
| 1.- Pessimistic | 0 | 100 | 200 | 300 | 400 | 400 |
| 2.- Expected | 0 | 200 | 300 | 600 | 900 | 1200 |
| 3.- Optimistic | 0 | 300 | 600 | 1200 | 2000 | 2500 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
