Explanation Given information: Brian’s commission remains constant at 4 % and his salary goal is $ 70 , 000 , $ 75 , 000 , $ 80 , 000 , $ 85 , 000 . Consider the Brian’s sales be B, the sales goals of Brian be P and commission rate be R . Since, it is provided that his salary goal is $ 70 , 000 , $ 75 , 000 , $ 80 , 000 , $ 85 , 000 and the value of commission rate is 4 % . Now, write the table for Brian’s salary goals and Brian’s commission rate, Brian’s Salary goal P Brian’s Commission rate R $ 70 , 000 4 % $ 75 , 000 4 % $ 80 , 000 4 % $ 85 , 000 4 % Calculate the change in sales of Brian according to his salary goals by using Excel as follows: Step 1 : Write P in A 1 , R in B 1 and B in C 1

11th Edition

ISBN: 8220103632072

Author: NOBLE

Publisher: Pearson Education (US)

See similar textbooks

Concept explainers

Equations and Inequations

Equations and inequalities describe the relationship between two mathematical expressions.

Linear Functions

A linear function can just be a constant, or it can be the constant multiplied with the variable like x or y. If the variables are of the form, x2, x1/2 or y2 it is not linear. The exponent over the variables should always be 1.

Videos

Question

Chapter 6, Problem 2CP

To determine

The explanation for the change in Brian’s sales with change in his salary goal if his commission remains constant at 4% and his salary goal is $70,000, $75,000, $80,000, $85,000. Use excel to form a table which shows Brian’s sales.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 6, Problem 1CP

Chapter 6, Problem 1CS1

Students have asked these similar questions

Please solve and explain

i need help please hand written

Not use ai please

Chapter 6 Solutions

EBK BUSINESS MATH

Ch. 6.1 - Prob. 1-1SC Ch. 6.1 - Prob. 1-2SC Ch. 6.1 - Prob. 1-3SC Ch. 6.1 - Prob. 1-4SC Ch. 6.1 - Prob. 1-5SC Ch. 6.1 - Prob. 1-6SC Ch. 6.1 - Prob. 1-7SC Ch. 6.1 - Prob. 1-8SC Ch. 6.1 - Prob. 1-9SC Ch. 6.1 - Prob. 1-10SC

