Yorkville High School Computer Science

Computer Applications I :: Projects :: Expensive Mall Store

Problem

You have been hired by a trendy store in the mall to calculate their profits and determine which items they make the most money on. You will be using Excel to do this.

Instructions

1. Create a spreadsheet that that contains the information above.
2. Create a new column called Markup that calculates the profit generated by each item sold.
3. Create a new column called Total Sales Made that determines how much money was made on each item by multiplying the amount sold by the selling price.
4. Create another column called Actual Profit that determines how much profit was made on the amount of items sold.
5. Create a column called Percent Profit that says the percentage of the Actual Profit is or the Total Sales Made.
6. Use the table-array below and the vlookup function in one final column called Suggestion.
   
7. Finally, create a line chart named Item Pricing that plots the item cost and the selling price. Make sure everything is labeled correctly.
8. Make your spreadsheet look professional by using color and borders. Format all the numbers correctly.