URGENT PLEASE HELP ME

- Fomulate spreadsheet model of this problem on the next wrksheet tab named Problem 2 SS Model. Make sure to follow best practice formatting for the model

- Solve this model using Excel Solver and write the optimal solution and optimal objective function values below?

- Optimal Solution:

- Optiimal Objective function value:

No-name B-School is trying to decide how many of each type of computer to buy for its computer labs. The Appease (A) model can only be used for spreadsheets and costs $1400. The Basic (B) model can be used for spreadsheets and databases and costs $2000. The Capture (C) model can only be used for multimedia and costs $2500. Finally, the Doitall (D) model can do any task and costs $3500. Due to class cnrollments, the school must have at least 100 machines capable of doing spreadsheets, at least 50 machines capable of doing databases, and at least 30 machines capable of doing multimedia. The dealer the school is buying from has only 45 of model Appease (A) available. The school wishes to minimize their total purchase cost. They formulated their problem as a linear programming model. Let A-number of Appease model purchased B-number of Basic model purchased C-number of Caprure model purchased D-number of Doitall model purchased Minimize1400A+2000B+2500C+3500DSubjecttoA+B+D=100B+D>50C+D>30A=45A,B,C,D=0 A, B, C, D =0