The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%.
All other sales (any amount greater than 0) earn a bonus rate of 2%.
With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5.
Fill the formula down through cell C8.

< back to assignment attempts: 1 1 keep the highest: 1 / 2 2. determining opportunity cost juanita is deciding whether to buy a suit that she wants, as well as where to buy it. three stores carry the same suit, but it is more convenient for juanita to get to some stores than others. for example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $102 for the suit: store travel time each way price of a suit (minutes) (dollars per suit) local department store 15 102 across town 30 88 neighboring city 60 65 juanita makes $42 an hour at work. she has to take time off work to purchase her suit, so each hour away from work costs her $42 in lost income. assume that returning to work takes juanita the same amount of time as getting to a store and that it takes her 30 minutes to shop. as you answer the following questions, ignore the cost of gasoline and depreciation of her car when traveling. complete the following table by computing the opportunity cost of juanita's time and the total cost of shopping at each location. store opportunity cost of time price of a suit total cost (dollars) (dollars per suit) (dollars) local department store 102 across town 88 neighboring city 65 assume that juanita takes opportunity costs and the price of the suit into consideration when she shops. juanita will minimize the cost of the suit if she buys it from the . grade it now save & continue continue without saving

Suppose your rich uncle gave you $50,000, which you plan to use for graduate school. you will make the investment now, you expect to earn an annual return of 6%, and you will make 4 equal annual withdrawals, beginning 1 year from today. under these conditions, how large would each withdrawal be so there would be no funds remaining in the account after the 4th withdraw?

Aproject currently generates sales of $14 million, variable costs equal 50% of sales, and fixed costs are $2.8 million. the firm’s tax rate is 40%. assume all sales and expenses are cash items. (a). what are the effects on cash flow, if sales increase from $14 million to $15.4 million? (input the amount as positive value. enter your answer in dollars not in (b) what are the effects on cash flow, if variable costs increase to 60% of sales? (input the amount as positive value. enter your answers in dollars not in millions). cash flow (increase or decrease) by $