; Merchandise Inventory Spreadsheet
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Merchandise Inventory Spreadsheet

VIEWS: 1,000 PAGES: 70

This Merchandise Inventory Spreadsheet is for maintaining an inventory of merchandise and allows a company to manage the following: a list of all purchased items ready for resale; a list of merchandise items sold; a real time inventory as per movements in purchased and sold items. This form contains a worksheet for the list of merchandise items to be included as inventory, a list of items purchased, a list of items sold, a merchandise inventory sheet guide, and a supplier and customer contact worksheet.

More Info
  • pg 1
									Merchandise Inventory Spreadsheet
This spreadsheet is for maintaining an inventory of merchandise and allows the user manage the following:
       - a list of all purchased items ready for resale;
       - a list of merchandise items sold;
       - a real time inventory as per movements in purchased and sold items

The following worksheets are included in this workbook:

      Item List
             List of merchandise items with a corresponding item code.

      Purchased
            List of purchased items organized by date of purchase.

      Sold
              List of sold items available in stock.

      Merchandise Inventory
            Updated list of merchandise items in stock available for resale.

      Suppliers - Customers
             Directory of suppliers and customers.

Note: To fully utilize the spreadsheet, set the Macro Security to Medium. (Tools > Options > Macro Security > Medium)

ITEM LIST GUIDE




Specify an item code , item name , and description . Make sure to list all items to be included in the inventory.



PURCHASED SHEET GUIDE
Item Code - Use the dropdown list to select an item code from the item list. User cannot create an item code in this
column. All item codes must be defined in the item list sheet.



                                                 Note: Use the scroll bars to display a list of item codes.




Item Name - Automatically displays the value upon selection of an item code.
Unit Price - Specify the purchase price per unit of the selected item
Quantity - Specify the quantity of the purchased item
Total Amount - Calculates the total amount of purchased items (unit price x quantity)
Date Purchased - Specify the purchase date
Supplier - Specify the Name of the Supplier
Expiration Date - Specify the item expiry date, if applicable
Notes - Indicate other necessary information pertaining to the purchased item



SOLD SHEET GUIDE
Item Code - Use the dropdown list to select an item code from the item list. User cannot create an item code in this
column. All item codes must be defined in the item list sheet
Item Name - Automatically displays the value upon selection of an item code
Retail Price - Specify the retail price of the selected item
Quantity Sold - Specify the quantity of items sold
Total Amount - Calculates the total amount of sold items (retail price x quantity)
Date Sold - Specify the date of sale
Customer - Specify the name of the customer to whom the item is sold
Notes - Indicate other necessary information pertaining to the sold item



MERCHANDISE INVENTORY SHEET GUIDE




Item Code - Select an item code from the dropdown list to display a real-time inventory of merchandise as per items declared in PURCHA
Item Name - Value automatically displayed upon selection of a particular item code
Description - Value automatically displayed upon selection of a particular item code
Total Quantity in Stock - Automatically calculates and displays the total quantity in stock. (total quantity purchased - total quantity sold)
Retail Price - Specify the desired retail price of the item in stock
Total Amount in Stock (Retail Price) - Calculates the Total Amount in stock per defined Retail Price
Stock Status - Displays a warning that the total quantity in stock is less than 10 (WARNING: LOW)
Reorder Priority - Specify the reorder priority of the related item
Notes - Indicate other necessary information pertaining to the sold item



SUPPLIERS - CUSTOMERS SHEET GUIDE
Supplier Contact List - Used to maintain a list of supplier details. Use the SORT button to sort the list by supplier name.
Customer Contact List - Used to maintain a list of customer details. Use the SORT button to sort the list by customer name.
items declared in PURCHASED and SOLD sheets


hased - total quantity sold)
stomer name.
Items for Inventory

   Item Code             Item Name
KITCH0001      Kitchen Ware: Spoon and Fork
KITCH0002      Kitchen Ware: Plates
KITCH0003      Kitchen Ware: Frying Pan
           Item Description
Silver
China
Aluminum
Purchased Goods

                                                           Total         Date
 Item Code        Item Name         Unit Price Quantity
                                                          Amount      Purchased
             Kitchen Ware: Spoon
KITCH0001    and Fork                  $10.00    20         $200.00    10/12/11

KITCH0002    Kitchen Ware: Plates      $20.00    10         $200.00    10/12/11
             Kitchen Ware: Spoon
KITCH0001    and Fork                  $10.00    10         $100.00    10/12/11
                       Expiration
            Supplier                Notes
                         Date


KitchenMagic           n/a

Plate-o-Genius         n/a

KitchenMagic           n/a
Sold Goods

                                                          Total
                                    Retail    Quantity
 Item Code        Item Name                              Amount     Date Sold
                                    Price      Sold
                                                          Sold
             Kitchen Ware: Spoon
KITCH0001    and Fork                $15.00      5         $75.00   10/13/01

KITCH0002    Kitchen Ware: Plates    $25.00      8        $200.00   10/13/11
           Customer   Notes


John Doe

Juan Dela Cruz
Merchandise Inventory
                                                             Total
 Item Code        Item Name                  Description   Quantity in Retail Price
                                                             Stock
             Kitchen Ware: Spoon
KITCH0001    and Fork            Silver                        25

KITCH0002    Kitchen Ware: Plates China                        2
             Kitchen Ware: Frying
KITCH0003    Pan                  Aluminum                     0
Total Amount in
                                 Reorder
     Stock        Stock Status
                                 Priority
 (Retail Price)

                                 MEDIUM

                     LOW          HIGH

                     LOW          LOW
Notes
Supplier Contact List

        Name            Address   Contact No
Grill-King
Kitchen Magic
Plate-O-Genius
  SORT          Customer Contact List

Email Address           Name            Address
                Amelia Earhart
                John Doe
                Juan Dela Cruz
                   SORT


Contact No   Email Address
LOW
MEDIUM
HIGH
								
To top