answer this question using solver function in excel only.

3-Points B A Question 03: TAPS Plumbing D H 3-Points TAPS, a plumbing supply store, has two locations - one in Penticton and one in Vernon. Today, the office received orders from two contractors, each requiring the same model of bathtub to be delivered. The first contractor in Kelowna needs fifty tubs and the second contractor in Peachland needs seventy tubs. TAPS-Penticton has eighty tubs in stock, while TAPS-Vernon has forty-five tubs in stock. Delivery costs per tub are as follows: $15.00 from Penticton to Peachland, $17.00 from Penticton to Kelowna, $16.00 from Vernon to Peachland, and $14.00 from the Vernon to Kelowna. Find the best possible shipping arrangement for TAPS to minimize their total delivery costs