WEEK 5 ASSIGNMENT .docx - a. Formulate the problem as a...

• 8
• 100% (11) 11 out of 11 people found this document helpful

This preview shows page 1 - 3 out of 8 pages.

The preview shows page 1 - 3 out of 8 pages.
a.Formulate the problem as a linear program, with the optimal solution providing the hours eachconsultant should be scheduled for each client to maximize the consulting firm’s billings. What is theschedule and what is the total billing?.
Max100x11+125x12+115x13+100x14+120x21+135x22+115x23+120x24+155x31+150x32+140x33+130x34s.t.1x11+1x12+1x13+1x141601x21+1x22+1x23+1x241601x31+1x32+1x33+1x341401x11+1x21+1x31=1801x12+1x22+1x32=751x13+1x23+1x33=1001x14+1x24+1x34=85xij≥ 0 for alli,jb.Hours AssignedBillingAvery-Client A0\$0Avery-Client B405000Avery-Client C10011500Avery-Client D00Baker-Client A404800Baker-Client B354725Baker-Client C00Baker-Client D8510200Campbell-Client A14021700Campbell-Client B00Campbell-Client C00Campbell-Client D00
Total Billing\$57925d.e.New information shows that Avery doesn’t have the experience to be scheduled for client B. Ifthis consulting assignment is not permitted, what impact does it have on total billings? What is therevised schedule?Hours AssignedBillingAvery-Client A40\$4000Avery-Client B00Avery-Client C10011500Avery-Client D00Baker-Client A00Baker-Client B7510125Baker-Client C00Baker-Client D8510200Campbell-Client A14021700Campbell-Client B00Campbell-Client C00Campbell-Client D00Total Billing\$57525Chapter IntroductionProblem 10-07 (Algorithmic)Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Itsmain power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table showsAggie Power Generation's major residential markets, the annual demand in each market (in megawattsor MWs), and the cost to supply electricity to each market from each power generation plant (pricesare in \$/MW).Distribution CostsCityLos AngelesTulsaSeattleDemand (MWs)Seattle\$348.25\$585.75\$51.38942.00Portland\$380.25\$617.75\$202.13855.25San Francisco\$157.13\$454.00\$275.882354.00Boise\$357.25\$476.00\$297.88594.75Reno\$222.50\$460.00\$341.25935.00Bozeman\$442.63\$442.63\$323.88520.15Laramie\$380.25\$439.63\$380.251211.50Park City\$377.25\$377.25\$496.00624.25

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 8 pages?