4. On the sheet of 2016 Orders, complete the following tasks. a. Make of list on the entire dataset. b. Sort the dataset by Product first and then by Region. (Other idea: By Salesperson first and then by Month) c. Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (D4:D7) and show prices for all orders. d. Add a column at the right of Unit. Name it Total. The order totals = Price * Unit. e. At the right of Total, add a column called Discount. Use a nested If function to decide the discounts. The company gives 10% discount to all orders from the West region, and the other regions only enjoy 10% discount in December. f. At the right of Discount, add a column called Totalw/Dis. It is the order totals – discounts. g. In cell L2, use the AVERAGE function to calculate the average number of units sold from the column Unit. Next, use conditional formatting tool and highlight the orders with unit sold greater than average unit sold. Select the green fill and dark green text color option if the cells meet this rule.

Areal estate agent is considering changing her cell phone plan. there are three plans to choose from, all of which involve a monthly service charge of $20. plan a has a cost of $.42 a minute for daytime calls and $.17 a minute for evening calls. plan b has a charge of $.52 a minute for daytime calls and $.15 a minute for evening calls. plan c has a flat rate of $80 with 275 minutes of calls allowed per month and a charge of $.38 per minute beyond that, day or evening.a. determine the total charge under each plan for this case: 150 minutes of day calls and 70 minutes of evening calls in a month. (do not round intermediate calculations. round your answer to 2 decimal places. omit the "$" sign in your response.)c. if the agent will use the service for daytime calls, over what range of call minutes will each plan be optimal? (round each answer to the nearest whole number.include the indifference point itself in each answer.)d. suppose that the agent expects both daytime and evening calls. at what point (i.e., percentage of total call minutes used for daytime calls) would she be indifferent between plans a and b?

In a perfectly competitive market, the long-run market supply curve tends to be horizontal or nearly so. what is another way to state this fact? (a) market supply is much more elastic in the long run than the short run. (b) in the long run, average total cost is minimized. (c) in the long run, price equals marginal cost. (d) market supply is much less elastic in the long run than the short run.

Which of the following is a benefit of a hat? it has a sports team logo on it. it makes the wearer look cool. it is red. it costs $12.