1) Develop a network representation of the problem. You may reference the Network Diagram Template.
2) Formulate the problem as a linear program, with the optimal solution providing the hours each consultant should be scheduled for each client to maximize the consulting firm’s billings. What is the schedule and what is the total billing?
How do I solve number 2 using an excel spreadsheet, specifically solver?