Using IF functions, compute the sales bonus for each of the different scenarios. Please add in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using IF functions, compute the sales bonus for each of the different scenarios. Please add in cells where needed for each problem to create the required "model input block". None of the criteria should be typed into the formula, it should reference a cell in the model input block. Sales people get a 3% bonus (monthly sales .03), if they had monthly sales of $10,000 or more Monthly Sales Sales Bonus 8,450.00 11,250.00 13,500.00 Problem #1 Sales Person Sally Blue Betty White Henry Green Barry Black Scarlet Purple William Orange 7,025.00 9,580.00 10,250.00 Sales people get a 3% bonus (monthly sales .03), if they sold over $10,000 in the month or got 3 or more new customers Monthly Sales New Customers Sales Bonus 8,450.00 Problem #2 Sales Person Sally Blue Betty White Henry Green Barry Black Scarlet Purple William Orange 3 11,250.00 13,500.00 7,025.00 9,580.00 10,250.00 3 1 4 Using IF functions, compute the sales bonus for each of the different scenarios. Please add in cells where needed for each problem to create the required "model input block". None of the criteria should be typed into the formula, it should reference a cell in the model input block. Sales people get a 3% bonus (monthly sales .03), if they had monthly sales of $10,000 or more Monthly Sales Sales Bonus 8,450.00 11,250.00 13,500.00 Problem #1 Sales Person Sally Blue Betty White Henry Green Barry Black Scarlet Purple William Orange 7,025.00 9,580.00 10,250.00 Sales people get a 3% bonus (monthly sales .03), if they sold over $10,000 in the month or got 3 or more new customers Monthly Sales New Customers Sales Bonus 8,450.00 Problem #2 Sales Person Sally Blue Betty White Henry Green Barry Black Scarlet Purple William Orange 3 11,250.00 13,500.00 7,025.00 9,580.00 10,250.00 3 1 4
Expert Answer:
Answer rating: 100% (QA)
Answer As per given Situations Formula for Cell C6 IFb610000B60... View the full answer
Related Book For
Operations and Supply Chain Management
ISBN: 978-0077403652
13th edition
Authors: F. Robert Jacobs, Richard Chase
Posted Date:
Students also viewed these accounting questions
-
For each of the different priorities in question 3, describe the unique characteristics of the market niche with which it is most compatible?
-
Henry and Sally each choose 1 candy from a bag of treats, without replacement. There are 20 sweet candies and 3 sour candies. Let X = 1 if Henry's candy is sweet, or X = 0 otherwise. Let Y = 1 if...
-
@ You are considering two independent projects, Project A and Project B. The initial cash outlays associated with Project A and Project B is RM60,000. The discount rate on both projects is 12...
-
(b) (i) A long single mode optical fiber has an attenuation of 0.40 dBkm when operating at a wavelength of 1.55 m. The fiber core diameter is 6 pm and the laser source bandwidth is 500 MHz. Determine...
-
Describe a real estate short sales transaction. What are the potential benefits and costs from the perspective of the homeowner?
-
Write a rate law for if the reaction is known to be first order in ammonia and second order in hydrogen chloride. NH3(g) + HCl(g) NHCl(g)
-
An inward-flow radial turbine (see Fig. P12.48) involves a nozzle angle, \(\alpha_{1}\), of \(60^{\circ}\) and an inlet rotor tip speed, \(U_{1}\), of \(3 \mathrm{~m} / \mathrm{s}\). The ratio of...
-
Cameron Bly is a sales manager for an automobile dealership. He earns a bonus each year based on revenue from the number of autos sold in the year less related warranty expenses. Actual warranty...
-
Blue Bird Sporting Goods reported the following data at July 31, 2021, with amounts in thousands: (Click the icon to view the income statement.) (Click the icon to view the balance sheet.) Read the...
-
(a) In the circuit in Fig. 4.71, calculate vo and Io when vs = 1 V. (b) Find vo and io when vs = 10 V. (c) What are vo and Io when each of the 1-Ω resistors is replaced by a...
-
Daniels house is for sale. In his living room are two valuable original paintings by a well-known Artist, one of the California coastlines and the other of a field of Golden State wildflowers. Daniel...
-
Evaluate the following. 2 3 k=1=0 (3k+12) I
-
Suppose you wanted to show 2+4+6+8+...+2n = n(n+1) a) What is the basis step? b) What is P(k)? c) What is P(k+1)? c) (7 Points) Show P(k)=P(k+1)
-
i. With reference to Python programming: A number is to read into the variable num. Write an input statement. Print I x=2 Prent x The value of the expression (10-5)%3 is to be assigned to the...
-
Brief the following case, including the facts, issue, holding, reasoning, and reasoning. The facts section should be no more than one hundred words. Citation: Tarasoff v. Regents of University of...
-
Alice Baxter acquires a residential property on May 1, 2022 and rents out the property. The cost of the property is $385,000, with $95,000 attributable to the land and $290,000 to the building. In...
-
Johnson's Pic has the following costs related to a new project:Marketing costs already spent: 1 5 , 0 0 0 1 5 , 0 0 0 Variable costs associated with the project: 7 2 , 5 0 0 7 2 , 5 0 0 Additional...
-
The cash records of Holly Company show the following four situations. 1. The June 30 bank reconciliation indicated that deposits in transit total $720. During July, the general ledger account Cash...
-
What strategies are used by supermarkets, airlines, hospitals, banks, and cereal manufacturers to influence demand?
-
Your company's new process improvement guru is aggressive at providing and requiring online self-service at all levels of management, from making travel arrangements to doing check requests, travel...
-
The major auto companies are planning to invest millions of dollars in developing new product and process technologies required to make electric cars. Describe briefly why they are investing in these...
-
A faculty member wishes to assess the relationship between students' scores on the Scholastic Aptitude test (SAT) and their performance in college. a. What is a possible research hypothesis in this...
-
Name the scale of measurement (nominal, ordinal, interval, ratio) for each of the following variables: a. One's age (in years) b. Size of soft drink (small, medium, large, extra large) c. Voting...
-
Name the scale of measurement (nominal, ordinal, interval, ratio) for each of the following variables: a. The amount of time needed to react to a sound b. Gender c. Score on the Scholastic Aptitude...
Study smarter with the SolutionInn App