The following are the things you should consider in your spreadsheet:
1.The main page consisting of your company name, company address, company contact details, company logo, and hyperlinks that would allow users to navigate to all the different sheets. All of the different sheets should also have a hyperlink that allows users to navigate back to the main page.
2.The inventory sheet, which should consist of the following (but not limited to):
a.Product ID that is uniquely assigned to all items
b.Product description that describes the item
c.Number of each item bought from suppliers
d.Initial cost per item bought from suppliers
e.Selling price of each item (40% in addition to the corresponding initial cost per item)
f.Number of each item sold
g.Number of on hand for each item that are in stock
3.The sales sheet(s), which should consist of the following (but not limited to):
aProduct ID, product description, selling price, and the number of on hand should be displayed exactly as in the inventory (no modification of data is allowed here)
b.Number of item sold that would automatically update the inventory’s number of item sold (access given only to the employee with the corresponding brand)
4.The employees’ salary sheet should consist of the following (but not limited to):
a.Staff’s ID that is uniquely assigned to all employees
c.Staff’s fix monthly salary
i.If the target sales revenue is less than RM1500, the commission is 5% from the selling price of the item sold
ii.If the target sales revenue is equal to or greater than RM 1500, the items sold after that will be counted with a commission of 15% from the selling price.
i.If the target sales revenue is equal to or greater than RM 1500, the performance is “Good”.
ii.If the target sales revenue is less than RM1500 but greater than RM1000, the performance is “Above average”.
iii.If the target sales revenue is less than RM1000 but greater than RM500, the performance is “Satisfactory”.
iv.If the target sales revenue is less than RM500, the performance is “Below average”.
5.The analysis sheet should consist of the following (but not limited to):
a.The sales revenue for each brand
b.The total sales revenue for all brands
c.The cost for each brand
d.The total cost for all brands
e.The salary plus commission for each employee
f.The total salary plus commission for all employees
g.The profit (excluding the rent for the shop lot, utility bills, etc…)