Formulate the appropriate linear program

Assignment Help Operation Management
Reference no: EM13648985

Problem 1 :- In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in a following table. The plant supervior would like to assign jobs so that total time is minimized. Find the best solution. Formulate the appropriate linear program and solve uisng Excel Solver. Show your work.

COSTS Machine 1 Machine 2 Machine 3 Machine 4
A12 10 14 16 13 
A15 12 13 15 12 
B2 9 12 12 11 
B9 14 16 18 16 


Problem 2:  An air conditioning manufacturer produces room air conditioners at plants in Houston, Phoenix,an d Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver. The shipping costs vary, and the conpany would like to find the least-cost way to meet the demands at each of the distribution centers.

Dallas needs to receive 800 air conditioners per month, Atlanta needs 600, and Denver needs 200.
Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300.
The shipping cost per unit from Houston to Dallas is $8, to Atlanta is $12, and to Denver is $10. 
The cost per unit from Phoenix to Dallas is $10, to Atlanta is $14, and to Denver is $9. 
The cost per unit from Memphis to Dallas is $11, to Atlanta is $8, and to Denver is $12. 
Formulate the appropriate linear program and solve uisng Excel Solver. Show your work. 

Reference no: EM13648985

Questions Cloud

Water close to surface of oceanis hotter than deep water : At the tropics, the water close to the surface of the oceanis hotter than the deep water. Would the Second Law ofther modynamics be violated if a machine is been put to operate between these two water levels? Explain.
A curved portion of a highway under construction : A curved portion of a highway under construction has aradius of 520 m. The legal speed limit of this highway is 100 km/h. At what angle does this portion of the highway have to bebanked so that a car can safely travel at the speed limit when there ..
How much is corporation dividends-received deduction : For the current taxable year,  Corporation's gross income from operations was $1,000,000 and its expenses from operations were $1,500,000.  Corporation also received a $600,000 dividend from a 25 percent-owned corporation. How much is Corporation's d..
Identify one country in eastern asia : Identify one country in Eastern Asia (e.g., Japan, China, North Korea, South Korea, Macau, Taiwan, or Mongolia) to be the focus of your essay.
Formulate the appropriate linear program : In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in a following table. The plant supervior would like to assign jobs so that total time is minimized. Find the b..
How large is the frictional force : A force of 40.0 N accelerates a 5.0-kg block at 6.0m/s^2 along ahorizontal surface. How large is the frictional force
Evaluate the magnitude and direction of the friction force : You Push a 325 N trunk up a 20 degree inclined plane at a constantvelocity by exerting a 211 N force parallel to the plane's surface, what are the magnitude and direction of the friction force
Estimate what is the tangential speed of the ball : A 5.0 kg ball is whirled on a 1.2 m string so that the ballmoves in uniform circular motion above the horizontal plane. What is the tangential speed of the ball
Find the change in height of the brick : A lead brick with the dimensions (6.0 cm leftto right, 5.0 cm front to back and 2.0 cm top to bottom) rests on arough, solid surface. Find the change in height of the brick

Reviews

Write a Review

Operation Management Questions & Answers

  Evaluate the effectiveness of the police department

Suppose you have been asked to evaluate the effectiveness of the police department in a medium-sized community. Where would you begin, and how would you proceed?

  What is meant by a work breakdown structure

What is meant by a work breakdown structure, and how does it help manage projects?

  How could two companies with similar gross profit figures

How could two companies with similar gross profit figures end up with dramatically different net operating income.

  Determine theoretical number of workstations

An insurance company uses accompanying tasks to process paperwork. Forty claims need to be processed in an eight-hour day. Determine theoretical number of workstations.

  Calculate the profit of locations

The owner of Genuine Subs, Inc., hopes to expand the present operation by adding one new outlet. She has studied three locations. Each would have the same labor and materials costs of $1.60 cents per sandwich.

  Formulate and solve this lp production mix situation

The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling.

  Determine the range of demand probabilities

What is the decision to be made, what is the chance event and what is the consequence for this problem? How many outcomes are there for the chance event?

  How does a firm know they have the correct objectives

Citing reputable sources, explain why having objectives is a very important part of the business strategy and what happens when a firm does not identify "good" objectives. How does a firm know they have the correct objectives?

  Discuss debtor creditor relationship

The University of North is the major state university. The University was preparing for its upcoming re-accreditation, so the University board set aside extra funds to make sure that the professors could travel for research purposes.

  Why might deming and juran disagree with crosby

Crosby states that the ‘zero defects' concept is widely misunderstood and resisted. Explain the zero defects concept. Why might Deming and Juran disagree with Crosby that zero defects should be openly promoted as a goal?

  Annual carrying costs per pot are estimated

Garden Variety Flower Shop uses 750 clay pots a month. The pots are purchased at $2 each. Annual carrying cost per pot are estimated to be 30 percent of the cost and ordering costs are $20 per order

  Elucidate how many cs will be required

onsider the following bill of material. Fifty units of Product A are required. Assuming no on-hand inventory, explode the bill of material. If 17 Ps are required also no on-hand inventory exists for any items, elucidate how many Cs will be require..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd