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 brand Y.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 4P: The file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year...
icon
Related questions
Question

(Please use the format of the speadsheet in the image)

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 brand Y. (Possible Answer: $216)

1
2
3
4
25
26
5
6
7
8
9
10
11
12
13
14
15 MODEL
16
17
18
19
20
21
22
23
24
31
32
33
A
34
35
DATA
36
37
29
27
28
29 CONSTRAINTS
30 LS
B
DECISION VARIABLES
с
OBJECTIVE FUNCTION
RELATION RS
D
[Name]
E
F
LL
Transcribed Image Text:1 2 3 4 25 26 5 6 7 8 9 10 11 12 13 14 15 MODEL 16 17 18 19 20 21 22 23 24 31 32 33 A 34 35 DATA 36 37 29 27 28 29 CONSTRAINTS 30 LS B DECISION VARIABLES с OBJECTIVE FUNCTION RELATION RS D [Name] E F LL
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,