Question: 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.

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

PLEASE PROVIDE FULL STEP BY STEP EXCEL WORK Given the increase in remote work and the popularity of business casual, a popular clothing manufacturer decided to discontinue their women's professional...

ITEC355-001 Homework 1.pdf Open with Preview ITEC-355-001 Homework 1 General Instructions This assignment is worth 7% of your total grade and evaluates your ability to solve a capacity/optimization...

Evaluate and rate this: Nike: Nike's most recent 10-k says that Nike was incorporated in 1967. Nike bases their principal business activities on the "design, development, and worldwide marketing and...

As women clothing styles have transitioned to more casual, a popular clothing line is looking to revamp their production to include the following new products: yoga pants, hoodies, sweatshirts, and...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Please answer the part EFGH. thanks! Question 5. (22 points) OPTIMAL PRODUCT MIX AND WHAT-IF QUESTIONS AU Electronics manufactures is the supplier of components C1, C2 and C3 for the production of...

In preparation for the winter season, a clothing company is manufacturing shirts and caps, pants, and gloves. All products are manufactured in four different departments: cutting, insulating, sewing,...

please solve asap with steps (12.5 pts) Q.3 Comfortable Hands" is a company that features a product line of winter gloves for the entire family - men, women, and children. They are trying to decide...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Show the products of thesereactions: CH NaOH Br2 Bra b) a) . .

Is it true that crushed fruits are not used for the commercial production of wine and alcohol? Options: 1) True 2) False

5 - 2 7 C What are the three major assumptions used in the derivation of the Bernoulli equation?

Use sentence structure. Write one or more sentences to tell members of a school jazz band that their application to perform in a parade at Disneyland has not been accepted. Use sentence structure to...

Use mechanical means. Use mechanical means in a sentence to emphasize the importance of attending a business seminar on job interviews.

Use format. Use format in a sentence to emphasize the number of students in your graduating class who will continue their education.