Question Details

(Solved) Sporting Goods Resource Requirements per Unit (a) Product Basketball Football Rubber (lb.) Leather (f2) 2.2 input Constraints Total resources...


I have attached a copy of my homework questions along with the answer sheet. If formulas a needed in excel please input the formulas. Thanks for your help.

Sporting Goods
Resource Requirements per Unit (a)
Product
Basketball
Football Rubber (lb.) Leather (f2) 2.8
1.5 3.7
5.2
input Constraints Total resources available Profits ($) 600 900 Basketball
11 Football
15 Basketball
Football Decision variables Maximized profits Objective function Resource Requirements per Unit (b)
Product
Basketball
Football Rubber (lb.) Leather (f2) 2.8
1.5 3.7
5.2
input Constraints Total resources available Profits ($) 600 900 Basketball
12 Football
15 Basketball
Football Decision variables Maximized profits Objective function Please use computer method to solve the problem
Please enter your solution in Yellow cells Resource Requirements per Unit (c-1)
Product
Basketball
Football
Total resources
available Profits ($) Rubber (lb.) Leather (f2) 2.8
1.5 3.7
5.2 1000 900 Basketball
11 Football
15 Basketball
Football
Maximized profits Resource Requirements per Unit (C-2)
Product Rubber (lb.) Leather (f2) Basketball
Football 2.8
1.5 3.7
5.2 Total resources
available 600 1500 Basketball
11 Football
15 Profits ($) Basketball
Football
Maximized profits A & B products
Hours/ Unit
Line 1
Line2
11
5
6
9 (a)
Product
A
B Constraints
Total Hours Profits ($)
Product A
Product B Maximized profits 65 40 A
11 B
15
decision variables Objective function (b) Sensitivity Range for the coefficient of # of units of product A in the objectivefunction
Sensitivity Range for the coefficient of # of units of product B in the objectivefunction (c') Shadow Price for additional hours of production time on Line 1
Shadow Price for additional hours of production time on Line 2
Which one of the two the company would prefer (Line 1 or Line 2?) Irwin textile mills
(a)
Profits for each product Corduroy
3.25 denim
2.5
Resources Cotton
Labor Corduroy
denim 8
4 6
3 <=
<=
Demands
<=
<= Available Resources
6500
3000 510
1000000 Maximized profits Write the standard form of the LP model in the space provided below (b) How much extra cotton and processing time are lef at the optimal solution?
Cotton
Processing Time
Is the demand for Corduroy met? ('c) If Irwin Mills can obtain additional cotton or processing time, but not both, which should it
Processing Time or additional cottone?
How much? ut not both, which should it select? How much? Bradley Family
(a) Land
Budget
Govt. Restriction Let X1 = # of acres of corn and X2 = # of acres of tobacco
Corn Tobacco 300
1
105
0 520
1
210
1 X1 X2 Resources
Available
<=
<=
<= 410
52500
100 Decision Variables
Objective function (b) How many acres of farm land will not be cultivated at the optimal solution?
Do the Bradleys use the entire 100 acre tobacco allotment? ('c) Should the Bradleys' lease extral land from their neighbor at $110 per acre?
What is the maximum price the Bradleys' should pay their neighbor? And how much land shoud th
maximum price
# of acres of land (d) For each dollar they borrow , how much additional profit will they make?
If they borrowed a additional $1000, would the number of acres of corn and tobacco they plant cha Government Restriction d how much land shoud they lease? and tobacco they plant change?

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200254325.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now