Hello, I need a full and detailed solution to the following questions including the excel solver if needed to produce the solution:

Book: Applied Management Science, Second Edition

Author: Lawrence and Pasternack

Publisher: Wiley

Chapter: 5Project Scheduling Models

Question: Case Study 1: Saratoga Mountatin National Park

and

Chapter: 3 Application of Linear Programming and Integer Programming Models

Question: 8 Production: Pacific Aerospace

I need a detailed solution by return showing a full explanation of the answer.

Thank you

Kate