Essay on Stanford University and Study Data Analysis

Submitted By genious1233
Words: 628
Pages: 3
Open Document
Assignment # 3 Solutions
LP Case Study

Data Analysis:

Solution:

Incorrect Statements

Using the rating system, only 800,000 pounds of whole tomatoes can be used.
This is because the equation for canned whole tomatoes is
[pic]
It follows that, as A tomatoes can be 600,000 maximum, that solving for B (i.e. solving for x2 when x1 = 600,000) would equate it to 200,000 pounds. Therefore, total can only be 800,000 pounds of whole canned tomatoes used.

In this case, Myers has used a different allocation of costs that have already been paid. These should not influence the decision on product mix.

Model formation

Define: (these definitions were given to students)
Pounds of quality A in whole tomatoes[pic],
Pounds of quality B in whole tomatoes[pic],
Pounds of quality A in juice[pic],
Pounds of quality B in juice[pic],
Pounds of quality A in paste [pic],
Pounds of quality B in paste [pic]
Preliminary Calculations: Objective Coefficients: Canned: $1.48/case, 18 pounds/case [pic] Juice: $1.32/case, 20 pounds/case [pic] Paste: $1.85/case, 25 pounds/case = [pic]

Quality Requirements:

Whole: [pic], so therefore [pic] Juice: [pic], so therefore [pic]

Demand: to calculate, multiple forecast by pounds per case = 14,400,000

Maximize: [pic]

Constraints:
[pic]

Solution (student need to provide a managerial statement and do interpretation of the solution)

[pic]

|Produce |700000 | Pounds of whole tomatoes |
|Produce |300000 | Pounds of Juice |
|Produce |2000000 | Pounds of paste |

|Total Profit: |$225,340.00 |
|Cost of tomatoes: |$180,000.00 |
|Net Profit: |$45,340.00 |

[pic]

This the Excel solver sensitivity reports
[pic]
Zero (i.e. Red Brand Canner is willing to pay nothing for such a campaign).
Justification: Since Shadow price = 0 or since there is already slack in the demand for juice constraint

Shadow price on Grade B supply constraint is $0.0579 for up to an additional 466,666.67 pounds. Thus would be willing to pay 50,000*0.0579 = $2,895 for the entire 50,000 pounds.

The suggested change will increase the price of juice by $0.10/20 = 0.005. Although this is within the allowable increases on the
Show More

Related Documents: Essay on Stanford University and Study Data Analysis

Enriched Uranium and north Korea Essay

North Korea Learning to Make Crucial Nuclear Parts, Study Finds SEOUL, South Korea — North Korean scientists have learned to produce crucial components of gas centrifuges inside their isolated country, undermining years of export controls and sanctions intended to stop the country’s enrichment of uranium for nuclear weapons, according to an analysis by two American arms control experts made available on Monday. The analysis comes as experts have reported other signs that North Korea is activating…

Words 762 - Pages 4

Essay on Career Research Report

and Language Development Department San Jose State University Prepared by San Jose State University October 16, 2013 TABLE OF CONTENTS Introduction……………………………………….……………………………………………….3 The Ideal Company……………………………….……………………………………………….3 Company I: Cisco…………………………………………………………………………………4 Background……………………………….……………………………………………….4 Products and Services…………………….……………………………………………….4 HR Work Culture…………….……………………………………………………………4 SWOT Analysis…….……………………………………………………………………..5 Company II: Google……………

Words 3020 - Pages 13

Greek: Marketing and Case Study Components Essay

Johns Hopkins University Marketing Strategy Spring 2010 Syllabus COURSE TITLE: Marketing Strategy—660.350 LOCATION: 216 Hodson MEETING TIME: Tues./Thurs. 10:30-11:45 a.m. PROFESSOR: Leslie L. Kendrick Office: 104 Whitehead Office Phone: 410-516-4586 email: kendrick@jhu.edu OFFICE HOURS: Mon. /Wed., 2-3 p.m. REQUIRED TEXT: Cravens & Piercy, Strategic Marketing (ISBN: 978-0-07-338-100-8), 9th edition, 2009, McGraw-Hill. Online text available for purchase at: www.coursesmart.com…

