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 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
To calculate the number of sales representatives needed for each market in Excel follow these steps ... View full answer
Get step-by-step solutions from verified subject matter experts
