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 |