Question: Spreadsheet A university currently has a recycling program for paper waste. The fixed cost of running this program is $10,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 $10,000 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $40. Ir the work is outsourced to a recycling company, the cost would be $65 per ton. a. If the forecasted demand is 950 tons, what should the university do? Use the Break-even Excel template to find your answer. Round your answers to the nearest dollar Total cost of doing the job in-house: $ Total cost of outsourcing the job: So the best decision for the university is to do the job in-house for a savings of b. Find the break even 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 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!