The following is a linear programing problem solved in excel with \"solver. Can I get assistance on how to figure out the 5 interpretation questions? Do need the excel model to compare to mine, can you please show or give an explanation on how each question was derived. Thank you Scenario and Decision The Baltic Avenue Community Hospital has four wards which are imaginatively named Ward 1, Ward 2, Ward 3, and Ward 4. Each ward has patients admitted for the same general purpose though patient focus between the wards is different. Each ward generates different profit levels per patient per day and each ward has different staffing requirements. Each ward must be staffed by orderlies, certified nursing assistants (CNAs), and nurses. The table below summarizes profit and staffing requirements for the wards per patient per day. (Remember, staffing requires multiple shifts so staffing levels combine staffing from all shifts.) Profit Orderly CNA Nursing Ward 1 400 1.5 4.0 2.0 Ward 2 600 2.0 1.0 3.0 Ward 3 300 4.0 2.0 1.0 Ward 4 100 3.0 1.0 2.0 All figures are per patient per day The hospital has 120 hours of orderly time to schedule each day, 150 hours of CNA time, and 100 nursing hours. The hospital can allocate these hours to any ward. You must recommend patient admission levels for each ward. Solution Components You are to arrange all solution components except for the two output reports Excel generates on new tabs from top to bottom on a single Excel tab with labels at the top of each section to identify where the sections start. Mathematical Model of the Problem Convert the textual description of the model into a mathematical model. While Office products do include a pretty slick mathematical typesetting tool I do not want you to use it. Instead, just use ordinary text in the default font typed into the text box. You will submit your answer by using a text box drawn onto an Excel spreadsheet page. Your text box will start with a definition of decision variables used in your model and then will have the model itself. Excel has limited text formatting capabilities but you will use text representations as shown below. The table below illustrates the model used for the in-class demonstration next to a representation of the model created in the Excel text box tools the way I want you to do it. Notice that Interpretation 1. How many patients will be admitted to each ward. 2. How many hours of each type of labor should be allocated to each ward. 3. How much profit will be generated? 4. How much unused labor of each type is represented in the solution? 5. How much more profit could be generated if 10 additional hours of nurse staffing could be provided