Manufactures two home appliances

Assignment Help Operation Management

Reference no: EM131745620

Bearkats Inc. manufactures two home appliances: a microwave and a coffee maker. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each microwave takes 3 hours of wiring and 2 hours of drilling. Each coffee maker goes through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time and 140 hours of drilling time are available. Each microwave sold has a profit of $25 and each coffee maker sold has a profit of S15. a) Formulate this problem as a linear program to determine the best combination of the 2 product that yields the highest profit. Include the objective, decision variables, and constraints. b) Solve the problem presented in part (a) using Microsoft Excel solver. Remember to upload your Excel file and label the objective function, constraints and decision variable cells clearly in your file.

Reference no: EM131745620

Questions Cloud

Describe the purpose of a strategic plan : Describe the purpose of a strategic plan - Explain why multiple stakeholders are important to the strategic planning process

Correlation in percent of classes attended and grade index : Class attendance and grades. A study of class attendance and grades among first-year students at a state university showed that in general students.

Calculate the projects return on investment : Calculate the projects return on investment, List and describe five potential benefits of decentralization

Create a fictional climograph for your city : Create a fictional climograph for your city that simultaneously displays a bar graph for monthly precipitation and a line graph for average monthly temperature.

Manufactures two home appliances : Bearkats Inc. manufactures two home appliances: a microwave and a coffee maker.

What is the probability that a randomly selected driver : Fuel Consumption and Cars An automobile insurance policy depends on many factors, What is the probability that a randomly selected driver is paid $5000

Find the predicted value of fat gain : Find the predicted value and the residual. Another individual in the NEA data set has NEA increase equal to 143 calories and fat gain equal to 3.2 kg.

Discuss depreciation and amortization expense : During 2015, Rindal Vinyards Inc. had EBITDA of $1000, Depreciation and Amortization Expense of $200, Interest Expense of $100

Create a relational database to keep track of our employees : Create (that is, define the structure of) the necessary tables to define this database in Access. Give the entire database this name.

User Account

All Pages