Question

please do it in microsoft exel transpo oprtn logitics management

Inventory Control Problem In preparation for the winter season, a clothing company is manufacturing parka and goose overcoats, insulated pants, and gloves. All products are manufactured in four different departments: cutting, insulating, sewing, and packaging. The company has received firm orders for its products. The contract stipulates a penalty for undelivered items. Devise an optimal production plan for the company based on the following data: Time per n hr ks Dpmnt Ge paty h Cuing as 0004 1000 ating 38 0 as Pakagng Demand S0 s3 Ui py A company supplies goods to three customers, who each require 30 units. The company has two warehouses. Warehouse 1 has 40 units available, and warehouse 2 has 30 units available. The costs of shipping 1 unit from warehouse to customer are shown in Table below. There is a penalty for each unmet customer unit of demand: With customer 1, a penalty cost of $90 is incurred; with customer 2, $80; and with customer 3, $110. Formulate a balanced transportation problem to minimize the sum of shortage and shipping costs To Custamer 3 From Castomer 1 Custemer 2 $35 $25 Wareheuse 1 $10 $50 $40 Warehouse 2

Answer 1

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE TTHERE TO HELP YOU..ALL THE BEST..

AS FOR GIVEN DATA...

Let A represent no of Parka produced

B be number of Goose Produced

C be number of Number of Pants

and D be number of Gloves

A' , B' ,C' and D' are shortages in production if any. The range of these variables will be from 0 to Demand

Out objective is to plan our production to maximise net profit (Profit-Penalty)

Marimize P 30.A40B 20C10D 15A 20B- 10C -8D s.t 0.3A 0.3B 0.25C0.15D 1000 0.25 A 0.35B 0.30C0.10D< 1000 0.45.A 0.50B0.40C0.22D< 1000 0.15.4 0.15B 0.10C0.05D< 1000 0 A 800 0< B< 750 0 < C< 600 0 D<500

I HOPE YOU UNDERSTAND..

PLS RATE THUMBS UP..ITS HELPS ME ALOT..

THANK YOU...!!