Question a car manufacturer has three assembly lines plant, Ask an Expert

Management Studies

Question: A car manufacturer has three assembly lines, Plant A, B, and C and three distribution centers: Center I, II, and III. Every day, Plant A can assemble at most 200 cars, Plant B can assemble 150 cars, and Plant C can assemble 250 Cars. Distributor I requires at least 120 cars/day. Distribution II requires at least 270 cars a day and Distribution III requires at least 200 cars a day. The cost for transpiration one car is given as

	Plant A	Plant B	Plant C
Distributor 1	$230	$150	$190
Distributor 2	$410	$320	$130
Distributor 3	$210	$230	$200

Please answer the following questions:

(1) Formulate the LP Model;

(2) Solve this problem using optimization tools such as Excel solver. Please make sure to attach the excel table as part of the solution.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92672071

Have any Question?Write your Review or question?

Related Questions in Operation Management

All question must be minimum words 1000do the

All Question must be minimum words 1000 DO THE RESEARCH Company StarBuck 1. For Starbuck Company write one corporate aim and one objective within the limitations of the department (customers, time, ethical and legal requ ...

In this particular scenario you are taking the perspective

In this particular scenario, you are taking the perspective of a contractor who has identified a possible instance of fraud. Respond to one of the questions below. There are no right or wrong answers. You are a mid-level ...

The following questions are ldquobad questionsrdquo due to

The following questions are “bad questions” due to one of the following reasons: recall dependent, loaded, socially desirable, ambiguous, leading, and double-barreled. For each question associate the appropriate reason. ...

Letrsquos model the market for maple syrup of a small

Let’s model the market for maple syrup of a small fictional economy. We start by making assumptions on consumer’s preferences so as to derive the market demand. Suppose 2,000 families live in the small country and that t ...

A corporation decided to repurchase stock of a shareholder

A corporation decided to repurchase stock of a shareholder who recently died. The corporation was in existence for three years and had lost $50,000 during this period. The original shareholders had invested $25,000 in th ...

A study-aid desk staffed by a graduate student has been

A study-aid desk staffed by a graduate student has been established to answer students' questions and help in working problems in your OSCM course. The desk is staffed eight hours per day. The dean wants to know how the ...

1 describe your expectations for a job how well does your

1. Describe your expectations for a job. How well does your employer meet the expectations you bring to the psychological contract? 2. Assess the Gildan Activewear actions and responses regarding employment issues in Hon ...

The frequency of users at an atm machine is estimated at an

The frequency of users at an ATM machine is estimated at an average of 15 people arriving every 30 mins. Assuming the arrival times are exponentially distributed and each customer may spend anywhere between 1-5 minutes a ...

1 undertake research find out what options are available to

1. Undertake research; find out what options are available to digitally sign master files before storage. Write a 1 to 2 page report in which you set out your findings including the benefits of digital signatures and the ...

What is transformational leadership why do people consider

What is transformational leadership? Why do people consider Walt Disney to be a transformational leader? How do these types of leaders change industries, communities, and influence society? What characteristics do they h ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert