Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SOLVE THIS WITH EXCEL SOLVER. I NEED EXCEL SOLVER SOLUTION. Problem: A clothing company manufactures coats, pants, gloves, and hats for the winter season.

PLEASE SOLVE THIS WITH EXCEL SOLVER. I NEED EXCEL SOLVER SOLUTION. image text in transcribed
Problem: A clothing company manufactures coats, pants, gloves, and hats for the winter season. All products are manufactured in four different departments: cutting, insulating, sewing, and packaging. According to firm orders, the contract stipulates a penalty for undelivered items. Considering the data in the table, formulate the problem to obtain an optimal production plan. Mathematical model: Indexes i=1,2,3,4 (products, respectively) Decision variables xi: The number of ith product to be produced si: The demand for tth product which is not met Model Maxz=30x1+40x2+20x3+10x4(15s1+20s2+10s3+8s4) St, 0,30x1+0,30x2+0,25x3+0,15x41000 0,25x1+0,35x2+0,30x3+0,10x4800 0,45x1+0,50x2+0,40x3+0,22x41200 0,15x1+0,15x2+0,10x3+0,05x41080 x1+s1=800x2+s2=750 x3+s3=600x4+s4=500 xi,si0i

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

Guide To Conducting Internal Audits Of Your Management Systems

Authors: Martin Pykett

1st Edition

B099C3GPMH, 979-8538997749

Students also viewed these Accounting questions