Please provide BOTH questions detail answer to excel LP Solver. I would love to give a big LIKE LIKE LIKE

1. (worth 16 points) A vending machine is programmed to count out the correct change for each transaction. Formulate and solve an IP model that will determine how change is to be made for a purchase of $4.43, when a $10 bill is inserted into the machine. This means that the machine should deliver $5.57 to the purchaser (i.e. 10-4.43). The model's solution should be based on the availability of coins in the machine, with the objective of minimizing the total number of coins used to make change. IP formulation is optional. But clearly, you need it to plug numbers in Excel. 2. (worth 16 points) Hinkel Rotary Engine, Ltd., produces four-, six-, and eight-cylinder models of automobile engines. The firm's sale price for each four-cylinder engine sold during its quarterly production cycle is $1,800$50X1, where X1 is the number of fourcylinder engines sold. Hinkel's sales price is $2,400 - $70X2 for each of the six-cylinder engines sold, with X2 equal to the number of six-cylinder engines sold. The sales price associated with each eight-cylinder engine is $1,950 - $65X3, where X3 is equal to the number of eight-cylinder engines sold. There are 5,000 hours of production time available during each production cycle. A four-cylinder engine requires 100 hours of production time, a six-cylinder engine takes 130 hours, and an eight-cylinder model takes 140 hours to manufacture. Formulate this production problem for Hinkel and solve it by using Excel to maximize the total profit. NLP formulation is optional. But clearly, you need it to plug numbers in Excel. Hint: Set up the objective function in terms of profit by multiplying the number of engines by sales price for three engine types. The model also includes one constraint