Bearkats inc manufactures two home appliances a microwave


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.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Bearkats inc manufactures two home appliances a microwave
Reference No:- TGS02541133

Expected delivery within 24 Hours