i need the answer quickly A factory manufactures three products namely X, Y and Z.Each of the product require processing on threemachines, Turning, Milling and Grinding. Product Xrequires 10 hours of turning, 5 hours of milling and 1 hourof grinding. Product Y requires 5 hours of turning, 10hours of milling and 1 hour of grinding, and Product Zrequires 2 hours of turning, 4 hours of milling and 2 hoursof grinding. In the coming planning period, 5000 hours ofturning, 2500 hours of milling and 1250 hours of grindingare available. The profit contribution of X, Y and Z are 10$, 15 $ and 20 $ per unit respectively. By using simplexmethod, find the optimal product mix to maximize theprofit=X=Y=Z=Z(Max.)

make a table for the data as follows X Y Z availability turning 10 5 2 5000 milling 5 10 4…

Answered: A factory manufactures three products…

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter6: Linear Systems

Section6.8: Linear Programming

Problem 5SC: If during the following year it is predicted that each comedy skit will generate 30 thousand and...

See similar textbooks

Similar questions

If during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.
The workers of the company "Malova" work in a 5-day work week and worked them for 22 days in the month of November 2020. The standard work schedule is 8 hours per day with a 30-minute break included in this time. Now, "Malova's" company is in the process of manufacturing screwdrivers and manufactured 3100 pieces of screwdrivers. In addition, the company manufactures screwdrivers in batches of 300 and after each batch makes a pause to check the quality of production and make certain adjustments to the machines if necessary. The break is 1 hour. Calculate the parts produced per hour by the Malova company in November. Important: Use the formula (the one I put in the image)
Infotron Inc makes electronic hockey and soccer games. Each hockey game requires 2 labor-hours of assembly and 2 labor-hours of testing. Each soccer game requires 3 labor-hours of assembly and 1 labor-hour of testing. each day there are 53 labor-hours available for assembly and 35 labor-hours available for testing. how many of each game should Infotron produce each day to maximize its total daily output?
Infotron Inc makes electronic hockey and soccer games. Each hockey game requires 2 labor-hours of assembly and 2 labor-hours of testing. Each soccer game requires 3 labor-hours of assembly and 1 labor-hour of testing. Each day there are 63 labor-hours available for assembly and 33 labor-hours available for testing. How many of each game should Infotron produce each day to maximize its total daily output?
Solve step by step in digital format 3. Graph and conclude according to the variable under study, productions were taken in tons of corn, sorghum and beans in three different regions of the country and the following was found in the northern zone: 500, 400, 200, respectively, for the central region the following 700,500,500 were found and for the southern region the following 1000,700,300.
A company that produces two kinds of office tables, T1 and T2. It takes 2 hours to produce the parts of one unit of T1, 1 hour to assemble and 2 hours to polish. It takes 4 hours to produce the parts of one unit of T2, 2.5 hour to assemble and 1.5 hours to polish. Per month, 7000 hours are available for producing the parts, 4000 hours for assembling the parts and 5500 hours for polishing the tables. The profit per unit of T1 is $90 and per unit of T2 is $110. COMPUTE THE DUAL PRICE
Newyork University Building 8 has a 15-story structure. Mr. Raju works on the 11th floor of this building. Except for stopping on a floor where the button has been pressed, the single elevator travels endlessly between floors 1,2,3,..., 14,15,14,...,3,2,1. Assume that the amount of time required to load and unload passengers is minimal compared to the actual trip time.Mr. Raju always wonders when he is about to leave his office at 6 PM, most of the time, the lift goes up before stopping at his floor. One day, Raju encounters you in the lift and shared his thoughts with you. Since you are taking Discrete Mathematics course, he expects you to solve the mystery for him. Provide a valid explanation in terms of probability to Mr. Raju.
The JAV Company manufactures two types of lamps; Special lamp and regular lamp. Each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machine, The company's machine are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from Hongkong. The importation of these bulb is limited to 200 units. The contribution to profit of each special lamp and regular lamp are P400 and P360 respectively. Question: What will happen to the optimal solution if the unit profit on both x and y change to 700? Solve this problem in three ways: 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report.
The 1-Dream company makes two different BLU-ray players, which are assembled on two different assembly lines. Line 1 can assemble 40 units of the BLU-Ray player and 55 units of the BLU-Ray player with DVR per hour, and line 2 can assemble 110 units of the BLU-Ray player and 195 units of the BLU-Ray player with DVR per hour. The company needs to produce at least 3,989 BLU-Ray players and 6,755 BLU-Ray player with DVR to fill an existing order. It cost $100 per hour to run line 1 and $310 per hour to run line 2, how many hours should each line run to fill the order at minimum cost? (Use x for line 1 hours and y for line 2 hours.) Minimize C= ≥ 3,989 6, 755 Enter the solution to the simplex matrix below. If there is no solution enter 'DNE' in the boxes below. If more than one solution exists, enter only one of the multiple solutions below. If needed round hours to 1 decimal place and cost to 2 decimal places. Number of hours to run line 1 is Minimum cost is $ Number of hours to run line 2…
A constant number of files are processed daily at Mehenti Carobar (MC) Pvt. Ltd. Three clerks can do the processing. To process MC’s daily files, the Senior clerk takes 2 hours more than the Head clerk; while the Junior clerk takes six more hours than the Senior clerk to process the same files. When working together, the Senior clerk and the Junior clerk can process a day’s files in just four hours. Today, Junior clerk has reported sick. How much time will it take the Head clerk and the Senior clerk, working together, to process MC’s daily files?
RFC company manufactures two types of lamps: special lamp and regular lamp. each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply is limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machines. The company's machines are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from Hongkong. The importation of these bulbs is limited to 200 units. The contribution to profit of each special lamp is $400 and $360 on the regular lamp. How many units of the special lamp and regular lamp should be produced per production period in order to maximize the profit.
I only want to know how to input the formulas into an excel spreadsheet for both step 2 and 3. Every time that I try it, it goes haywire. I know it can be done, I am just not getting it all done on the same sheet as I think I am supposed to do. HELP

SEE MORE QUESTIONS

Recommended textbooks for you

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Elementary Geometry for College Students

Geometry

ISBN:

9781285195698

Author:

Daniel C. Alexander, Geralyn M. Koeberlein

Publisher:

Cengage Learning

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Elementary Geometry for College Students

Geometry

ISBN:

9781285195698

Author:

Daniel C. Alexander, Geralyn M. Koeberlein

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

A factory manufactures three products namely X, Y and Z. Each of the product require processing on three machines, Turning, Milling and Grinding. Product X requires 10 hours of turning, 5 hours of milling and 1 hour of grinding. Product Y requires 5 hours of turning, 10