--%>
Assignment Help - homework help

Linear programming model of a Cabinet company

A cabinet company produces cabinets used in mobile and motor homes. Cabinets produced for motor homes are smaller and made from less expensive materials than those for mobile homes. The home office in Dayton Ohio has just distributed to its individual manufacturing centres the production quotas required during the upcoming quarter. The scheduled production requirements for the Huber Heights OHOI plant are provided in the table below.

2321_cabinet.jpg

Each motor home cabinet requires three man hours to produce whereas each mobile home cabinet requires five man hours. Labor rates normally average $18 pr hour. During July and august however when the company employs many part time workers labor rates only average $14 and $16 per hours respectively. A total of 2.100 man hours are available in July 1,500 in august and 1,200 in September. During any given month management can schedule up to 50% additional man hours using overtime as the standard rate of time and a half. Material costs of motor home cabinets are $146andfor mobile home cabinets they are $210.

The plant expects to have 25 motor home an d20 mobile home assembled cabinets in stock at the beginning of July. The home office wants the plant to have at least 10 motor home and 25 mobile cabinet assemblies in stocks at the beginning of October to cover possible shortages in production at the other plants.

The plants has storage facilities capable of holding up to 300 cabinets in any one month. The costs for storing motor home cabinets is $6 pr cabinet and $9 for storing mobile home cabinets per cabinet.
Formulate a linear programming model to help management devise a monthly production schedule for the next quarter that will minimize their costs over the quarter. Report back the production and storage levels. Report costs per month in addition to the total costs.

Implement your formulation in excel and fin d the optimal solution using solver. Summarize your solution (decision variable values and objective functions value ) below your formulation. Report back the production and storage levels. Report costs per month in addition to the total costs.

   Related Questions in Mathematics

  • Q : Problem on budgeted cash collections

    XYZ Company collects 20% of a month's sales in the month of sale, 70% in the month following sale, and 5% in the second month following sale. The remainder is not collectible. Budgeted sales for the subsequent four months are:     

    		•
  • Q : Profit-loss based problems A leather

    A leather wholesaler supplies leather to shoe companies. The manufacturing quantity requirements of leather differ depending upon the amount of leather ordered by the shoe companies to him. Due to the volatility in orders, he is unable to precisely predict what will b

    		•
  • Q : The mean of the sampling distribution

    1. Caterer determines that 87% of people who sampled the food thought it was delicious. A random sample of 144 out of population of 5000 taken. The 144 are asked to sample the food. If P-hat is the proportion saying that the food is delicious, what is the mean of the sampling distribution p-hat?<

    		•
  • Q : Area Functions & Theorem Area Functions

    Area Functions 1. (a) Draw the line y = 2t + 1 and use geometry to find the area under this line, above the t - axis, and between the vertical lines t = 1 and t = 3. (b) If x > 1, let A(x) be the area of the region that lies under the line y = 2t + 1 between t

    		•
  • Q : Who independently developed

    Who independently developed a model for simply pricing risky assets?

    		•
  • Q : Who developed a rigorous theory for

    Who developed a rigorous theory for Brownian motion?

    		•
  • Q : Probability and Stochastic assignment

    Introduction to Probability and Stochastic Assignment 1: 1. Consider an experiment in which one of three boxes containing microchips is chosen at random and a microchip is randomly selected from the box.

    		•
  • Q : Global And Regional Economic Development

    The Pharmatec Group, a supplier of pharmaceutical equipment, systems and services, has its head office in London and primary production facilities in the US. The company also has a successful subsidiary in South Africa, which was established in 1990. Pharmatec South A

    		•
  • Q : Abstract Algebra let a, b, c, d be

    let a, b, c, d be integers. Prove the following statements: (a) if a|b and b|c. (b) if a|b and ac|bd. (c) if d|a and d|b then d|(xa+yb) for any x, y EZ

    		•
  • Q : Numerical Analysis Hi, I was wondering

    Hi, I was wondering if there is anyone who can perform numerical analysis and write a code when required. Thanks

    		•