Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer the questions using the cells from the excel provided Beverly sells donuts for $.50 each at the local bakery. If a customer buys
please answer the questions using the cells from the excel provided
Beverly sells donuts for $.50 each at the local bakery. If a customer buys at least a dozen donuts, the cost is reduced $.40 each. Beverly earns a commission based on the number of donuts she sells to a customer. - If a sale totals more than $10, she earns 2% on that sale total. - If a sale totals more than $5 (but is $10 or less), she earns 1% commission on that sale total. - If a sale totals $5 or less, she does not earn a commission. Because the bakery makes so much money on beverages, she also earns a beverage commission in addition to her donut commission. Beverly earns a 10% commission on the total sale of any order where a customer buys a beverage. Complete the table on the If Function worksheet to help Beverly calculate her commission based on the 50 customers she helped this morning. (2.1) Use an IF function in cell E10) to calculate the price to charge per donut for order 1 . a. Customer are charged $.50 per donut unless they (2.1) Use an IF function in cell E10) to calculate the price to charge per donut for order 1. a. Customer are charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. b. Refer to the appropriate price in cells (3) and (4) for your "value_if_true" and "value_if_false" arguments. c. Use absolute and relative references when appropriate. (5) (2.2) Copy your formula in cell E10) and paste it down (2.3) Use an IF function in cell H10 ) to calculate the commission rate for the total sale for order 1. a. The commission rate is 2% for all sales that total more than $10. It is 1% for all sales that total more than $5, but are less than or equal to $10. b. No commission is paid on sales that total $5 or less. c. Reference the threshold levels (cells F5) and F6) in your logical tests for your IF function and the commission rates (cells G5 ) and G6 ) as your "value_if_true" and "value_if false" arguments. d. Use appropriate relative and absolute references. (2.5) Use an IF function in cell 10 to calculate the commission earned for beverages for order 1. a. The beverage commission is 10% of the total sale if the customer buys a beverage. b. If the beverage sale amount (cell D10)) is greater than 0 , the beverage commission equals the sales total (cell G10) multiplied by the beverage commission rate (cell G4). c. Otherwise, the beverage commission is 0 . d. Use appropriate relative and absolute cell references. (5) (2.6) Copy your formula in cell 10 ) and paste it down (2.7) Beverly treats herself to a donut if her daily commission is more than her set Donut Threshold. a. Use an IF function in cell KS ) to determine if she should buy herself a donut. b. Cell K5) should contain the value "Yes" if her total commission in cell K3 ) is more than her "Donut Threshold". c. Otherwise, cell K5) should contain the value "No". d. Be sure to reference the "Donut Threshold" value in cell K6 ) in your formula Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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