Project 5: Profitability, Customers, and Inventory Spreadsheets in Sales Workbook

Building in the previous workbook created in class, students add additional sheets for inventory tracking, customer data, and a table of costs and sales totals. Using this data, students are able to assess profitability of the enterprise when given fixed and variable costs.  Include:

Customer Tab:

• Customer_ID
  
• First_Name
  
• Last_Name
  
• Address 1
  
• City
  
• State
  
• ZipCode
  
• Email
  
• Loyalty Status

Inventory Tab:

• Item_ID
  
• Item_Name
  
• Item_Description
  
• Item_Price
  
• Taxable
• Quantity_On_Hand: needed for next week's assignment

Costs:

• Fixed_Cost_Name
  
• Fixed_Cost_Type
  
• Fixed_Cost_Amount
  
• Variable_Cost_Name
  
• Variable_Cost_Type
  
• Variable_Cost_Amount

Fixed costs include rent, insurance, utilities, managerial overhead; variable costs include materials and labor.

Calculate the final profitability for your enterprise by taking all expenses out of the gross revenue amount that you had calculated on the sale data sheet.