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.