Use Excel and solver to solve the following problem

ClockCo has four factories that produce deluxe grandfather clocks. Plants Orlando, Kissimmee, and Daytona can each produce 100 grandfather clocks per day. Plant Jacksonville can produce 50 grandfather clocks per day. Each day, the grandfather clocks produced in the factories must be shipped to satisfy the demand of 3 customers. Customer Alex requires 75 grandfather clocks per day, customer Beatrice requires 100 grandfather clocks per day, and customer Camile requires 175 grandfather clocks per day. The shipping costs for each possible route are shown in the table below: Shipping Costs Customer per unit Plant A Orlando $ 25 $ 35 $ 15 Kissimmee $ 20 $ 30 $ 40 Daytona $ 40 $ 35 $ 20 Jacksonville $ 15 $ 20 $ 25 The company needs to satisfy all demand each day, but would like to minimize the total costs