Formulate the LP model for given problem

Assignment Help Management Information Sys

Reference no: EM132667162

Question: The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 3 hours of wiring and 2 hour of testing and can be sold for a $275 profit. Each alternator requires 3 hours of wiring and 3 hours of testing and can be sold for a $190 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period and Electrotech wants to maximize profit.

1. Formulate the LP model for this problem.
2. Create the spreadsheet model and use Solver to solve the problem.

Attachment:- excersice P6-21.rar

Reference no: EM132667162

Questions Cloud

Study-innovation at ikea : Redecorating and renovating have become a popular international pastime. In a world facing persistent terrorist alerts and lagging economies

Find what amount should be reported as inventory on december : What amount should be reported as inventory on December 31, 2020? Sam Company's inventory at December 31, 2020 was P1,000,000 based on physical count priced.

Apply relevant information underlying goal setting : Demonstrate the ability to analyze and apply relevant information underlying goal setting, job-related task criteria, and business decision making

Explain trauma informed care in detail : Explain Trauma Informed Care in detail. How you can use Trauma Informed Care to assist a child who has been impacted by trauma?

Formulate the LP model for given problem : Formulate the LP model for this problem and Create the spreadsheet model and use Solver to solve the problem - next production period and Electrotech wants

How assessment is similar and dissimilar at macro level : Describe the assessment process as related to individuals and families. Compare how assessment is similar and dissimilar at the macro level.

What does diversify means in finance : What does diversify means in finance? What are ways in which people diversify? How does it benefit on organization? Why do organizations diversify?

Find what will cost fl : Using a range of units produced from 1,400 to 4,300, and a range of total costs from $37, 000 to $42,000, producing 1,800 units will cost FL

Find how cost of goods sold for the month of june should be : Find how the cost of goods sold for the month of June should be increased (decreased) by the amount of over/under applied factory overhead of

User Account

All Pages