Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company manufactures three products, P1, P2, and P3, with a unit profit of R$10, R$5 and R$4, respectively. The production manager identified the following

A company manufactures three products, P1, P2, and P3, with a unit profit of R$10, R$5 and R$4, respectively. The production manager identified the following restrictions in the production process: . The total production capacity is 600 units per month. . By using perishable material, the company receives at the beginning of the month a shipment of 1 Ton of material that has to be fully used within of the month . The required quantities of perishable material to manufacture the product are 2Kg, 1Kg, and 3Kg respectively. The market in the current situation demands that exact 25 weekly units of P1, a minimum of 50 weekly units of P2, and P3. You are asked to calculate by Excel Solver, the monthly production schedule and its respective profit, in addition to the production capacity and raw material slacks, knowing that the company works 4 weeks a month, and five days per week

PS: Solve by SOLVER EXCEL.

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

The Restaurant From Concept to Operation

Authors: John R Walker

6th Edition

9781118139950, 470626437, 111813995X, 978-0470626436

More Books

Students also viewed these General Management questions