Question

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.

Answer 1

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