Each variable and solution must be clearly indicated on the excel worksheet, do not just solve the question, clearly define each variable and comment on the objective function and sensitivity analysis (explain each resulting sensitivity analysis page). Sensitivity analysis pages without your comments will not be graded.

5. A hardware store packages handyman bags of screws, bolts, nuts, and washers. Screws come in 100-lb boxes and cost $110 each, bolts come in 100-lb boxes and cost $150 each, nuts come in 80-lb boxes and cost $70 each, and washers come in 30 -lb boxes and cost $20 each. The handyman package weighs at least lib and must include, by weight, at least 10% screws and 25% bolts, and at most 15% nuts and 10% washers. To balance the package, the number of bolts cannot exceed the number of nuts or the number of washers. A bolt weighs 10 times as much as a nut and 50 times as much as a washer. Determine the optimal mix of the package