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

Reference no: EM1323525

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.

User Account

All Pages