3.1 Tutorial Overview
The tutorial is designed to teach new users about pc/MRP. The tutorial has 18 lessons. Below is a description of each lesson.
3.1.1 pc/MRP manual and Contents
A brief discussion about the manual and where to find things.
3.1.2 The Bicycle Shop
Discusses what the Bicycle Shop is and how to utilize the tutorial.
3.1.3 Settings and Utilities
Explains a few custom settings that users should learn.
3.1.4 Creating a Practice Directory
Shows users how to make a backup copy and a practice directory of pc/MRP.
3.1.5 Address Book Module
Discusses where all of your vendor and customer information resides.
3.1.6 Inventory Module
Covers where all of you part information exists and how to enter and edit parts.
3.1.7 BOM Module
Explains how to build the recipes that are your assemblies.
3.1.8 Inventory Flow Model
Explains the general flow of material from order entry, to production, and shipping.
3.1.9 Sales Order Module
Order entry for customer sales.
3.1.10 Work Order Module
Order entry for scheduling or building to stock.
3.1.11 Single Bkt MRP Purchasing
Material Requirements Planning. This tells you what you need to buy based on your demand from Sales Orders and Work Orders.
3.1.12 Infinite Bucket MRP
Advanced Material Requirements Planning. This tells you what you need to buy, when you need to buy it, and schedules your builds and issues to and from manufacturing. (MPS)
3.1.13 Purchasing Module
Ordering from your vendors.
3.1.14 Receiving Module
Vendors fulfilling Purchase Orders and creating Accounts Payable.
3.1.15 Stock Room Module
Using the stockroom to convert parts to assemblies and adjust inventory.
3.1.16 Invoice Module
Creating invoices and building Accounts Receivable.
Posting GL transactions, paying bills, receiving payments from customers, and Posting Financials.
3.1.18 Some Final Thoughts
Discusses where to go from here.
3.1.1 pc/MRP manual
The manual for pc/MRP is broken down into five sections: Standard Modules, Accounting, Utilities and Configuration, Optional Modules, and Trouble Shooting. Take a few moments to review the chapter headings and become familiar with how the manual is formatted. The manual will become an invaluable tool while you are learning pc/MRP. The manual is available both in the drop down menus within pc/MRP and in hard copy form from Software Arts.
3.1.2 The Bicycle Shop
The Bicycle Shop is the fictitious company that will be used in this tutorial. Throughout running the bicycle shop, we will carry out several tasks that companies perform in their day-to-day operations. Since the tutorial is in HTML and uses your Internet Browser (no you are not online, the tutorial simply uses your browser) you will often be asked to refer back to pc/MRP. You should thus learn the ALT-Tab function. By pressing ALT-Tab, you will be able to go back and forth between applications. If you have the tutorial open and pc/MRP or any other program, simply press and hold down on the ALT key, now hit the tab key once. On most Windows operating systems, this brings up a bar in the center of the screen that has all of your currently open programs. To easily go between the tutorial and pc/MRP use the ALT-Tab function.
This is the tutorial. You are in the tutorial NOW. The tutorial is a written tutorial. There are no parts to load and or data sets available. Users should learn how to enter parts and build BOMs and run the program. That is why the tutorial was written. You can expect the tutorial to take about 2-4 hours.
3.1.3 Settings and Utilities
pc/MRP can be configured to operate in several different business environments. The Utilities and Configuration chapter covers in detail all of the custom settings available pending on your business circumstances. Before you start using pc/MRP "live”, you should have a thorough understanding of what these settings are and what they mean to your company. For the sake of this tutorial, there are just a few that will be addressed now. To access the Settings and Utilities menu from within pc/MRP select: Configuration, and Settings & Utilities.
Option 4, Inventory Adjustment Method (S/A/P/W/R)
We recommend "A." The tutorial is designed around inventory adjustment method "A." This is the recommended method for manufacturers, distributors, and retailers. By default, pc/MRP is set to "A". You might find a setting that better fits your specific requirements. However, to successfully utilize the tutorial, you must have this option set to "A".
Option 8, Auto Accounting, On or Manual
We recommend "M." The tutorial is designed around manually entering GL transactions. By default, pc/MRP is set to Manual. It is also recommended that it be always set to manual and never changed to automatic.
Take the time to study the settings and utilities chapter. You may find several things that are of specific interest to your circumstances. By reading this section, you will be able to form ideas on how pc/MRP will work for your company. Be sure to make a list of all of the settings that will need changing for pc/MRP to run successfully with your company.
Note: The trial version of pc/MRP will accept any password and does not need a configuration code number. As you view the Settings and Utilities, simply press OK when it asks you for your configuration code number.
Note: Throughout the tutorial references will be made to executable paths in pc/MRP. These paths will always begin in the drop down menus accessible on the main screen in pc/MRP.
Example: Select Configuration, About pc/MRP. This means select from the drop down menus, Configuration, and then About pc/MRP. These executable paths will be used in performing specific tasks associated with completing the tutorial. When a letter is underlined, you can press the Alt key and the underlined letter of the desired function. You can also use your mouse. At this time, press OK to return to the main pc/MRP screen.
To view your current Settings and Utilities start pc/MRP and select Configuration, and then Settings & Utilities. Hit Next or Previous as desired. Hit Cancel to exit the Settings and Utilities.
Note: Throughout using pc/MRP you will constantly accessing the drop down menus. At this time, take a few minutes to review all of the options accessible from the drop down menus.
3.1.4 Creating a Practice Directory and Backup Copies
A practice directory or practice copy of pc/MRP should be created to run the examples in this tutorial. This practice directory can be created by following the commands listed below after you have initially installed pc/MRP.
Open Windows Explorer. (Do a right click on the Start Button and select Explorer)
On the left scroll up to your C drive and find the pcmrpw directory.
Do a right-click on the pcmrpw directory and select Copy.
Right-click on the C drive and select Paste. This creates a "Copy of pcmrpw" on your C drive.
Press File and Close to close Explorer
We are finished creating a backup copy. You will want to become familiar with creating backup copies and practice directories. The file pcmrpw.exe starts pc/MRP and whenever you want to do a test run on something, simply make a copy of the pcmrpw folder and double click on the exe file. Do not however leave a lot of practice copies throughout your network. This simply confuses end-users.
Furthermore, for practice copies of pc/MRP, we recommend going to Configuration, Settings & Utilities, and Option 1. Edit the second address line to contain the word ‘practice’. This will put a red practice logo in place of the standard pc/MRP logo alerting users that they are in a practice copy and not the standard copy of pc/MRP. For pc/MRP Versions prior to version 7.90, use option 20 to change the color of the data entry screens to an ugly blue to alert users they are in a practice copy of pc/MRP.
We have thus far built a reasonable framework. You should have an understanding of how to: find things in the pc/MRP manual, navigate through the pc/MRP menus, how to find and change the settings and utilities, and create and use practice directories. We will continue with explaining how to enter vendor/customer, inventory, and BOM information. This will be the foundation that we use to enter orders and complete the Order-to-Cash process.
3.1.5 Address Book
The primary source of all of your data is found in the Address-book, Inventory, and Bills of Materials modules. All of this data, once entered, is automatically entered into sales orders, purchase orders, work orders, and receivers. We will first discuss the Address Book Module. The Address Book Module is the location in pc/MRP where all customer, vendor, employee, and contact information will be stored. At this time, take a few minutes to read the Address Book Module. This lesson will assume the chapter has been read.
18.104.22.168 Entering an Address
While using pc/MRP in the course of running your business you will need to add addresses. To add new addresses simply select Modules, Address Book, and New.
Note: You will find that all of the modules are setup very similar. To make a new purchase order select, Modules, Purchase, New. To make a new sales order select: Modules, Sales, New. This is constant throughout the program.
After selecting Modules, Address Book, New, you will be prompted to enter the company name that
you wish to add to the address book. Please enter "ABC TIRE COMPANY."
Note: when entering an address where most of the customer information exists in an address that is already entered into the address book, you can select "Import Address information from existing address" on this screen, to save time.
After entering the company name press: OK
As you can see, there are many options and fields to enter data for each entry. Most are self-explanatory. For further details on what each field does refer back to the chapter in the manual on the Address Book. At this time, take a few moments to look over this screen and refer back to the manual if there are questions about specific fields.
Enter the data as described in the picture below. Except for the Start Date, this will automatically be populated by the date in your computer.
Notice that several tabs exist to allow users to enter additional data. The additional tabs consist of: Sales Contact Information, additional billing and shipping addresses, and Invoice and Receiver history. Salesperson information, the billing address, and the shipping address will automatically be populated in sales orders and invoices. Select the Billing/Shipping tab and enter separate address information into the fields provided. We will use this address entry later to enter purchase orders and sales orders.
22.214.171.124 Viewing an Address
To view the address just entered select Modules, Address Book, and Edit.
Note: The EDIT function is similar throughout pc/MRP. If you wish to edit a Sales Order, select Modules, Sales Order, and Edit. To edit a receiver select Modules, Receiver, and Edit.
To edit choices you must choose "Edit" under the Action square. To simply view, select "View." Users can also search address information in a number of different ways. Select the gray square with the black down arrow to access the drop down menu under "Sort Order." This allows searches to be made on Account ID Number (a unique address ID number per customer created by pc/MRP), company name, company telephone number, and serial number.
Note: This scroll selection and actual scroll screens are similar throughout pc/MRP. Sales Orders, Work Orders, Invoices, Receivers, Purchase Orders, Stockroom Transactions, and the BOM engine all utilize this same screen. (If you ever edit something and the changes are not saved, you undoubtedly had the View checked in the Action Square.)
At this time, within the Address Book Scroll screen, select the entry we have created and press OK or enter.
Note: Several fields have drop down menus. (Addr Type, Status, and under the sales contact information tab: source, purpose, priority, interest, and concern.)These fields are user definable through Option 52 in the Settings and Utilities, and are used in address reports to further parse customer/vendor data.
Example: ADDR TYPE allows users to define their relationship with the entry. Examples: EMP for employee, VEN for Vendor, CUS for customer, PRB for accounts on probation.
126.96.36.199 Editing an Address
To edit an address, with the address entry still open from above, edit the Status drop down menu to CUS. (Similar to making new entries the edit feature is the same throughout pc/MRP. To edit Receivers simply select, Modules, Receive, and Edit. To edit Inventory simply select Modules, Inventory, and Edit)
Press OK. This saves the changes made.
If the OK button is not highlighted you are not in Edit mode. Select Cancel and attempt to edit the address entry again. This time, with the address scroll screen present select the Edit radio button in the Action square. When you are done editing, select OK.
Look up the address again and see if the changes were saved. If the changes are not there, then you never made the changes, you selected view rather than edit in the "Action Square", or you selected cancel after making the changes. If the changes are there, congratulations, you have successfully edited another entry.
188.8.131.52 Deleting an Address
Create another address entry with a company name of "Bad Company." This will be the entry we remove. (Modules, Address Book, New...enter the new company.)
To remove this entry "Bad Customer" from the address book selects Modules, Address Book, and Edit. Make sure the Action square is set to edit and scroll for the "Bad Customer" entry. Select that entry. With the address book open to this customer entry select the Delete button from the row of buttons on the bottom of the screen and then OK.
Finally, to delete an address or anything within pc/MRP you must take two steps. The record must first be marked for deletion as we have done above, then, the records marked for deletion must be deleted.
To remove records marked for deletion select, Modules, Address Book, and Remove Marked Records for Deletion. This two-step deletion method is the same throughout pc/MRP.
Note: Once your software is activated into the full version, deleting records marked for deletion will be secured by your configuration code.
You have now successfully deleted your first record.
We have just learned almost everything about the Address Book. The steps above can be repeated for entering, looking up, editing, or deleting any address in the address book. For reports and label making, refer back to the manual. We will continue with the lesson on data entry with the Inventory module.
3.1.6 Inventory Module
The Inventory Module contains price, quantity, lead-time data, and a number of other fields associated with parts, labor parts, and assemblies. Inventory does not contain information about how the assemblies are built. This is in the Bills of Materials. BOMs will be covered in the BOM lesson.
To become familiar with what the various fields do in the main inventory screen, please take a few minutes to read the Inventory Module chapter. You should not begin this lesson without having an understanding of the Inventory Module.
Several things should be considered when entering your own parts and creating a part number scheme. For the purpose of this tutorial, we will keep all of the standard settings. As you begin entering your own parts, you will want to read about Options, 28, 29, 48, and 49 in the Settings and Utilities module. For special cases and consignment parts, read chapter 15.9.5, Special Cases.
184.108.40.206 Entering New Parts
Similar to the Address Book, when an end-user wants to enter a new part, simply select: Modules, Inventory, and New. Then select "Next Available Partnumber".
pc/MRP will automatically assign the next available part number or users can simply highlight the pc/MRP built part number and enter their own.
Press OK to accept part number 000000001.
The part number data entry screen is presented. Enter data as described in the picture below.
Notice that similar to the address book entry screen, several tabs exist in the inventory entry screen. A tab exists for Quantities/Costs, Vendor Information, Sales Prices, Manufacturers\Model Number\Alternate Part numbers, and Miscellaneous data. Each tab is explained in detail in the Inventory chapter. For purposes of this tutorial, be sure to enter the part description, a lead-time of 1 day and under the Sales Prices a price of $1,500.00 for Level 1 Quantity 1.
With all of the information entered, select OK to have this entry saved. Congratulations, you have entered your first part.
220.127.116.11 Editing Parts
At this time, we will edit the part we just entered.
Select Modules, Inventory, and Edit. Select the same part number we just entered. Edit this part so that the Lead-time is 2 days. Select Save.
Note: Did you select "EDIT" in the action square?
After making sure you successfully changed the lead-time for the bike assembly, take a few minutes to enter two more addresses, Smith Bikes and Canonwale, INC. and the remaining parts for the bike assembly. The picture below lists the parts to create and the vendor to use for each part. For the sake of time, many of the basic fields are left blank. Please however enter:
Note: If you edit the part number, number, you must select "Change Part Number" from the Inventory drop down menu. This will allow you to change the part number in all applicable modules in just one step.
Similar to the Address Book there are numerous fields that do a variety of things. All of these fields can be manually edited. Most of these fields require manual data entry. Most of these fields are self-explanatory. Several of these fields are automatically updated through performing specific actions.
Below is a list of those fields that are automatically updated, and how they are updated.
STD COST/UNIT: Standard Cost per Unit.
pc/MRP calculates the standard cost per unit using purchasing history by running the cost roll-up feature in Inventory and selecting Standard Cost. This STD COST/UNIT field is populated when you run this feature.
AVE COST/UNIT: Average Cost per Unit.
pc/MRP calculates the average cost per unit using purchasing history by running the cost roll-up feature in Inventory and selecting Average Cost. This AVE COST/UNIT field is populated when you run this feature.
LAST PO COST: Last Purchase Order Cost.
This field brings in the cost of the last purchase order made for this part.
ON ORDER: Quantity on Order.
This field contains the quantity on order from purchase orders. This field increases when purchase orders are made and decreases when receivers are made. This feature will be further discussed in purchasing.
ON DEMAND: Quantity on Demand.
This field contains the quantity on demand from open work orders and open sales orders. This field increases by creating work orders or sales orders. This field decreases when sales orders are invoiced or parts are converted into assemblies from the work order. Furthermore, this field can be updated when edits are made to sales orders and work orders by running the Audit On-Demand Quantities feature in the Sales Order Module.
AVAILABLE: Quantity Available.
This field contains the quantity available after allocation. This field is updated by running the single bucket purchasing report or the optional module Infinite Bucket MRP. The MRP programs will allocate parts on hand and on order and populate the Quantity Available field with the quantity available after allocation.
These features will become more obvious as we make sales and work orders and run MRP reports. For the time being, we will just let this sink in.
Note: pc/MRP does not allocate things every time an order is entered. The quantity available field is only updated as described above.
18.104.22.168 Deleting Parts
Deleting parts is exactly like deleting addresses. You must first mark the record for deletion and then remove marked records for deletion. To test this, delete the TUBE ASSEMBLY, part number 000000012. Once again, in the full version, deleting entries will be secured by your configuration code.
You should now be familiar with viewing, editing, and entering parts. If you have any questions about what these fields do or how to perform the tasks above, start the lesson over and refer back to the manual.
Up to this time, we have discussed the Address Book and Inventory Modules. This next section completes the Data Entry Lesson by covering the Bills of Materials Module.
3.1.7 BOM Module
The BOM module is where all of your bills of materials or recipes for assemblies will be stored in pc/MRP. At this time, take a few minutes to read the Bill of Materials chapter in the manual. This lesson assumes you have read the BOM chapter.
The BOM module is set up very similar to all other modules. To edit a BOM simply select Edit from the BOM menu. To enter a new BOM simply select New from the BOM menu. Most modules when printing have the Report option. For the address book and BOM module end users select Print.
Note: All parts within a BOM must exist as an entry in inventory before you can create that BOM. Assemblies can exist in inventory but do not have to exist. If an assembly does not exist in inventory the BOM module will automatically create one.
Before we create a BOM in pc/MRP, it would be best to see one on a piece of paper.
Notice how all of the various levels are separated by periods. Parts are labeled as PART and bills of materials are labeled as BOM. From this picture, we can deduct that parts and assemblies: 000000002, 000000003, 000000005, 000000006, 000000007, 000000011, and 000000013 are all on the first level of the Bicycle BOM. The WHEEL assembly contains parts 000000004, 000000013, and 000000009 and the BOM 000000012. The TUBE assembly contains two parts, 000000008 and 000000010.
To reinforce this idea of indented bills of materials we will make this BOM using the parts entered into pc/MRP in the Inventory lesson.
22.214.171.124 Entering Bills of Materials
We are now going to begin by entering the lowest level of the Bicycle BOM. Users can start by entering the top of their assembly or at the bottom. For this tutorial, we will start at the bottom.
Select Modules, BOM, New.
Enter BOM number: 000000012 with a description of TUBE ASSEMBLY.
You should now be at the main BOM data entry screen as depicted below.
Notice that the Add New component to BOM 000000012 window automatically is created. We have just created the TUBE ASSEMBLY; now we have to add the parts for this BOM level. We will add the tube and stem inventory items to this assembly.
To add these items to this assembly enter:
The desired quantity. (2)
Then press the ellipsis button next to the Part # field.
Search for the stem and press OK.
To add this to the assembly press OK again.
Notice that we are now at the basic BOM edit screen. This screen allows users to edit the BOM, add additional items, save changes, enter reference designators (through the reference designator tab), view miscellaneous data (through the miscellaneous tab), and even revert the BOM. (Revert allows users to place the BOM back at the original condition before editing.)
Select the Add Item button and add the NGF TUBE quantity 1 to this assembly. (After pressing Add Item button enter a quantity of 1 and press the ellipsis button to search and select the NFG TUBE.)
Select: Save and Finished to save the changes and then exit the BOM module.
Note: Bills of Materials are assembled in the BOM module one level at a time.
Note: Labor parts can also be entered into BOMs. This allows users to calculate theoretical job costs.
Now we are going to add our next level. This level we will add not only parts, but also the newly built TUBE ASSEMBLY.
Select Modules, BOM, New.
Enter BOM number: 000000002 with a description of WHEEL.
This entry is a little different however. The WHEEL already exists in inventory. pc/MRP is going to warn you about this. Go ahead and select Yes.
Now we can add our parts just as we did before. Enter the first part, Dirt Teaser Tire. Click on Add Item.
Now simply add the remaining items. Add the spokes, quantity 40. Add a few bolts, quantity 4. Finally, add the TUBE ASSEMBLY just like you would any regular part. Press Save and Finished when you done.
Now on your own...
Select Modules, BOM, New.
Enter BOM number: 000000001 with a description of BICYCLE TOP ASSEMBLY.
Enter the items that finish off this assembly so that it matches the picture below.
We have just completed the entire Bicycle BOM.
126.96.36.199 Editing the Bills of Materials.
Similar to everything in pc/MRP if you wish to edit something, select the module you wish to edit and select edit.
Select, Modules, BOM, and EDIT. Select BOM 000000001. When you select an item that is an assembly (depicted by an A in the Type column), you can use the Move To: Sub-Assy and Parent Assy features to scroll through the various levels of your assembly. Scroll to the TUBE ASSEMBLY. In the quantity field under BOM DATA, enter "1.0000" for the STEM quantity. We do not want do double up on or STEM ordering.
Are you in Edit or View Mode?
Now just to see what we have done select Modules, BOMs, Print BOMs/Pick List/Where Used and select the exploded-costed report. Scroll to enter your BOM number. Select
Print - Narrow and press the OK button. Your report should look very similar to the example report at the beginning of this section. If it does not, edit the BOM and run the report again. It will need to match for our purchasing results to match.
188.8.131.52 Deleting Parts within a BOM
Similar to all other areas of pc/MRP the deletion process is a two-step process. You must first mark the entry for deletion and then delete marked records. If you go into a BOM to delete a part and the delete button is not accessible, you do not have the Action Item Edit selected, or you do not have deletion rights in the Advance Password Module.
Note: There are several useful options in the BOM drop down menu. From that menu, you can delete a BOM, duplicate a BOM, change a BOM number, change the BOM description, and Audit BOMs.
Note: You can view the image for that specific part or BOM by selecting BOM Image or PART Image from the miscellaneous tab.
Note: Users can also view where used for a part or assembly and recalculate assembly costs in the miscellaneous tab
Note: bills of materials can have 26 levels in pc/MRP.
We have now covered data entry into the Address Book, Inventory Module, and BOM Module. The next lesson covers the Order-to-Cash process.
3.1.8 Inventory Flow Model
pc/MRP has a simple Order-to-Cash process. Take a few minutes to view the diagram below.
As you can see, Sales Orders and Work Orders start the entire process. These orders are based on your demand from customers or a desire to build items to stock. Items that are available for sale are directly invoiced, inventory is automatically deducted from stock, and we can begin building some A/R (Accounts Receivable). Sales Orders on order entry and Works Orders that have to be built take a different path. The will go through the MRP process. Purchase orders and receivers will be made for the piece parts required and build A/P (Accounts Payable), the stockroom will be used to convert parts to assemblies, and finally we will sell the item once again building A/R. It is important to understand this basic process. Through the next several sections, we will follow this process.
3.1.9 Sales Orders
Sales orders and work orders generate demand for parts and assemblies. This demand sets in motion your purchase orders, receivers, stockroom, invoicing, and inevitably accounting. pc/MRP can use work orders and sales orders in a number of different ways since both can be issued into manufacturing. For complete details, refer to the Sales Order Module and Work Order Module in the manual.
In short, the first method uses work orders to build to stock and sales order to build per customer order. The second method pc/MRP uses work orders to forecast demand while sales orders represent actual demand. pc/MRP can do this because demand from Sales Orders and Work Orders can be included or excluded from purchasing requirement reports. The differences between these two methods will become apparent once we run our MRP purchasing reports. For now, this tutorial will use method one, where we use work orders to build to stock and sales orders for customers. The important thing to consider is once you have chosen how you are going to utilize Sales Orders and Work Orders, you should stick to this method. If you are constantly changing how requirements are generated, you are increasing the probability of making mistakes.
184.108.40.206 Entering a Cash and Carry Sales Order
We will first simply create a Sales Order for a few bikes. To do this, first view the bicycle assembly in inventory (part 000000001). Make sure the quantity in Area Stores is 2. If it is not, edit the quantity so that it is 2.
Now, select Modules, Sale Order, and New.
The next screen allows the user to select sales type, terms, tax code, product issuing area, and shipping method. For the purpose of this tutorial, we will really only discuss the Sales Type. The other fields are explained more in the Sales Order Module chapter. Understanding the Sales Field type is essential however and deserves more attention.
The Sales Type field is essential to understand, because it directly affects inventory and invoicing. Sales Types entered as Cash and Carry or On Account and Carry automatically decrease the stores quantity of the line items on the sales order and creates an invoice. Thus, if you have these items in stock or not, by telling pc/MRP you are carrying the line items out the door, on-hand quantities will decrease.
Note: pc/MRP will not automatically convert parts into assemblies or back flush in the sales order module. All back flushing is done through the Stockroom Module or by running the convert parts into assemblies command.
Order Entry sales simply places demand on the line items chosen in the sales order. These items will be due on the date as specified by the end-user in the DATE REQ field. Demand for sub-components, that are part of the sales order line item, is not created until the MRP purchasing reports are ran. Invoicing is then done once the product has been assembled and is ready to ship.
To make this clearer, select a sales type of On Account and Carry, issuing from area 1, press OK.
On the sales order entry screen notice that at the bottom of the screen there is an Auto Look-up and Data selection box. Having the part number and root address checked means that data from the Address module and Inventory module will automatically be entered when you choose an address or part that already exists in those DBF files. To make an address or part from this screen select one of the check boxes under Data. If the applicable address has an alternate Bill to Address or Ship to Address, they will automatically be populated in the sales order.
Note: To change the BILL TO or SHIP TO address, the customer address or part after initial selection simply check the desired box, highlight the root address of the desired entry, type in a partial for the entry and hit enter. This will bring back the scrolling box for selection of the correct entry.
At this time, check "Make Address." We need to enter our new customer, TIM. Tim is purchasing two bicycles today. Once you have pressed, Make Address, enter some applicable data for Tim in his address entry. Then select OK to finish the address entry. Now put the cursor back into the top left CUSTOMER field and type T and press enter. This allows you to scroll to the applicable address. Select Tim as our customer and press enter.
The customer data for TIM should have automatically appeared on the sales order screen. Now put the cursor down into the description field and type "BICYCLE" and press enter. This automatically brings up the part number, model number, description, and price. We could have also selected the "BICYCLE" by entering the applicable part or model number.
Enter two for the quantity of bikes being purchased. Notice the SC field. Do not change this field. This field abbreviates the Sales Type and Tax Code information.
With the address entered and the bicycle assembly selected press F1. This is a shortcut method to view the part selected in the sales order. The inventory screen for this assembly should appear. Notice that we just happen to have 2 finished bikes in area Stores (1). Press ESC to get back to the sales order screen
Select Finish on the sales order screen.
This next screen confirms that an invoice is going to be made since the sale was entered as On Account and Carry or Cash and Carry.
This screen explains that two bicycles are being removed from inventory area One.
If you wish to print the Invoice, you can do so at this screen.
On this next screen, if you wish to view or print a shipping label press OK.
On the final screen, we can select NO.
At this time go to the inventory module and view the bicycle assembly part. Notice that in area one the quantity was driven to 0. As explained above and reinforced with this sales order, if you choose a sales type as cash and carry or on account and carry, it is automatically invoiced and the quantity field will decrease in the area chosen and by the quantity chosen in the sales order.
220.127.116.11 Entering Order Entry Sales Orders
Now, enter a new sales order for Tim but select Order Entry as the Sales Type. Put in quantity 1 and a DATE REQ (date required) of one week from today’s date. (The current date plus seven days.)
Note: to add additional line items we can select Add Item. Of-course to view these various items you can press Back and Next.
After entering the sales order, view the bicycle assembly in inventory. Notice that since this is order entry we have only created demand for this assembly. The QTY ON DEMAND field should be 1.
Take a few seconds to view the other parts in this assembly. Notice nothing has changed with these parts and the various quantity fields associated with these parts. Once again as mentioned above, when we run our purchasing reports these fields will be updated.
18.104.22.168 Editing a Sales Order
To edit a sales order or work order is similar to editing any other entry in pc/MRP. Simply select edit in the drop down menu for that module. It is important to note however, that if you frequently edit sales order item quantities that you should run the Audit sales order function. This function re-populates the on-demand quantity in inventory and is representative of the updated sales orders. Edit the' order entry' sales order for TIM to be quantity 2. Make sure the edit took.
Go back and look in inventory. Notice that the On Demand field did not change. Run the Audit On demand Feature under Sales Orders to correct this. Once again, our MRP reports will also update this.
3.1.10 Work Order Module
Besides our existing sales order, we want to build two bicycles to stock. At this time, enter a Work order for two additional bicycles with a DATE REQ of 14 days from now. Work orders are entered the same way sales orders are. You do not need to enter a receiving customer though. Simply enter the desired assembly or subassembly, the quantity and date desired, and press Finished.
Note: Work orders only allow one line item.
Once again, editing work orders is similar to all other modules. Simply select edit in that module.
At this time, we have entered demand for 4 bicycles. Take note in the inventory module that none of the subassemblies has been affected yet. The only thing that has happened is the QTY ON DEMAND for the BICYCLE has gone up. Since we have nothing on hand to build these bicycles, we will now run our MRP purchasing reports. These reports will tell us everything we need to buy to fulfill our orders. We will run two purchasing reports, our standard MRP Single Bucket report, and then the optional Infinite Bucket MRP report. After that, we will briefly compare the two. Of-course from there, we will make purchase orders to fulfill the demand, receivers to receive the parts necessary to build, issue the builds to the stockroom, receive finished goods back into inventory, and then we will be ready to invoice.
3.1.11 MRP, Scheduling Production, and Purchasing
The Purchasing MRP (all parts required) report and Infinite Bucket optional module is where all of the demand calculations are made. Once we run one of these reports, demand will populate all parts necessary to build everything that has been entered as a sales order or work order. We will first run the standard MRP purchasing report.
Select Modules, Purchasing, Reports. On the drop down menu, scroll to the bottom of the list and select the MRP Report (all parts required).
Note: End users can choose to include or exclude demand from Sales Orders or Work Orders. As mentioned above, this allows users to use work orders in several different ways and prioritize demand.
Note: The Consolidated report looks at both true demands from Sales Orders and Work Orders and takes into consideration MIN and MAX quantities set up in inventory. The MIN/MAX report only takes into consideration MIN and MAX quantities that were populated in the inventory entry screens.
Note: Print Trace Calculations creates a report that shows where demand is coming from for each individual part.
In the 'Include Demand from' field, leave the Sales Order and Work Order check boxes checked. Select Consolidated, area 1 Stores, Sort By Vendor, Display or send it to the Printer and press OK.
A report is created that shows all current demand. Take note that all demand is representative of needing to purchase parts to build 4 bicycles. Furthermore, even though our sales order is not due for a week and our work order is not due for 2 weeks the standard MRP not utilizing lead-times does not schedule purchasing or builds.
After viewing this report for a minute or two, press OK.
The Excess Inventory Report allows users to more closely track inventory. Go ahead and view this report as well by choosing the constraints you would like. At this time, there will not be any misallocation.
After viewing the Excess Inventory Report or hitting cancel, the next option is to automatically create purchase orders. At this time, select NO. We are not quite ready to make purchase orders yet.
Take a few minutes to see all of the changes made in inventory. For all parts required, the quantity available decreased since we do not have these parts available. Once again, the quantity available field in inventory is only updated through running the MRP reports. If we had parts in inventory, the quantity available field would be the difference between existing inventory, on order parts, and demand representative of the constraints chosen. Further more, nothing in the sub-assemblies used has changed. pc/MRP does not place demand on these sub-assemblies unless they are directly created through a Sales Order or Work Order. Only the quantity available field for individual parts utilized in the builds has changed.
If you have a printer hooked up to your computer, re-run the report above and rather than selecting display, select Print Narrow. This way we will have a printed report to compare against the Infinite Bucket report. Once again, select NO when you are prompted if you want to "Automatically create Purchase Orders".
3.1.12 Infinite Bucket MRP Purchasing Reports
This time we will run the more advanced MRP, the Infinite Bucket purchasing report. What this will do is utilize our lead times and provide a schedule to buy, issue, make, and sell.
Note: The Infinite Bucket MRP is an optional module. This module like most of the other optional modules is fully testable in the trial. To activate this module or any other optional module, select Configuration, Module Activation, Activate, and Yes. Optional modules are testable throughout the use of the trial. Once the trial is activated into a single user or multi-user version, optional modules can be activated for a 10-day trial period.
After activating the Infinite Bucket MRP module, select optional, Infinite Bucket. You should have the options as depicted below.
Select Generate Action Items. This step creates a database that we will access to query our purchasing reports. This action should be performed around once a week depending on how fast things are in your business. Select to run your MRP on both Sales Orders and Work Orders and use just inventory area 1.
You will see several screens flash in front of you. If you receive any errors in this process, you will have to view the errors and go back and fix them. Once the MRP generation process is complete, you will be back at the main pc/MRP screen.
Now select Optional, Infinite Bucket, and Print Action Item reports.
We will keep the default settings to look at this report. However, you should take note at all of the different options available to sort parse the data. Your report should look similar to the picture below.
Take note that everything is sorted by date with an action item listed for each part and assembly. Take a few minutes to view this page. The infinite bucket can be an invaluable tool if businesses want to plan and keep inventory (costs) to a minimum.
Once again, if you have a printer that you can print to, print this report by going through the same steps as above and sending it to the printer. If you have additional calculations that need to be performed, you can also send it to an XLS spreadsheet.
Note: At this time, nothing has changed in inventory after running our regular purchasing report. Companies do not have to run both MRP reports. Companies either want the extra planning module or simply use the standard MRP Report (all parts required).
Take a few minutes to study the differences between the two different MRP reports. If you have a small company and like to take the time to plan things yourself, you might find the standard MRP in the Purchasing module adequate. If you want to schedule things, and produce more detailed reports about what to do and when, then the Infinite Bucket is your best bet.
We are now going to act on the recommendations of our MRP reports and purchase the required parts for the sales order and work order entered above.
3.1.13 Purchasing Module
Entering purchase orders is the same as sales orders. This time however we are entering individual parts or purchased assemblies and choosing a vendor. At this time, take a few minutes to read the Purchasing Module chapter.
Choose the Banana Bicycle part in inventory. Make sure this part has a vendor. If this part does not have a vendor add an applicable address or choose and existing vendor. After viewing this part in inventory, take note that the quantity available field is -4. Now go to the Purchasing module and select New. Choose the bicycle seat by entering in the part number or entering the description. Vendor data should automatically appear.
Once again, take note of the Auto Look-up and Data check boxes. These can be used to save time.
By entering the part number or description first, a vendor list will pull up. If you were to enter the quantity first, the STD/COST per unit price break is automatically entered with the best vendor for that quantity.
To add items to this purchase order select Add. These buttons by now should be very familiar.
Note: The Clone button and Breakdown buttons can be utilized to automatically duplicate or break down orders to have multiple shipping dates.
After selecting the Banana Seat, enter the quantity of 4 and a due date of tomorrow. Press Finished. Now, go back to the inventory module to see what fields have changed. The QTY ON ORDER should now be 4.
Note: If purchase orders are often being edited the Audit PO function should be ran. This function automatically corrects the QTY ON ORDER in the Inventory Module.
Now that we have made our first purchase order, we will have pc/MRP do the rest of the work. Go to the optional module, the Infinite Bucket, and select to Generate Action Items. By creating the purchase order, our requirements have changed. After generating our action items, you can view the reports and see that we no longer have a buy requirement for the seats. Now select Optional, Infinite Bucket, and Automatically create Purchase Orders. Select Weekly Orders under ORDER CONSOLIDATION. This will consolidate all of the multiple orders for the same part by week.
Note: Automatically creating purchase orders is very handy. However, look at the purchase order for my BOLTS. It did two things that we could have prevented. #1, we did not enter a standard order quantity into inventory. If we had entered a standard order quantity of 100, then we would have had one purchase order for quantity 100. #2, when we choose to automatically create purchase orders, pc/MRP does not take advantage of any price/quantity breaks. To take advantage of our price break, we would have had to manually enter the purchase order. These are all things to watch for.
After automatically creating the purchase orders, we will bypass a few days and receive these purchase orders into inventory.
3.1.14 Receiving Module
The Receiving module is the next logical step in this process. We must receive parts and inform pc/MRP that we have parts to build our assemblies. This is what the Receiving module does. Refer to the Receiving Module chapter for complete details.
At this time, enter a Receiver for the Banana Seat. As with the creation of new entries throughout pc/MRP, to do this, select New in the receiving module. You will be able to scroll for the associated purchase order and press OK. Once we have went through several screens informing us of everything that pc/MRP is doing we can accept this transaction. Continue to enter the rest of the receivers. You may also notice once you have started on a purchase order that has multiple line items you do have the option to automatically receive the remaining line items. You may want to take advantage of this to expedite this process.
Note: pc/MRP can receive partial shipments. You can also edit receivers. However, there is not an audit function to correct edited receivers. Once a receiver is edited, end users must edit both the corresponding purchase order and inventory parts. With out editing both areas your quantities in stores will be incorrect.
Now that we have received our parts into inventory, we are ready to begin building. We will next utilize the Stockroom Module to convert parts into assemblies. Before convert these parts into assemblies. Once again, view several parts in inventory. Your stores quantity should have increased. Also, notice that for the top bicycle assembly still nothing has changed. You could even run an additional MRP and you will find that the Single Bucket MRP has no Action Items. The Infinite Bucket however will still have issues, sales, and, makes
3.1.15 Stockroom Module
The Stockroom module is where we turn piece parts into assemblies, or back-flush. Similar to everything in pc/MRP, when you want a new transaction simply select New in the module desired. In this case, select Modules, Stockroom New. There are several types of transactions available. To issue sales orders and work orders to the manufacturing floor use the "I" type transaction. To review the rest of these transactions refer to the Stockroom Module.
At this time select, the "I" type transaction and select the order entry Sales Order that we created. Enter and accept the issuing quantities. Notice in inventory parts have now moved from stores area 1 into WIP.
To receive this back as a finished assembly enter the R type transaction in the stockroom. Choose the Sales Order issued and receive this Sales Order back into area 1.
Take a few minutes to review this process entire process. Go into inventory and view a few parts and the final Bicycle assembly. You will notice that all of the individual component parts have decreased the precise amount used to build the bicycles. The bicycles in inventory have now increased.
Note: Once received, pc/MRP will only track one serial number per invoice line item. For multiple serial numbers per line item, the optional module Serial/Lot Number Tracking can be utilized.
Note: You have the choice to issue sub-assemblies or parts only. You can also do partial issuing and then utilize the F or M stockroom transactions for makeup issues. There is also an undo feature; transaction T that takes back issued parts.
Note: If you are often editing stock room transactions, you can use the audit WIP function in the Inventory module to help clean up things.
Note: It is always best to utilize the various stockroom transactions to help clean things up when mistakes have occurred. This creates a record for each transaction. When inventory is simply edited, there is often no paper trail. To help with this you can lock-up various editing processes through option 62 in the Settings and Utilities.
Note: Work orders are issued and processed in the exact same way as sales orders.
Go ahead and build the work order too.
The final step in this process is invoicing. In this step, we will relieve quantities in the storage areas representative of the 'order entry sales order' we entered. This step is taken in the Invoicing Module.
3.1.16 Invoice Module
To enter a new invoice, select Modules, Invoicing, and New. You will have to choose the terms of the sale and accept the invoice information. Once again, if the invoice must be edited, you may wish to edit the sales order as well. You may even want to edit the sales order first, thus the invoice will be automatically representative of the sales order. For more information, refer to the Invoice Module in the manual.
Go ahead and invoice the sales order on account. Once you have invoiced the sales order, go into the Inventory Module and view what has changed. WIP for the parts used was cleared through the Stockroom, and now inventory for the finished assemblies has decreased by the amount of the sales order. The sales cycle is now complete. The process to pay vendors and track accounts receivable has just begun. If you anticipate using pc/MRP for accounting, continue. If pc/MRP is going to be just an inventory and planning tool, now might be a good time to clean up this trial copy and start entering some of your inventory.
The fastest way to become familiar with pc/MRP's Accounting System is by actually using it. By entering the work sheet transactions on the following page, you will become familiar with pc/MRP's easy to use accounting system.
The first entry, labeled 000001 represents a typical transaction for starting an account or business. pc/MRP will automatically increment this number by one as transactions are made. Do not create your own transaction numbers. Transaction numbers should be chronological with no missing numbers.
To set up you company all of the company's assets are debited and the starting capital account is credited an equal amount. Then the company's liabilities are credited and the starting capital account is debited an equal amount.
To make the same starting entries in pc/MRP, go to Modules, Accounting, GL Transactions, and New Transaction, select A for All types of transactions and press OK. pc/MRP will give you the next available transaction number. You will now see the transaction data entry screen. Take note that the transaction number is 000001.
Click on the Description field and enter the description as STARTING BUSINESS. Throughout all of these first three transactions, enter a description of STARTING BUSINESS. Now go to the first debit account field. Enter 10100000 and you will see the description, CASH ON HAND appear next to the account number. Enter the sum $5000 under the AMT Field. Next debit account 10200000 for $10,000 and account 12100000 for $6000 (pc/MRP will take up to four debit accounts and five credit accounts in one byte). Notice at the bottom right in red pc/MRP says the transaction is currently UNBALANCED. To balance the three debit accounts, credit Account 25100000, STARTING CAPITAL with $21,000. If the transaction is now balanced, press Save to enter this transaction. pc/MRP will ask, "Do another record?" Select Yes. If the transaction is not balanced, review the steps above and look to see where you made a mistake in entering the dollar amounts.
After selecting Yes, take note that pc/MRP automatically increase the transaction number by 1. You should now be at transaction number 000002.
Now, debit accounts 13100000 for $15000, account 11100000 for $4000, and account 15100000 for $1000. To balance the debit accounts, credit account 25100000, STARTING CAPITAL for $20,000. Once again make sure the transaction is Balanced. If the transaction is balanced, press Save to enter this transaction and Yes to continue to the next transaction. If the transaction is not balanced, review the entries and make the necessary corrections.
Debit account 25100000, STARTING CAPITAL $25000 and credit account 24100000, NOTES PAYABLE $25000. If the transaction is balanced, select Save to save this transaction and select No when asked if you wish to enter another record. If the transaction is not balanced once again review the dollar amounts entered.
This final Starting entry, labeled 000004, prepares the inventory for purchase and sale transactions during the month. It does so by moving the stock from an asset account 12100000 to an expense account 40100000. This type of transaction is only necessary for companies using periodic accounting methods and not companies using perpetual accounting methods.
To make this final starting entry in pc/MRP, similar to above, go to Modules, Accounting, GL Transactions, New Transaction, select A for All types of transactions and press OK. Enter STOCK INVENTORY ADJUSTMENT in the description field. Debit account 40100000 for $6,000 and credit account 12100000 for $6,000.
Transaction 000005 - Transaction 000015
Enter the remaining transactions shown on 22.214.171.124
Transaction 000014 moves the months end remaining inventory back into the asset account so that the month's retained earnings will reflect the changes in inventory levels. . This type of transaction is only necessary for companies using periodic accounting methods and not companies using perpetual accounting methods.
Once all transactions have been entered, return to the Main Accounting Menu. Print out the transactions you have just entered by selecting Accounting Reports, select General Ledger Transactions, select All Transactions (3 times), and select Print. Your Transaction Report should match the sample Transaction report found in the Accounting Report Section of this manual.
If the Transaction Report looks good, return to the Main Accounting Menu and post the month by selecting Post/Re-post a Month and Print Financials. Enter the month and year that contain the above entries. Since pc/MRP stores the transactions in a database, you can edit incorrect transactions and repost the month if necessary.
pc/MRP's posting program begins by making sure the initial debit and credit balances are equal.
When pc/MRP finishes posting the month it automatically initializes the next month by: (1) zeroing out all starting balances of revenue and expense accounts (2) transferring forward all asset, liability and equity accounts and (3) adding the retained earnings (rev - exp) to the YTD earnings.
Finally yet importantly, pc/MRP's posting program will automatically print out the month's financial statements such as Income Statement, Expense Distribution Report, Trial Balance, YTD Revenue and Expense Report, and a Detailed Transaction Report. If you entered all the transactions correctly, your reports should match the sample reports found on the following pages.
126.96.36.199 Transaction Lesson Entries
TRAN ACCT. DESCRIPTION DEBIT CREDIT
0001 10100000 CASH ON HAND STARTING BUSINESS 5,000.00
10200000 BANK 10,000.00
12100000 STOCK INVENTORY 6,000.00
25100000 STARTING CAPITAL 21,000.00
0002 13200000 SHOP EQUIPMENT STARTING BUSINESS 15,000.00
11100000 ACCTS RECEIVBLE 4,000.00
15100000 PREP EXPENSES 1,000.00
25100000 STARTING CAPITAL 20,000.00
0003 25100000 STARTING CAPITAL 25,000.00
24100000 NOTES PAYABLE STARTING BUSINESS 25,000.00
0004 40100000 START INVENTORY STOCK INV ADJUST 6,000.00
12100000 STOCK INVENTORY 6,000.00
0005 41100000 PURCHASES KMART 3,000.00
41400000 FREIGHT 400.00
20100000 ACCTS PAYABLE 3,400.00
0006 11100000 ACCTS RECEIVABLE FM PRODUCTS 15,000.00
30100000 BUSINESS INCOME 15,000.00
0007 10200000 BANK CHECKING FM PRODUCTS 12,000.00
11100000 ACCTS RECEIVABLE 12,000.00
0008 50100000 WAGES P GOMEZ 500.00
22100000 PAYROLL TAX PAY 50.00
10200000 BANK CHECK 450.00
0009 61500000 RENT R TORRES 1,000.00
10200000 BANK CHECKING 1,000.00
0010 60100000 ADVERTISING S F EXAMINER 50.00
10200000 BANK CHECKING 50.00
0011 61000000 INSURANCE B BERNAL 700.00
10200000 BANK CHECKING 700.00
0012 61400000 OFFICE EXPENSE FRY'S 8.00
10100000 CASH ON HAND 8.00
0013 10200000 BANK CHECKING WFB INTEREST 25.00
80100000 OTHER INCOME 25.00
0014 12100000 STOCK INVENTORY ENDING INVENTORY 1,500.00
42100000 ENDING INVENTORY 1,500.00
0015 70100000 DEPRECIATION EXP 125.00
14100000 DEPREC ACCRUED 125.00
188.8.131.52 Transaction Lesson Reports
Entering the transactions from the accounting lesson and posting the month will create the following reports:
SMITH MANUFACTURING CORP
GENERAL LEDGER INCOME STATEMENT 04 89
GROSS REVENUE = 15000.00
COST OF GOODS SOLD = 7900.00
GROSS NET PROFIT 7100.00
COST OF LABOR = 500.00
OPERATING EXPENSES = 1758.00
NET PROFITS BEFORE WRITE OFFS 4842.00
WRITE OFF EXPENSES = 125.00
NET PROFIT BEFORE OTHER INCOME 4717.00
OTHER INCOME = 25.00
OTHER EXPENSES = 0.00
NET PROFIT BEFORE INCOME TAXES 4742.00
INCOME TAXES = 0.00
NET PROFIT 4742.00
184.108.40.206 The YTD Report
SMITH MANUFACTURING CORP
YTD EXPENSE AND REVENUE REPORT 04 89
Current Month YTD Budge YTD Budget %Var YTD %Var
30100000 BUSINESS INCOME 15000.00 15000.00 20000.00 20000.00 75 75
30900000 REFUNDS 0.00 0.00 0.00 0.00 *** ***
80100000 OTHER INCOME INTEREST 25.00 25.00 0.00 0.00 *** ***
REVENUE TOTALS 15025.00 15025.00 20000.00 20000.00 75 75
40100000 STARTING INVENTORY 6000.00 6000.00 0.00 0.00 *** ***
41100000 PURCHASES 3000.00 3000.00 0.00 0.00 *** ***
41200000 OUTSIDE LABOR 0.00 0.00 0.00 0.00 *** ***
41400000 FREIGHT 400.00 400.00 0.00 0.00 *** ***
42100000 ENDING STK INVENTORY 1500.00 -1500.00 0.00 0.00 *** ***
COST OF GOODS SOLD TOTALS 7900.00 7900.00 0.00 0.00 *** ***
50100000 WAGES 500.00 500.00 0.00 0.00 *** ***
51100000 PAYROLL TAXES 0.00 0.00 0.00 0.00 *** ***
---------------------------------------------------------------------------------------COST OF LABOR TOTALS 500.00 500.00 0.00 0.00 *** ***
60100000 ADVERTISING 50.00 50.00 0.00 0.00 *** ***
60600000 CAR AND TRUCKS 0.00 0.00 0.00 0.00 *** ***
60800000 DUES AND SUBSCRIPTIONS 0.00 0.00 0.00 0.00 *** ***
60900000 INSURANCE AUTO 0.00 0.00 0.00 0.00 *** ***
61000000 INSURANCE GENERAL 700.00 700.00 0.00 0.00 *** ***
61400000 OFFICE SUPPLIES 8.00 8.00 0.00 0.00 *** ***
61500000 RENT 1000.00 1000.00 0.00 0.00 *** ***
62300000 TELEPHONE 0.00 0.00 0.00 0.00 *** ***
---------------------------------------------------------------------------------------OPERATING EXPENSES TOTALS 1758.00 1758.00 0.00 0.00 *** ***
70100000 DEPRECIATION EXPENSES 125.00 125.00 0.00 0.00 *** ***
70200000 AMORTIZATION EXPENSES 0.00 0.00 0.00 0.00 *** ***
---------------------------------------------------------------------------------------WRITE OFF EXPENSES TOTALS 125.00 125.00 0.00 0.00 *** ***
81100000 OTHER EXPENSES PORTFOLIO 0.00 0.00 0.00 0.00 *** ***
OTHER EXPENSES TOTALS 0.00 0.00 0.00 0.00 *** ***
RETAINED EARNING TOTALS 4742.00 4742.00 0.00 0.00 *** ***
220.127.116.11 The Trial Balance Report
SMITH MANUFACTURING CORP
GENERAL LEDGER TRIAL BALANCE 05 92
ACCT DESCRIPTION TYPE DEBIT CREDIT
10100000 CASH ON HAND AC 4992.00
10200000 BANK CHECKING ACCOUNT AC 19825.00
10300000 BANK SAVINGS ACCOUNT AC 0.00
11100000 ACCNT/RECVB.CUSTOMERS AC 7000.00
11200000 ACCNT/RECVS.OTHERS AC 0.00
11900000 A/R BAD DEBT RESERV AC 0.00
12100000 STOCK INVENTORY AC 1500.00
13100000 SHOP EQUIPMENT AF 0.00
13200000 FURNITURE & FIXTURES AF 15000.00
13300000 TRANSPORTATION EQUIP. AF 0.00
13400000 LEASEHOLD EQUIP. AF 0.00
13500000 LAND AF 0.00
13600000 BUILDING AF 0.00
14100000 DEPRECIATION ACCRUED AD 125.00
14200000 AMORTIZATION ACCRUED AD 0.00
15100000 PREPAID EXPENSES AL 1000.00
20100000 ACCNTA/PAYAB.VENDORS LC 3400.00
20200000 ACCNTS/PAYAB.OTHERS LC 0.00
21100000 SALES TAX LC 0.00
22100000 PAYROLL TAX. F.W.T. LC 50.00
22110000 PAYROLL TAX. F.I.C.A. LC 0.00
22120000 PAYROLL TAX. F.U.T.A. LC 0.00
22130000 PAYROLL TAX.S.D.I.C.A. LC 0.00
22140000 PAYROLL TAX.S.W.T.C.A. LC 0.00
22150000 PAYROLL TAX.S.U.I.C.A. LC 0.00
22160000 PAYROLL TAX.E.T.T.CA. LC 0.00
22900000 INCOME TAX. FEDERAL LC 0.00
22910000 INCOME TAX. STATE LC 0.00
23100000 MORTGAGES LL 0.00
24100000 NOTES PAYABLE LL 25000.00
25100000 STARTING CAPITAL QN 16000.00
26100000 CAPITAL INCREASE QN 0.00
27100000 CAPITAL DECREASE QN 0.00
28100000 OTHER INVESTMENT QN 0.00
29100000 COMPANY TAXES QN 0.00
29900000 YTD RETAINED EARNINGS QR 0.00
30100000 BUSINESS INCOME RN 15000.00
30900000 REFUNDS RN 0.00
40100000 STARTING INVENTORY EG 6000.00
41100000 PURCHASES EG 3000.00
41200000 OUTSIDE LABOR EG 0.00
41300000 SALES COMMISIONS EG 0.00
41400000 FREIGHT EG 400.00
42100000 ENDING STOCK INVENTORY EG 1500.00
50100000 WAGES EL 5000.00
51100000 PAYROLL TAXES EL 500.00
51200000 WORKERS COMP.INSURANCE EL 0.00
51300000 EMPLOYEES BENEFITS EL 0.00
Trial Balance Continued
60100000 ADVERTISING EN 50.00
60200000 ACCOUNTANT/ATTORNEY EN 0.00
60300000 BAD DEBTS EN 0.00
60400000 BANK CHARGES EN 0.00
60500000 BOOKEEPER EN 0.00
60600000 CARS AND TRUCKS EN 0.00
60800000 DUES & SUBSCRIPTIONS EN 0.00
60900000 INSURANCE AUTO EN 0.00
61000000 INSURANCE GENERAL EN 700.00
61100000 INTEREST EN 0.00
61200000 LUANDRY & CLEANING EN 0.00
61300000 LEASING EQUIPMENT EN 0.00
61400000 OFFICE SUPPLIES EN 8.00
61500000 RENT EN 1000.00
61600000 REPAIRS EN 0.00
61700000 SHOP SUPPLIES EN 0.00
61800000 PROMOT/ENTERTAINMENT EN 0.00
61900000 TRAVEL EN 0.00
62000000 TAXES EN 0.00
62100000 OTHER TAXES EN 0.00
62200000 PERMITS & LICENSES EN 0.00
62300000 TELEPHONE EN 0.00
62400000 TELECOMMUNICATIONS EN 0.00
62500000 UTILITIES EN 0.00
70100000 DEPRECIATION EXPENSE EW 125.00
70200000 AMORTIZATION EXPENSE EW 0.00
80100000 OTHER INCOME INTEREST RO 25.00
81100000 OTHER EXP PORTOFIO EO 0.00
90100000 COMPANY TAX-FEDERAL ET 0.00
90200000 COMPANY TAX STATE ET 0.00
TOTALS 61100.00 61100.00
18.104.22.168 Balance Sheet
SMITH MANUFACTURING CORP
BALANCE SHEET 04 89
10100000 CASH ON HAND + 4992.00
10200000 BANK CHECKING ACCOUNT + 19825.00
10300000 BANK SAVINGS ACCOUNT + 0.00
11100000 ACCNT/RECVB CUSTOMERS + 7000.00
11200000 ACCNT/RECVS OTHERS + 0.00
11900000 A/R BAD DEBT RESERV - 0.00
12100000 STOCK INVENTORY + 1500.00
15100000 PREPAID EXPENSES + 1000.00
13100000 SHOP EQUIPMENT + 0.00
13200000 FURNITURE & FIXTURES + 15000.00
13300000 TRANSPORTATION EQUIP + 0.00
13400000 LEASE HOLD EQUIPMENT + 0.00
13500000 LAND + 0.00
13600000 BUILDING + 0.00
14100000 DEPRECIATION ACCRUED - 125.00
14200000 AMORTIZATION ACCRUED - 0.00
TOTAL ASSETS 49192.00
22.214.171.124 Balance Sheet Continued
SMITH MANUFACTURING CORP
BALANCE SHEET 04 89
20100000 ACCNTS/PAYAB VENDORS + 3400.00
20200000 ACCNTS/PAYABLE OTHERS + 0.00
21100000 SALES TAX + 0.00
22100000 PAYROLL TAX F.W.T. + 50.00
22110000 PAYROLL TAX F.I.C.A. + 0.00
22120000 PAYROLL TAX F.U.T.A. + 0.00
22130000 PAYROLL TAX S.D.I.C.A + 0.00
22140000 PAYROLL TAX S.W.T.C.A + 0.00
22150000 PAYROLL TAX S.U.I.C.A + 0.00
22160000 PAYROLL TAX E.T.T.C.A + 0.00
22900000 INCOME TAX FEDERAL + 0.00
22160000 INCOME TAX STATE + 0.00
LONG TERM LIABILITIES
23100000 MORTGAGES + 0.00
24100000 NOTES PAYABLE + 25000.00
25100000 STARTING CAPITAL + 16000.00
27100000 CAPITAL DECREASE - 0.00
28100000 OTHER INVESTMENT + 0.00
29100000 COMPANY TAXES - 0.00
29900000 YTD RETAINED EARNINGS + 4742.00
TOTAL LIABILITY + EQUITY 49192.00