Please help me solve my assignment which is a transportation problem through the use of excel solver.

3) TRANSPORTATION PROBLEM (Excel Solver, Spreadsheet) Royal Printing Corp (RSC) receives an order to print 100 pcs of Math books, 250 pcs of Science books, and 150 pcs of Reading books. RSC has 2 machines where these books can be printed. The older machine A produces a book at a rate of 6 pcs per hour, while the new machine B can print 10 books per hour. Assume that there are only 3.5 available working days to print all these books before its deadline. At 10 working hours per day, this translates to 35 hours availability of each machine. As a result of different book features (e.g., Science has a lot of colored pictures, while Reading is usually black-and- white text), cost of printing these books also depends on which machine they are printed. The cost per piece is shown below, in Php. Find the best book printing setup. Machine / Book Math Science Reading Machine A 21 19 27 Machine B 25 30 23