--%>
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 : State Prime number theorem Prime number

    Prime number theorem: A big deal is known about the distribution of prime numbers and of the prime factors of a typical number. Most of the mathematics, although, is deep: while the results are often not too hard to state, the proofs are often diffic

    		•
  • Q : Relationships Between Data Introduction

    Relationships Between Data - Introduction to Linear Regression Simple Regression Notes If you need guidance in terms of using Excel to run regressions, check pages 1 - 10 of the Excel - Linear Regression Tutorial posted to th

    		•
  • Q : Probability assignments 1. Smith keeps

    1. Smith keeps track of poor work. Often on afternoon it is 5%. If he checks 300 of 7500 instruments what is probability he will find less than 20substandard? 2. Realtors estimate that 23% of homes purchased in 2004 were considered investment properties. If a sample of 800 homes sold in 2

    		•
  • Q : Elasticity of Demand For the demand

    For the demand function D(p)=410-0.2p(^2), find the maximum revenue.

    		•
  • Q : Statistics Caterer determines that 37%

    Caterer determines that 37% of people who sampled the food thought it was delicious. A random sample of 144 out of population of 5000. 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 : 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 : Linear programming model of a Cabinet

    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 ce

    		•
  • Q : Explain Factorisation by trial division

    Factorisation by trial division: The essential idea of factorisation by trial division is straightforward. Let n be a positive integer. We know that n is either prime or has a prime divisor less than or equal to √n. Therefore, if we divide n in

    		•
  • Q : Problem on Nash equilibrium In a

    In a project, employee and boss are working altogether. The employee can be sincere or insincere, and the Boss can either reward or penalize. The employee gets no benefit for being sincere but gets utility for being insincere (30), for getting rewarded (10) and for be

    		•
  • Q : Examples of groups Examples of groups:

    Examples of groups: We now start to survey a wide range of examples of groups (labelled by (A), (B), (C), . . . ). Most of these come from number theory. In all cases, the group axioms should be checked. This is easy for almost all of the examples, an

    		•