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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!