ZuoTi.Pro
Question

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.
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution:-

Price per Donut 0-11 Total Sales Total Commission $396.53 $23.82 Commission Rate 0.50 Threshold Rate 0.40 10% Beverage Sales> $5 $ Sales> $10 $10.00 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

0.50 Total Commission DO Beverage Total Commission =D18*SG$12 =118+18 D19 $G$12119+J19 $0.00=IF(C18<12,SC$11,SC$12)-c18*E18 $0.00-|F(C19く12,$C$11,SC$12)-C19E19 $66.24-IF(C20<12,$С$11,$С$12)-c20*E20 37.20 IF(C21<12,SC$11,SC$12) C21 E21 =C22*E22 $0.00:F(C23-12,SC$11,SC$12)-c23*E23 $7.50 IF(C24<12,SC$11,$С$12)-C24*E24 $0.00-|F(C25<12,$C$11,$C$12)-C25E25 E26 $0.00-IF(C27<12,SC$11,SC$12)-c27E27 $0.00 =IF(C28<12,SC$11,SC$12)=C28*E28 $0.00:F(C29<12,$C$11,SC$12)=C29*E29 $11.61-|F(C30<12,$C$11,$С$12)-C30*E30 $0.00-F(C31<12,$C$11,SC$12) -c31E31 0.00 IF(C32 12,SC$11,SC$12) -C32 E32 $0.00-1 F(C33-12,SC$11,SCS12)-СЗЗE33 $0.00:F(C34c12,SC$11,SC$12) -c34*E34 $0.00:F(C35c12,$C$11,$C$12)-C35*E35 $0.00-IF(C36-12,$C$11,$С$12) -c36E36 0.00-IF(C37<12,$C$11,SC$12)-c37E37 0.00 IF(C38 12,SC$11,sc$12)C38 E38 76 IF(C39 12,SC$11,SC$12) -C39 E39 $29.04-IF(C40<12,$C$11,$С$12)-C40*E40 =D18+F18=IF(F18>5,IF(F18>10,$G$14,SG$13),0)=F18*H18 -D19+F19 :F(F1925,IF(F19210,$G$14,$G$13),0)-F19*H19 -D20+F20-IF(F2025,IF(F20>10,$G$14,$G$13),0)-F20H20 D21+F21 IF(F21>5,IF(F21 10,SG$14,SG$13),0 F21 H21 22-IF(F22>5,IF(F22>10,SG$14,SG$13),0)-F22H22 -О23tF23:F(F2325,IF(F23>10,SG$14,SG$13),0)-F23*H23 D24+F24:F(F24>5,IF(F24>10,SG$14,$G$13),0)-F24*H24 -D25tF25 =IF(F2525, IF(F25>10,$G$14,$G$13),0)=F25*H25 -D26+F26:IF(F2625,IF(F26210,SG$14,SG$13),0) -F26H26 -D27+F27-IF(F27>5,IF(F27>10,SG$14,SG$13),0)-F27H27 =D28+F28 =IF(F28>5,IF(F28>10,SG$14,SG$13),0)=F28*H28 =D29+F29=IF(F2925,IF(F29210,SG$14,SG$13),0)=F29*H29 »D30+F30 :F(F3025,IF(F30>10,$G$14,SG$13),0)-F30*H30 -D31+F31-IF(F3125,IF(F31>10,SG$14,SG$13),0) -F31H31 D32+F32IF(F32>5,IF(F32>10,SG$14,SG$13),0) F32*H32 -D33tF33:F(F3325,IF(F33-10,SG$14,SG$13),0)-F33H33 -D34+F34:F(F3425,IF(F34>10,$G$14,SG$13),0) -F34*H34 -D35+F35-IF(F35>5,IF(F35210,$G$14,$G$13),0)-F35*A35 -D36+F36-IF(F3625,IF(F36210,$G$14,SG$13),0) -F36H36 -D37+F37-IF(F37>5,IF(F37>10,SG$14,SG$13),0)-F37H37 D38+F38IF(F38>5,IF(F38 10,$G$14,SG$13),0) F38*H38 D39+F39IF(F39>5,IF(F39 10,SG$14,SG$13),0) F39 *H39 »D40+F40 :F(F40>5,IF(F40>10,$G$14,SG$13),0)-F40*H40 $0.00=IF(C22-12,SCS11,SCS12) -o22+F D23 SG$12 123+J23 $56.88 -IF(C26 12,SC$11,SC$12) -C26 -D26 $G$12 126+J26 D27 $G$12 127+J27 D30 $G$12 -130+J30 -D31 $G$12 131+J31 D32 $G$12 132+J32 D33 $G$12133+J33 D35 $G$12 135+J35 -D36 $G$12 136+J36 -D37*$G$12 137+J37 8 =D39SG$12 =139 39 5.

1 0
Add a comment
Know the answer?
Add Answer to:
Use a 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

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 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 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.

  • Doug wants to go into the donut business. For $500 per month he can rent a...

    Doug wants to go into the donut business. For $500 per month he can rent a bakery complete with all the equipment he needs to make a dozen different kinds of donuts (K=l). He must pay unionized donut bakers a monthly salary of $400 each. He projects his production function to be Y = 5KL (where Y is tons of donuts). A) How many donuts does Doug need to produce in order for K=4 to be the optimal level of...

  • In Java Pls Class Design: Donut (Suggested Time Spent: < 15 minutes) The Donut class is intended to be an abstract a...

    In Java Pls Class Design: Donut (Suggested Time Spent: < 15 minutes) The Donut class is intended to be an abstract and simplified representation of a yummy edible donut Class Properties (MUST be private) Name of the donut Type of donut Price of the donut Class Invariants Donut name must not be empty (Default: "Classic") Type of donut can only be one of the following: "Plain," "Filled," or "Glazed" (Default: "Plain") Class Components Public Getter and Private Setter for name,...

  • (20 points) Frank wants to go into the donut business. For $500 per month he can rent a bakery co...

    (20 points) Frank wants to go into the donut business. For $500 per month he can rent a bakery complete with all the equipment he needs to make a dozen different kinds of donuts (K-1,r-500). He must pay unionized donut bakers a monthly salary of $400 each. He projects his monthly production function to be q-5LK, where q is tons of donuts. 4. With the current level of capital, derive the total product of labor and the marginal product of...

  • Wendell's Donut Shoppe is investigating the purchase of a new $34,600 donut-making machine. The new machine...

    Wendell's Donut Shoppe is investigating the purchase of a new $34,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $6,200 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 2,200 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...

  • Wendell's Donut Shoppe is investigating the purchase of a new $33,700 donut-making machine. The new machine...

    Wendell's Donut Shoppe is investigating the purchase of a new $33,700 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,500 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 2,200 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...

  • Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new machine...

    Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,700 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,100 dozen more donuts each year. The company realizes a contribution margin of $2.60 per dozen donuts sold. The new machine would have...

  • Wendell’s Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine...

    Wendell’s Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $3,800 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,000 dozen more donuts each year. The company realizes a contribution margin of $1.20 per dozen donuts sold. The new machine would have...

  • Wendell's Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine would permi...

    Wendell's Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $3,800 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,000 dozen more donuts each year. The company realizes a contribution margin of $1.20 per dozen donuts sold. The new machine would have...

  • Exercise 13-3 Internal Rate of Return [LO13-3] Wendell’s Donut Shoppe is investigating the purchase of a...

    Exercise 13-3 Internal Rate of Return [LO13-3] Wendell’s Donut Shoppe is investigating the purchase of a new $40,000 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,200 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 2,000 dozen more donuts each year. The company realizes a contribution margin of $2.40 per dozen...

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