Question: One Way and Two way data table is an application of what if analysis in the model created. As part of the exercise /practice: create


Nowlin Plastics Parameters Manufacturing Fixed Cost $234,000.00 Manufacturing Variable Cost per Uni $2.00 Outsourcing Cost per Unit Model Quantity Total Cost to Produce Total Cost to Outsource Savings due to Outsourcing Instruction: Create a two way data table for the Model presented What if you replace the quantity from 25,000 up to 300,000 units with an increment of 25,000 Replace also, the outsoucing cost per unit given below (from 3.00 to 4.75 ) Suppliersoutsourcingprice3.003.25 3.75 4.50 4.75 $254.000.00 $45.000.00 $209,000.00 and Two Way Data Table.xlsx Nowlin Plastics Nowlin Plastics Instruction: Create a one way data table for the Model presented. What if you replace the quantity from 25,000 up to 300,000 units with an increment of 25,000 and Two Way Data Table.xlsx Nowlin Plastics Nowlin Plastics Instruction: Create a one way data table for the Model presented. What if you replace the quantity from 25,000 up to 300,000 units with an increment of 25,000 Nowlin Plastics Parameters Manufacturing Fixed Cost $234,000.00 Manufacturing Variable Cost per Uni $2.00 Outsourcing Cost per Unit Model Quantity Total Cost to Produce Total Cost to Outsource Savings due to Outsourcing Instruction: Create a two way data table for the Model presented What if you replace the quantity from 25,000 up to 300,000 units with an increment of 25,000 Replace also, the outsoucing cost per unit given below (from 3.00 to 4.75 ) Suppliersoutsourcingprice3.003.25 3.75 4.50 4.75 $254.000.00 $45.000.00 $209,000.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
