Please show the work in Excel! We have been using the solver extension and data analysis extention in class

Dara Khoun is a senior at Tech and she's She estimates it will cost her $1.00 for each hot investigating different ways to finance her final dog and $2.50 for each barbecue sandwich if she year at school. She is considering leasing a food makes the barbecue herself the night before. She booth outside the Tech stadium home football measured a hot dog and found it takes up about games. Tech sells out every home game, and 16 in 2 of space, whereas a barbecue sandwich Dara knows from attending the games herself takes up about 20in2. She plans to sell pizza that everyone eats a lot of food. She has to pay for $3.00 per slice, hot dogs for $2.00 each, and $500 per game for a booth, and the booths are barbecue sandwiches for $3.50 each. She has not very large. Vendors can either sell food or $2,000 in cash available to purchase items for the drinks on Tech property, but not both. Only the first home game; for the remaining five games Tech athletic department concession stands can she will purchase her ingredients with money she sell both inside the stadium. She thinks slices of has made from the previous games. (Assume cheese pizza, hot dogs, and barbecue sandwiches that Dara can pay for the first game's booth rental are the most popular food items among fans, so after the game.) these are the items she would sell. Most food items are sold during the hour be- Dara has talked to some students and vendors fore the game starts and during half-time; thus, at Tech as well as at other universities. From it will not be possible for Dara to prepare the this she has discovered that she can expect to food while she is selling it. She must prepare the sell at least twice as many slices of pizza as hot food ahead of time and then store it in a warming dogs and barbecue sandwiches combined. She oven. For $1,000 she can lease a warming oven also anticipates that she will sell at least 50 perfor the six-game home season. The oven has 10 cent more hot dogs than barbecue sandwiches. shelves, and each shelf is 3 feet by 4 feet. She She believes that she will sell everything she can plans to fill the oven with the three food items stock and develop a customer base for the seabefore the game and then again before half-time. son if she follows these general guidelines for Dara has negotiated with a local pizza de- demand. livery company to deliver 16-inch cheese pizzas twice each game - two hours before the game If Dara clears at least $1,000 in profit for and right after the opening kickoff. Each pizza each game after paying all of her expenses she will cost her $15.00 and will include 8 slices. believes it will be worth leasing the booth. Assignment Prepare a brief report addressing the questions below. In addition to the "correctness" of your answers, your write-up will also be evaluated on how well you communicate the responses, including any assumptions that you need to make. You do not need to repeat background material in your write-up - assume that the reader is familiar with the basic facts of the case. The write-ups will be evaluated on their content and presentation, including logic, organization, grammar, and spelling. Case write-ups can be done in groups of one (1), two (2), or three (3) students. The maximum group size is three (3) students. You are responsible for determining who is in your group and how work is allocated. Please turn in one write-up per group, and list the names of all group members on the write-up. Write-ups usually range in length from two to three pages (not including supporting documentation, Excel worksheets, etc.). Case Questions 1. Formulate and solve a linear optimization model for Dara that will help you advise her if she should lease the booth. (Assume that Dara can pay for the first game's booth rental after the game.) [4.0pts] - Be sure to define the decision variables explicitly and to write out the objective function and constraints clearly. - Identify at least two key assumptions that you have made in order to formulate and solve this problem. - In addition to the mathematical expressions, provide a brief explanation of the formulation in words. 2. If Dara were to borrow some more money from a friend before the first home game to purchase more ingredients, could she increase her profit? If so, how much should she borrow and how much additional profit would she make? What factor constrains her from borrowing even more money than this amount (i.e., the amount indicated in your answer to the previous question)? [1.5 pts] 3. When Dara looked at the solution to Question 1 , she realized that it would be physically difficult for her to prepare all the hot dogs and barbecue sandwiches indicated in this solution. She believes she can hire a friend of hers to help her for $100 per game. Based on the results in Questions 1 and 2, is this something you think she could reasonably do and should do? [1.5 pts] 4. Dara seems to be basing her analysis on the assumption that everything will go as she plans. What are some of the uncertain factors in the model that could go wrong and adversely affect Dara's analysis? Given these uncertainties and the results in Questions 1, 2, and 3, what do you recommend that Dara do? [1.5 pts]