Determine the commision expense in cell b16

Reference no: EM13334387

The commision expense is based on the advertising revenue amount only. If the advertising revenue in cell b10 is greater than 1000, then the commission expense is the commision percentage in cell b4 in the assumptions area times the advertising revenue value in b 10. Otherwise, the commision expense is zero. Use this information to create a formula using the IF function to determine the commision expense in cell b16.

Reference no: EM13334387

Questions Cloud

Find what is the total inventory cost at the eoq level : The optimal safety stock (which is on hand initially) is 1,200 bags. Each bag costs Green Thumb $4, inventory carrying costs are 20 percent, and the cost of placing an order with its supplier is $25.

Discuss the role of family : Discuss the role of family

What is the height of the bridge above the water : A rock is dropped off the side of a bridge and hits the water below 5.7 s later. What is the height of the bridge above the water

Explain the heat lost by the boiling water is equal : The heat lost by the boiling water is equal to the heat gained by the room-temperature water. How much heat was transferred in this process

Determine the commision expense in cell b16 : The commision expense is based on the advertising revenue amount only. If the advertising revenue in cell b10 is greater than 1000, then the commission expense is the commision percentage in cell b4 in the assumptions area times the advertising reven..

How much would it be willing to spend each year to reduce : Clearwater Glass Company examined its cash management policy and found that it takes an average of five days for checks that the company writes to reach its bank and thus to be deducted from its checking account balance.

Determine where should the object be placed : A convex spherical mirror, whose focal length has a magnitude of 15.2 cm, is to form an image 10.4 cm behind the mirror. where should the object be placed

Explain final volume of reading in the measuring cylinder : A cube of metal measuring 14.2 mm on a side is placed in a graduated cylinder containing 25.3 mL of water. What is the final volume of reading in the measuring cylinder

How to set the correct valuation of a company : How to set the correct valuation of a company? What is the formula or data we need to calculate/estimate a company's valuation?

User Account

All Pages