Create a textbox withineach problem to write your LP model. Students are permitted to work in groups but eachstudent must complete their own unique spreadsheet model. Submitting identicalexcel files will result in a zero on the assignment$\mathrm{.}1.$The Electrotech Corporation manufactures two industrial$-$sized electricaldevices: generators and alternators. Both of these products require wiring andtesting during the assembly process. Each generator requires $2$ hours of wiringand $1$ hour of testing and can be sold for a $$250$ profit. Each alternator requires $3$hours of wiring and $2$ hours of testing and can be sold for a $$150$ profit. There are$260$ hours of wiring time and $140$ hours of testing time available in the nextproduction period and Electrotech wants to maximize profit. At least $20$Generators and Alternators must be produced.$$ Formulate an LP model for this problem.$$ Create a spreadsheet model for this problem and solve it using Solver.$$ What is the optimal solution?$2.$ Sanderson Manufacturing produces ornate, decorative wood frame doors andwindows. Each item produced goes through three manufacturing processes: cutting, sanding, and finishing. Each door produced requires $1$ hour in cutting, $30$minutes in sanding, and $30$ minutes in finishing. Each window requires $30$minutes in cutting, $45$ minutes in sanding, and $1$ hour in finishing. In the comingweek Sanderson has $40$ hours of cutting capacity available, $40$ hours of sandingcapacity, and $60$ hours of finishing capacity. Assume all doors produced can besold for a profit of $$500$ and all windows can be sold for a profit of $$400.$ Formulate an LP model for this problem.$$ Create a spreadsheet model for this problem and solve it using Solver.$$ What is the optimal solution?