(An electronics Manufacturer, general description) An electronics manufactureris
ID: 3661525 • Letter: #
Question
(An electronics Manufacturer, general description) An electronics manufactureris producing and selling the following products: 1. ipods 2, dvd players 3. calculators 5. watches In addition to individual sales of each product, the company is also selling a bundle of am ipod and a watch. The products are commonly using the following resources: Ipod DVD CAL CAM WATCH electronic components 3 6 5 non-electronic components 2 10 3 12 assembly labor (minutes) 25 60 18 48 72 inspection labor (minutes) l 14 21 20 32 For the next ten weeks: demand of each product and the ipod-watch bundle, available electronics components. available non-electronics components. available assembly labor hours. available inspection labor hours, and unit production costs are provided in the excel table. Demand of each week must be satisfied within the week. The total worth of inventories at the end of each week should not exceed S120.000. The worth of inventory at the end of each week is computed by multiplying the amount of imentory by its production cost that week. Implement this LP problem in LINGO and prepare a minimum cost production plan for the company for the next 10 weeks.Explanation / Answer
Here is the lingo code....
-------------------------------------------------------------------------------------
MIN=8,250*IPOD+3150*DVD+19,470*CALCULATOR+7,520*CAMERA+15,690*WATCH+6,910*IPOD&WATCH:
8,250+3510+19,470+7,520+15,690+6,910<120,000:
SETS:
IPOD/WEEK1......WEEK10/:PRODUCTION COST
DVD/WEEK1......WEEK10/:PRODUCTION COST
CALCULATOR/WEEK1......WEEK10/:PRODUCTION COST
CAMERA/WEEK1......WEEK10/:PRODUCTION COST
WATCH/WEEK1......WEEK10/:PRODUCTION COST
IPOD&WATCH WEEK1......WEEK10/:PRODUCTION COST
ENDSETS
MIN_COST=@MIN(IPOD(J):PRODUCTION COST(J));
MIN_COST=@MIN(DVD(J):PRODUCTION COST(J));
MIN_COST=@MIN(CALCULATOR(J):PRODUCTION COST(J));
MIN_COST=@MIN(CAMERA(J):PRODUCTION COST(J));
MIN_COST=@MIN(WATCH(J):PRODUCTION COST(J));
MIN_COST=@MIN(IPOD&WATCH(J):PRODUCTION COST(J));
SETS
DAYS/MO,TU,WE,TH,FR,SA,SU/:COST;
ENDSETS
DATA:
COST=$120,000;
ENDDATA
IPOD=
900+610+850+740+450+1110+1030+840=8250
DVD=
440+220+430+290+440+260+320+240+580+290=3510
CALCULATOR=
1920+1530+1860+2000+1950+2270+2410+1750+1790+1990=19470
CAMERA=
670+740+740+810+730+900+750+800+710+670=7520
WATCH=
1400+1600+1630+1710+1400+2030+1400+1450+1740+1330=15690
IPOD+WATCH=
510+660+650+620+600+700+600+850+900+820=6910
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.