Please show full working and forumlas for the solution

Question 1 (20 MARKS) Vaccine Supplies Limited (VSL) has been contracted to deliver H1N1 vaccines to various regional health centres. The cost of delivery to various regional health centres from five (5) of VSL's warehouses is shown in Table 1 (below): Table 1. Vaccine Supplies Limited cost of delivery to regional health centres schedule Table 2 (below) shows, the number of batches of H1NI vaccines that each warehouse is able to supply on a monthly basis and the number of batches of H1N1 vaccines required by each regional centre on a monthly basis: Table 2. Supply and Demand information for VSL and Regional Health Centres a) Determine the number of batches to transport from each warehouse to each regional centre on a monthly basis and the associated cost, in order to minimize the total cost of transportation, using the following: i. The Northwest Corner Rule (5 Marks) ii. The Intuitive Lowest-Cost Method (5 Marks) iii. Linear Programming using Microsoft Excel Solver (10 Marks) TOTAL 20 MARKS