Three clients have asked the accounting firm of Abramowitz and Jones (A&J) to prepare their tax...

Transcribed Image Text:

Three clients have asked the accounting firm of Abramowitz and Jones (A&J) to prepare their tax returns. Since it is the busy season, there are only four accountants available and each of them can prepare only one return. The difficulty of the work is different for each client and the skills of the accountants also vary. The hours each accountant will require to complete the return for each client is as follows: Accountant Aachen Bashar Chopra Dac Xue 225 250 270 240 Client Yeseghian 315 350 350 360 Zischke 400 330 340 350 A&J wants to assign accountants to the three projects to minimize the total work time required. a. Formulate a linear program to determine which accountant to assign to which client. b. Create an Excel spreadsheet of the program and use it to find the solution. e. What happens to the solution if Dae needs 250 hours to complete Xue's return instead of 240 hours? d. What happens to the solution if Dae needs 205 hours to complete Xue's return instead of 240 hours? e. What happens to the solution if Chopra needs 370 hours to complete Zischke's return instead of 340 hours? f. What happens if Zischke requires two accountants instead of one? Three clients have asked the accounting firm of Abramowitz and Jones (A&J) to prepare their tax returns. Since it is the busy season, there are only four accountants available and each of them can prepare only one return. The difficulty of the work is different for each client and the skills of the accountants also vary. The hours each accountant will require to complete the return for each client is as follows: Accountant Aachen Bashar Chopra Dac Xue 225 250 270 240 Client Yeseghian 315 350 350 360 Zischke 400 330 340 350 A&J wants to assign accountants to the three projects to minimize the total work time required. a. Formulate a linear program to determine which accountant to assign to which client. b. Create an Excel spreadsheet of the program and use it to find the solution. e. What happens to the solution if Dae needs 250 hours to complete Xue's return instead of 240 hours? d. What happens to the solution if Dae needs 205 hours to complete Xue's return instead of 240 hours? e. What happens to the solution if Chopra needs 370 hours to complete Zischke's return instead of 340 hours? f. What happens if Zischke requires two accountants instead of one?

Answer rating: 100% (QA)

a Linear Program Formulation Lets denote the decision variables as Xij Hours Accountant ii spends on Client j The objective is to minimize the total work time required Minimize Z 225X11 250X12 270X13 ... View the full answer