Question: Consider Nowlin.xlsx (you can either get it from Module 9 or this link); use Goal Seek to determine what the Order Quantity must be for

Consider Nowlin.xlsx (you can either get it from Module 9 or this link); use Goal Seek to determine what the Order Quantity must be for the Savings Due to Outsourcing to be -125,000. If necessary, round your answer to the nearest whole unit.

Consider Nowlin.xlsx (you can either get it from

X Nowlin.xlsx + Open with Google Sheets B E 1 Nowlin Plastics 2 3 4 Parameters Manufacturing Fixed Cost Manufacturing Variable Cost per Unit $234,000.00 $2.00 5 6 7 Outsourcing Cost per Unit $3.50 8 9 10 Model 11 Quantity 10,000 12 13 Total Cost to produce $254.000.00 14 15 Total Cost to Outsource $35,000.00 16 17 Savings due to Outsourcing $219,000.00 18 19 20

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!