Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I am suppose to create a chart and fill up the chart with calculations but I don't know how to do that. I am
Hello, I am suppose to create a chart and fill up the chart with calculations but I don't know how to do that. I am given the information that I need to use on the left side Part 2: Data Table There's more interplay between bonus rate and sales increase than you were thinking. You decide you need to do some additional analysis using a data table. 2A) Create a data table with the sales increases along the top, and bonus rates along the side. Put this off to the right of your assumptions on the "GS and DT" sheet. Bonus rates should range from 0% to 15% (in 1% increments), sales increases should range from 0% to 35% (in 5% increments). 2B) Use conditional formatting to highlight output values per instructions below: - If more profitable than current profit (i.e., your answer to question 1A) highlight with green background/text - If less profitable than current profit, highlight with red background/text - If equally profitable than current profit, highlight with yellow background/text 2C) Re-create your data table using a formula with mixed cell references. Put this below your original data table. You don't need to conditionally format this data, but it could be a good check that your formula is correct. Part 2: Data Table There's more interplay between bonus rate and sales increase than you were thinking. You decide you need to do some additional analysis using a data table. 2A) Create a data table with the sales increases along the top, and bonus rates along the side. Put this off to the right of your assumptions on the "GS and DT" sheet. Bonus rates should range from 0% to 15% (in 1% increments), sales increases should range from 0% to 35% (in 5% increments). 2B) Use conditional formatting to highlight output values per instructions below: - If more profitable than current profit (i.e., your answer to question 1A) highlight with green background/text - If less profitable than current profit, highlight with red background/text - If equally profitable than current profit, highlight with yellow background/text 2C) Re-create your data table using a formula with mixed cell references. Put this below your original data table. You don't need to conditionally format this data, but it could be a good check that your formula is correct
Hello, I am suppose to create a chart and fill up the chart with calculations but I don't know how to do that. I am given the information that I need to use on the left side
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started