Statistics - Linear and Integer Programming in Excel
Not what you're looking for?
Need help with the following problem. Need solution in excel.
RESTAURANT OPERATION. Jackson's Sports Bar and Grill would like to minimize the cost of installing television sets throughout the restaurant so that it can accommodate a potential viewership of at least 750 patrons. It is considering purchasing two models of Sony televisions. The large-screen 60-inch model costs $3500 and, with proper placement, could be viewed by 150 customers. The 27-inch models costs $800 each and can be seen by 35 customers. Jackson's wishes to have at least one 60-inch television and no more than 20 27-inch models.
a. Formulate the model for the problem faced by Jackson's
b. Solve for the optimal linear programming solution. Round the solution to integer values. What is the total cost of the rounded solution?
c. Solve for the optimal solution for the integer programming model. Did you get the rounded solution of part (b)? What is the total cost of the optimal integer solution?
Thank you
Purchase this Solution
Solution Summary
A Complete, Neat and Step-by-step Solution is provided in the attached file.
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.