Statistical Case Study The Possibility essay

Download this essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from essay:

The four possible points which could be the optimal solution are labeled from one to four. The solutions to these are then given in Table 1, along with the profits which would result from these combinations. The values of each of these points were calculated by solving the simultaneous equations where the lines crossed. It can be seen from Table 1 that the maximum profit would be reached by producing 20 beef dinners and 40 fish dinners each day.

Figure 1: Feasible region for the linear programming problem

Table 1: Resultant profits from each of the critical points


Value of X1

Value of X2

Resultant Profit

Now Excel may also be used to solve this problem. The solution which is given is shown in Figure 2. From this it may be confirmed that the optimal solution for the restaurant is to prepare 20 beef meals and 40 fish meals each night. The sensitivity report is also given for this model in Figure 3.

Figure 2: Computer Solution to the Linear Programming Problem

Figure 3: Sensitivity Output from the Excel Model

It is also possible that these solutions may be used to answer further questions related to the problems. For example, if the profit from the fish dinners was raised to be equal to the profit from the beef dinners this would then change the optimal solution to one in which any point on the line between points 3 and 4 would produce the same profit. The profit overall would also be increased subject to this increase in price not affecting the number of customers overall. Also, if it was determined that at least 20% of customers would want beef dinners, this also would not change the optimal meal preparation, as this would move one of the lines, would but not alter which of the points gave the optimal solution, where more than 20% are beef dinners anyway.

It is also possible to answer the problems presented in the second case study from the model presented. It would not be worth them paying for an advertisement to increase the total number of meals. This is because it may be seen from Figure 1 and Figure 2 that the labor constraint is binding at the present time. This means that they would not have the labor available to increase their meal output in a way which would create more profit.

Also, as the labor is a binding factor on the current optimal solution to the programming problem, this means that a decrease in labor would reduce the profit available. In fact, this would change the parameters of the optimal solution to 10 beef dinners and 40 fish dinners, with only $640 profit rather than $800. Finally, if the profit obtained from the fish meals was to be changed, then the actual solution to the problem would not change, all that would happen is that the profit would be raised to $880. Therefore, Pierre should have no problems with this!

Conclusions and Recommendations

It may be seen from the solutions presented above that the best strategy for the restaurant based on this would be to produce 20 beef dinners and 40 fish dinners at the present time. From the sensitivity analysis it would however seem that the number of dishes which was produced could be reduced by 2 without altering the optimal solution, so it would possibly benefit them under this model to instead produce only 58 meals. Then if there was a greater demand it would serve them well to re-assess the entire model. For example if they found that they had a greater demand for meals then they would in fact need to add to the labor hours before they would be able to increase their profitability.


Banker, R.D. & Morey, R.C. (1986). Efficiency analysis for exogenously fixed inputs and outputs. Operations Research, 34(4), 513-521.

Brusco, M.J. & Johns, T.R. (1998). Staffing a multiskilled workforce with varying levels of productivity: An analysis of cross-training policies. Decision Sciences, 29(2), 499-515.

Chase, R.B. & Apte, U.M. (2007). A history of research in service operations: What's the big idea? Journal of Operations Management, 25(2), 375-386.

Gattoufi, S., Oral, M. & Reisman, a. (2004). A taxonomy for data envelopment analysis. Socio-Economic Planning Sciences, 38(2-3), 141-158.

Gimenez-Garc'a, V.M., Mart'nez-Parra, J.L. & Buffa, F.P. (2007). Improving resource utilization in multi-unit…[continue]

Cite This Essay:

"Statistical Case Study The Possibility" (2008, August 06) Retrieved December 5, 2016, from

"Statistical Case Study The Possibility" 06 August 2008. Web.5 December. 2016. <>

"Statistical Case Study The Possibility", 06 August 2008, Accessed.5 December. 2016,

Other Documents Pertaining To This Topic

  • Case Study Tina s Story

    Tina's Story There is a considerable of variation in the occurrence of MDD among U.S. youth as reported by research studies on depression in adolescents. Fleming and Offord (1990) conducted a critical review and found that currently the occurrence depression ranges from .4-5.7%, with a mean occurrence of 3.6%. Similarly another study in which the sample were high school students (between the ages of 14-18 years), the results revealed that the

  • Broken Heart Syndrome Cardiovascular Case Study Broken

    Broken Heart Syndrome Cardiovascular Case Study Broken heart syndrome, otherwise called stress or Takotsubo cardiomyopathy (TTC), represents an adverse physiological response to an acute psychological or physical stressor (Derrick, 2009). The death of a loved one or experiencing a physically traumatic event, represent two examples of life stressors that can cause this reversible form of cardiomyopathy. Although effective treatment is available, the seriousness of the condition is such that it explains how

  • ADHD Case Study Our Focus

    There is however no cure. There is currently a lot of research dedicated to the development of more effective interventions as well as treatments for ADHD. These include the use of revolutionary tools such as brain scanners. The management and treatment of ADHD should be given a multidirectional approach. References Child Development Institute (2010). Suggested Classroom Interventions For Children With ADD & Learning Disabilities Collins, K (2008).Strategis/techniques for ADHD DSM-IV-TR workgroup (1994 ). The Diagnostic

  • Deploying a Pilot Case Study

    The more that your questions are descriptive or explanatory the more that the case study method will be relevant; How should I select the case to be studied?": According to Yin: "you need sufficient access to the potential data, whether involving people to be interviewed documents or records to be reviewed, or observations to be made in the 'field'. Given such access to more than a single candidate, you should

  • Mdd Tina s Case STUDY& 8230 Tina s Case Study

    MDD: Tina's Case Study…" Tina's Case Study MDD "MDD: Tina's Case Study.." Major Depressive Disorder: Tina's Story Tina's Story- Case Study Tina is a 23-year-old black female. She is currently separated from her husband of five years. She is currently employed by two companies, one at which she works Monday- Thursday mornings, and the other on Wednesday -- Friday evenings, and all day Saturday and Sunday. However, she hasn't shown up for work on

  • Idc Case Study This Report

    This ordering process was completely undocumented by the Interdrinks sales force because the customers would call a switch board to make their orders as opposed to calling the sales team. This process entailed that there was no control over the products the bottling company wanted or needed to move. The sales team was working on an outdated pay scale system and needed some type of incentive restructuring to help

  • Arborite Case Study the Need to Increase

    Arborite Case Study The need to increase profits and revenues has forced many establishments to evaluate and redefine the way they carry out strategies within the organization and the manner in which they deal with external factors affecting the company. The rationale being that an organization needs to constantly grow and evolve if it has to be competitive in a constantly changing market. Leaders and managers who head organizations should have

Read Full Essay
Copyright 2016 . All Rights Reserved