ZuoTi.Pro
Question

1.Use an IF function in cell E18 to calculate the price to charge per donut for...

1.Use an IF function in cell E18 to calculate the

1.Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your "value_if_true" and "value_if_false" arguments. Use absolute and relative references when appropriate.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1

Price per Donut 0-11 Total Sales Total Commission $396.53 $23.82 Commission Rate 0.50 Threshold Rate 10% Beverage Sales> $5 $ Sales> $10 $10.00 0.40 196 Buy a Donut? Sales Amount Commissions Order ##Donuts Beverage Price/Donut Donuts Total Rate Sales Beverage Total Commission 0.40 0.40 0.40 0.40 0.50 0.50 0.50 0.40 0.40 0.50 0.50 0.50 0.50 0.40 0.50 0.50 0.50 0.40 0.40 0.50 0.40 0.50 0.40 296 $0.48 $0.00 0% $0.00 $0.00 296 $0.38 $6.62 1% $0.10 $3.72 096 $0.00 $0.00 096 $0.00 $0.00 096 $0.00 $0.75 2% $0.38 $0.00 2% $0.29 $5.69 096 $0.00 $0.00 0% $0.00 $0.00 096 $0.00 $0.00 0% $0.00$1.16 1% $0.10 $0.00 096 $0.00 $0.00 096 $0.00 $0.00 096 $0.00 $0.00 296 $0.48 $0.00 096 $0.00 $0.00 096 $0.00 $0.00 1% $0.10 $0.00 0% $0.00 $0.58 1% $0.10 $2.90 $24.00$24.00 $4.80 $4.80 $19.20$85.44 9.60$46.80 12 $66.24 $37.20 $7.01 $3.82 24 10 $1.50$1.50 3.00$10.50 $19.20$19.20 $14.40$71.28 $3.00$3.00 2.00 $2.00 $1.50$1.50 $4.50 $16.11 9.60$9.60 $3.50$3.50 $7.50 $0.75 $0.38 $5.98 10 12 $11.61 $1.16 $0.10 24 15 10 $1.00$1.00 $24.00$24.00 $4.80 $4.80 $1.50$1.50 9.60$9.60 $2.00$7.76 9.60$38.64 19 12 $0.10 $0.58 $3.00 24 $5.76 23 24

Working

The Formula used in excel is shown below and the table is B10 : K40

2 Total Commission 3 $0.00-IF(C18<12,$C$11,$С$12) -c18E18 -D18+F18 -IF(F18-5,IF(F18>10,SG$14,SG$13),0) -F18*H18 D19*$G$12119

5 0
Add a comment
Know the answer?
Add Answer to:
1.Use an IF function in cell E18 to calculate the price to charge per donut for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Use a IF function in cell E18 to calculate the price to charge per donut for...

    Use a IF function in cell E18 to calculate the price to charge per donut for order 1. a customer is charge $.50 per donuts unless they buy a dozen or more in this case they are charge $.40 a donut.

  • Use an IF function in cell H18 to calculate the commission rate for the total sale...

    Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true"...

  • Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several...

    Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from...

  • Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and...

    Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if...

  • 1.Use the VLOOKUP function in cell F9 to determine the number of days it will take...

    1.Use the VLOOKUP function in cell F9 to determine the number of days it will take to ship order 1. Use the distance in cell E9 to lookup the appropriate value on the "Delivery Information" reference table (range K10:M15). Make sure to use relative and absolute references appropriately. 2.Use the VLOOKUP function in cell G9 to calculate the delivery price for order 1. The delivery price can be referenced on the "Delivery Information" lookup table. Use appropriate relative and absolute...

  • Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...

    Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B2” was...

  • Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...

    Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B2” was entered,...

  • Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...

    Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...

  • Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...

    Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...

  • Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating...

    Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT