Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A firm is planning to produce 3 products P1, P2, and P3 over a time horizon of 4 months (January to April). Demand for the

image text in transcribed

A firm is planning to produce 3 products P1, P2, and P3 over a time horizon of 4 months (January to April). Demand for the products over the months is as follows: Demand P1 January 5300 4500 4400 February 1200 5400 6700 March April 7400 5300 6500 7200 1250013200 P2 P3 Sales prices, production costs, production quotas, and setup costs are: P1 Product Sales price Setup cost Production cost Daily production quota $124 $150,000 $73 P2 $109 $150,000 $52 450 P3 $115 $100,000 $65 550 500 There are 23 production days in January, 20 in February, 23 in March and 22 in April. The setup of a production line can be changed every month. Moreover, storage space can be rented at monthly rates of $3.50 per unit for P1, $4.00 per unit for P2, and $3.00 per unit for P3. Each product takes the same amount of storage space. The total available storage space can accommodate up to 1200 units. Formulate a mixed-integer program (MIP) to maximize the profit. Use Microsoft Excel Solver to solve your MIP formulation. Submit your Excel file as well as a report (PDF or MS Word document) describing the LP formulation, the optimal solution, and the optimal objective value found. A firm is planning to produce 3 products P1, P2, and P3 over a time horizon of 4 months (January to April). Demand for the products over the months is as follows: Demand P1 January 5300 4500 4400 February 1200 5400 6700 March April 7400 5300 6500 7200 1250013200 P2 P3 Sales prices, production costs, production quotas, and setup costs are: P1 Product Sales price Setup cost Production cost Daily production quota $124 $150,000 $73 P2 $109 $150,000 $52 450 P3 $115 $100,000 $65 550 500 There are 23 production days in January, 20 in February, 23 in March and 22 in April. The setup of a production line can be changed every month. Moreover, storage space can be rented at monthly rates of $3.50 per unit for P1, $4.00 per unit for P2, and $3.00 per unit for P3. Each product takes the same amount of storage space. The total available storage space can accommodate up to 1200 units. Formulate a mixed-integer program (MIP) to maximize the profit. Use Microsoft Excel Solver to solve your MIP formulation. Submit your Excel file as well as a report (PDF or MS Word document) describing the LP formulation, the optimal solution, and the optimal objective value found

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Electronics Data Processing Systems

Authors: WATNE

1st Edition

0130516163, 978-0130516169

More Books

Students also viewed these Accounting questions

Question

1. Identify and control your anxieties

Answered: 1 week ago