Ch. 6.1 - Prob. 1-11SC Ch. 6.1 - Prob. 1-12SC Ch. 6.1 - Prob. 2-1SC Ch. 6.1 - Prob. 2-2SC Ch. 6.1 - Prob. 2-3SC Ch. 6.1 - Prob. 2-4SC Ch. 6.1 - Prob. 2-5SC Ch. 6.1 - Prob. 2-6SC Ch. 6.1 - Prob. 2-7SC Ch. 6.1 - Prob. 2-8SC Ch. 6.1 - Prob. 2-9SC Ch. 6.1 - Prob. 2-10SC Ch. 6.1 - Prob. 2-11SC Ch. 6.1 - Prob. 2-12SC Ch. 6.1 - Prob. 1SE Ch. 6.1 - Prob. 2SE Ch. 6.1 - Prob. 3SE Ch. 6.1 - Prob. 4SE Ch. 6.1 - Prob. 5SE Ch. 6.1 - Prob. 6SE Ch. 6.1 - Prob. 7SE Ch. 6.1 - Prob. 8SE Ch. 6.1 - Prob. 9SE Ch. 6.1 - Prob. 10SE Ch. 6.1 - Prob. 11SE Ch. 6.1 - Prob. 12SE Ch. 6.1 - Prob. 13SE Ch. 6.1 - Prob. 14SE Ch. 6.1 - Prob. 15SE Ch. 6.1 - Prob. 16SE Ch. 6.1 - Prob. 17SE Ch. 6.1 - Prob. 18SE Ch. 6.1 - Prob. 19SE Ch. 6.1 - Prob. 20SE Ch. 6.1 - Prob. 21SE Ch. 6.1 - Prob. 22SE Ch. 6.1 - Prob. 23SE Ch. 6.1 - Prob. 24SE Ch. 6.1 - Prob. 25SE Ch. 6.1 - Prob. 26SE Ch. 6.1 - Prob. 27SE Ch. 6.1 - Prob. 28SE Ch. 6.1 - Prob. 29SE Ch. 6.1 - Prob. 30SE Ch. 6.1 - Prob. 31SE Ch. 6.1 - Prob. 32SE Ch. 6.1 - Prob. 33SE Ch. 6.1 - Prob. 34SE Ch. 6.1 - Prob. 35SE Ch. 6.2 - Prob. 1-1SC Ch. 6.2 - Prob. 1-2SC Ch. 6.2 - Prob. 1-3SC Ch. 6.2 - Prob. 1-4SC Ch. 6.2 - Prob. 1-5SC Ch. 6.2 - Prob. 1-6SC Ch. 6.2 - Prob. 1-7SC Ch. 6.2 - Prob. 1-8SC Ch. 6.2 - Prob. 2-1SC Ch. 6.2 - Prob. 2-2SC Ch. 6.2 - Prob. 2-3SC Ch. 6.2 - Prob. 2-4SC Ch. 6.2 - Prob. 2-5SC Ch. 6.2 - Prob. 2-6SC Ch. 6.2 - Prob. 2-7SC Ch. 6.2 - Prob. 2-8SC Ch. 6.2 - Prob. 2-9SC Ch. 6.2 - Prob. 1SE Ch. 6.2 - Prob. 2SE Ch. 6.2 - Prob. 3SE Ch. 6.2 - Prob. 4SE Ch. 6.2 - Prob. 5SE Ch. 6.2 - Prob. 6SE Ch. 6.2 - Prob. 7SE Ch. 6.2 - Prob. 8SE Ch. 6.2 - Prob. 9SE Ch. 6.2 - Prob. 10SE Ch. 6.2 - Prob. 11SE Ch. 6.2 - Prob. 12SE Ch. 6.2 - Prob. 13SE Ch. 6.2 - Prob. 14SE Ch. 6.2 - Prob. 15SE Ch. 6.2 - Prob. 16SE Ch. 6.2 - Prob. 17SE Ch. 6.2 - Prob. 18SE Ch. 6.2 - Prob. 19SE Ch. 6.2 - Prob. 20SE Ch. 6.2 - Prob. 21SE Ch. 6.2 - Prob. 22SE Ch. 6.2 - Prob. 23SE Ch. 6.2 - Prob. 24SE Ch. 6.2 - Prob. 25SE Ch. 6.2 - Prob. 26SE Ch. 6.2 - Prob. 27SE Ch. 6.2 - Prob. 28SE Ch. 6.2 - Prob. 29SE Ch. 6.2 - Prob. 30SE Ch. 6.2 - Prob. 31SE Ch. 6.2 - Prob. 32SE Ch. 6.2 - Prob. 33SE Ch. 6.2 - Prob. 34SE Ch. 6.2 - Prob. 35SE Ch. 6.2 - Prob. 36SE Ch. 6.2 - Prob. 37SE Ch. 6.2 - Prob. 38SE Ch. 6.3 - Prob. 1-1SC Ch. 6.3 - Prob. 1-2SC Ch. 6.3 - Prob. 1-3SC Ch. 6.3 - Prob. 1-4SC Ch. 6.3 - Prob. 1-5SC Ch. 6.3 - Prob. 1-6SC Ch. 6.3 - Prob. 2-1SC Ch. 6.3 - Prob. 2-2SC Ch. 6.3 - Prob. 2-3SC Ch. 6.3 - Prob. 2-4SC Ch. 6.3 - Prob. 2-5SC Ch. 6.3 - Prob. 2-6SC Ch. 6.3 - Prob. 2-7SC Ch. 6.3 - Prob. 3-1SC Ch. 6.3 - Prob. 3-2SC Ch. 6.3 - Prob. 3-3SC Ch. 6.3 - Prob. 3-4SC Ch. 6.3 - Prob. 3-5SC Ch. 6.3 - Prob. 3-6SC Ch. 6.3 - Prob. 1SE Ch. 6.3 - Prob. 2SE Ch. 6.3 - Prob. 3SE Ch. 6.3 - Prob. 4SE Ch. 6.3 - Prob. 5SE Ch. 6.3 - Prob. 6SE Ch. 6.3 - Prob. 7SE Ch. 6.3 - Prob. 8SE Ch. 6.3 - Prob. 9SE Ch. 6.3 - Prob. 10SE Ch. 6.3 - Prob. 11SE Ch. 6.3 - Prob. 12SE Ch. 6.3 - Prob. 13SE Ch. 6.3 - Prob. 14SE Ch. 6.3 - Prob. 15SE Ch. 6.3 - Prob. 16SE Ch. 6.3 - Prob. 17SE Ch. 6.3 - Prob. 18SE Ch. 6.3 - Prob. 19SE Ch. 6.3 - Prob. 20SE Ch. 6 - Prob. 1ES Ch. 6 - Prob. 2ES Ch. 6 - Prob. 3ES Ch. 6 - Prob. 4ES Ch. 6 - Prob. 5ES Ch. 6 - Prob. 6ES Ch. 6 - Prob. 7ES Ch. 6 - Prob. 8ES Ch. 6 - Prob. 9ES Ch. 6 - Prob. 10ES Ch. 6 - Prob. 11ES Ch. 6 - Prob. 12ES Ch. 6 - Prob. 13ES Ch. 6 - Prob. 14ES Ch. 6 - Prob. 15ES Ch. 6 - Prob. 16ES Ch. 6 - Prob. 17ES Ch. 6 - Prob. 18ES Ch. 6 - Prob. 19ES Ch. 6 - Prob. 20ES Ch. 6 - Prob. 21ES Ch. 6 - Prob. 22ES Ch. 6 - Prob. 23ES Ch. 6 - Prob. 24ES Ch. 6 - Prob. 25ES Ch. 6 - Prob. 26ES Ch. 6 - Prob. 27ES Ch. 6 - Prob. 28ES Ch. 6 - Prob. 29ES Ch. 6 - Prob. 30ES Ch. 6 - Prob. 31ES Ch. 6 - Prob. 32ES Ch. 6 - Prob. 33ES Ch. 6 - Prob. 34ES Ch. 6 - Prob. 35ES Ch. 6 - Prob. 36ES Ch. 6 - Prob. 37ES Ch. 6 - Prob. 38ES Ch. 6 - Prob. 39ES Ch. 6 - Prob. 40ES Ch. 6 - Prob. 41ES Ch. 6 - Prob. 42ES Ch. 6 - Prob. 43ES Ch. 6 - Prob. 44ES Ch. 6 - Prob. 45ES Ch. 6 - Prob. 46ES Ch. 6 - Prob. 47ES Ch. 6 - Prob. 48ES Ch. 6 - Prob. 49ES Ch. 6 - Prob. 50ES Ch. 6 - Prob. 51ES Ch. 6 - Prob. 52ES Ch. 6 - Prob. 53ES Ch. 6 - Prob. 54ES Ch. 6 - Prob. 55ES Ch. 6 - Prob. 56ES Ch. 6 - Prob. 57ES Ch. 6 - Prob. 58ES Ch. 6 - Prob. 59ES Ch. 6 - Prob. 60ES Ch. 6 - Prob. 61ES Ch. 6 - Prob. 62ES Ch. 6 - Prob. 63ES Ch. 6 - Prob. 64ES Ch. 6 - Prob. 65ES Ch. 6 - Prob. 66ES Ch. 6 - Prob. 67ES Ch. 6 - Prob. 68ES Ch. 6 - Prob. 69ES Ch. 6 - Prob. 70ES Ch. 6 - Prob. 71ES Ch. 6 - Prob. 72ES Ch. 6 - Prob. 73ES Ch. 6 - Prob. 74ES Ch. 6 - Prob. 75ES Ch. 6 - Prob. 76ES Ch. 6 - Prob. 77ES Ch. 6 - Prob. 78ES Ch. 6 - Prob. 79ES Ch. 6 - Prob. 80ES Ch. 6 - Prob. 81ES Ch. 6 - Prob. 82ES Ch. 6 - Prob. 83ES Ch. 6 - Prob. 84ES Ch. 6 - Prob. 85ES Ch. 6 - Prob. 86ES Ch. 6 - Prob. 87ES Ch. 6 - Prob. 88ES Ch. 6 - Prob. 89ES Ch. 6 - Prob. 90ES Ch. 6 - Prob. 91ES Ch. 6 - Prob. 1PT Ch. 6 - Prob. 2PT Ch. 6 - Prob. 3PT Ch. 6 - Prob. 4PT Ch. 6 - Prob. 5PT Ch. 6 - Prob. 6PT Ch. 6 - Prob. 7PT Ch. 6 - Prob. 8PT Ch. 6 - Prob. 9PT Ch. 6 - Prob. 10PT Ch. 6 - Prob. 11PT Ch. 6 - Prob. 12PT Ch. 6 - Prob. 13PT Ch. 6 - Prob. 14PT Ch. 6 - Prob. 15PT Ch. 6 - Prob. 16PT Ch. 6 - Prob. 17PT Ch. 6 - Prob. 18PT Ch. 6 - Prob. 19PT Ch. 6 - Prob. 20PT Ch. 6 - Prob. 21PT Ch. 6 - Prob. 22PT Ch. 6 - Prob. 23PT Ch. 6 - Prob. 24PT Ch. 6 - Prob. 25PT Ch. 6 - Prob. 26PT Ch. 6 - Prob. 1CT Ch. 6 - Prob. 2CT Ch. 6 - Prob. 3CT Ch. 6 - Prob. 4CT Ch. 6 - Prob. 5CT Ch. 6 - Prob. 6CT Ch. 6 - Prob. 7CT Ch. 6 - Prob. 8CT Ch. 6 - Prob. 9CT Ch. 6 - Prob. 10CT Ch. 6 - Prob. 1CP Ch. 6 - Prob. 2CP Ch. 6 - Prob. 1CS1 Ch. 6 - Prob. 2CS1 Ch. 6 - Prob. 3CS1 Ch. 6 - Prob. 1CS2 Ch. 6 - Prob. 2CS2 Ch. 6 - Prob. 3CS2 Ch. 6 - Prob. 1CS3 Ch. 6 - Prob. 2CS3 Ch. 6 - Prob. 3CS3 Ch. 6 - Prob. 4CS3 Ch. 6 - Prob. 5CS3 Ch. 6 - Prob. 6CS3 Ch. 6 - Prob. 7CS3

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.

The explanation for the change in Brian’s sales with change in his salary goal if his commission remains constant at 4 % and his salary goal is $ 70 , 000 , $ 75 , 000 , $ 80 , 000 , $ 85 , 000 . Use excel to form a table which shows Brian’s sales.

Concept explainers

Videos

The explanation for the change in Brian’s sales with change in his salary goal if his commission remains constant at 4% and his salary goal is $70,000, $75,000, $80,000, $85,000. Use excel to form a table which shows Brian’s sales.

Want to see the full answer?

Chapter 6 Solutions