Chapter 3 Problems 111 :08 nits Material Labor Gross Required (Square Feet) Required (Minutes) Glove (per Peir) Men's 2 Women's 1.5 45 Children's Each full-time employee earns $13 per hour, while each part-time employee earns $10 per hour. Management wishes to know what mix of each of the three types of gloves to produce per week, as well as how many full-time and part-time workers to employ. They would like to maximize their net profit-their gross profit from sales minus their labor costs. a./Formulate and solve a linear programming model for this problem on a spreadsheet. kSummarize this formulation in algebraic form. Oxbridge University maintains a powerful mainframe computer for research use by its faculty, Ph.D. students, and research associates. During all working hours, an operator must to onerate and maintain the computer, as well as to -u 3.24. 1.klo tho director

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Need the answer for a and b.

-234
$10 per
know what mix of each of the th
Back
000'
per week, as well as how many f
to employ. They would like to m
gross profit from sales minus thei
Furthermore, the weight of the cargo in the respective com-
partments must be the same proportion of that compartment's
weight capacity to maintain the balance of the airplane.
The following four cargoes have been offered for shipment
on an upcoming flight as space is available.
a./Formulate and solve
for this problem on a
Summarize this form
Oxbridge University ma
computer for research use by it
research associates. During all w
be available to operate and maint
perform some programming serv
of the computer facility, oversees
It is now the beginning of the
fronted with the problem of assig
her operators. Because all the op
the university, they are available
3.24.
Weight
Volume
Profit
Cargo
(Cubic Feet/Ton)
($/Ton)
(suol)
320
25
009
13
290
of hours each day.
There are six operators (four
Any portion of these cargoes can be acceptni. The chjec-
tive is to determine how much (if any) of each cargo siould be
accepted and how to distribute each among the compartments to
maximize the total profit for the flight.
graduate students). They all have
Gfferences in their experience w
gramming abilicy. The following ta
with the mex mum numbeT of hou
a. Formulate and solve a linear programming medel
for this mixed problem on a spreadsheet.
unuxew
b. Express the model in algebraic form.
Operetors Wage Rate Mo
323.
uct line of winter gloves for the entire family-men, women, and
chiliren. They are trying to decide what mix of these three types
of gloves to produce.
Confortable Hands's manufacturing labor force is union-
ized. Each full-time employee works a 40-hour week. In addi-
tion, by union contract, the number of full-time employees
can never drop below 20. Nonunion, part-time workers also
can be hired with the following union-imposed restrictions:
(1) each part-time worker works 20 hours per week and
(2) there must be at least two full-time employees for each part-
time employee.
All three types of gloves are made out of the same 100
percent genuine cowhide leather. Comfortable Hands has a
long-term contract with a supplier of the leather and receives a
5,000-square-foot shipment of the material each week. The mate-
rial requirements and labor requirements, along with the gross
profit per glove sold (not considering labor costs), are given in
the following table.
Comfortable Hands is a company that features a prod-
$20.0
$20.20/hour
H. B.
$19.80/hour
S. C.
$19.60/hour
K. S.
$21.60/hour
N. K.
$22.60/hour
Each operator is guaranteed
hours per week that will mainta
operation. This level is set arb
the undergraduate students (K.
7 hours per week for the gradua
The computer facility is to E
to 10 PM Monday through Frid
duty during these hours. On S
puter is to be operated by other
Transcribed Image Text:-234 $10 per know what mix of each of the th Back 000' per week, as well as how many f to employ. They would like to m gross profit from sales minus thei Furthermore, the weight of the cargo in the respective com- partments must be the same proportion of that compartment's weight capacity to maintain the balance of the airplane. The following four cargoes have been offered for shipment on an upcoming flight as space is available. a./Formulate and solve for this problem on a Summarize this form Oxbridge University ma computer for research use by it research associates. During all w be available to operate and maint perform some programming serv of the computer facility, oversees It is now the beginning of the fronted with the problem of assig her operators. Because all the op the university, they are available 3.24. Weight Volume Profit Cargo (Cubic Feet/Ton) ($/Ton) (suol) 320 25 009 13 290 of hours each day. There are six operators (four Any portion of these cargoes can be acceptni. The chjec- tive is to determine how much (if any) of each cargo siould be accepted and how to distribute each among the compartments to maximize the total profit for the flight. graduate students). They all have Gfferences in their experience w gramming abilicy. The following ta with the mex mum numbeT of hou a. Formulate and solve a linear programming medel for this mixed problem on a spreadsheet. unuxew b. Express the model in algebraic form. Operetors Wage Rate Mo 323. uct line of winter gloves for the entire family-men, women, and chiliren. They are trying to decide what mix of these three types of gloves to produce. Confortable Hands's manufacturing labor force is union- ized. Each full-time employee works a 40-hour week. In addi- tion, by union contract, the number of full-time employees can never drop below 20. Nonunion, part-time workers also can be hired with the following union-imposed restrictions: (1) each part-time worker works 20 hours per week and (2) there must be at least two full-time employees for each part- time employee. All three types of gloves are made out of the same 100 percent genuine cowhide leather. Comfortable Hands has a long-term contract with a supplier of the leather and receives a 5,000-square-foot shipment of the material each week. The mate- rial requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs), are given in the following table. Comfortable Hands is a company that features a prod- $20.0 $20.20/hour H. B. $19.80/hour S. C. $19.60/hour K. S. $21.60/hour N. K. $22.60/hour Each operator is guaranteed hours per week that will mainta operation. This level is set arb the undergraduate students (K. 7 hours per week for the gradua The computer facility is to E to 10 PM Monday through Frid duty during these hours. On S puter is to be operated by other
Chapter 3 Problems
111
limits
Material
SSO9
Required
(Square Feet)
Required
(Minutes)
Glove
(per Pair)
Men's
Women's
1.5
45
10
Children's
1
et)
Each full-time employee earns $13 per hour, while cachs
part-time employee earns $10 per hour. Management wishes to
know what mix of each of the three types of gloves to prodduce
per week, as well as how many full-time and part-time workers
to employ. They would like to maximize their net profit-their
gross profit from sales minus their labor costs.
Formulate and solve a linear programming model
a./
for this problem on a spreadsheet.
bSummarize this formulation in algebraic form.
nt's
ent
3.24. Oxbridge University maintains a powerful mainframe
computer for research use by its faculty, Ph.D. students, and
research associates. During all working hours, an operator must
aunilahle to operate and maintain the computer, as well as to
1 Ingram the director
Transcribed Image Text:Chapter 3 Problems 111 limits Material SSO9 Required (Square Feet) Required (Minutes) Glove (per Pair) Men's Women's 1.5 45 10 Children's 1 et) Each full-time employee earns $13 per hour, while cachs part-time employee earns $10 per hour. Management wishes to know what mix of each of the three types of gloves to prodduce per week, as well as how many full-time and part-time workers to employ. They would like to maximize their net profit-their gross profit from sales minus their labor costs. Formulate and solve a linear programming model a./ for this problem on a spreadsheet. bSummarize this formulation in algebraic form. nt's ent 3.24. Oxbridge University maintains a powerful mainframe computer for research use by its faculty, Ph.D. students, and research associates. During all working hours, an operator must aunilahle to operate and maintain the computer, as well as to 1 Ingram the director
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.