Sophia owns a salon that provides an array of services for her customers. She has been collecting data for the past 2 years. The sales revenues from her five most-common services are as follows: Which service had the largest magnitude of change in sales revenue from Year 1 to year 2 (up or down)?
A) Color: 23.00% Decrease
B) Cut: 23.62% Increase
C) Pedicure: 27.37% Decrease
D) Pedicure: 27.37% Increase

Question

Sophia owns a salon that provides an array of services for her customers. She has been collecting data for the past 2 years. The sales revenues from her five most-common services are as follows:  Which service had the largest magnitude of change in sales revenue from Year 1 to year 2 (up or down)?
A) Color: 23.00% Decrease 
B) Cut: 23.62% Increase 
C) Pedicure: 27.37% Decrease 
D) Pedicure: 27.37% Increase

Quizplus · Accepted Answer

This question requires familiarity with using Excel for simple calculations. To solve for the change in sales revenue for each row, calculate the percent difference in sales revenue for Year 1 and Year 2. For Cut: (Year 2 Sales - Year 1 Sales)/(Year 1 Sales), or =(C2-B2)/B2 that should return a percent increase of 23.62%. Repeat the process for the remaining services, and the values returned for each row should be: Color: 23.00% increase; Perm: 21.66% decrease; Manicure: 22.99% increase; and Pedicure: 27.37% increase. Pedicure had the biggest change with an increase of 27.37% (Choice D).

Sophia Owns a Salon That Provides an Array of Services