ABC Manufacturing produces machine tools. their lead planner oversees production two machines and needs to determine how many of each to produce this month. The two machines are the toolmate and benchmate. these two machines usr a rubber grommet as one of the raw materials. Toolmate needs 10 of these groomets and benchmate uses 7 of this groomer.

objective: determine the number of toolmate and benchmate machines in order to maximize profit

final part of the question: The sales department requires that the manufacturing department must produce at least five products in total per month. The profit for the Toolmate is 50,000 and 34,000 for the benchmate.

Objective: determine the number of toolmate and benchmate machines to build in order to maximize profit

please set this up in an excel spreadsheet with the parameters and model.