Friendly family apple products-linear programming model

Assignment Help Operation Management
Reference no: EM1323525

Friendly Family apple products: linear programming model; solve in Excel

On their farm, the Friendly family grows apples that they harvest each fall and make into three products-apple butter, applesauce, and apple jelly. They sell these three items at several local grocery stores, at craft fairs in the region, and at their own Friendly Farm Pumpkin Festival for 2 weeks in October. Their three primary sources are cooking time in the kitchen, their own labor time, and the apples. They have a total of 500 cooking hours available, and it requires 3.5 hours to cook a 10-gallon batch of apple butter, 5.2 hours to cook 10 gallons of applesauce, and 2.8 hours to cook 10 gallons of jelly. A 10 gallon batch of apple butter requires 1.2 hours of labor, a batch of sauce takes 0.8 hour, and a batch of jelly requires 1.5 hours. The Friendly family has 240 hours of labor available during the fall. They produce about 6,500 apples each fall. A batch of apple butter requires 40 apples, a 10 gallon batch of applesauce requires 55 apples, and a batch of jelly requires 20 apples. After the products are canned, a batch of apple butter will generate \$190 in sales revenue, a batch of applesauce will generate sales revenue of \$170, and a batch of jelly will generate sales revenue of \$155. The Friendly's want to know how many batches of apple butter, applesauce, and apple jelly to produce in order to maximize their revenues.

a. Formulate a linear programming model for this problem.
b. Solve the model by using the computer either excel solver or QM for windows

Questions Cloud

 The growth of the human brain : The genetic differences between female and male brain and how weight loss can take place by learning how the brain regulates hunger and thirst. Solution-oriented decision models : Select a real company (not a retailer). Identify four decisions that the company makes at different levels of the organization. Explain the policies, procedures and decision-making tools which might be used to make each of the four decisions. Experience of using information technology : Show your experience of using information technology Max 500 words - Using information and communications technology Motivation and function of brain : This solution describes the desire to exercise, and how it is related with motivaiton and the brain. Friendly family apple products-linear programming model : On their farm, the Friendly family grows apples that they harvest each fall and make into three products-apple butter, applesauce, and apple jelly. Propose a linear programming model for this problem. Solve the model by using the computer either ex.. Multinational organization from a global organization : Transnational and Multinational Organizations - This solution explains how you would differentiate a transnational or multinational organization from a global organization. Assessing the effectiveness of interventions and brain scan : The solution debated on how certain interventions worked with different psychological issues. Information about what is marketing research : This posting describes what is marketing research. It states the many ways to conduct the research, as well as how the internet has impacted field. Summary report of a computer crime : Computer Crime and Punishment - summary report of a computer crime or cyber crime committed by using a covert online money transfer site.

Write a Review

Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

Operating decisions for process solutions

Solutions provides a computer-based document processing service

Stochastic dynamic programming problem

Determine the problem as stochastic dynamic programming problem. Specify phases, states, decisions and the optimal value function.

Market research explained solution

Let's say your market research firm is hired to assist retail store that is interested in revamping their overall store format in an effort to keep people in their store longer.

Shortest-route technique

Minimal-spanning tree technique and Shortest-route technique

Four essential elements of contract

Identify and define each of the four essential elements of a contract. Use the facts of the case to explain whether each of these elements is present and whether a contract has been formed.

Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

Operational process

Find one scholarly journal article reporting on one or more of the following techniques: business/predictive analytics, dashboards, decision support systems, supply chain management.

Statistical conclusion

The investor hires a researcher who randomly samples 19 warehouses that are for sale and finds that the mean price per square metre is \$316,70, with a standard deviation of \$12.90. If the researcher uses a 5% level of significance, what statistica..

Marketing research-six step process

In brief discuss the marketing research process. How can firm leverage its marketing information system (MIS) to yield the greatest value for its research efforts?

Usefulness of lp even under degree of uncertainty

Must linear programming be employed under conditions of certainty? This solution discusses the usefulness of LP even under the degree of uncertainty in 241 words.

Risk identification and risk control

What is the difference between risk identification and risk control in the context of protecting information systems?