--%>
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 : Elementary Logic Set & Model of a

    Prove that Elementary Logic Set is a Model of a Boolean Algebra The three Boolean operations of Logic are the three logical operations of  OR ( V ), AN

    		•
  • Q : Problem on Prime theory Suppose that p

    Suppose that p and q are different primes and n = pq. (i) Express p + q in terms of Ø(n) and n. (ii) Express p - q in terms of p + q and n. (iii) Expl

    		•
  • Q : Formal logic It's a problem set, they

    It's a problem set, they are attached. it's related to Sider's book which is "Logic to philosophy" I attached the book too. I need it on feb22 but feb23 still work

    		•
  • Q : Calculus I need it within 4 hours. Due

    I need it within 4 hours. Due time March 15, 2014. 3PM Pacific Time. (Los Angeles, CA)

    		•
  • Q : Problem on mixed-strategy equilibrium

    Assume three Offices (A, B, & C) in downtown,  simultaneously decide whether to situate in a new Building. The payoff matrix is illustrated below. What is (are) the pure stratgy Nash equilibrium (or equilibria) and mixed-strtegy equilibrium of the game?

    		•
  • Q : Set Theory & Model of a Boolean Algebra

    II. Prove that Set Theory is a Model of a Boolean Algebra The three Boolean operations of Set Theory are the three set operations of union (U), intersection (upside down U), and complement ~.  Addition is set

    		•
  • Q : What is the probability that the film

    T.C.Fox, marketing director for Metro-Goldmine Motion Pictures, believes that the studio's upcoming release has a 60 percent chance of being a hit, a 25 percent chance of being a moderate success, and a 15 percent chance of being a flop. To test the accuracy of his op

    		•
  • Q : Problem on mass balance law Using the

    Using the mass balance law approach, write down a set of word equations to model the transport of lead concentration. A) Draw a compartmental model to represent  the diffusion of lead through the lungs and the bloodstream.

    		•
  • 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

    		•
  • Q : Maths A cricketer cn throw a ball to a

    A cricketer cn throw a ball to a max horizontl distnce of 100m. If he throws d same ball vertically upwards then the max height upto which he can throw is????

    		•