AutoSave OFF A Module 4 HW problems part 1_revised Tell me Insert Draw Page Layout Formulas Data Review View x Calibri (Body) 11 A A a. A III General A BIU $ % ) Conditional Format Cell Formatting as Table Styles x x C D E G H 1 M N 0 Cave Low 18 PROBLEM (1 point) Scenario used Price Fixed cost Unit cost Quantity Value 2 2 2 2 500 Mid 5 400 1 100 High 18 500 16 110 16 110 25 600 18 120 a) Enter a formula that produces a random integer between 1 and 3 for the cases of Price and Unit Cost Just use case for Fixed cost and Quantity b) Press 19 6 times and after each time you press F9, record the profit observed to call E24, then E15, then E16, to cell E19 Variablecos Total cost Revenue Profit 1760 2260 1980 -280 Do any values in the range E14 E19 repeat? if this happent, what do you think is the reason it happene If this does not happen, what do you think is the reason it did not happen HW prob 4,1 HW prob 4.2 HW prob 4.3 HW prob 44 HW prob 4.5 HW prob 46 Challenge problem AutoSave OFF A Module 4 HW problems part 1_revised Tell me Insert Draw Page Layout Formulas Data Review View x Calibri (Body) 11 A A a. A III General A BIU $ % ) Conditional Format Cell Formatting as Table Styles x x C D E G H 1 M N 0 Cave Low 18 PROBLEM (1 point) Scenario used Price Fixed cost Unit cost Quantity Value 2 2 2 2 500 Mid 5 400 1 100 High 18 500 16 110 16 110 25 600 18 120 a) Enter a formula that produces a random integer between 1 and 3 for the cases of Price and Unit Cost Just use case for Fixed cost and Quantity b) Press 19 6 times and after each time you press F9, record the profit observed to call E24, then E15, then E16, to cell E19 Variablecos Total cost Revenue Profit 1760 2260 1980 -280 Do any values in the range E14 E19 repeat? if this happent, what do you think is the reason it happene If this does not happen, what do you think is the reason it did not happen HW prob 4,1 HW prob 4.2 HW prob 4.3 HW prob 44 HW prob 4.5 HW prob 46 Challenge