Step 1: Open a blank Excel spreadsheet. Step 2: 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 B 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. Step 3: Save your file as lastnameclocks (You must save your file to your computer's desktop rather than to the cloud. If your file begins with a "$", this means that it is a temporary file, and I will not be able to open it, which result in 0 points.) Step 4: Upload your completed Excel file