Hi I need help. I have attached an Excel sheet with the questions and the problems. Please show all work in excel.

Thank you!

Problem 7-14 Input the numbers in the beige cells Write formulas to compute values (e.g. profit, resoure utilization) in blue cells Solution AC Maximize WIRING TIME DRILLING TIME FAN Total 0 0 = 0 = 0 >= 0 >= RHS in blue cells 7-18 Question: The dean of the Western College of Business must pla necessary to offer at least 30 undergraduate and 20 graduate courses total. Each undergraduate course taught costs the college an average undergraduate and graduate courses should be taught in the fall so th ge of Business must plan the school's course offerings for the fall semester. Student demands make it nd 20 graduate courses in the term. Faculty contracts also dictate that at least 60 courses be offered in the college an average of $2,500 in faculty wages, and each graduate course costs $3,000. How many e taught in the fall so that total faculty salaries are kept to a minimum