Please answer in excel thanks a lot. Please teach me the process, please answer step by step. I need process and results.

A building supply has two locations in town. The office receives orders from two customers, aach requiring 3/4-inch plywood. Customer A needs fifty sheets and Customer B needs ieventy sheets. The warehouse on the east side of town has 80 sheets in stock; the west-side warehouse has 45 theets in stock. Delivery costs per sheet are as follows: $0.50 from the eastern warehouse to Customer A, \$0.60 from the eastern warehouse to Customer B, \$0.40 from the western varehouse to Customer A, and $0.55 from the western warehouse to Customer B. a. Find the shipping arrangement that minimizes costs. (Copy the Relevant part of the Excel worksheet below with the answer) (10 points) b. If customer B needs 5 more sheets, what is the absolute minimum you should charge them? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) (5 points) c. If you find out that the west warehouse has only 41 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) (5 points) d. If you find out that the East Side Warehouse has 84 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report to provide the answer to this question.) (5 points)