+1-415-670-9189
info@expertsmind.com
Formulate and solve a linear programming model
Course:- Finance Basics
Reference No.:- EM1349747




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
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
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Finance Basics) Materials
Since the banks do not themselves plan to hold the securities but intend to sell them to others as soon as possible, why are they so concerned about making careful investiga
At the end of the year, it had a market value of $12 million even though it experienced a loss, or negative net income, of $2.5 million. Did the analyst's prediction prove c
Company A is planning to lease a machine for the next six years for an annual lease payment of $1700 paid in advance, plus an initial fee of $500. There is a one-year delay
As a result of the Financial Reform Act of 2010, the Consumer Financial Protection Bureau was established and housed within the Federal Reserve. - Explain the role of this b
When companies cut dividends, it is usually a bad sign for the stock. But apparently not at Monsanto. Several years ago, the company cut its dividend and the stock price wen
What will be your estimate of NPV and IRR if the average RDS sales price per unit must be reduced by 5 percent (from $10,900 per unit to $10,355 per unit) in order to sell the
The price of foodstuff generally increased by 20% at the beginning of a drought season and reduced by 30% during harvesting season. Express the new price at a ratio of the o
Identify historical events that led to the implementation of current standards. Analyze how these events and standards are correlated and the impact that they have on the acc