PLEASE SOLVE USING EXCEL

Must be solved using Excel

Widgetce produces widgets by combining processed elements A and B. At most 15,000 widgets can be sold for $20 per widget. Machine 1 processes 5 pounds of A and 6 pounds of B per hour. Machine 1 costs $40,000 per year to rent and costs $2.50 per hour to operate. Unlimited amounts of unprocessed A and B can be purchased at a cost of $2 per pound for A and S3 per pound of B. Processed A and B can be turned into widgets by using either machine 2 or machine 3. Each machine 2 costs $30,000 per year to rent and $3.50 to operate. Each minute that machine 2 is operated, it uses 2 pounds of processed A and 1.5 pounds of processed B to produce a widget Each machine 3 costs $25,000 per year to rent and $2.20 per hour to operate. Every 1.5 minutes that machine 3 is operated, it uses 1.5 pounds of processed A and 1.4 pounds of processed B to produce a widget. Widgets cannot be stored, so each week the company will produce the same number of widgets and operate machines for the same number of hours. Also any processed A and B coming out of machine 1 that is not used to produce widgets must be disposed of at a cost of $0.35 per pound. Each machine can be operated up to 40 hours per week. Machines must be rented for the whole year and widgets are sold by the pound, so a fractional number of widgets can be produced each week. The number of machines of each type must be an integer. How can Widgetcamaximize its weekly (or annual profit)? Widgetce produces widgets by combining processed elements A and B. At most 15,000 widgets can be sold for $20 per widget. Machine 1 processes 5 pounds of A and 6 pounds of B per hour. Machine 1 costs $40,000 per year to rent and costs $2.50 per hour to operate. Unlimited amounts of unprocessed A and B can be purchased at a cost of $2 per pound for A and S3 per pound of B. Processed A and B can be turned into widgets by using either machine 2 or machine 3. Each machine 2 costs $30,000 per year to rent and $3.50 to operate. Each minute that machine 2 is operated, it uses 2 pounds of processed A and 1.5 pounds of processed B to produce a widget Each machine 3 costs $25,000 per year to rent and $2.20 per hour to operate. Every 1.5 minutes that machine 3 is operated, it uses 1.5 pounds of processed A and 1.4 pounds of processed B to produce a widget. Widgets cannot be stored, so each week the company will produce the same number of widgets and operate machines for the same number of hours. Also any processed A and B coming out of machine 1 that is not used to produce widgets must be disposed of at a cost of $0.35 per pound. Each machine can be operated up to 40 hours per week. Machines must be rented for the whole year and widgets are sold by the pound, so a fractional number of widgets can be produced each week. The number of machines of each type must be an integer. How can Widgetcamaximize its weekly (or annual profit)