+1-415-670-9189
info@expertsmind.com
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
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Finance Basics) Materials
An IT strategy should create a relationship between the investment in IT and organizational strategies and objectives. IT systems leverage the value of information for an or
Select any publicly traded company that their financials are published on the SEC website. For the purpose of this assignment we have selected Kirkland's Corporation Kirkland
A three-month call option is the right to buy stock at $20. Currently the stock is selling for $22 and the call is selling for $5. You are considering buying 100 shares of the
Calculating discounted payback. An investment project has annual cash inflows of $6,500, $7,000, $7,500, and $8,000, and a discount rate of 14%.
Mama Leone's operates 250 days per year and maintains a minimum inventory level of 2 days' worth of cheese as a safety stock. If the lead-time to receive orders of cheese is
This solution provides the learner with challenges and opportunities that US Airways may face in the coming years that would potential require financial management and analy
You're employed by CPA firm that has international client, Global Manufacturing, with home offices in country in the European Union. The company recently entered in a lucrat
Research United and Continental Airline merger, measure the challenges experienced during the merger and resulting impact to the business.