Question: Please I need help in this supply contract: driver date order_quantity demand mean_demand sd_demand 0 3/1/17 78 72 78.44395 8.856858924 0 5/1/17 86 78 68.0901
Please I need help in this supply contract:
| driver | date | order_quantity | demand | mean_demand | sd_demand |
| 0 | 3/1/17 | 78 | 72 | 78.44395 | 8.856858924 |
| 0 | 5/1/17 | 86 | 78 | 68.0901 | 8.251672558 |
| 1 | 4/1/17 | 78 | 77 | 69.615 | 8.343560391 |
| 1 | 6/1/17 | 92 | 58 | 66.521 | 8.156040706 |
| 2 | 7/1/17 | 78 | 66 | 67.405 | 8.210054811 |
| 2 | 9/1/17 | 79 | 75 | 68.084575 | 8.25133777 |
| 2 | 11/1/17 | 90 | 74 | 69.963075 | 8.364393283 |
| 2 | 1/1/18 | 89 | 74 | 83.317 | 9.127814634 |
| 3 | 6/1/17 | 74 | 75 | 66.521 | 8.156040706 |
| 3 | 8/1/17 | 89 | 66 | 66.6315 | 8.162812015 |
| 4 | 4/1/18 | 95 | 75 | 69.498975 | 8.336604525 |
| 5 | 8/1/17 | 77 | 74 | 66.6315 | 8.162812015 |
| 5 | 10/1/17 | 89 | 68 | 69.498975 | 8.336604525 |
| 6 | 12/1/17 | 85 | 95 | 79.289275 | 8.904452538 |
| 6 | 2/1/18 | 102 | 78 | 83.8916 | 9.159235776 |
| 7 | 11/1/18 | 98 | 98 | 94.49895 | 9.721057041 |
| 7 | 1/1/19 | 118 | 104 | 112.91735 | 10.62625757 |
| 8 | 3/1/17 | 78 | 95 | 106.13005 | 10.30194399 |
| 8 | 5/1/17 | 94 | 98 | 92.1219 | 9.59801542 |
| 8 | 7/1/17 | 113 | 94 | 91.195 | 9.549607322 |
| 9 | 9/1/18 | 112 | 84 | 91.9724 | 9.590224189 |
| 9 | 11/1/18 | 101 | 97 | 94.49895 | 9.721057041 |
| 10 | 1/1/17 | 78 | 105 | 112.52865 | 10.60795221 |
| 10 | 3/1/17 | 94 | 107 | 106.13005 | 10.30194399 |
| 10 | 5/1/17 | 113 | 100 | 92.1219 | 9.59801542 |
| 10 | 7/1/17 | 120 | 84 | 91.195 | 9.549607322 |
| 11 | 10/1/18 | 126 | 99 | 94.341975 | 9.712979718 |
| 11 | 12/1/18 | 119 | 94 | 107.154125 | 10.35152767 |
| 12 | 4/1/17 | 78 | 96 | 94.185 | 9.704895672 |
| 12 | 6/1/17 | 94 | 93 | 89.999 | 9.486780276 |
| 12 | 8/1/17 | 112 | 83 | 90.1485 | 9.494656392 |
| 13 | 9/1/18 | 131 | 110 | 91.9724 | 9.590224189 |
| 13 | 11/1/18 | 132 | 100 | 94.49895 | 9.721057041 |
| 13 | 1/1/19 | 120 | 107 | 112.91735 | 10.62625757 |
pricing data are :
Retail price: $ 5.00
Price from supplier: $ 2.00
Price cargo charges drivers $ 4.00
From data above, I need to find the mean total profit, order quantity, driver profit, cargo profit, and total profit?!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
