8.1 Create a one-way data table for profit at different levels of supplier contact in range B22:C33.
Fantastic news! We've Found the answer you've been seeking!
Question:
8.1 Create a one-way data table for profit at different levels of supplier contact in range B22:C33.
- Ensure that the price in cell C3 is $290 and the advertising budget in cell C5 is $35,000,000 (you may need to manually adjust these values).
- Use the values in range B23:B33 as the different levels of the supplier contract.
- Reference the profit calculation in cell F12.
- Notice the Supplier Contract and Profitability chart updates with the values in the data table to visually demonstrate the relationship between supplier contract amounts and the profitability.
8.2 Create a two-way data table for profit at different levels of price and advertising budget in range B36:E57.
- Use the values in range B37:B57 as the values for Price.
- Use the values in range C36:E36 as the values for Advertising Budget.
- Reference the profit calculation in cell F12.
8.3 Complete the Price, Advertising, and Profitability chart.
- Notice that the series for $25,000,000 is already on the chart.
- Add the series for advertising budgets $50,000,000 and $75,000,000 from your data table to the chart.
Related Book For
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg
Posted Date: