Question: Please help me ! ! I will upvote!! Need done asap Spreadsheet A university currently has a recycling program for paper waste. The fixed cost
Please help me I will upvote!! Need done asap Spreadsheet
A university currently has a recycling program for paper waste. The fixed cost of running this program is $ per year. The variable cost for picking up and disposing of each ton of recyclable paper is $ If the work is outsourced to a recycling company, the cost would be $ per ton.
a If the forecasted demand is tons, what should the university do Use the BreakEven Excel template in MindTap to find your answer. Round your answers to the nearest dollar.
Total cost of doing the job inhouse: $
Total cost of outsourcing the job: $
So the best decision for the university is to for a savings of $
b Find the breakeven point using the Excel Goal Seek tool. Round your answer to the nearest whole number.
tons
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
