Business, 22.04.2021 21:30 lesmontoya10

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)

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 14:10

Needs 83,000 optical switches next year (assume same relevant range). by outsourcing them, worldsystems can use its idle facilities to manufacture another product that will contribute $ 140,000 to operating income, but none of the fixed costs will be avoidable. should worldsystems make or buy the switches? show your analysis.

Answers: 3

Answer

Business, 22.06.2019 02:10

Materials purchases (on credit). direct materials used in production. direct labor paid and assigned to work in process inventory. indirect labor paid and assigned to factory overhead. overhead costs applied to work in process inventory. actual overhead costs incurred, including indirect materials. (factory rent and utilities are paid in cash.) transfer of jobs 306 and 307 to finished goods inventory. cost of goods sold for job 306. revenue from the sale of job 306. assignment of any underapplied or overapplied overhead to the cost of goods sold account. (the amount is not material.) 2. prepare journal entries for the month of april to record the above transactions.

Answers: 1

Answer

Business, 22.06.2019 07:40

Xyz corporation has provided the following data concerning manufacturing overhead for july: actual manufacturing overhead incurred $ 69,000 manufacturing overhead applied to work in process $ 79,000 the company's cost of goods sold was $243,000 prior to closing out its manufacturing overhead account. the company closes out its manufacturing overhead account to cost of goods sold. which of the following statements is true? multiple choice manufacturing overhead was overapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $253,000 manufacturing overhead was underapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $233,000 manufacturing overhead was underapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $253,000 manufacturing overhead was overapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $233,000

Answers: 1

Answer

Business, 23.06.2019 04:10

Which of the following would not be listed under cash outflows in a financial plan?

Answers: 2

Answer

You know the right answer?

Step 1:In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your j...

Questions