Answer:
Hello the required attached file is missing and attached to the answer is the file and the Excel solution to the problem
answer : The expected units sold is ; 65.9
Explanation:
ATTACHED IS THE SOLUTION OF THE PROBLEM USING EXCEL and also attached is the missing file
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