Formulate and solve a linear programming model
Course:- Finance Basics
Reference No.:- EM1349747

Assignment Help
Assignment Help >> Finance Basics

Comfortable Hands is a company that features a product line of winter gloves for the entire family â?" men, women, and children. They are trying to decide what mix of these three types of gloves to produce.

Comfortable Hand's manufacturing labor force is unionized. Each full-time employee works a 40-hour week. In addition, 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 material requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs), are given in the following table:

Glove Material Required (square ft) Labor Required (minutes) Gross Profit (per pair)
Men's 2 30 $8
Women's 1.5 45 $10
Children's 1 40 $6

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 using Solver.


Put your comment

Ask Question & Get Answers from Experts
Browse some more (Finance Basics) Materials
A perpetuity with the first annual cash flow paid at the beginning of year 4 is equivalent to receiving $100,000 in 15 years time. Assume that the perpetuity and the lump sum
Kathy, age 29, is married and has a son, age 3. She owns a $100,000 ordinary life insurance policy that contains a waiver-of-premium provision, guaranteed purchase option, a
List and describe two sectors you believe spends the most money in health care? (Example sectors; hospital care, home health care, governmental insurance, pharmaceuticals, e
Is the magnitude of value of a commodity determined by the quantity of abstractlabor necessary to produce it, or by the quantity of other commodities against whichit can be
Write a 350 word article in which you identify rules and regulations governing patient billing. This is in regards to healthcare. Please cite your sources and paraphrase if
Michelle and Ken Dunn, both in their mid-20s, have been married for 4 years and have two preschool-age children.  Ken has an accounting degree and is employed as a cost acco
All Clear Corporation is a large manufacturer of custom draperies. In all, the company has seven divisions spread out across the country. Furthermore, the company has adopted
Find the marginal tax rate for the following levels of corporate earnings before taxes: $15,000; $60,000; $90,000; $200,000; $400,000; $1 million; and $20 million. Plot the ma