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 columnist in the New York Times writes: "So, according to Okun's Law, the unemployment rate should have gone from 7.4 percent at the start of [2009] to 9 percent a year la
For this assignment, choose a company that has had ethical issues based on an accounting issue, such as internal control issues, fraudulent activity, theft, and so forth. Cr
Skylab's CFO has determined that the firm needs an additional $2,000,000 and has decided to issue 10-year, $1,000 par value bonds that pay only $40 in interest every six month
What percentage of the total assets controlled by Scully Corporation does its common stock equity represent? If another company owns 15% of the common stock of Scully Corporat
The bank offers you a 15-year mortgage you to pay a 3 percnt loan origination fee, which will reduce the effective amount the bank lends to you. Compute the annual percentag
1. What are your thoughts about reinvestment rate risk, and how this can be related to interest rate risk. In addition, is there a connection between rating risk and cre
1) Download a long set of daily S&P500 price data. Plot the data. What do you see? 2) Calculate daily net returns and plot them. What do you see? Hint : Net return is given by
Builtrite preferred stock has a 5% coupon based on a par value of $60 a share. Currently, investors require a 4% return. What is the value of Builtrite's preferred stock?