Welcome to TutorsOnSpot.Com!

World's No. 1 Assignment Writing Market

Post Your Homework

Proposals

Post your homework and get free proposals here!

Post Your Homework

Stuck in your homework and missing deadline?

Get Urgent Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework Writing

100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Get Free 2 Pages Post Your Requirements And Get Free Help

Q1) After you make those changes to the GPU sheet and run solver, which of the GPUs and how many GPUs should I buy?

Category: Accounting & Finance Paper Type: Online Exam | Quiz | Test Reference: N/A Words: 1124

Objective		Objective Function Value=>			22835


Variables:	1050	1050 ti	1060	1070	1070 ti	1080

Obj Func Coefficients:	1862	2138	4375	6463	8186	8873

Variable Values:	0	0	0	1	2	0
							Calculated	Set to
Constraint 1	1	1	1	1	1	1	3	6	# GPUs

Constraint 2	140	170	300	400	450	550	1300	1300	Cost

Constraint 3	75	75	120	150	180	180	510	1200	Power

Q2) Suppose I got lucky at the casino and won an extra $200. If I add that to my GPU budget, how does my selection of GPUs change?

Objective		Objective Function Value=>			26420


Variables:	1050	1050 ti	1060	1070	1070 ti	1080

Obj Func Coefficients:	1862	2138	4375	6463	8186	8873

Variable Values:	1	0	0	0	3	0
							Calculated	Set to
Constraint 1	1	1	1	1	1	1	4	4	# GPUs

Constraint 2	140	170	300	400	450	550	1490	1500	Cost

Constraint 3	75	75	120	150	180	180	615	1200	Power

Q3) suppose that my mother board decided that I can only use 1 type of GPU and up to 6 of them. Which GPU and how many of that single GPU should I buy? (Assume that my budget is $1,300)

Objective		Objective Function Value=>			17500


Variables:	1050	1050 ti	1060	1070	1070 ti	1080

Obj Func Coefficients:	1862	2138	4375	6463	8186	8873

Variable Values:	0	0	4	0	0	0
							Calculated	Set to
Constraint 1	1	1	1	1	1	1	4	6	# GPUs

Constraint 2	140	170	300	400	450	550	1200	1300	Cost

Constraint 3	75	75	120	150	180	180	480	1000	Power

Constraint 4	0	0	1	0	0	0	1	1

Gas Problem:

You have a sheet that I can use for determining the optimal mix of gas for my car using 4 different types of fuel. For your initial settings, set E85 gas at 110 octane and the prices of gasoline to:

E85 - $2.00/gal

87 Oct - $2.50/gal

89 Oct - $2.70/gal

93 Oct - $3.10/gal

Q1) Run the solver with these initial settings. What is the optimal blend of fuel for my car? How much does it cost?

Objective		Objective Function Value=>			40


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	2	2.5	2.7	3.1

Variable Values:	4	8	3	2
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	100	87	89	93		1456	1456	Octane

Constraint 3	1					3.5	3.5	Gal E85

Q2) Pretend to do a web search for the octane rating of E85 gas. You would find that there are a few different ideas about how much octane is in a gallon of E85. How does the blend of fuel change when E85 has:

110 Octane: (From Q1)

103 Octane:

98 Octane:

Objective		Objective Function Value=>			38


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	2	2.5	2.7	3.1

Variable Values:	4	12	0	0
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	100	110	103	98		1725	1456	Octane

Constraint 3	1					3.5	3.5	Gal E85

Q3) Suppose that the government ends subsidies to corn farmers and the price of E85 goes up $0.50 per gallon. What is the optimal blend of fuel and price for a tank of gas now? (Assume E85 has 110 octane)

Objective		Objective Function Value=>			40


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	2.5	2.5	2.7	3.1

Variable Values:	4	12	0	0
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	110	87	89	93		1472.5	1456	Octane

Constraint 3	1					3.5	3.5	Gal E85

Q4) Going back to the original prices of each fuel, pretend the price of all gas goes up $2.00/gallon. (So each price is in the $4.00 - $5.10 range.) Does this change in price have the same optimal solution you found in Q1? (Price will be higher but, is the blend the same?)

Objective		Objective Function Value=>			74


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	4.5	4.5	4.7	5.1

Variable Values:	4	7	4	2
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	100	87	89	93		1456	1456	Octane

Constraint 3	1					3.5	3.5	Gal E85

Q5) Going back to the original prices, suppose that I stop at a gas station that has no E85 to sell. What blend of fuel should I buy?

Objective		Objective Function Value=>			46


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	2.5	2.5	2.7	3.1

Variable Values:	0	1	6	9
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	100	87	89	93		1456	1456	Octane

Constraint 3	1					0	3.5	Gal E85

Extra credit: Suppose that I’m traveling to Denver for a “conference” this summer and I am driving there. Out West, the price of 89 Octane gas can be cheaper than 87 octane. What is the blend of fuel I buy when gas costs:

87 Octane - $2.50/gal, 89 Octane - $2.25/Gal, 93 Octane - $2.70/gal (NOTE: No E85 gas for sale.)

Objective		Objective Function Value=>			40


Variables:	E85	87 Oct	89 Oct	93 Oct

Obj Func Coefficients:	2	2.5	2.25	2.7

Variable Values:	0	0	8	8
						Calculated	Set to
Constraint 1	1	1	1	1		16	16	Total Gallons

Constraint 2	100	87	89	93		1456	1456	Octane

Constraint 3	1					0	3.5	Gal E85