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
Indicate whether the U.S. Company should use a long or short forward contract to hedge currency risk. Calculate the no-arbitrage price at which the U.S. Company could enter in
A Treasury bill with 90-day maturity sells at a bank discount yield of 3%. Assume the par value is 10,000. (a) What is the price of the bill? (b) What is the 90-day holding pe
If you were offered an investment that will pay you $10,000 every year forever, and you require an 8% return on investments with the same levels of risk, how much are you wi
1. Base your answer on yearly data from the following series that is available from Board of Governors of the Federal Reserve Website via the DDP Program. 10-year Treasury co
How many of the coupon bonds must East Coast Yachts issue to raise the $45 million? How many of the zeroes must it issue? In 30 years, what will be the principal repayment du
Given the following balance sheet, determine how much additional money Hoffman could borrow at this time to invest in inventory and accounts receivable without violating the t
In what ways does the company adapt its writing style, use of graphics, and other features to adapt to different cultures? Write a brief report on your findings, and include
Rationale for the contemporary management technique selected. In-depth analysis of the technique, in which you fully describe the technique, its implementation process, its a