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 $10,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 $45 per ton.
a. If the forecasted demand is 550 tons, what should the university do? Use the Break-Even Excel template in MindTap 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 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
 Please help me!! I will upvote!! Need done asap Spreadsheet A

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!