Formulate the appropriate linear program

Assignment Help Basic Statistics

Reference no: EM1389737

A cruise line is planning its menu for the next trip. Vacationers like eating steak, lobster, and chicken. The cruise line has decided to plan for at least half of all booked passengers to have a steak dinner, for at least a quarter of all passengers to have lobster, and the rest to have chicken. Steak dinners cost the company $8, lobsters cost $15, and chicken costs the line $4. On the next cruise, there are 400 passengers booked. In addition, the cruise line has decided to plan for an additional 25% more meals than bookings. Formulate the appropriate linear program and solve using Excel Solver. Show your Work in Excel.

Reference no: EM1389737

Questions Cloud

Confidence interval and true mean : A food snack manufacturer samples 13 bags of pretzels off the assembly line and weighs their contents. If the sample mean is 14.7 oz. and the sample standard deviation is 0.50 oz., find the 95% confidence interval of the true mean.

Construct a control chart for test errors : Construct a control chart for test errors and set the control limits to contain 99.73% of the random variations in test scores. What does the chart tell you? Has the new math program been effective?

People receiving and waiting to receive information : A new shopping mall is considering setting up an information desk manned by one employee. Based upon information obtained from similar information desks, it is believed that people will arrive at the desk at the rate of 15 per hour.

Determine expected frequencies of individual progeny : Estimate expected frequencies of each individual progeny possibility based on the 1.5 M.U. distance. Do this through showing a punnet square for frequencies.

Formulate the appropriate linear program : In addition, the cruise line has decided to plan for an additional 25% more meals than bookings. Formulate the appropriate linear program and solve using Excel Solver. Show your Work in Excel.

Mild phenotypic consequence : Determine which of the following mutations is more likely to produce a severe rather than mild phenotypic consequence

Evidence of a linear relationship : a) Draw the scatter diagram. Does it appear that x and y are related? If so, how? b) Test to determine whether there is evidence of a linear relationship.

Sequence of a genome : Determine which of the below are types of analyses that can occur once an entire sequence of a genome is known?

Explain whether and how this adversely affected the magazine : While the ReadyMade magazine was still in the design stages, very little research was done to determine whether an interested market existed.Explain whether and how this adversely affected the magazine as it moved forward to publication.

User Account

All Pages