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
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.
