Question: please show all steps on how it is done in excel displaying variables, objective function and constraints then solved using solver Cattle Feed Company produces

please show all steps on how it is done in excel displaying variables, objective function and constraints then solved using solver

Cattle Feed Company produces two types of cattle feed. Both feeds consist totally of wheat and alfalfa. Feed 1 must contain at least 80% wheat, and feed 2 must contain at least 60% alfalfa. Feed 1 sells for $4/1b and feed 2 sells for $5/lb. The company can purchase up to 1000 lbs of wheat at $1/1b and up to 800 lbs of alfalfa at $0.80/1b. Demand for each type of feed is unlimited. Formulate and solve the LP to maximize the cattle feed company's profit

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!

Objectives - To develop two-variable Linear Programming (LP) model. - To solve the LP model using the graphical method. - To solve the LP model using EXCEL solver. Background Ebara Co. produces two...

Linear Programming (Statistics) 1. The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters...

MGMT 3115 EXAM 1 Cal State East Bay By completing and submitting the answer to the exam, the student fully understands the university's policy on academic dishonesty and agree to abide by this...

please show steps on how it is done in excel displaying variables, objective function and constraints and solved using solver . Moyer Masonry Company produces a product that involves a manufacturing...

please show work for part a & b, thank you so much! decision variables: X1 = 0.498oz X2 = 0.265 oz X3 = 0.237 oz objective function (solved): z = (cost per lb of A)*X1 + (cost per lb of B)*X2 + (cost...

please show step by step and show the solver using excel Problem Statement Suppose that you are throwing a pizza party for yourself and your closest friends, with a total of ten (10) people expected...

I need help with excel file please: The Mason Wine Company produces two kinds of wine - Mason Blanc and Mason Merlot. The wines are produced in 1,000-gallon batches. The profit for a batch of Blanc...

The Mason Wine Company produces two kinds of wine Mason Blanc and Mason Merlot. The wines are produced in 1,000-gallon batches. The profit for a batch of Blanc is $12,000 and the profit for a batch...

AmeriPlas, Inc., produces 20-ounce plastic drinking cups that are embossed with the names of prominent beers and soft drinks. a. Prepare a time-series plot of the sales data. Does there appear to be...

Iman (1994, p. 505) presents data on how college students and experts perceive risks for 30 activities or technologies. Each group ranked the 30 activities. The rankings for the eight greatest risks,...

Which of the following budgets are NOT needed in service firms? Multiple select question. Selling and administrative Cash Manufacturing overhead Production

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...