+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
Could you fly on the same airlines and stay at the same hotels in the packages that you could when you searched individually? What were the differences in price? How would y
The next dividend payment by Blue Cheese, Inc., will be $1.52 per share. The dividends are anticipated to maintain a growth rate of 6 percent forever. If the stock currently
the fact that she is providing no collateral, the bank is going to charge her a fee of 2.0% of her loan amount as well as take out the interest upfront. The bank is offering
You have just completed an analysis of an investment. You used Net Present Value, Profitability Index and Internal Rate of Return. Your boss has just asked you for the payba
$1000 par, 6 1/8% coupon rate, 15 year maturity bond which is currently selling for $1020. If jay required a return is 9%, what would he be willing to pay for the bultrite b
A final suggestion is a make a 10% across-the-board price reduction. By how much would dollar sales have to increase to maintain Alliance's current contribution.
Based on your above calculations, compare the calculated price with the current market price and indicate whether is the stock price overvalued, undervalued, or at equilibri
Assume the car can be purchased for 0% down for 60 months (in lieu of rebate). A car with a sticker price of $42,950 with factory and dealer rebates of $5,100 (a) Find the m