Input information for new stock addition in the designated cells
3
Perform calculations for total quantity of particular items
4
Calculate value of all items in inventory
5
Input data of items sold
6
Calculate remaining quantity of each item
7
Generate report for items sold
8
Approval: Sales Report
9
Input data for items received in stock
10
Calculate updated quantity of items in stock
11
Perform periodic inventory check
12
Enter count from physical inventory check
13
Reconcile physical inventory with system inventory
14
Identify any discrepancies between physical and system inventory
15
Apply appropriate corrections for identified discrepancies
16
Approval: Inventory Check
17
Generate overall inventory report
18
Approval: Total Inventory Report
19
Save and close Excel template
Open inventory management template in Excel
Open the Excel template for managing inventory. This task is crucial as it sets the foundation for the entire inventory management process. By opening the Excel template, you will be able to access and update all the necessary information.
Input information for new stock addition in the designated cells
Once the Excel template is open, input the relevant information for the new stock addition in the designated cells. This includes details such as item name, quantity, price, and any other relevant information. By accurately inputting this information, you ensure that the inventory management system reflects the correct stock levels.
Perform calculations for total quantity of particular items
Perform calculations in Excel to determine the total quantity of particular items. This involves using formulas and functions to sum up the quantities of the same item across different cells. By performing these calculations, you can easily track the total quantity of each item in your inventory.
Calculate value of all items in inventory
Calculate the total value of all items in the inventory. This requires multiplying the quantity of each item by its respective price and summing up the values. By calculating the value of all items in the inventory, you can track the total worth of your inventory.
Input data of items sold
Input the data of items sold into the Excel template. This includes details such as item name, quantity sold, and price per item. By accurately recording this information, you can track the items that have been sold and their respective quantities.
Calculate remaining quantity of each item
Perform calculations in Excel to determine the remaining quantity of each item in the inventory. This involves subtracting the quantity sold from the initial quantity of each item. By calculating the remaining quantity, you can keep track of the stock levels for each item.
Generate report for items sold
Generate a report in Excel that provides an overview of the items sold. This report should include details such as item names, quantities sold, and total sales value. By generating this report, you can have a clear view of the items that have been sold and their overall impact on sales.
Approval: Sales Report
Will be submitted for approval:
Generate report for items sold
Will be submitted
Input data for items received in stock
Input the data for items received in stock into the Excel template. This includes details such as item name, quantity received, and price per item. By accurately recording this information, you can track the items that have been received in stock and their respective quantities.
Calculate updated quantity of items in stock
Perform calculations in Excel to determine the updated quantity of each item in the inventory after receiving new stock. This involves adding the quantity received to the previous quantity of each item. By calculating the updated quantity, you can ensure that the inventory reflects the correct stock levels.
Perform periodic inventory check
Perform a periodic inventory check to ensure the accuracy of the inventory records. This involves physically counting the items in stock and comparing the count with the inventory records in the Excel template. By conducting periodic checks, you can identify any discrepancies and take appropriate actions to correct them.
Enter count from physical inventory check
Enter the count from the physical inventory check into the Excel template. This includes recording the quantity of each item as counted during the physical inventory check. By accurately entering this count, you can compare it with the inventory records to identify any discrepancies.
Reconcile physical inventory with system inventory
Compare the physical inventory count with the system inventory records in the Excel template. This involves checking if the counts match for each item and identifying any discrepancies. By reconciling the physical inventory with the system inventory, you can identify any potential issues or errors in the inventory records.
Identify any discrepancies between physical and system inventory
If any discrepancies between the physical and system inventory are identified, record them in the Excel template. This includes noting down the items with mismatched quantities or any other discrepancies found during the reconciliation process. By identifying these discrepancies, you can take appropriate actions to address them and ensure the accuracy of the inventory records.
1
Mismatched quantities
2
Missing item
3
Extra item
1
Mismatched quantities
2
Missing item
3
Extra item
1
Mismatched quantities
2
Missing item
3
Extra item
Apply appropriate corrections for identified discrepancies
Apply the appropriate corrections for the identified discrepancies in the Excel template. This may involve adjusting the quantities, adding or removing items, or updating any other relevant information. By applying these corrections, you can ensure that the inventory records accurately reflect the actual stock levels.
1
Adjust quantity
2
Add item
3
Remove item
1
Adjust quantity
2
Add item
3
Remove item
1
Adjust quantity
2
Add item
3
Remove item
Approval: Inventory Check
Will be submitted for approval:
Perform periodic inventory check
Will be submitted
Enter count from physical inventory check
Will be submitted
Reconcile physical inventory with system inventory
Will be submitted
Identify any discrepancies between physical and system inventory
Will be submitted
Apply appropriate corrections for identified discrepancies
Will be submitted
Generate overall inventory report
Generate an overall inventory report in Excel that provides a comprehensive view of the current stock levels and any adjustments made. This report should include details such as item names, quantities, prices, and any corrections applied. By generating this report, you can have a clear overview of the inventory status and any changes made.
Approval: Total Inventory Report
Will be submitted for approval:
Generate overall inventory report
Will be submitted
Save and close Excel template
Save the Excel template after completing all the necessary tasks and close the file. By saving and closing the template, you ensure that all the updates and changes made are preserved for future reference.
