--%>
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 : Define Big-O notation Big-O notation :

    Big-O notation: If f(n) and g(n) are functions of a natural number n, we write f(n) is O(g(n)) and we say f is big-O of g if there is a constant C (independent of n) such that f

    		•
  • Q : How do it? integral e^(-t)*e^(tz) t

    integral e^(-t)*e^(tz) t between 0 and infinity for Re(z)<1

    		•
  • Q : Explain Black–Scholes model Explain

    Explain Black–Scholes model.

    		•
  • Q : Statistics math Detailed explanation of

    Detailed explanation of requirements for Part C-1 The assignment states the following requirement for Part 1, which is due at the end of Week 4: “Choose a topic from your field of study. Keep in mind you will need to collect at least [sic] 3- points of data for this project. Construct the sheet y

    		•
  • Q : Nonlinear integer programming problem

    Explain Nonlinear integer programming problem with an example ?

    		•
  • Q : First-order formulas over the

    Consider the unary relational symbols P and L, and the binary relational symbol On, where P(a) and I(a) encode that a is apoint and a (sraight) line in the 2-dimensional space, respectively, while On(a,b) encodes  that a is a point, b is a line, and o lies on b.

    		•
  • 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 : Pig Game Using the PairOfDice class

    Using the PairOfDice class design and implement a class to play a game called Pig. In this game the user competes against the computer. On each turn the player rolls a pair of dice and adds up his or her points. Whoever reaches 100 points first, wins. If a player rolls a 1, he or she loses all point

    		•
  • Q : Formulating linear program of a

    A software company has a new product specifically designed for the lumber industry. The VP of marketing has been given a budget of $1,35,00to market the product over the quarter. She has decided that $35,000 of the budget will be spent promoting the product at the nat

    		•
  • Q : Breakfast program if the average is

    if the average is 0.27 and we have $500 how much break fastest will we serve by 2 weeks

    		•