Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions