Question: Spreadsheet A university currently has a recycling program for paper waste. The fixed cost of running this program is $25,000 per year. The variable cost

Spreadsheet A university currently has a
Spreadsheet A university currently has a recycling program for paper waste. The fixed cost of running this program is $25,000 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $20. If the work is outsourced to a recycling company, the cost would be $40 per ton. a. If the forecasted demand is 700 tons, what should the university do? Use the Broak-Even Excel template to find your answer. Round your answers to the nearest dollar Total cost of doing the job / -house: Total cost of outsourcing tjob: $ So the best decision for the university is to outsource the job for a savings of b. Find the break-even point using the Excel Goal Seek tool. Round your answer to the nearest whole number. 39000 28000 11000 tons Hide Feedback Partially Correct

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 General Management Questions!