Answer the following questions based on the following Sensitivity Report. Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Acres to Plant Watermelons 60 256 28.5 66.33333333 $C$19 Acres to Plant Cantaloupes 40 284.5 99.5 28.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SF$11 Water Used per hour) 6,000 1 6000 1500 1000 SF$19 Acres Planted per hour) 100 199 100 20 20 1. How much can the price of watermelons drop before it isn't optimal to plant any watermelons? (round to 2 decimal places) 2. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes? (round to 2 decimal places)

Answer the following questions based on the following Sensitivity Report. Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Acres to Plant Watermelons 60 256 28.5 66.33333333 $C$19 Acres to Plant Cantaloupes 40 284.5 99.5 28.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SF$11 Water Used per hour) 6,000 1 6000 1500 1000 SF$19 Acres Planted per hour) 100 199 100 20 20 1. How much can the price of watermelons drop before it isn't optimal to plant any watermelons? (round to 2 decimal places) 2. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes? (round to 2 decimal places)

Management, Loose-Leaf Version

13th Edition

ISBN:9781305969308

Author:Richard L. Daft

Publisher:Richard L. Daft

Chapter19: Managing Quality And Performance

Section: Chapter Questions

Problem 3CFCA: Cousins Jeri Lynn De Bose, Tish Hoover, and Josephine (Joey) Parks looked forward to meeting up...

See similar textbooks

Similar questions

