Step 1:In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your job to assess the data for anyone who receives a bonus. Employees get a 10% bonus of their total sales if they have total annual sales above $10,000. Employees also get a quarterly bonus of 3% if a single quarters sale is above $3,000. You are to use conditional formatting to: i) If an employee gets a quarterly bonus, the quarter in which they received the bonus, should be highlighted light yellow. ii) If an employee gets an annual bonus the Total column should be highlighted light green ii) The top 10% of total earning employees should be marked with a greed dot icon in their total column. You must use conditional formatting to complete these tasks. EIN 3354 Eng. Econ. 2 Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon with an X is placed in the cell, and if they turned it in on or before 12/17/2020 a green icon with a check is placed in that cell. (10 points)

The larger the investment you make, the easier it will be to: get money from other sources. guarantee cash flow. buy insurance. streamline your products.

In december of 2004, the company you own entered into a 20-year contract with a grain supplier for daily deliveries of grain to its hot dog bun manufacturing facility. the contract called for "10,000 pounds of grain" to be delivered to the facility at the price of $100,000 per day. until february 2017, the supplier provided processed grain which could easily be used in your manufacturing process. however, no longer wanting to absorb the cost of having the grain processed, the supplier began delivering whole grain. the supplier is arguing that the contract does not specify the type of grain that would be supplied and that it has not breached the contract. your company is arguing that the supplier has an onsite processing plant and processed grain was implicit to the terms of the contract. over the remaining term of the contract, reshipping and having the grain processed would cost your company approximately $10,000,000, opposed to a cost of around $1,000,000 to the supplier. after speaking with in-house counsel, it was estimated that litigation would cost the company several million dollars and last for years. weighing the costs of litigation, along with possible ambiguity in the contract, what are three options you could take to resolve the dispute? which would be the best option for your business and why?

In the 1970s, kmart used blue light specials to encourage customers to flock to a particular department having a temporary sale. a spinning blue light activated for approximately 30 seconds, and then an in-store announcement informed shoppers of the special savings in the specific department. over time, loyal kmart shoppers learned to flock to the department with the spinning blue light before any announcement of special savings occurred. if kmart was employing classical conditioning techniques, what role did the spinning blue light play?