Question: Use Excel: Construct a n income statement for Harvest from the revenue streams and the costs that have been identified in the case. Assume a
Use Excel:
Construct an income statement for Harvest from the revenue streams and the costs that have been identified in the case. Assume a tip Fee of $50 per Ton. Assume a 40% benefit package for salaried personnel (1.4 x salary)
Follow this Income Statement format:
a. Revenue (per Ton)
b. Variable Cost (per Ton)
i. Revenues Costs per ton should give you a profit or a loss per ton
c. Fixed Costs (annual)
d. Depreciation (annual)
i. (For simplicity, for equipment/plant costs, use straight line depreciation for the life of the asset for the annual costs)
6. Using your data from Q#5 - Calculate the condition under which the business will be profitable - i.e. breakeven analysis how many tons must be processed to breakeven?
7. If the plant runs at full capacity, what is the estimated annual profit?


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