You have been tapped by a newly elected President of the United States to formulate a “Year 1” strategic plan for his / her new administration. Discuss in-detail how you would prioritize all possible initiatives proposed by the 15 major Departments (only those who have an Presidentially appointed Secretary - (ie. Department of Defense; State Department; etc.). Consider all benefits / costs as well as any challenges and constraints. Then, identify your top 5 recommendations and justify your selection. Keep in mind that the President wants to maximize his Elector Satisfaction metrics and maintain bi-partisan support in Congress.
Read the following examples and decide whether the statement can be studied using Quantitative or Qualitative research. Write QN for Quantitative and QL for Qualitative. 1. Maria wanted to find out the why some children frequently misbehave. 2.Drinking two tablets of paracetamol is more effective than one.3. A business owner wants to know if his company is performing well compared to his competitors.4. Coping mechanisms when losing a loved one5. How much water is absorbed by different brands of tissue?
Explain how organisations such as Amazon.com or ebay.com use businessintelligence to extract information used for predicting the futureperformance of the organisations. In your answer indicate characteristicsof such business intelligence technologies (Use a minimum of two pages).
Research on 3 ethical challenges/issues encountered in the practice of Business Analytics/Intelligence.For each ethical challenge/issue, there should be:• Description and explanation of the ethical challenges/issues• Example• Possible solutions/recommendations on how to mitigate the situation
General Motors planned to essentially quit making cars and trucks for nine weeks from mid-July through Sept and CC Power planned to close one of its nuclear plants permanently. Based on these particular news reports, what is the differencebetween GM’s and CC Power’s decisions?a. CC Power was trying to get rid of excess inventory, and GM was trying to become more efficient.b. GM was trying to maximise profits while CC Power was trying to minimise losses.c. GM’s decision to idle plants was a short-run shutdown decision. CC Power, by contrast, made a long-run decision toexit a specific market.d. There is no difference between GM’s and CC Power’s decisions; both were trying to get rid of excess inventory
Explain more why of the Lewin Model is more of a better choice?
How would you define business intelligence (BI)? Identify and briefly discuss a real-world application of BI that you recently experienced.
Give some current instances of Business Intelligence (BI) application, using the Internet as a source of information. What business intelligence advantages have businesses discovered? A24
Auva and Chad knew that they wanted more out of life. Auva works as an inspector for the city health department, which involves inspecting restaurants and food service establishments to see whether they are operating according to local laws. Chad worked as an insurance agent for the first 10 years of their marriage and stays at home even though their kids are old enough to take car of themselves. Their home is paid for and their oldest daughter has received a scholarship to attend their local state university. Their son, Chester, is a senior in high school. Neither Auva nor Chad has much experience in owning or operating a small business, yet this is what they want to do when their son graduates from high school. They have been frugal and have saved over $200,000 for this venture. Auva will not be quitting her job for a while. This will leave Chad with the responsibility of running the business. What type of business to start and why?
Subject: Qualitative research method MCQ's 1) Researchers usually adopt or adapt questionnaire in_____ research.EthnographyPhenomenologyGrounded TheoryQuantitative 2) All the factors are true for Quantitative Research except:Controlled environmentLaboratoryData richnessStatistical interpretation 3) The study of female acid victim cases is the area of concern for ____ philosophers.Disability TheoryQueer TheoryFeministNone of the above 4) Reforms and action plan should be designed to support the marginalized section of society. This refers to ___.InterpretivistSocial constructivistPost positivismTransformative Framework 5) The historians ink past events according to their ideology and interpretation of events. This phenomenon refers to ____.SubjectivityObjectivityAbductive approachAll of the above 6) Silence to be brought on limelight. This philosophy is followed in:Post PositivismPost modernismPositivismPragmatism 7) Advocates of Social Constructivist approach believe that:Reality is…
The following are the factors contributing to the weaknesses in SWOT analysis, except____. Select one: a. economic slump b. product disadvantages c. lack of capital d. inexperience employees
Cousins Jeri Lynn DeBose, Tish Hoover, and Josephine (Joey) Parks looked forward to meeting up during the Christmas holidays to compare notes on the results of midyear teacher evaluations. All were public school teachers in districts scattered over the state. In the pressured search for new levels of teacher accountability demanded by legislators, the state department of education joined 16 other States in implementing a new teacher evaluation system. The goal is to hold teachers account-able for student learning progress in the classroom. Under the guidance of the National Council for Teacher Quality, criteria varies by State, but in most cases, 40 percent of each teacher's accountability score would be based on the principal's evaluation and ranking based on personal observation, 30 percent would be based on personal observation by a master teacher from outside the district, and the Other 30 percent would be based on student test score gains. The state department of education would set a performance goal each school district, and the principal would set a performance goal for each teacher. In preparation, the State conducted intensive training sessions for principals and designated master teachers who would conduct the evaluations based on four class observations per teacher. Officials used standardized achievement tests to derive value-added scores that measure student learning over the year. Teacher ratings were 1-5, with I am being the lowest and 5 representing near perfection. The publication of the first year's evaluations stirred interest and controversy, particularly among teachers who worried about the possible long-term effects on job retention and tenure. Now, with the first-year evaluations in hand, the three cousins pored over their experiences. The three represented different types of school systems within the state. Jeri Lynn worked for a metropolitan system in the state capital. The system included many low-income students whose first language was nor English, and several schools within the system were teetering on the brink of State takeover if improvement in student scores didn't materialize this school year. Tish worked in a county System dominated by upper-income residents, and Joey taught in the rural community in which all three grew up. The rural community had high unemployment, and a low percentage of graduates went on to college. As a result, the cousins came to the table with differing teaching experiences. "The numbers are all over the place," Jeri Lynn remarked as she studied the pages. "The whole system is flawed, and they need to make changes," Joey said. " It's too subjective. The principal and master teacher observations are subjective because there are personal factors that affect a true outcome." "Yeah, look at the numbers from your upper-income district," Jeri Lynn said to Tish. " How can 60 percent of the teachers score 5s?" Tish chuckled. "Yeah, lucky us. Our schools are overflowing with children from wealthy families. These are the kids who will apply to Ivy League schools. I can tell you that the principals are going to avoid confrontation on all fronts. No principal is going to give any indication that their students are receiving an education that's less than perfect, and that means cramming the rankings with 5s. They claim a higher level of motivation for students, and thus the selection of an elite team of educators. So with those pressures, I don't think we get personal feedback that IS accurate." "At the other end of the spectrum, we have my rural district," Joey said. "The big problem is that the principals know everyone and have longstanding relationships with everyone in the county, so I think scores are based on personal history. We could almost predict who would get high or low scores before the observations. For principals, it can go back as far as 'his daddy and my daddy hated each other in high school, and now I get to evaluate his daughter." "I think that in many cases, principals feel pressure to align scores with state expectations. The stare expected my district to have high scores and expected rural schools such as yours to be lower," Tish said. "But isn't that partially offset by lower goals for the rural school distracts responded Joey. "The key to the accountability system is the principal in each school," Jeri Lynn suggested. "With several of the schools in Metro teetering on the edge of state takeover by the end of the year, we had lots of strict principals who wanted to hold our feet to the fire with lower scores." "I thought the whole idea was to provide the teachers With feedback so that we would know the areas where we need improvement," Tish said. "The principals were supposed to conduct two observations in the fall and two more in the spring," Jeri Lynn said. think that's asking too much of them when they already have so much on their plates. I think a lot of them are skimping on their visits. know I only had one observation last semester, and I'm sure Mr. Talley just faked the second set of numbers. The master teachers make only two observations a year, which may be more objective but counts for less." "I'm wondering, too, how a principal measure performance in a course area outside his area of expertise, such as math," Joey said. "If the guy has a phobia about math, anything the teacher says or does is going to 100k brilliant—thus a 5." Tish and Jeri Lynn looked at each other and laughed. Maybe we picked the wrong subjects," Tish said. "My question is one of perception," Jeri Lynn said. "A large percentage of my students are ELL. That affects their scores. How do you measure a 3 in my situation against a 5 for Tish? At the end of the school year, little Carlos is thrilled that his reading in English has improved, but there's no Big Bang here. a slow steady improvement that may not actually show up in big strides for a couple of years." "So, the question is how do they create a system that is fair?" Tish asked. "And accurate," added Jeri Lynn. Is a 1-5 grading System by principals and master teachers a valuable part of a feedback control system for teachers? Why?