Question: please answer using linerar programing model above in excell. show work please. thank you! Problem2 (10points) Kevin's Company produces a sausage mixture in 1000-pound batches.

please answer using linerar programing model above in excell. show work please. thank you!

Problem2 (10points) Kevin's Company produces a sausage mixture in 1000-pound batches. The mixture contains two ingredients-beef (x1) and lamb (x2). The meat producer wants to know the optimal mixture of ingredients that will minimize cost. As shown in the following linear programming model, the meat producer has some requirements for the quantity of beef and lamb in each batch: Minimize Z=4x1 + 7x2 subject to x1+x2=1000 (batch weight) X1>-450 (minimum amount of beef) x2>=150 (minimum amount of lamb) x1-4x2> 0 x1, x2>=0 I I a- Solve the linear programming model above using Excel (copy/paste your Excel output below- show your Excel work under the Excel worksheet"Problem2") (4 pts) b- What is the optimal cost of a batch of mixture? (2 pts) C- How many pounds of beef should be contained in a batch of mixture? (2 pts) d. How many pounds of lamb should be contained in a batch of mixture? (2 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

resign Layout References Mailings Review View Body AA ELE Aabbccdte Asbecode ale x. x2 A Normal No Spacing pup-to-date with security updates, fixes, and improvements, choose Check for Updates....

Please answer using C++ programing language. 4. Determine the final value for x in the following expressions. X = 3.8 + 2 * 7 - 9 / 5; int X double x X = 8 % 5 * 15.0 / 4.0; int X double X

Please answer using Lisp programing Question 1: February 29th appears in years that obey the following conditions: the year is divisible by 4 and the year is not divisible by 100, unless the year is...

Please answer this question: Programing language Visual Basics . Please provide the code to be: ( To add one of the items in the list to the shopping cart, then close. Select one item then add then...

IC PAC TOE Rules. Robot goes first. Robot must place other player's balls. Robot must never place a ball where there already is a ball. Robot must wait its turn. Robot must stop playing the game when...

Please answer this question: Programing language Visual Basics. Please provide the code to be: ( To add one of the items in the list to the shopping cart, then close. Select one item then add then...

Please answer in C++ programing language: The Problem: In class you saw how to create a dynamic list of property names. This time we are going to extend that by making a class that keeps track of...

**PLEASE SOLVE USING GOAL PROGRAMING MODEL AND EXCEL** I need explanation to understand. Thank you. 4. A farmer in the Midwest has 1,000 acres of land on which she intends to plant corn, wheat, and...

PLEASE SOLVE USING C PROGRAMING ONLY NOT JAVA OR C++ You are tasked with writing a program that will read different parts of a tape. The tape itself is represented as a 1 dimensional byte array of n...

Please answer in C++ programing language. The problem: Overload the + and = operators for the Square class we have provided you. The = should make a deep copy of the Square object. The + operator...

The federal government is a major financier of biomedical research. Congress continues to increase the nih budget when most other health-related federal budgets are declining. Suggestions have been...

Franklin Equipment, Ltd. (FEL), with headquarters and main fabrication facilities in Saint John, New Brunswick, was founded 75 years ago to fabricate custom-designed large machines for construction...

Ecological, incorporation, A company that produces environmentally safe products, has production facilities and more than 1 0 states. The ownership of the company is widely held, with international...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...