Question: Please solve the below with all steps and provide the screenshot of the answers that you solved by either Excel QM for windows or solver.

Please solve the below with all steps and provide the screenshot of the answers that you solved by either Excel QM for windows or solver.

Samsung sells its four flagship productscell phones, TVs, computing devices, and memory storage devicesthrough its exclusive showroom in a city. To support sales, it has hired 20 per-sons and trained them to service every product. Depending on the nature of the job, the cost of overhead expenses varies. The overhead cost of the cellphone section of the showroom per day is 70, for the TV section is 65, for the computing device section is 60, and for the memory storage section is 25. The store has allotted a budget of 1,000 for the showroom per day. A cell phone serviceman generates a revenue of 480 a day, a TV serviceman, 480, a computing devices serviceman, 450, and a memory storage section serviceman, 300. Each section needs at least two servicemen. The outlet wants to determine the number of servicemen to be assigned to each section that will maximize the revenue.

a. Formulate an integer programming model for this problem.

b. Solve this model by using the Excel QM for windows or solver.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!