Question: Question Completion Status Consider the following scenario and the image Your five sales staff have their Monthly Performance RMPRO performed monthly according to the following

Question Completion Status Consider the following scenario and the image Your five sales staff have their Monthly Performance RMPRO performed monthly according to the following rules.The result is to appear in procent . If the staff member was hired less than or equal to 365 days ago, hier MP Probo . Otherwise, if the staff member sold greater than or equal to 15.000 in Guided Tours and greater than or equal to 54.000 in Camping and te per than or equal to 5.000 in Kayaking or pe than or equal to 51.000 in Fishing trips for both, then the MP Excellent Cherwise, if the staff members totales is greater than or equal to $20,000, and there are no produta on, Guided Tours Campire ayaking Fahing Trowth 30 sales for the month for that start member, then the MPRISO Omewise, the MPR IS *Review which will reper a personal performance reen interview with the stuit neberie, note of the previous conditions were Hired A B 3 2 Employeeld Surname First name 3 1 Smith Angela 4 2 Jones Robert 5 3 Wang Cynthia 6 4 Schneider Jim 7 5 Reynolds Wayne 8 D G H 1 Sales (this month) Monthly Guided Tour Camping Kayaking Fishing Trip Total Perf. Rev. (MPR) 17/04/2021 s 9,960 $4,400 $3,020 S 920S 18,300 Probation 16/01/2021 $ 5,700 S 970S 8,020 S 2,140S16,830 Probation 3/02/2020 $ 5,020 S 3,520 S 5,820 S $ 14,360 Review 15/06/2020 S 7,4605 3,000 $8,700 S 1,050 S 20,210 OK 5/08/2018 5 6.490 S 8,940S 6,040 S 5,810S 27,280 Excellent Your task CEI MARS 0 A B 1 2 Employeeld Surname First name 3 1 Smith Angela 4 2 Jones Robert 5 3 Wang Cynthia 6 4 Schneider Jim 7 5 Reynolds Wayne 8 D E F G H 1 Sales (this month) Hired Guided Tour Camping Kayaking Fishing Trip Total 17/04/2021 S 9,960 S 4,400 S 3,020 S 920S 18,300 16/01/2021 S 5,700 S 970S 8,020 S 2,140 S 16,830 3/02/2020 $ 5,020 $ 3,520 S 5,820 S $ 14,360 15/06/2020 S 7,460 S 3,000 $8,700 $ 1,050 $ 20,210 5/08/2018 S 6,490S 8,940$ 6,040S 5,810 $ 27,280 Monthly Perf. Rev. (MPR) Probation Probation Review OK Excellent - Your task: Replicate the formula used in 3. which will be copied down to IZ) to obtain the correct MPR status to display You must use 15. TODAY. AND.OR. COUNTE Question Completion Status Consider the following scenario and the image Your five sales staff have their Monthly Performance RMPRO performed monthly according to the following rules.The result is to appear in procent . If the staff member was hired less than or equal to 365 days ago, hier MP Probo . Otherwise, if the staff member sold greater than or equal to 15.000 in Guided Tours and greater than or equal to 54.000 in Camping and te per than or equal to 5.000 in Kayaking or pe than or equal to 51.000 in Fishing trips for both, then the MP Excellent Cherwise, if the staff members totales is greater than or equal to $20,000, and there are no produta on, Guided Tours Campire ayaking Fahing Trowth 30 sales for the month for that start member, then the MPRISO Omewise, the MPR IS *Review which will reper a personal performance reen interview with the stuit neberie, note of the previous conditions were Hired A B 3 2 Employeeld Surname First name 3 1 Smith Angela 4 2 Jones Robert 5 3 Wang Cynthia 6 4 Schneider Jim 7 5 Reynolds Wayne 8 D G H 1 Sales (this month) Monthly Guided Tour Camping Kayaking Fishing Trip Total Perf. Rev. (MPR) 17/04/2021 s 9,960 $4,400 $3,020 S 920S 18,300 Probation 16/01/2021 $ 5,700 S 970S 8,020 S 2,140S16,830 Probation 3/02/2020 $ 5,020 S 3,520 S 5,820 S $ 14,360 Review 15/06/2020 S 7,4605 3,000 $8,700 S 1,050 S 20,210 OK 5/08/2018 5 6.490 S 8,940S 6,040 S 5,810S 27,280 Excellent Your task CEI MARS 0 A B 1 2 Employeeld Surname First name 3 1 Smith Angela 4 2 Jones Robert 5 3 Wang Cynthia 6 4 Schneider Jim 7 5 Reynolds Wayne 8 D E F G H 1 Sales (this month) Hired Guided Tour Camping Kayaking Fishing Trip Total 17/04/2021 S 9,960 S 4,400 S 3,020 S 920S 18,300 16/01/2021 S 5,700 S 970S 8,020 S 2,140 S 16,830 3/02/2020 $ 5,020 $ 3,520 S 5,820 S $ 14,360 15/06/2020 S 7,460 S 3,000 $8,700 $ 1,050 $ 20,210 5/08/2018 S 6,490S 8,940$ 6,040S 5,810 $ 27,280 Monthly Perf. Rev. (MPR) Probation Probation Review OK Excellent - Your task: Replicate the formula used in 3. which will be copied down to IZ) to obtain the correct MPR status to display You must use 15. TODAY. AND.OR. COUNTE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Sun trek, based in China, is a global supplier of denim jeans for apparel companies around the world. They purchase raw cotton from producers in Arkansas, Mississippi, and Texas, where it is picked,...

Consider the following scenario and the image. Your five sales staff have their Monthly Performance Review (MPR) performed monthly according to the following rules. The result is to appear in 13:37...

Given summary about this article the most important Humans inherit artificial intelligence biases Luca Vicente & Helena Matute * Artificial intelligence recommendations are sometimes erroneous and...

Case Summary Read the Discussion Assignment 1-1 on p.24 of the text Winning and Longevity. Select a health care entity to focus on, this could be a clinic or hospital of your choosing. Apply the case...

Minimum monthly, weekly, and daily productivity levels are strictly specified for each TSS, and there are strict quotas on repair expenses and travel expenses. Prior approval from an FSM is required...

Two Discussion Questions. A minimum of 200 words per question. Both questions are attached to the word document and each chapter to both questions are attached to the PDF. Any references/citations...

Administrative Law 5 A dministrative law governs and defines the powers of government agencies. A number of political and technological factors have led to an explosion in the growth of government...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Following is a bank reconciliation for Surf Shop for June 30, 2012: When reviewing the bank reconciliation, Surf's auditor was unable to locate any reference to the NSF check on the bank statement....

Analyze the relationship between self-reported health condition and general happiness. a. Use SPSS to construct a table showing the relationship between health condition (HEALTH) and reported general...

1 2 . The Cash Payments Journal is for recording only payments by cheque. ( 1 Point ) True False

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....