please provide excel solver

Problem 1 Goldilocks needs to find at least 12 lb of gold and at least 18 lb of silver to pay the monthly rent. There are two mines in which Goldilocks can find gold and silver. Each day that Goldilocks spends in mine 1, she finds 2 lb of gold and 2 lb of silver. Each day that Goldilocks spends in mine 2, she finds 1 lb of gold and 3 lb of silver. Formulate an LP to help Goldilocks meet her requirements while spending as little time as possible in the mines. Problem 2 A hospital employs volunteers to staff the reception desk between 8:00 am and 10:00 p.m. Each volunteer works three consecutive hours except for those starting at 8:00p.m who work for two hours only. The minimum need for volunteers is approximated by a step function over 2-hour intervals starting at 8:00a.m. as 8, 6, 8, 6, 4, 6, and 5. Because most volunteers are retired] individuals, they are willing to offer their services at any hour of the day (8:00 a.m. to 10:00 p.m.). However, because of the large number of charities competing for their service, the number needed must be kept as low as possible. Formulate this problem as an LP model. Problem 3 A hardware store packages handyman bags of screws, bolts, nuts, and washers. Screws come in 100-1b boxes and cost $120 each, bolts come in 100-1b boxes and cost $175 each, nuts come in 80-1b boxes and cost $75 each, and washers come in 30-16 boxes and cost $25 each. The handyman package weighs at least 1 lb 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. The goal is to minimize the cost. Formulate this problem as an LP model Note: Provide the LP formulation for the following problems and SOLVE the resulting models using Excel Solver. For this assignment, you are expected to submit 2 files: A Word document showing the LP formulations, and an Excel document showing the formulations of the problems using Excel Solver highlighting the optimal solutions. Problem 1 Goldilocks needs to find at least 12 lb of gold and at least 18 lb of silver to pay the monthly rent There are two mines in which Goldilocks can find gold and silver. Each day that Goldilocks spends in mine 1, she finds 2 lb of gold and 2 lb of silver. Each day that Goldilocks spends in mine 2, she finds 1 lb of gold and 3 lb of silver. Formulate an LP to help Goldilocks meet her requirements while spending as little time as possible in the mines. Problem 2 A hospital employs volunteers to staff the reception desk between 8:00 am and 10:00 pm Each volunteer works three consecutive hours except for those starting at 8:00 pm who work for two hours only. The minimum need for volunteers is approximated by a step function over 2 hour intervals starting at 8:00 am as 8. 6.8.6. 4.6, and 5. Because most volunteers are retired individuals, they are willing to offer their services at any hour of the day (8:00 am to 10:00 p.m.). However, because of the large number of charities competing for their service, the number needed must be kept as low as possible. Formulate this problem as an LP model Problem 3 A hardware store packages handyman bags of screws, bolts, nuts, and washers. Screws come in 100-16 boxes and cost $120 each, bolts come in 100-1b boxes and cost $175 each, nuts come in 80-16 boxes and cost $75 each, and washers come in 30-16 boxes and cost $2$ each. The duman nackage weighs at least 1 lb and must include, by weight, at least 10% screws and