A B C D B P G H K M C P O R. S T 1 A company is res earching better w ays to se e how many sa les calls to have its sales people make for be ing efficient as poss ib le. Sales calls, as an estim ate, cost$104 each. If a sale is made, the first 40 sales lead to $800 in contribution toward profit, and for anything more than 40, expe cts $300. Number of optimal Sales Calls 0.12 Prob of a sale 3 104.00 Cost of a sales call S 4 S 800.00 Profit from a sale 50 Expected Total Revenue Expected Total Cost Determine the optim al number of s ales calls so that profit is maximized. Profit the to tal co ntrib ution to profit from sales less the cost of the s ales ca lls. A data tab le is requ ired with the functions pres ente d. 5 S 6 7 8 The probability of a sale during each sales call is 0.12. Expected Total Profit 10 11 12 Data Table Number of Calls to Try 13 14 Revenue Prob Sales Probability Revenue 340 Functions areneeded. I am assuming C14,B14, and under datatable.. Not surethough. Thetop left, cells A2, A7, A8, and A9 are retreiving info from the below table Not sure if a column for cost and or profit need to be added to data ?? 0 341 15 16 17 18 1 342 2. 343 344 Notes: 4 345 19 20 21 22 23 24 25 346 Column A-Sales (A14) goes from row number 15 to 515 (0-500 sales) 6 347 7 348 8 349 Column G-G14, 340 number of callsto try all theway to 540 number of cal ls to try 350 10 351 11 352 26 27 28 29 30 12 353 13 354 14 355 15 356 16 357 31 32 33 34 35 36 37 17 358 18 359 19 360 20 361 21 362 22 363 23 364 38 39 40 41 42 43 24 365 25 366 26 367 27 368 28 369 29 370 44 45 46 47 30 371 372 31 32 373 33 374 48 49 50 51 52.. 34 375 35 376 36 377 37 378 38 379 53 54 55 56 39 380 40 381 41 382 42 383 57 A B C D B P G H K M C P O R. S T 1 A company is res earching better w ays to se e how many sa les calls to have its sales people make for be ing efficient as poss ib le. Sales calls, as an estim ate, cost$104 each. If a sale is made, the first 40 sales lead to $800 in contribution toward profit, and for anything more than 40, expe cts $300. Number of optimal Sales Calls 0.12 Prob of a sale 3 104.00 Cost of a sales call S 4 S 800.00 Profit from a sale 50 Expected Total Revenue Expected Total Cost Determine the optim al number of s ales calls so that profit is maximized. Profit the to tal co ntrib ution to profit from sales less the cost of the s ales ca lls. A data tab le is requ ired with the functions pres ente d. 5 S 6 7 8 The probability of a sale during each sales call is 0.12. Expected Total Profit 10 11 12 Data Table Number of Calls to Try 13 14 Revenue Prob Sales Probability Revenue 340 Functions areneeded. I am assuming C14,B14, and under datatable.. Not surethough. Thetop left, cells A2, A7, A8, and A9 are retreiving info from the below table Not sure if a column for cost and or profit need to be added to data ?? 0 341 15 16 17 18 1 342 2. 343 344 Notes: 4 345 19 20 21 22 23 24 25 346 Column A-Sales (A14) goes from row number 15 to 515 (0-500 sales) 6 347 7 348 8 349 Column G-G14, 340 number of callsto try all theway to 540 number of cal ls to try 350 10 351 11 352 26 27 28 29 30 12 353 13 354 14 355 15 356 16 357 31 32 33 34 35 36 37 17 358 18 359 19 360 20 361 21 362 22 363 23 364 38 39 40 41 42 43 24 365 25 366 26 367 27 368 28 369 29 370 44 45 46 47 30 371 372 31 32 373 33 374 48 49 50 51 52.. 34 375 35 376 36 377 37 378 38 379 53 54 55 56 39 380 40 381 41 382 42 383 57