Words 4266 - Pages 18

Quality of life three years after diagnosis of prostate cancer Essay

BMJ 2009; 339:b4817 doi: 10.1136/bmj.b4817 (Published 27 November 2009) Cite this as: BMJ 2009; 339:b4817 Research Quality of life three years after diagnosis of localised prostate cancer: population based cohort study 1. David P Smith, research coordinator1, 2. Madeleine T King, director of quality of life office2, 3. Sam Egger, statistician1, 4. Martin P Berry, director of cancer services3, 5. Phillip D Stricker, urologist4, 6. Paul Cozzi, urologist5, 7. Jeanette Ward, adjunct professor6…

Words 9200 - Pages 37

Essay Professional Development for Strategic Managers

preferred learning style. TASK2.1: In this task a skills audit of the employee is done through the SWOT approach. The strengths, weaknesses, opportunities for career progression and threats to progress are identified. SWOT analysis which is alternately called as SLOT analysis is a strategic planning[->0] method used to evaluate the Strengths, Weaknesses/Limitations, Opportunities, and Threats involved in a project[->1] or in a business[->2] venture. It involves specifying the objective of the business…

Words 1837 - Pages 8

Criminal Justice Literature Review

variables measured were alcohol, marijuana, cocaine, and cigarettes; the data came in the form of self-reported drug use surveys within the last 30 days. Data was taken from 1975 up until 1991. The data for drug use amongst college students reported using drugs within the past 30 days (as well as across every other age group) shows a steady decrease in reported drug use for all of the illicit drugs previously mentioned. The data shows that in the matter of high school seniors, drug use peaked in 1979…

Words 1536 - Pages 7

BoP Balance of power Essay

not almost entirely worthless. Underlying this entire argument stands the realization that the debate over this concept spans over hundreds of years, and that therefore this essay will harness a large variety of historical and modern sources in its analysis. This paper will be structured into three main sections. The first section will highlight the definitional jungle that underlies the phrase balance of power and show how this leads this concept as it stands alone it to be almost without meaning.…

Words 2492 - Pages 10

J Holist Nurs 2010 McDonald 92 8 Essay

article explores three key aspects selected from Nightingale’s more than 40 years of applied statistical work: her adaptation of Quetelet’s methodological foundations, the use of statistics in monitoring public health care systems, and her pioneering study of maternal mortality in childbirth. Keywords: statistics; health care; public health Nightingale’s passionate commitment to statistics was intimately related to her spirituality. God was a god of order, who created the world and let it run by law…

Words 4536 - Pages 19

Essay on particle theory

1126/science.1247566 Essays on Science and Society Science & SciLifeLab Prize From Persistence to Cross-Species Emergence of a Viral Zoonosis Authors Daniel G. Streicker Institute of Biodiversity, Animal Health, and Comparative Medicine, University of Glasgow, Glasgow, G12 8QQ, Scotland, UK. E-mail: daniel.streicker@glasgow.ac.uk Emerging infectious diseases threaten all forms of life on Earth. Many pathogens of great historical and contemporary significance have originated from other species…

Words 2028 - Pages 9

The Squam Lake Working Group On Financial Regulation

Baily Brookings Institution Frederic S. Mishkin Columbia University Andrew B. Bernard Dartmouth College Raghuram G. Rajan University of Chicago John Y. Campbell Harvard University David S. Scharfstein Harvard University John H. Cochrane University of Chicago Robert J. Shiller Yale University Douglas W. Diamond University of Chicago Hyun Song Shin Princeton University Darrell Duffie Stanford University Matthew J. Slaughter Dartmouth College Kenneth R. French…

Words 3447 - Pages 14