Question: work through excel please! A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle is

work through excel please!

A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle is required to have 360 grams of protein and 360 grams of fat. Brand X has 5 grams of protein and 10 grams of fat. Brand Y has 10 grams of protein and 5 grams of fat. Rancher has found that Brand X costs $3.5 and brand Y costs $5 per unit. Find out how much of each type should be used by the rancher to minimize cost. Keep in mind that the rancher has to buy at least one unit of each brand. Moreover, the number of brand X has to be twice the number of brandY. (Possible Answer: $216 )

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!

I just want to know if the minimum is $216.00. If not, I'm not sure what I'm missing. A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle is required...

A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle .each serving for cattle is required to have 360 gram of protein and 360 grams of fat. brand x has 5 grams of protein and...

A rancher is mixing two types of foods, Brrand x and Brend Y , for his cattle. Each serving for cattle is required to have 5 6 0 grams of protein and 5 6 0 grams of fat. Brand x has 5 . 5 grams of...

A rancher is mixing two types of food, Brand A and Brand B for his cattle. If each serving is required to have at least 60 grams of protein and at least 30 grams of fat. Brand A has 15 grams of...

10 & 11 please! 10. A furniture manufacturer makes two types of furniture chairs and sofas. The production of the sofas and chairs requires three operations carpentry, finishing, and upholstery....

10. A furniture manufacturer makes two types of furniture chairs and sofas. The production of the sofas and chairs requires three operations carpentry, finishing, and upholstery. Manufacturing a...

Introduction Costco Wholesale Corporation is the third largest retailer in the United States behind Wal-Mart and Amazon. Headquartered in Issaquah Washington State, just outside Seattle, in 2017 the...

Hello, Will you please assist with questions a and b below. I have attached the spreadsheet. THE TAB IS LABEL P3-6A (a) Prepare a schedule that shows how the equivalent units were computed so that...

(a) Propose step-by-step mechanisms for both transformations of the Robinson annulations sequence just shown. (b) Would you expect 2-methylcyclohexane-1, 3-dione to be more or less acidic than...

Brian Smith, network administrator at Advanced Energy Technology (AET), was given the responsibility of implementing the migration of a large data center to a new office location. Careful planning...

A stock with a current market price of $ 4 5 . 6 0 has an associated put option priced at $ 7 This put has an intrinsic value of and a time value of 1 ; 6 . 9 6 . 9 ; 1 0 ; 7 . 9 7 . 9 ; 0

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...