A upp 1 Supp Supplier3 0.2 0.2 0.6 % small % medium 0.4 0.35 9 %large 10 Cost/value 0.2 75 Origirnal requirernents 12 13 Small 1 Medium 1 Large 16 % change in requirement USe Sglver o 15 19Valvs purchased Supplicr 1 Supplicr 2Supplicr 3 21 vailable with suplir 2400 1000 l. Actual required in cell temge E25 10E27 triusl be-Original requirernetts 14% change in 2. Use cell C16 as the input cell in Solver Table. urement) 21 Sizes in the lots purchased wailable ctua Small 27 28 2 Total cost 30 31 Explanation when % chan Large Answer key Cell C29-16500 in requirement is at least 36% Replace ?? with appropriate text and then use lustily carntriand t illout the box properly with the tex small % medium % large Cost/valve Supplier 1 Supplie Supplier 3 0.2 0.2 0.6 0.4 0,4 0.2 75 0.3 0.35 0.35 Original requirements Small Medium Large % change in requirement e Solver Supplier 1 Suppier Supplier 3 Valves purchased Available with supplier 2400 1000 Hint: I. Actual required in cell range E25 toE27 must be-Original requirements x (1+% change in requirement) 2. Use cell C16 as the input cell in Solver Table. Actual required Sizes in the lots purchased Small Available Large Answer key Cell C29 16500 Total cost Explanation when % change in requirement is at least 36% Replace ? With appropriate text and then use Justify command to fill out the box properly with the text. A upp 1 Supp Supplier3 0.2 0.2 0.6 % small % medium 0.4 0.35 9 %large 10 Cost/value 0.2 75 Origirnal requirernents 12 13 Small 1 Medium 1 Large 16 % change in requirement USe Sglver o 15 19Valvs purchased Supplicr 1 Supplicr 2Supplicr 3 21 vailable with suplir 2400 1000 l. Actual required in cell temge E25 10E27 triusl be-Original requirernetts 14% change in 2. Use cell C16 as the input cell in Solver Table. urement) 21 Sizes in the lots purchased wailable ctua Small 27 28 2 Total cost 30 31 Explanation when % chan Large Answer key Cell C29-16500 in requirement is at least 36% Replace ?? with appropriate text and then use lustily carntriand t illout the box properly with the tex small % medium % large Cost/valve Supplier 1 Supplie Supplier 3 0.2 0.2 0.6 0.4 0,4 0.2 75 0.3 0.35 0.35 Original requirements Small Medium Large % change in requirement e Solver Supplier 1 Suppier Supplier 3 Valves purchased Available with supplier 2400 1000 Hint: I. Actual required in cell range E25 toE27 must be-Original requirements x (1+% change in requirement) 2. Use cell C16 as the input cell in Solver Table. Actual required Sizes in the lots purchased Small Available Large Answer key Cell C29 16500 Total cost Explanation when % change in requirement is at least 36% Replace ? With appropriate text and then use Justify command to fill out the box properly with the text
