One-Variable Data Table Your maximum weekly production capability is 200 gallons. You would like to create a one-variable data table to measure the impact of Production Cost, Gross Profit, and Net Profit based on selling between 10 and 200 gallons of paint within a week.

a. Start in cell E3. Complete the series of substitution values ranging from 10 to 200 at increments of 10 gallons vertically down column E.

b. Enter references to the Total Production Cost, Gross Profit, and Net Profit in the correct location for a one-variable data table.

c. Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places. d. Apply custom number formats to make the formula references appear as descriptive column headings. Bold and center the headings and substitution values.

I am not sure to complete the table. Whenever I do, all of the boxes come up with the same value. This is what I have and I am unsure what to do next.

e06c1Manufacturing (1) - Excel Jacqueline Fisher -O X Insert Page Layout FormulasData Review View Help Tell me what you want to do Share AutoSum . A Cut 9- Wrap Text Accounting Fill Paste Merge & Center. $. % , 2: Conditional Format as Cell Insert Delete Format | Sort & Find & Filter Select B 1 u . Fonmat Painter Formatting Table. Styles --Clear Clipboard Font Alignment Number Cells Editing F3 Delta Paint One-Variable Data Table: Production Total Production Cost Gross Profit Net Profit nput 4 Units Sold 5 Unit Selling Price 6 Employee Hourly Wage 7Maximum Capabilty per week 1666.666667 $ 30.00 15.00 30 50 imitations 70 10 Raw Materials in Units 11 Required raw materials per unit 12 Required Labor Hours Per Gallon 13 Labor Hours available 90 0.25 110 Expenses 16 Raw Materials Consumed 17 Labor Hours Consumed 18 Total Production Cost 150 160 170 416.6666667 $ 6,250.00 21 Gross Profit 22 Net Profit 23 24 50,000 $43,750 Two-Variable Data Table: Production and Manufacturing Time Forecast Range Names | Q&A | Ready F -+ 100%