Step 1: Open a blank Excel spreadsheet. Do not use a template.

Step 2: Use Excel to solve the following problem.

A local market wants to produce Blueberry, Apple and Peach pies. Each blueberry pie sold has a profit of $17, each apple pie sold has a profit of $15, and each Peach pie sold has a profit of $16.

The market has one small oven available that can bake one pie at a time. The oven can bake an apple pie in 19 minutes, a blueberry pie in 17 minutes, and a peach pie in 14 minutes. The oven is available for 6 hours per day.

Pies require cooling time. An apple pie cools in 25 minutes, a blueberry pie cools in 28 minutes, and a peach pie cools in 20 minutes. There are 8 hours available on one cooling rack for one pie at a time.

The owner of the store is trying to determine how to best use the resources available. Solve this problem in Excel using solver to determine how many of each type of pie the bakery should make to maximize their profit.

Step 3: Save your file as lastnamepies (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 results in 0 points.)

Step 4: Upload your completed Excel file.