Formulate the lp problem to determine the optimum production

Assignment Help Operation Management

Reference no: EM13747962

Problem 1

Consider the Reddy Mix problem

(a) Implement and solve this optimization problem using Excel Solver.

(b) Produce the sensitivity reports and explain meaning of each column in the report

(c) Introduce a new product ("ecopaint") into the problem that requires 2 units of raw material Ml and 1 unit of raw material M2. Other constraints are not affected. What should be the minimal price of the new product at which it is profitable to produce non-zero quantity of it?
Hint: Start with 0 price

(d) Explain how the shadow prices, dual prices and reduced costs are related using the results from parts a,b and c.

Problem 2

Acme Manufacturing Company has received a contract to deliver home windows over the next 6 months. The successive demands for the 6 periods are 100, 250, 190, 140, 220, and 110 units, respectively. Production cost per window varies from month to month depending on the cost of labor, material, and utilities. Acme estimates the production cost per window over the next 6 months to be $50, $45, $55, $48, $52, and $50, respectively. To take advantage of the fluctuations in manufacturing cost, Acme may elect to produce more than is needed in a given month and hold the excess units for delivery in later months. This, however, will incur storage costs at the rate of SS per window per month assessed on end-of-month inventory.

(a) Formulate the LP problem to determine the optimum production schedule that minimizes the total costs.

(b) Implement and solve this optimization problem using Excel Solver

(c) Assuming that one employee can produce 10 windows a month. What will be the minimal number of employees required in each month.

(d) Assuming that each employee must get one month vacation after 5 consec¬utive working month, and each employee gets $15000 for the half year period. Add necessary variables and constraints to the initial problem and decide how many employees should work in the company (still minimizing the total costs).

Problem 3

A manufacturing company has a production plan where they produce 21 unit every week for the next 50 weeks. However, the demands and related costs (production and inventory) are fluctuating from week to week due to some external factors. Therefore, some overproduction and high inventory costs are encountered.

The demands, costs and the current production plan can be found in the attached excel file. Formulate the optimization problem and re-optimize the production plan.

Reference no: EM13747962

Questions Cloud

A competitive advantage for the organization : Select an organization with which all of your classmates would be familiar. Select a process in which your selected organization engages on a regular basis. Describe a company that would be considered a "leader" in the business process that you ha..

Explain the need for a budget contingency plan : Question 1: Explain the need for a budget contingency plan Question 2: Identify two (2) events or problems that could occur in which a budget contingency plan is needed.

Construct a house of quality to provide the organization : Imagining yourself to be the customer, construct a House of Quality to provide the organization with your perspectives on what the important dimensions of quality are and how well the organization is currently meeting your needs.

Why is access to health services important : Why Is Access to Health Services Important-Access to wellbeing administrations implies the convenient utilization of particular wellbeing administrations to attain the best wellbeing outcomes.1 It obliges 3 unique steps:

Formulate the lp problem to determine the optimum production : Formulate the LP problem to determine the optimum production schedule that minimizes the total costs.

Patterns in human inheritance traits : Patterns in Human Inheritance Traits-Is your hypothesis supported by the findings? What statistical tool might help you to make this decision

How to submit your american art project : How to Submit Your American Art Project? What is the artist trying to portray with the image? What feelings is he trying to evoke?

Discuss organizational interventions to recommend : Discuss organizational interventions to recommend. Take into consideration your previous diagnosis and the emotional state of your employees from your interview.

Implement a database based on the provided er diagram : Analyse and comprehend a provided ER diagram and Database Schema - To implement a database based on the provided ER diagram and Database Schema.

User Account

All Pages