--%>
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 : What is the definition of a group Group

    Group: Let G be a set. When we say that o is a binary operation on G, we mean that o is a function from GxG into G. Informally, o takes pairs of elements of G as input and produces single elements of G as output. Examples are the operations + and x of

    		•
  • 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 : Use MS Excel to do the computations

    Select a dataset of your interest (preferably related to your company/job), containing one variable and atleast 100 data points. [Example: Annual profit figures of 100 companies for the last financial year]. Once you select the data, you should compute 4-5 summary sta

    		•
  • 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 : 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 : 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 : Formulating linear program of an oil

    An oil company blends two input streams of crude oil products alkylate and catalytic cracked to meet demand for weekly contracts for regular (12,000 barrels) mind grade ( 7,500) and premium ( 4,500 barrels) gasoline’s . each week they can purchase up to 15, 000

    		•
  • 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 : Problem on Linear equations Anny, Betti

    Anny, Betti and Karol went to their local produce store to bpought some fruit. Anny bought 1 pound of apples and 2 pounds of bananas and paid $2.11.  Betti bought 2 pounds of apples and 1 pound of grapes and paid $4.06.  Karol bought 1 pound of bananas and 2

    		•
  • Q : Econ For every value of real GDP,

    For every value of real GDP, actual investment equals

    		•