In the previous video, you created a new spreadsheet and gave it a title.
In this video, you will list the items you sell
and record data on what you have in stock and what you have sold.
To begin, label the first column “Product Type.”
Beneath that heading, list the products or materials you sell.
As you list each item, some text may overlap between columns.
To keep each item easily visible, wrap the text.
To do this, select the entire column.
Then, wrap the text, so it fits in the cell.
Now, your inventory is easier to see.
Next, add headings to the right of the “Product Type” column.
Label the next column “Original Stock.”
This shows the number of each product you had available when you launched your business.
For example, if you created twenty-five tablet stands, put the number twenty-five in this row.
Type “Total Sold” at the top of the next column.
List how many of each item you have sold, even if it is zero.
Label the next column “Current Stock.”
Add the header, but leave the rest blank.
Now, add a label for "Cost Per Unit."
This is how much it costs you to make your product.
Complete this column based on your expenses per item.
The “Retail Price” column shows the amount of money you charge your customers.
Next, add a column heading for “Margin.”
Leave this column blank.
You will fill it in the next video.
To make your spreadsheet easier to read, make the headings stand out.
Select the last 3 columns, then adjust the format to display the numbers as amounts of money.