Please use excel solver!

The Graphic Palette Carolina, that does graphic artwork and produces color and black-and-white posters, lithographs, and banners. The firm's owners, Kathleen and Lindsey Taylor, have been approached by a client to produce a spectacularly colored poster for an upcoming arts festival. The poster is more complex than anything Kathleen and Lindsey have previously worked on. It requires color screening in three stages, and the processing must proceed rapidly to produce the desired color effect. By suspending all their other jobs, they can devote three machines to the first stage, four to the second stage, and two to the last stage of the process. Posters that come off the machines at each stage can be processed on any of the machines at the next stage. However, all the machines are of different models and of varying ages, so they cannot process the same number of posters in the specified time frame necessary to complete the job. The different machine capacities at each stage are as follows: Because the machines are of different ages and types, the costs of producing posters on them differ. For example, 310 CHAPTER 6 TRANSPORTATION, TRANSSHIPMENT, AND ASSIGNMENT PROBLEMS a poster that starts on machine 1 and, then proceeds to machine 4 costs $18. If this poster at machine 4 is then processed on machine 8 , it costs an additional $36. The processing costs for each combination of machines for stages 1,2 , and 3 are as follows: Kathleen and Lindsey are unsure how to route the posters from one stage to the next to make as many posters as they possibly can at the lowest cost. Determine how to route the posters through the vanous stages for Graphie Palette to minimize costs