I've provided a starting file to try to make it easier!

Scenario: As the manager of Super Store Furniture, you are responsible for determining the potential profit of each item in the store for each month and submitting that data to the District Manager (DM), who will then use that information to determine if any changes need to be made.

Each month, the DM is looking for the following for each type of item:

• Total Cost
• Average Unit Price
• Total Value
• Potential Profit

In addition, they are also looking for:

• The Totals for Units on Hand, Total Cost, Total Value, & Potential Profit
• The Average for Unit Cost, Total Cost, Average Unit Price, Total Value, Profit Potential
• The Highest and Lowest values for Unit Cost, Total Cost, Average Unit Price, Total Value, Profit Potential

1. Calculate the Total Cost for each item by multiplying the Units on Hand by the Unit Cost
2. Calculate the Average Unit Price by multiplying the Unit Cost by 1.5 (50% markup)
3. Calculate the Total Value by multiplying the Units on Hand by Unit Price.
4. Calculate the Total Potential Profit by subtracting Total Value minus Total Cost.
5. Calculate the following Totals: Units on Hand, Total Cost, Total Value, and Profit Potential.
6. Calculate the following averages: Unit Cost, Total Cost, Unit Price, Total Value, and Profit Potential.
7. Calculate the following maximum and minimum vales: Unit Cost, Total Cost, Unit Price, Total Value, and Profit Potential.
8. Format the sheet appropriately using cell styles, appropriate number styles, applying Landscape orientation, and a header including the following, so it updates automatically: Sheet Name and Date
9. Set this page to print one sheet wide.

Super Store Furniture Profit Potential Total Valuetential Pro Unit Price Item Numt Item Desci 12 Rugs 22 Sofas 23 Loveseats 42 End Tables 52 Lamps Totals Units on Unit Cost Total Cost Hand 983 $ 89.00 1,980 678.00 2,187 189.00 2,354 65.45 2,346 23.85 Average High Low Super Store Furniture Profit Potential Total Valuetential Pro Unit Price Item Numt Item Desci 12 Rugs 22 Sofas 23 Loveseats 42 End Tables 52 Lamps Totals Units on Unit Cost Total Cost Hand 983 $ 89.00 1,980 678.00 2,187 189.00 2,354 65.45 2,346 23.85 Average High Low