Question: A Two-way data table: Summarizes two inputs' impact on the output. In the following Excel Problem, you shall construct a Two-Way Data Table to examine

A Two-way data table: Summarizes two inputs'

A Two-way data table: Summarizes two inputs' impact on the output. In the following Excel Problem, you shall construct a Two-Way Data Table to examine Savings Amount Due to Outsourcing at various Quantity levels at various Outsourcing Cost Per Unit for company, Nowlin Plastics. PROBLEM 2: Constructing a TWO-Way Data Table (Do NOT re-use file from problem 1. Please open a fresh new Excel file: Nowlin.xlsx) NOTE: Before you begin, you need to first manually enter values you see in cells D5 through D17, and, cells E4 through i4, as shown above. Step 0. Type in cell D4, =B17 Step 1. Select cells D4 through i17 Step 2. Click the DATA tab in the Ribbon Step 3. Click What-If Analysis in the Data Tools group, and select Data Table Step 4. When the Data Table dialog box appears: Enter B7 in the Row Input Cell: box Enter B11 in the Column Input Cell: box Click OK From your Excel file with the above steps completed, what is Savings Amount Due to Outsourcing when Quantity is 200,000 and Outsourcing Cost Per Unit is at $3.13 ? (Enter your response here)

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!