Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started