1. For each of the scenarios, compute the optimal floor price:

a. All regions have the same floor price.

b. Each geographic region has its own floor price.

2. ROI: What is the percentage change in profit, revenue, units sold, and percentage margin from implementing the optimal price floors in Question 1? (Define margin as % margin = profit/revenue.)

All Regions 79.66 New Floor Price Cost per Unit $ $ 68.00 $ Expected Profit Expected Quantity Expected Revenue 11,963,341 560,765 50,095,343 $ Price Floor Price Bin 1 Probability 0.82 79.66 $ 2 Avg WTP 81.16 83.94 86.29 88.53 0.99 3 79.66 79.66 79.66 79.66 1.00 1.00 4 5 91.43 93.75 1.00 1.00 6 79.66 7 96.09 1.00 Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $93.00-$94.99 $95.00-$ 96.99 $ 97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Current Quantity 31,043 $ 34,600 $ 44,124 $ 46,016 $ 45,609 $ 55,559 $ 52,065 $ 53,052 $ 31,270 $ 34,038 $ 30,031 $ 37,097 $ 27,625 $ 20,145 $ 18,405 $ 6,231 $ Current Profit 243,105 $ 355,238 $ 537,527 $ 651,231 $ 740,665 $ 1,006,582 $ 1,052,131 $ 1,171,666 $ 756,548 $ 889,994 $ 849,575 $ 1,125,320 $ 896,323 $ 693,353 $ 665,069 $ 233,529 $ 8 Current Revenue 2,354,029 $ 2,708,038 $ 3,537,959 $ 3,780,319 $ 3,842,077 $ 4,784,594 $ 4,592,551 $ 4,779,202 $ 2,882,908 $ 3,204,578 $ 2,891,683 $ 3,647,916 $ 2,774,823 $ 2,063,213 $ 1,916,609 $ 657,237 $ Avg Unit Price 75.83 $ 78.27 $ 80.18 $ 82.15 $ 84.24 $ 86.12 $ 88.21 $ 90.09 $ 92.19 $ 94.15 $ 96.29 $ 98.33 $ 100.45 $ 102.42 $ 104.14 $ 105.48 $ 79.66 79.66 $ $ $ $ $ $ $ $ $ $ $ $ 1.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Expected Profit for Bin 295,856 397,971 537,527 651,231 740,665 1,006,582 1,052,131 1,171,666 756,548 889,994 849,575 1,125,320 896,323 693,353 665,069 233,529 Expected Quantity for Bin Expected Revenue for Bin 25,371 $ 2,021,055 34,127 $ 2,718,618 44,124 $ 3,537,959 46,016 $ 3,780,319 45,609 $ 3,842,077 55,559 $ 4,784,594 52,065 $ 4,592,551 53,052 $ 4,779,202 31,270 $ 2,882,908 34,038 $ 3,204,578 30,031 $ 2,891,683 37,097 $ 3,647,916 27,625 $ 2,774,823 20,145 $ 2,063,213 18,405 $ 1,916,609 6,231 $ 657,237 9 1.00 1.00 10 98.39 102.48 104.46 106.87 108.91 111.09 114.13 115.99 118.37 11 1.00 12 1.00 79.66 79.66 79.66 79.66 79.66 79.66 79.66 79.66 13 1.00 1.00 14 15 1.00 1.00 $ $ $ 16 South Region 85.00 New Floor Price Cost per Unit $ $ 68.00 $ Expected Profit Expected Quantity Expected Revenue 3,864,304 196,311 17,213,436 $ Price Floor Probability 0.02 85.00 $ Avg WTP 81.11 83.75 85.76 87.80 85.00 0.22 0.68 29993 $ $ $ $ 85.00 85.00 85.00 85.00 0.94 90.10 92.12 94.34 0.99 1.00 Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$88.99 $89.00-$ 90.99 $91.00-$ 92.99 $ 93.00-$94.99 $95.00-$ 96.99 $97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Price Bin 1_s 2_s 3_S 4_S 5_S 6_S 7_S 8_S 9_S 10_S 11_s 12_S 13_S 14_5 15_S 16_S Current Quantity 30,730 $ 32,770 $ 36,178 $ 34,275 $ 27,633 $ 29,893 $ 28,014 $ 25,031 $ 1,935 $ 3,237 $ 3,353 $ 4,187 $ 4,381 $ 1,729 $ 2,214 $ $ Current Profit 240,288 $ 336,259 $ 440,043 $ 484,753 $ 447,306 $ 540,804 $ 565,091 $ 549,423 $ 47,777 $ 86,407 $ 95,128 $ 127,641 $ 141,774 $ 59,683 $ 80,852 $ $ Current Revenue Avg Unit Price 2,329,928 $ 75.82 $ 2,564,619 $ 78.26 $ 2,900,147 $ 80.16 $ 2,815,453 $ 82.14 $ 2,326,350 $ 84.19 $ 2,573,528 $ 86.09 $ 2,470,043 $ 88.17 $ 2,251,531 $ 89.95 $ 179,357 $ 92.69 $ 306,523 $ 94.69 $ 323,132 $ 96.37 $ 412,357 $ 98.49 $ 439,682 $ 100.36 $ 177,255 $ 102.52 $ 231,404 $ 104.52 $ NA NA 85.00 85.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1.00 1.00 1.00 96.10 Expected Profit for Bin 10,420 123,878 419,312 549,199 466,916 540,804 565,091 549,423 47,777 86,407 95,128 127,641 141,774 59,683 80,852 Expected Quantity for Bin Expected Revenue for Bin 613 $ 52,099 7,287 $ 619,392 24,665 $ 2,096,558 32,306 $ 2,745,993 27,466 $ 2,334,582 29,893 $ 2,573,528 28,014 $ 2,470,043 25,031 $ 2,251,531 1,935 $ 179,357 3,237 $ 306,523 3,353 $ 323,132 4,187 $ 412,357 4,381 $ 439,682 1,729 $ 177,255 2,214 $ 231,404 $ 85.00 85.00 99.12 101.16 103.17 105.38 107.24 109.90 85.00 85.00 1.00 1.00 1.00 1.00 1.00 85.00 $ $ $ $ $ $ $ 85.00 111.66 1.00 85.00 85.00 NA North Region New Floor Price Cost per Unit $ $ 85.00 68.00 $ Expected Profit Expected Quantity Expected Revenue 2,453,541 106,595 9,702,034 $ Avg WTP Expected Profit for Bin Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $ 93.00-$94.99 $95.00-$ 96.99 $97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Price Bin 1_N 2_N 3_N 4_N 5_N 6_N 7_N 8_N 9_N 10_N 11_N 12_N 13_N 14_N 15_N 16_N Current Quantity $ $ 6,382 $ 10,946 $ 10,729 $ 10,902 $ 9,616 $ 9,500 $ 9,908 $ 10,776 $ 7,712 $ 13,634 $ 5,759 $ 433 $ 572 $ $ Current Profit $ $ 78,322 $ 154,849 $ 173,064 $ 198,665 $ 195,392 $ 211,321 $ 239,755 $ 281,937 $ 217,711 $ 414,279 $ 186,489 $ 14,800 $ 20,874 $ $ Current Revenue NA NA 512,298 $ 899,177 $ 902,636 $ 940,001 $ 849,280 $ 857,321 $ 913,499 $ 1,014,705 $ 742,127 $ 1,341,391 $ 578,101 $ 44,244 $ 59,770 $ NA Avg Unit Price NA NA 80.27 $ 82.15 $ 84.13 $ 86.22 $ 88.32 $ 90.24 $ 92.20 $ 94.16 $ 96.23 $ 98.39 $ 100.38 $ 102.18 $ 104.49 $ NA 88.31 90.54 92.53 94.86 97.16 99.14 101.39 103.74 106.01 108.27 110.21 112.06 114.37 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Price Floor 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 Probability NA NA 0.96 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NA $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 104,668 185,356 182,295 198,665 195,392 211,321 239,755 281,937 217,711 414,279 186,489 14,800 20,874 Expected Quantity for Bin Expected Revenue for Bin $ $ 6,157 $ 523,340 10,903 $ 926,780 10,723 $ 911,475 10,902 $ 940,001 9,616 $ 849,280 9,500 $ 857,321 9,908 $ 913,499 10,776 $ 1,014,705 7,712 $ 742,127 13,634 $ 1,341,391 5,759 $ 578,101 433 $ 44,244 572 $ 59,770 $ West Region $ New Floor Price Cost per Unit 93.00 68.00 $ $ Expected Profit Expected Quantity Expected Revenue 5,455,612 188,786 18,293,056 $ Avg WTP Price Floor Avg Unit Price 77.00 Expected Quantity for Bin 0 86.46 93.00 78.37 87.39 93.00 7 $ $ $ $ 80.25 90.21 93.00 90 795 $ $ $ $ $ $ $ 93.00 92.43 94.86 82.63 84.60 86.09 88.20 93.00 96.25 $ $ $ $ 93.00 93.00 u Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $ 93.00-$ 94.99 $ 95.00-$ 96.99 $ 97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Probability 0.00 0.00 0.06 0.36 0.87 0.96 1.00 1.00 1.00 1.00 1.00 98.78 Price Bin 1_W 2_W 3_W 4_W 5_W 6_W 7_W 8_W 9 W 10_W 11_W 12_W 13_W 14_W 15_W 16_W Current Quantity 313 $ 1,830 $ 1,564 $ $ 7,247 $ 14,764 $ 14,435 $ 18,521 $ 19,427 $ 20,025 $ 18,966 $ 19,276 $ 17,485 $ 17,983 $ 15,619 $ 6,231 $ Current Profit 2,817 $ 18,979 $ 19,162 $ 11,628 $ 120,295 $ 267,114 $ 291,648 $ 410,923 $ 469,016 $ 521,649 $ 536,736 $ 583,400 $ 568,061 $ 618,870 $ 563,343 $ 233,529 $ Current Revenue 24,101 $ 143,419 $ 125,514 $ 65,688 $ 613,091 $ 1,271,066 $ 1,273,228 $ 1,670,351 $ 1,790,052 $ 1,883,349 $ 1,826,424 $ 1,894,168 $ 1,757,041 $ 1,841,714 $ 1,625,435 $ 657,237 $ 90.19 $ 101.10 $ 93.00 Expected Profit for Bin $ 11 $ 166 $ 2,256 $ 7,200 $ 156,804 $ 355,280 $ 359,762 $ 462,885 $ 485,660 $ 521,649 $ 536,736 $ 583,400 $ 568,061 $ 618,870 $ 563,343 $ 233,529 Expected Revenue for Bin $ 42 $ 619 $ 8,393 $ 26,786 $ 583,309 $ 1,321,641 $ 1,338,313 $ 1,721,931 $ 1,806,654 $ 1,883,349 $ 1,826,424 $ 1,894,168 $ 1,757,041 $ 1,841,714 $ 1,625,435 $ 657,237 92.14 $ 93.00 $ $ $ 93.00 94.05 96.30 288 6,272 14,211 14,390 18,515 19,426 20,025 18,966 19,276 17,485 17,983 15,619 6,231 93.00 103.36 105.38 107.88 110.12 112.35 114.59 $ $ $ $ 98.27 93.00 1.00 93.00 1.00 100.49 102.41 104.07 105.48 $ $ $ 1.00 $ $ $ $ 116.66 118.37 93.00 93.00 93.00 1.00 1.00 $ All Regions 79.66 New Floor Price Cost per Unit $ $ 68.00 $ Expected Profit Expected Quantity Expected Revenue 11,963,341 560,765 50,095,343 $ Price Floor Price Bin 1 Probability 0.82 79.66 $ 2 Avg WTP 81.16 83.94 86.29 88.53 0.99 3 79.66 79.66 79.66 79.66 1.00 1.00 4 5 91.43 93.75 1.00 1.00 6 79.66 7 96.09 1.00 Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $93.00-$94.99 $95.00-$ 96.99 $ 97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Current Quantity 31,043 $ 34,600 $ 44,124 $ 46,016 $ 45,609 $ 55,559 $ 52,065 $ 53,052 $ 31,270 $ 34,038 $ 30,031 $ 37,097 $ 27,625 $ 20,145 $ 18,405 $ 6,231 $ Current Profit 243,105 $ 355,238 $ 537,527 $ 651,231 $ 740,665 $ 1,006,582 $ 1,052,131 $ 1,171,666 $ 756,548 $ 889,994 $ 849,575 $ 1,125,320 $ 896,323 $ 693,353 $ 665,069 $ 233,529 $ 8 Current Revenue 2,354,029 $ 2,708,038 $ 3,537,959 $ 3,780,319 $ 3,842,077 $ 4,784,594 $ 4,592,551 $ 4,779,202 $ 2,882,908 $ 3,204,578 $ 2,891,683 $ 3,647,916 $ 2,774,823 $ 2,063,213 $ 1,916,609 $ 657,237 $ Avg Unit Price 75.83 $ 78.27 $ 80.18 $ 82.15 $ 84.24 $ 86.12 $ 88.21 $ 90.09 $ 92.19 $ 94.15 $ 96.29 $ 98.33 $ 100.45 $ 102.42 $ 104.14 $ 105.48 $ 79.66 79.66 $ $ $ $ $ $ $ $ $ $ $ $ 1.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Expected Profit for Bin 295,856 397,971 537,527 651,231 740,665 1,006,582 1,052,131 1,171,666 756,548 889,994 849,575 1,125,320 896,323 693,353 665,069 233,529 Expected Quantity for Bin Expected Revenue for Bin 25,371 $ 2,021,055 34,127 $ 2,718,618 44,124 $ 3,537,959 46,016 $ 3,780,319 45,609 $ 3,842,077 55,559 $ 4,784,594 52,065 $ 4,592,551 53,052 $ 4,779,202 31,270 $ 2,882,908 34,038 $ 3,204,578 30,031 $ 2,891,683 37,097 $ 3,647,916 27,625 $ 2,774,823 20,145 $ 2,063,213 18,405 $ 1,916,609 6,231 $ 657,237 9 1.00 1.00 10 98.39 102.48 104.46 106.87 108.91 111.09 114.13 115.99 118.37 11 1.00 12 1.00 79.66 79.66 79.66 79.66 79.66 79.66 79.66 79.66 13 1.00 1.00 14 15 1.00 1.00 $ $ $ 16 South Region 85.00 New Floor Price Cost per Unit $ $ 68.00 $ Expected Profit Expected Quantity Expected Revenue 3,864,304 196,311 17,213,436 $ Price Floor Probability 0.02 85.00 $ Avg WTP 81.11 83.75 85.76 87.80 85.00 0.22 0.68 29993 $ $ $ $ 85.00 85.00 85.00 85.00 0.94 90.10 92.12 94.34 0.99 1.00 Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$88.99 $89.00-$ 90.99 $91.00-$ 92.99 $ 93.00-$94.99 $95.00-$ 96.99 $97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Price Bin 1_s 2_s 3_S 4_S 5_S 6_S 7_S 8_S 9_S 10_S 11_s 12_S 13_S 14_5 15_S 16_S Current Quantity 30,730 $ 32,770 $ 36,178 $ 34,275 $ 27,633 $ 29,893 $ 28,014 $ 25,031 $ 1,935 $ 3,237 $ 3,353 $ 4,187 $ 4,381 $ 1,729 $ 2,214 $ $ Current Profit 240,288 $ 336,259 $ 440,043 $ 484,753 $ 447,306 $ 540,804 $ 565,091 $ 549,423 $ 47,777 $ 86,407 $ 95,128 $ 127,641 $ 141,774 $ 59,683 $ 80,852 $ $ Current Revenue Avg Unit Price 2,329,928 $ 75.82 $ 2,564,619 $ 78.26 $ 2,900,147 $ 80.16 $ 2,815,453 $ 82.14 $ 2,326,350 $ 84.19 $ 2,573,528 $ 86.09 $ 2,470,043 $ 88.17 $ 2,251,531 $ 89.95 $ 179,357 $ 92.69 $ 306,523 $ 94.69 $ 323,132 $ 96.37 $ 412,357 $ 98.49 $ 439,682 $ 100.36 $ 177,255 $ 102.52 $ 231,404 $ 104.52 $ NA NA 85.00 85.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1.00 1.00 1.00 96.10 Expected Profit for Bin 10,420 123,878 419,312 549,199 466,916 540,804 565,091 549,423 47,777 86,407 95,128 127,641 141,774 59,683 80,852 Expected Quantity for Bin Expected Revenue for Bin 613 $ 52,099 7,287 $ 619,392 24,665 $ 2,096,558 32,306 $ 2,745,993 27,466 $ 2,334,582 29,893 $ 2,573,528 28,014 $ 2,470,043 25,031 $ 2,251,531 1,935 $ 179,357 3,237 $ 306,523 3,353 $ 323,132 4,187 $ 412,357 4,381 $ 439,682 1,729 $ 177,255 2,214 $ 231,404 $ 85.00 85.00 99.12 101.16 103.17 105.38 107.24 109.90 85.00 85.00 1.00 1.00 1.00 1.00 1.00 85.00 $ $ $ $ $ $ $ 85.00 111.66 1.00 85.00 85.00 NA North Region New Floor Price Cost per Unit $ $ 85.00 68.00 $ Expected Profit Expected Quantity Expected Revenue 2,453,541 106,595 9,702,034 $ Avg WTP Expected Profit for Bin Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $ 93.00-$94.99 $95.00-$ 96.99 $97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Price Bin 1_N 2_N 3_N 4_N 5_N 6_N 7_N 8_N 9_N 10_N 11_N 12_N 13_N 14_N 15_N 16_N Current Quantity $ $ 6,382 $ 10,946 $ 10,729 $ 10,902 $ 9,616 $ 9,500 $ 9,908 $ 10,776 $ 7,712 $ 13,634 $ 5,759 $ 433 $ 572 $ $ Current Profit $ $ 78,322 $ 154,849 $ 173,064 $ 198,665 $ 195,392 $ 211,321 $ 239,755 $ 281,937 $ 217,711 $ 414,279 $ 186,489 $ 14,800 $ 20,874 $ $ Current Revenue NA NA 512,298 $ 899,177 $ 902,636 $ 940,001 $ 849,280 $ 857,321 $ 913,499 $ 1,014,705 $ 742,127 $ 1,341,391 $ 578,101 $ 44,244 $ 59,770 $ NA Avg Unit Price NA NA 80.27 $ 82.15 $ 84.13 $ 86.22 $ 88.32 $ 90.24 $ 92.20 $ 94.16 $ 96.23 $ 98.39 $ 100.38 $ 102.18 $ 104.49 $ NA 88.31 90.54 92.53 94.86 97.16 99.14 101.39 103.74 106.01 108.27 110.21 112.06 114.37 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Price Floor 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 85.00 Probability NA NA 0.96 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NA $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 104,668 185,356 182,295 198,665 195,392 211,321 239,755 281,937 217,711 414,279 186,489 14,800 20,874 Expected Quantity for Bin Expected Revenue for Bin $ $ 6,157 $ 523,340 10,903 $ 926,780 10,723 $ 911,475 10,902 $ 940,001 9,616 $ 849,280 9,500 $ 857,321 9,908 $ 913,499 10,776 $ 1,014,705 7,712 $ 742,127 13,634 $ 1,341,391 5,759 $ 578,101 433 $ 44,244 572 $ 59,770 $ West Region $ New Floor Price Cost per Unit 93.00 68.00 $ $ Expected Profit Expected Quantity Expected Revenue 5,455,612 188,786 18,293,056 $ Avg WTP Price Floor Avg Unit Price 77.00 Expected Quantity for Bin 0 86.46 93.00 78.37 87.39 93.00 7 $ $ $ $ 80.25 90.21 93.00 90 795 $ $ $ $ $ $ $ 93.00 92.43 94.86 82.63 84.60 86.09 88.20 93.00 96.25 $ $ $ $ 93.00 93.00 u Price Range $ 75.00-$ 76.99 $ 77.00-$ 78.99 $ 79.00-$ 80.99 $ 81.00-$ 82.99 $ 83.00-$ 84.99 $ 85.00-$ 86.99 $ 87.00-$ 88.99 $ 89.00-$ 90.99 $ 91.00-$ 92.99 $ 93.00-$ 94.99 $ 95.00-$ 96.99 $ 97.00-$ 98.99 $ 99.00-$ 100.99 $ 101.00-$ 102.99 $ 103.00-$ 104.99 $ 105.00-$ 106.99 Probability 0.00 0.00 0.06 0.36 0.87 0.96 1.00 1.00 1.00 1.00 1.00 98.78 Price Bin 1_W 2_W 3_W 4_W 5_W 6_W 7_W 8_W 9 W 10_W 11_W 12_W 13_W 14_W 15_W 16_W Current Quantity 313 $ 1,830 $ 1,564 $ $ 7,247 $ 14,764 $ 14,435 $ 18,521 $ 19,427 $ 20,025 $ 18,966 $ 19,276 $ 17,485 $ 17,983 $ 15,619 $ 6,231 $ Current Profit 2,817 $ 18,979 $ 19,162 $ 11,628 $ 120,295 $ 267,114 $ 291,648 $ 410,923 $ 469,016 $ 521,649 $ 536,736 $ 583,400 $ 568,061 $ 618,870 $ 563,343 $ 233,529 $ Current Revenue 24,101 $ 143,419 $ 125,514 $ 65,688 $ 613,091 $ 1,271,066 $ 1,273,228 $ 1,670,351 $ 1,790,052 $ 1,883,349 $ 1,826,424 $ 1,894,168 $ 1,757,041 $ 1,841,714 $ 1,625,435 $ 657,237 $ 90.19 $ 101.10 $ 93.00 Expected Profit for Bin $ 11 $ 166 $ 2,256 $ 7,200 $ 156,804 $ 355,280 $ 359,762 $ 462,885 $ 485,660 $ 521,649 $ 536,736 $ 583,400 $ 568,061 $ 618,870 $ 563,343 $ 233,529 Expected Revenue for Bin $ 42 $ 619 $ 8,393 $ 26,786 $ 583,309 $ 1,321,641 $ 1,338,313 $ 1,721,931 $ 1,806,654 $ 1,883,349 $ 1,826,424 $ 1,894,168 $ 1,757,041 $ 1,841,714 $ 1,625,435 $ 657,237 92.14 $ 93.00 $ $ $ 93.00 94.05 96.30 288 6,272 14,211 14,390 18,515 19,426 20,025 18,966 19,276 17,485 17,983 15,619 6,231 93.00 103.36 105.38 107.88 110.12 112.35 114.59 $ $ $ $ 98.27 93.00 1.00 93.00 1.00 100.49 102.41 104.07 105.48 $ $ $ 1.00 $ $ $ $ 116.66 118.37 93.00 93.00 93.00 1.00 1.00 $