PART 1: Question: Case Haller's Pub amp; Brewery Jeremy Haller of Haller's Pub amp; Brewery has compiled data describing the amount of different...

Please see the attached, this is what we have done so far. We need to answer all the attached questions. Also, we want to insure we are on the correct track and need help in creating the excel spreadsheets for this data along with developing the linear optimization model to maximize profit. Our goal is to create a report of our findings, so we will be using this information to develop a presentation. The final report needs to be written in a language in which a regular person who is not an expert on linear optimization would understand (basically written in simple business terms).