1. Tom's Inc. makes two salsa products: Western Foods salsa and Mexico City salsa. Essentially, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Tom's Inc. makes two salsa products: Western Foods salsa and Mexico City salsa. Essentially, the two products have different blends of whole tomatoes, tomato sauce, and tomato paste. A jar of Western Foods salsa uses 5 ounces of whole tomatoes, 3 ounces of tomato sauce, and 2 ounces of tomato paste. A jar of Mexico City salsa consists of 7 ounces of whole tomatoes, 1 ounce of tomato sauce, and 2 ounces of tomato paste. For the current production period Tom's Inc. can purchase up to 4480 ounces of whole tomatoes, 2080 ounces of tomato sauce, and 1600 ounces of tomato paste. Tom's Inc. makes a profit of $1.00 per jar of Western Foods salsa and $1.25 per jar of Mexico City salsa. The following linear optimization model was used to determine the mix of salsa products that will maximize the total profit contribution. Let W be the number of jars of Western Foods Salsa be the number of jars of Mexico City Salsa M Maximize Subject to 1W + 1.25M 5W + 7M ≤ 4480 3W + 1M 2080 2W + 2M ≤ 1600 W,M ≥ 0 (Whole tomatoes) (Tomato sauce) (Tomato paste) The problem was solved in Excel and the sensitivity report is shown below. Answer the following questions based on the sensitivity report. (If a question can't be answered using the sensitivity report say so. You don't need to change the model and solve it.) Adjustable Cells Cell Name $C$17 Western Foods Salsa $D$17 Mexico City Salsa Constraints Cell Name $K$10 Whole Tomatoes $K$11 Tomato Sauce $K$12 Tomato Paste Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 560 0.000 240 0.000 4480 1920 1600 1.00 1.25 0.125 0.000 0.187 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 0.107 0.25 4480 2080 1600 0.25 0.15 1120 1E+30 40 160 160 320 a) How many jars of Western Foods Salsa should Tom's produce? b) How many jars of Mexico City Salsa should Tom's produce? c) What is the profit of the optimal solution? d) Which constraints are non-binding? e) What would be the value of 30 more ounces of tomato paste? f) How much less profit would Tom's make if they had 100 fewer ounces of tomato sauce? g) How would Tom's profit change if they had 500 more ounces of tomato sauce? h) How would Tom's profit change if they had 170 more ounces of whole tomatoes? 1. Tom's Inc. makes two salsa products: Western Foods salsa and Mexico City salsa. Essentially, the two products have different blends of whole tomatoes, tomato sauce, and tomato paste. A jar of Western Foods salsa uses 5 ounces of whole tomatoes, 3 ounces of tomato sauce, and 2 ounces of tomato paste. A jar of Mexico City salsa consists of 7 ounces of whole tomatoes, 1 ounce of tomato sauce, and 2 ounces of tomato paste. For the current production period Tom's Inc. can purchase up to 4480 ounces of whole tomatoes, 2080 ounces of tomato sauce, and 1600 ounces of tomato paste. Tom's Inc. makes a profit of $1.00 per jar of Western Foods salsa and $1.25 per jar of Mexico City salsa. The following linear optimization model was used to determine the mix of salsa products that will maximize the total profit contribution. Let W be the number of jars of Western Foods Salsa be the number of jars of Mexico City Salsa M Maximize Subject to 1W + 1.25M 5W + 7M ≤ 4480 3W + 1M 2080 2W + 2M ≤ 1600 W,M ≥ 0 (Whole tomatoes) (Tomato sauce) (Tomato paste) The problem was solved in Excel and the sensitivity report is shown below. Answer the following questions based on the sensitivity report. (If a question can't be answered using the sensitivity report say so. You don't need to change the model and solve it.) Adjustable Cells Cell Name $C$17 Western Foods Salsa $D$17 Mexico City Salsa Constraints Cell Name $K$10 Whole Tomatoes $K$11 Tomato Sauce $K$12 Tomato Paste Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 560 0.000 240 0.000 4480 1920 1600 1.00 1.25 0.125 0.000 0.187 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 0.107 0.25 4480 2080 1600 0.25 0.15 1120 1E+30 40 160 160 320 a) How many jars of Western Foods Salsa should Tom's produce? b) How many jars of Mexico City Salsa should Tom's produce? c) What is the profit of the optimal solution? d) Which constraints are non-binding? e) What would be the value of 30 more ounces of tomato paste? f) How much less profit would Tom's make if they had 100 fewer ounces of tomato sauce? g) How would Tom's profit change if they had 500 more ounces of tomato sauce? h) How would Tom's profit change if they had 170 more ounces of whole tomatoes?
Expert Answer:
Answer rating: 100% (QA)
a Toms need to produce 560 jars of Western Foods Salsa This has been reflected in the Final Value co... View the full answer
Related Book For
International Economics Theory and Policy
ISBN: 978-0273754206
9th Edition
Authors: Paul R. Krugman, Maurice Obstfeld, Marc J. Melitz
Posted Date:
Students also viewed these mathematics questions
-
Suppose our drug company can purchase up to 500 hours of labor at $1 more per hour than its current labor costs. Calculate the new maximum profit. Change cell: Pounds to be made 0 0 0 596.6667 1084 0...
-
A food company produces tomato sauce at five different plants. The tomato sauce is then shipped to one of three warehouses, where it is stored until it is shipped to one of the companys four...
-
Let X be a linear space. Two affine subsets S and T are parallel if one is a translate of the other, that is, S = T + x for some x X Show that the relation S is parallel to T is an equivalence...
-
More sophisticated computer-assisted instruction systems monitor the students performance over a period of time. The decision to begin a new topic is often based on the students success with previous...
-
A system undergoes a four-process cycle. Several quantities for the various processes are listed in the following table. Determine the missing entries. All quantities are in kJ. Su Process -200 01-2...
-
Consider flow from a water reservoir through a circular hole of diameter D at the side wall at a vertical distance H from the free surface. The flow rate through an actual hole with a sharp-edged...
-
Using an incremental internal rate of return (IRR) analysis, the decision to replace the "current best" by the "challenger"' is based on what decision rule? a. The internal rate of return of the...
-
Greg Davis, a business major at the University of South Carolina (USC), has opened Six Points Saco (SPS), a specialty subs-taco restaurant, at the rim of the USC campus. SPS has grown in popularity...
-
A summary of two stocks is shown. 52W high 52W low Name of Stock Symbol High Low Close 37.18 29.39 Zycodec ZYO 11.76 7.89 Unix Co UNX 39.06 32.73 34.95 16.12 12.11 15.78 Last year, a stockholder...
-
The eight members of the Model United Nations team from Pima Community College are lining up for a photo. a) How many different ways can the eight team members line up? b) What is the probability...
-
For what purposes are employers authorized to collect an employee s Social Insurance Number?
-
Why is learning about interviews important? Why is it important to you, specifically? -ur own words: Explain the difference between/importance of behavioural questions and hypothetica yourown...
-
Please explain why the below scenario would be a viable investment. A power plant management is considering an investment in increased efficiency of their plant, which costs $1.2 million and lasts...
-
INTERVIEW QUESTIONS: 1- 2- 3- 4- 5- contributions? When we worked together on Work/Project/Activity (be sure to state the specific event), what did you see as my key When we worked together, how did...
-
Assume that you are currently working in the accounting department as a senior accountant for a multinational firm offering investment advisory services. The chief financial officer, Mr. Steve...
-
Prompt: Read the "Discussion" section on the Tuskegee Syphilis Research Study on p. 25 and answer the questions within the section in a well-organized essay. Your last paragraph should summarize your...
-
4. A shaft with a length L = 2.0 m is subjected to torques T = 5.10 kNm at either end. (See Fig. Q4). Segment AB (L = 1.0 m) is made of brass (Gb = 41.3 GPa) and has a square cross section (a = 75...
-
Explain how the graph of each function can be obtained from the graph of y = 1/x or y = 1/x 2 . Then graph f and give the (a) Domain (b) Range. Determine the largest open intervals of the domain over...
-
In October 1979, the U.S. central bank (the Federal Reserve System) announced it would play a less active role in limiting fluctuations in dollar interest rates. After this new policy was put into...
-
Countries A and B have two factors of production, capital and labor, with which they produce two goods, X and Y. Technology is the same in the two countries. X is capital-intensive; A is...
-
Imagine that two identical countries have restricted imports to identical levels, but that one has done so using tariffs while the other has done so using quotas. After these policies are in place,...
-
Generalize the model considered in Example 4.11 to a marginal model for the longitudinal DOS data and compare the findings with that in Example4.11 Example 4.11 For the models in Example 4.8 DOS,...
-
For the DTS study, use subjects with all five assessments in HamD scores in the CAU group for this question. The intraclass correlation coefficient among the repeated measures in Ham-D scores can be...
-
In this question we develop a regression model to assess the treatment effect for stigma in the DTS study, controlling for demographics and baseline measurements. We will use the cumulative logit...
Study smarter with the SolutionInn App