Question: answer this please in exal Example 3: Copy the example data in the following table and paste it in cell A1 of a new Excel

 answer this please in exal Example 3: Copy the example data

answer this please in exal

Example 3: Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. The following table represents the value of sales in different sales markets according to the three prices: $50,$45,$40. The required results are to determine the number of sales representatives that each market needs based on the following assumptions: 1. The market needs 5 sales representatives, if the sales value is less than or equal to $ 80,000. 2. The market needs 8 sales representatives if sales value is greater than $80,000. 3. A scenario summary that shows how many sales representatives for each market. Sales Market Oman UAE KSA Qatar Bhrain Sales Value ($50) Sales Value ($45) Sales Value ($40) Number of sales representatives $ 100,000.00 $ 111,000.00 $ 120,000.00 $ 80,000.00 $ 104,000.00 $ 118,000.00 $ 75,000.00 $ 85,000.00 $ 90,000.00 $ 50,000.00 $ 72,000.00 $ 79,000.00 $ 60,000.00 $ 74,000.00 $ 81,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the number of sales representatives needed for each market in Excel follow these steps ... View full answer

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 Databases Questions!