pc/MRP Tutorial

You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.

Please click below for
the latest pc/MRP Manual

Please click below to
reach the pc/MRP Main Page

Manual Logo

Main Page Logo

 

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 about.

3.1.4 Creating a Practice Directory

Shows users how to make a backup copy and 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 Bucket 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 Purchasing

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.

3.1.17 Accounting

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. Through 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 this. 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.

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 when ever 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 several copies throughout your network. This simply confuses end-users. Furthermore, we recommend using option number 19 in the settings and utilities to change the color of the pc/MRP screen to an ugly blue in test copies. This helps users recognize that they are in a test copy.

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.

3.1.5.1 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, 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 date Start Date. This will automatically be populated by the date in your computer.

Notice that several tabs exist that allow users to enter additional data. The additional tabs consist of: Sales Contact Information, additional billing and shipping addresses, and Invoice and Receiver history. Salesman 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.

3.1.5.2 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, 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: There are several fields that 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.

3.1.5.3 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, or 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.

3.1.5.4 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 select, 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.

There are several things that 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.10.1, Special Cases.

3.1.6.1 Entering New Parts

Similar to the Address Book, when an end-user wants to enter a new part, simply select: Modules, Inventory, and New. Select next available part number.

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 will be created. Enter data as described in the picture below.

Notice similar to the address book entry screen several tabs exist in inventory. 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.

3.1.6.2 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.

3.1.6.3 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.

Bicycle BOM

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.

3.1.7.1 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.

Select OK

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:

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 NFG 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 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 the newly built TUBE ASSEMBLY.

Select: Modules, BOM, New.

Enter BOM number: 000000002 with a description of WHEEL.

Select OK

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. And 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.

Select OK

Enter the items that finish off this assembly so that it matches the picture below.

We have just completed the entire Bicycle BOM.

3.1.7.2 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.

3.1.7.3 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 either 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 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.

3.1.9.1 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.

Press OK.

This screen explains that two bicycles are being removed from inventory area One.

Press OK.

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.

3.1.9.2 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.

3.1.9.3 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 representative of 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 however, 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 to edit 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 have 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 demand 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 be really no 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 basically 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 pending 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. Either companies 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 what 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, take a 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 things up.

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, once again 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.

3.1.17 Accounting

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, 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.

Transaction 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 $10000 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.

Transaction 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 $20000. 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.

Transaction 000003.

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.

Transaction 000004

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.

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 N 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.

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 back 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.

Last but not least 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.


 

3.1.17.1 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
 
 
 
      

 


 

 

3.1.17.2 Transaction Lesson Reports

Entering the transactions from the accounting lesson and posting the month will create the following reports:

SMITH MANUFACTURING CORP                              
09/23/90 
 
 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
 
  
 
 
 
     

 


 

3.1.17.3 The YTD Report

SMITH MANUFACTURING CORP                                                                  
9/23/90                                                         
                                                                                                  
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    ***     ***
 
 
 
 
 

 


 

3.1.17.4 The Trial Balance Report

 
 
SMITH MANUFACTURING CORP                                     
  09/23/90                                                     
                                                               
    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            
 41900000  PURCHASES DISCOUNTS    EG                          0.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    
 
 

 


 

14.4.6 Balance Sheet

SMITH MANUFACTURING CORP                                     
09/23/90                                                     
                                                              
BALANCE SHEET 04 89                                          
 ____________________________________________________________ 
 
ASSETS 
 
    CURRENT ASSETS                  
      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 
                                        ---------- 
 
                                TOTAL     33317.00 
                                          
    OTHER ASSETS 
      15100000  PREPAID EXPENSES      +    1000.00 
                                        ---------- 
 
                                TOTAL      1000.00
 
              
    FIXED ASSETS  
      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
                                        ---------- 
 
                                TOTAL     15000.00              
                                  
   LESS DEPRECIATION   
      14100000  DEPRECIATION ACCRUED   -    125.00 
      14200000  AMORTIZATION ACCRUED   -      0.00
                                        ---------- 
 
                                TOTAL      -125.00 
 
                                                 
  TOTAL ASSETS                            49192.00      
 
 
 
 
     
                                                           

 


 

Balance Sheet Continued

SMITH MANUFACTURING CORP 
09/23/90 
 
BALANCE SHEET 04 89 
____________________________________________________________ 

 LIABILITIES

    CURRENT LIABILITIES

        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

                                                         ---------

 

                                              TOTAL      3450.00

 

 

LONG TERM LIABILITIES

        23100000    MORTGAGES                 +             0.00

        24100000    NOTES PAYABLE             +         25000.00

                                                         ----------

                                              TOTAL     25000.00

 EQUITY

        25100000    STARTING CAPITAL          +         16000.00

        27100000    CAPITAL DECREASE          -             0.00

        28100000    OTHER INVESTMENT          +             0.00

        29100000    COMPANY TAXES             -             0.00

                                                           ----------

                                              TOTAL     16000.00

 

        29900000    YTD RETAINED EARNINGS +              4742.00

 

 TOTAL LIABILITY + EQUITY                                49192.00