solution
You currently have 80 units of a product on the shelf. The demand for the product has been simulated as follows: Demand Data.xlsx Sales are made to the extent that you have units in stock (for example, if the demand is for 65 units, then 65 units are sold; however, if the demand is for 135 units, then only 80 units are sold). Using the demand data in the attached file, the expected units sold is [a]. Round your answer to a single decimal point. For example, if your answer is 51.456, then round it to 51.5.
Demand_Data.xlsx (Following values correspond with each of the 200 rows)
| 65.2109419609769 |
| 36.3814378436655 |
| 12.0877429656684 |
| 42.5590896559879 |
| 82.2785877465503 |
| 63.8527707854519 |
| 63.4004335955251 |
| 15.8457750733942 |
| 71.0140411177417 |
| 70.8838469511829 |
| 17.5017830263823 |
| 55.8463070268044 |
| 72.5535427994328 |
| 83.9481016958598 |
| 77.4359377322253 |
| 51.6086528880987 |
| 61.2436578597408 |
| 41.7028003942687 |
| 61.3092779024737 |
| 57.1605268708663 |
| 63.4424295133795 |
| 105.393077268964 |
| 42.3098881077021 |
| 72.9272996471264 |
| 73.4634922485566 |
| 92.1699337998871 |
| 73.9350879887934 |
| 62.634502632427 |
| 75.1440792958601 |
| 78.2438873505453 |
| 132.73330654949 |
| 56.5183781366795 |
| 83.8099039759254 |
| 85.089108273969 |
| 79.8164036899107 |
| 87.0501152751967 |
| 41.0291376686655 |
| 63.5085725155659 |
| 84.9410880112555 |
| 59.0508206590312 |
| 56.5433210288757 |
| 59.7236421020352 |
| 65.8728722049273 |
| 73.6344772524899 |
| 49.9832039570902 |
| 47.852667143452 |
| 92.3204551730305 |
| 74.595608515956 |
| 66.5629058351624 |
| 32.4733391101472 |
| 97.4920239462517 |
| 74.2992041926482 |
| 9.96752891689539 |
| 85.1971107698046 |
| 110.769009501673 |
| 69.4912286638282 |
| 118.182118916884 |
| 80.9065695141908 |
| 66.242581801198 |
| 74.6631839722977 |
| 94.2071109823883 |
| 89.928620531573 |
| 59.5205746724969 |
| 104.95497367112 |
| 63.1786987872329 |
| 113.474574340507 |
| 47.0437170809601 |
| 79.1452875494724 |
| 82.0594904728932 |
| 45.6039869680535 |
| 97.7821527561173 |
| 65.7133240968687 |
| 58.5785200604005 |
| 84.1517375595868 |
| 41.9052539148834 |
| 63.9809640636668 |
| 78.9487002696842 |
| 85.280966181308 |
| 61.2992052486516 |
| 49.7980308358092 |
| 67.0680619298946 |
| 49.0870788274333 |
| 60.8445261098677 |
| 68.4155920174089 |
| 91.2059148907429 |
| 54.3580098968232 |
| 44.4463366369018 |
| 66.7196345096454 |
| 59.9047907092609 |
| 41.6861111664912 |
| 40.0889020459726 |
| 58.9671926212031 |
| 56.350849212613 |
| 65.2880671116873 |
| 75.5627424444538 |
| 48.9305093145231 |
| 35.4057319276035 |
| 71.0829808161361 |
| 32.9006197210401 |
| 86.8856786331162 |
| 77.7846607382526 |
| 104.655840863707 |
| 106.356141208671 |
| 48.7940851092571 |
| 72.7866462914972 |
| 61.3815372565296 |
| 95.9817170444876 |
| 51.57595655357 |
| 87.819729691837 |
| 85.2932898345171 |
| 27.4374669464305 |
| 52.1301571500953 |
| 79.2558366304729 |
| 82.1587163448567 |
| 97.4762896879111 |
| 42.4961980973603 |
| 78.3406121120788 |
| 62.3225004749838 |
| 69.8783550836379 |
| 69.651913640264 |
| 68.1852624841849 |
| 63.8094333629124 |
| 72.8979229682591 |
| 71.9960907593486 |
| 78.7327634901158 |
| 77.8358425525948 |
| 59.3799213168677 |
| 102.537536753807 |
| 75.808078640257 |
| 47.8837263875175 |
| 65.2613052300876 |
| 66.4013113640249 |
| 61.8226876616245 |
| 79.575478543411 |
| 91.3108705793275 |
| 96.5802555077244 |
| 32.6323187840171 |
| 63.5827418084955 |
| 42.1373114880407 |
| 76.5624135459075 |
| 89.248909666203 |
| 76.6884695115732 |
| 79.5514678832842 |
| 77.5245679909131 |
| 69.5065309121856 |
| 109.253427530639 |
| 61.218396644399 |
| 84.3726992973825 |
| 79.2933305495535 |
| 77.684093361604 |
| 9.07986208796501 |
| 65.9900151225156 |
| 67.2133537085028 |
| 97.0921646006173 |
| 55.312570061069 |
| 74.2412921175128 |
| 78.6738964455435 |
| 58.1307985560852 |
| 70.8149299901561 |
| 50.1941612531664 |
| 102.560546969762 |
| 69.0012838679832 |
| 71.4907982404111 |
| 107.142126529943 |
| 88.3843440026976 |
| 68.1837390805595 |
| 60.2680883678841 |
| 86.1327989189886 |
| 80.9313987195492 |
| 48.4910414746264 |
| 43.4493030700833 |
| 72.7449459594209 |
| 70.5454921847559 |
| 55.8600403968012 |
| 92.95628291904 |
| 50.2714683028171 |
| 56.9870862312382 |
| 127.145371101797 |
| 69.4912286638282 |
| 118.879155656323 |
| 80.3445017884951 |
| 119.5754648 |
| 54.8273546376731 |
| 76.6189386416227 |
| 57.2600028538727 |
| 94.6262061409652 |
| 80.7842652141699 |
| 88.6095803655917 |
| 59.0686012804508 |
| 64.1408532322384 |
| 53.0245542398188 |
| 55.6273007026175 |
| 101.024046620587 |
| 46.6278051538393 |
| 105.879475035472 |
| 113.218460632488 |
| 77.5130628829356 |
| 93.539587346022 |
| 89.7584540728712 |
| 71.5537125364062 |
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

