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
Please pull up the Social Security website for a minute and let me discuss a few interesting facts that you'll find. If you will type in SSA.gov, you will find a wealth of i
In, 1999, the S&P returned 21%, closing out a streak of five consecutive stellar up-years. Then in 2000, the S&P 500 returned -9.1%. In 2001, the S&P500 returned -16.1%.
Suppose that there are two independent economic factors, F1 and F2. The risk-free rate is 9%, and all stocks have independent firm-specific components with a standard devi
You invest $3,000 annually in a mutual fund that earns 10% annually, and you reinvest all the distributions. How much will you have in the account at the end of 20 years?
Your neighbor just received a credit offer in an e-mail. The company is offering him $6,000 at 12.8 percent interest. The monthly payment is only $110. If he accepts this of
1. How is the compounding process related to the payment of interest on savings? What is the general equation for future value? 2. How can the present value interest factors f
Project K costs $55,000, its expected cash inflows are $13,000 per year for 8 years, and its WACC is 7%. What is the project's discounted payback? Round your answer to two dec
1. Briefly describe your company and then benchmark the codes of conduct used by similar companies in the industry. Critique the codes of conduct of at least three (3) simil