Question
Attached is a spreadsheet with more data/ different data For example, 2015 to 2016 sales change would be figure out as follows: (2016 sales-2015 sales/2015sales)
Attached is a spreadsheet with more data/ different data
For example, 2015 to 2016 sales change would be figure out as follows: (2016 sales-2015 sales/2015sales) *100. Add a column in front of the 2016 column and put the %change in that column. Put the equation in that column. For sales, you are asked to add a red/green/yellow light icon to the spreadsheet. You will do this in the percentage change column with the equation you just created in it.Given the equation that I gave you, you will need to enter the values as decimals (some negative depending on the rule).
This may help on the operating expense one. More than last year and less than last year can be interpreted as 1% or .01. You will need to add a second column for the 2010 to 2009 comparison, but by that time, you will be pros at this.
Can you show me step by step for a, b, c, d .....
a: For sales: Green means that this years sales are larger than last years sales. Yellow means that this year's sales are at least 95% of the prior year's; red otherwise
b: For sales returns: Green means that returns are less than 4.5% of sales; yellow means between 4.5 and 5.5%; red means otherwise.
c. For operating expenses: Green means less than last year, yellow means less than a three percent increase; red means more than a 3% increase over the prior year.
d. For gross profit: Green means more than last year, yellow means less than a three percent drop; red means otherwise.
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