Reference no: EM13966826
Ima Hogg wants to determine the quantity of ingredients to use in making each pound of sausage at a minimum cost. The available ingredients and their relevant data are: Hog bellies cost $.30, and contain 3 ounces of protein, 5 ounces of fat, and 6 ounces of water; Tripe costs $.20, contains 5 ounces of protein, 3 ounces of fat, and 4 ounces of water; Beef costs $.70, contains 4 ounces of protein, 2 ounces of fat, and 5 ounces of water; Pork costs $.60, contains 3 ounces of protein, 4 ounces of fat, and 9 ounces Ima must meet the specified weight exactly, and there are further restrictions. No more than 10% of the sausage weight can be composed of hog bellies and chicken cannot exceed 25% of total content, and at least 30% of the sausage must be beef. In addition, a minimum of 3 ounces of protein must be present in each pound of sausage. Furthermore, each pound of sausage may contain a maximum of 4 ounces of fat and maximum of 8 ounces of water.
a. Formulate the problem as a linear program. Identify the objective function, decision variables, constraints and any other necessary information.
b. Use excel to display the linear program.
c. Use excel to find the optimal solution
1. What is the optimal Solution?
2. Which variable have slack?
3. Which are binding?
|
Advantages to community treatment for juvenile offenders
: If youths violate the rules of probation, should they be placed in a secure institution? Is juvenile restitution fair? Should a poor child have to pay back a wealthy victim? What are the most important advantages to community treatment for juvenile o..
|
|
Act of aggression against other countries
: Is war ever justified? If so, under what circumstances? Is terrorism every morally justified? If so, under what circumstances? Can you think of a time the United States engaged in terrorism (this doesn't have to be an act of aggression against other ..
|
|
Individual components and the input and output of components
: Which of the following statements about systems theory is NOT true? It concentrates on individual components and the input and output of those components. It provides the conceptual foundation on which the development of information systems is based...
|
|
What is their average aggregate inventory value
: The Marlin Company operates 50 weeks a year, and its cost of goods sold last year was $1,800,000. The firm carries six items in inventory: three raw materials, two work-in-process items, and one finished good. What is their average aggregate inventor..
|
|
Use in making each pound of sausage at a minimum cost
: Ima Hogg wants to determine the quantity of ingredients to use in making each pound of sausage at a minimum cost. The available ingredients and their relevant data are: Hog bellies cost $.30, and contain 3 ounces of protein, 5 ounces of fat, and 6 ou..
|
|
Explain purpose of gantt chart-performance improvement
: Explain the purpose of a Gantt chart. Provide an example of how a Gantt chart might be used in the performance improvement process. UC Hospital’s surgical center is reporting 24 surgical patients experienced complications with post-op procedure care ..
|
|
What is its effective capacity
: In a job shop, effective capacity is only 45 percent of design capacity, and actual output is 63 percent of effective output. What design capacity would be needed to achieve an actual output of 12 jobs per week? What is its effective capacity?
|
|
Addition of new plant to absorb the backlog of demand
: A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $15,400 per month and variable costs of $0.98 per unit produced.
|
|
Continuous review system to control the inventory
: If the firm uses the continuous review system to control the inventory, what would be its order quantity and reorder point? Assume that the firm decided to change to the periodic review system to control the item’s inventory. The time between reviews..
|