Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40. Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (A24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40.

Acustomer has come to your department with an urgent question. you promised her that you would collect information about her question and answer it by noon. it will take you at least 20 minutes to gather the information needed to provide an answer. it is now 11: 50 a.m. your supervisor just scheduled a 30-minute meeting to start at noon. this meeting is for all employees in your department. you decide to:

The revenues of a company increased by 39% in year one and decreased 22% in year two. what is the overall change over the two-year period?

Aprice ceiling is “binding” if the price ceiling is set below the equilibrium price. suppose that the equilibrium price is $5. if a price ceiling is set at $6, this will not affect the market in any way since $5 remains a legally allowable price (since $5 < $6). a price ceiling of $6 is called a “non-binding” price ceiling. on the other hand, if the price ceiling is set at $4, the price ceiling is “binding” because the natural equilibrium price is $5 but that is no longer allowed. what happens when there is a binding price ceiling? at a price below the equilibrium price, quantity demanded exceeds quantity supplied. there is a shortage. normally, price increases eliminate shortages by increasing quantity supplied and decreasing quantity demanded. in this case, however, price increases are not allowed past the price ceiling. we therefore predict that the observed market price will be right at the price ceiling and there will be a permanent shortage. the observed quantity bought and sold will be dictated by the quantity supplied at the price ceiling. although consumers would like to buy more, there are no more units for sale