3. ESTUDO EMPÍRICO
3.1 Estudo Quantitativo
26Select List Price, Decrease by Percent, and No Rounding from the drop-down lists.
27Enter 25.00 in the % field and click OK.
28Click OK to save the defaults.
. . . . . .
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
. . . .
A D D I N G I N V E N T O R Y I T E M S
After entering the inventory item default information, the next step is to enter each item. As items are added, you can use the default information that was entered or you can assign different information.
To add or edit inventory items, select Maintain, Inventory Items.
M a i n t a i n I n v e n t o r y I t e m s W i n d o w
The Maintain Inventory Items window is used to enter, change, and store information on the products and services you purchase and sell. Each tab is described below:
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
. . . . .
H E A D E R F I E L D S• Item ID: Identifies the inventory item in lookup lists, transactions, and reports. Once an ID is saved, you can click Change ID to make changes.
• Description: Enter a brief description of the item. This description appears in the Item lookup list on transaction windows.
• Item Class: Select an item class from the drop-down list. Every inventory item will fall under one of the classes defined earlier in the chapter.
Different fields will appear for each inventory class. Once an item has been saved, the Item Class field cannot be changed.
G E N E R A L T A B
Information specific to each inventory item is entered on the General tab. Depending on the item class of the inventory item, some fields may not be available on the General tab.
Beginning balances are also entered and maintained on the General tab. Fields of interest are described below:
• Description for Sales/for Purchases: Enter two descriptions per item, one for sales and another for purchases. The sales description for this item will appear when you enter quotes, sales orders and invoices. The purchase description for an item appears when purchase orders and purchases are entered.
• Price: Enter the sales price for the inventory item. To enter additional price levels, click the arrow button to open the Multiple Price Levels window. These price levels will correspond with those assigned to your customers.
• Last Unit Cost: For stock and assembly items, enter the last purchase price paid for the item. Once a beginning balance or transaction is entered using this item, this field is updated by Peachtree. For non-stock, service, and labor items, enter the Cost of Sales amount that should be posted when the item is sold.
• Cost Method: Select one of the three available costing methods from this drop-down list. Choices include FIFO, LIFO, and Average. The cost method cannot be changed after the inventory item has been saved. This field will show only for stock and assembly inventory items.
- Average Cost: When an item using Average Costing is sold, Peachtree uses the average cost of the item to calculate the cost of goods sold. The cost of goods sold amount is the average cost multiplied by the quantity of the item sold.
- FIFO: Using the First In First Out method, inventory is valued with the assumption that items are sold in the order in which they are received. The oldest cost of an item is the first cost to be used to calculate the value of the item.
. . . . . .
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
- LIFO: Using the Last In First Out method, inventory is valued with the assumption that items are sold in the reverse order in which they are received. The newest cost of an item is the first cost to be used to calculate the value of the item.
• Item Type: This case-sensitive field can be used to filter records for reporting purposes.
C U S T O M F I E L D S T A B
The Custom Fields tab contains the custom field labels entered through default information. Enter information specific to each inventory item in these fields.
If a field label is dimmed, then the field is not available, and you cannot enter information in the field. To make the field available, return to the Custom Fields tab in Inventory Item Defaults and select the Enabled check box for that field label.
H I S T O R Y T A B
Select the History tab to view the inventory item history information. Changes cannot be made on this window. This window displays the period history date and for that date the number of units sold, dollar sales, number of units received, and total costs for the selected item.
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
. . . . .
A C T I V I T Y 1 1 - A D D I N G I T E M S
Abracadabra sells books related to the Internet to its customers. Follow these steps to enter items:
1 Select Maintain, Inventory Items.
2 Enter an Item ID of bintro1.
3 The Description for this item is Introduction to the Internet.
4 Select Stock item for the Item Class.
Once the item is saved, the Item Class cannot be changed.
5 Select the Subject to Commission check box so that a sale of the item shows as commissionable on the Sales Rep Reports.
6 Enter a Description for Sales of Introduction to the Internet, a New User Guide to Getting Started on the Internet.
7 Click the drop-down arrow next to for Sales and select for Purchases from the drop-down list. This refreshes the box to the right so you can enter a
Description for Purchases for the item.
8 Enter a Description for Purchases of Introduction to the Internet, ISBN 0024876315.
. . . . . .
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
The Description for Sales will print on sales transactions, while the Description for Purchases will print on purchase transactions.
9 Click the arrow button to the right of the List Price field.
10Enter 33.59 in the Price field for the List Price level.
11Enter 30.59 in the Price field for the Personal level.
12Enter 25.49 in the Price field for the Commercial level.
13Click OK to return to the item window.
14Now, enter the following accounts:
15Books are taxable, so the Item Tax Type should be set to 1.
16Enter Each in the Stocking U/M field. Leave the Item Type and Location fields blank.
17Enter 5.00 for both the Minimum Stock and Reorder Quantity.
18Select 01comp from the Preferred Vendor ID lookup list.
19Click Save, then click New.
GL Sales Account 40600-P GL Inventory Acct 12000 GL Cost of Sales Acct 50500
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
. . . . .
20Using these steps as a guide, enter the second stock item.21Click Save to add the stock item, then click Close.
A C T I V I T Y 1 2 - A D D I N G S E R V I C E I T E M S
Web sites are programmed and maintained by Abracadabra. To make transaction entries easier, you will set up these service items in inventory. Each service item will have a description, accounts, and a sales price assigned, simplifying data entry.
Follow these steps to enter service items:
1 Select Maintain, Inventory Items.
2 The first service Item ID is htmlprogp.
3 The Description is HTML Programming-Personal.
Description for Sales Surfing the Net, an Intermediate Guide to the Internet
Description for Purchases Surfing the Net, ISBN 0856732840 List Price 36.99
. . . . . .
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
5 Sales of services are not commissionable, so do not check the Subject to Commission box.
6 In the Description for Sales enter HTML programming for personal web site.
Since the service is not purchased, there is no Description for Purchases.
7 Enter 35.00 in the List Price field.
8 Click the arrow button to the right of the List Price field.
9 Enter 31.50 in the Price field for the Personal level.
10Enter 26.25 in the Price field for the Commercial level.
11Click OK to return to the item window.
12Leave the Last Unit Cost field zero.
13Enter the following General Ledger accounts:
If the Last Unit Cost field is left zero, only the sales account will be affected when the item is sold.
14Since this is a non-taxable service, select an Item Tax Type of 2.
15Enter Hour in the Stocking U/M field.
16Click Save; then click New.
GL Sales Account 40400-P GL Salary/Wages Account 77500
GL Cost of Sales Acct 50000
S E T T I N G U P I N V E N T O R Y Adding Inventory Items
5
. . . . .
17Using these steps as a guide, enter the remaining service items. Remember toclick Save to add each item and New to add the next item:
18Click Close when you are finished.
Service Item #1 Service Item #2
Item ID htmlprogc webmaintp
Description HTML Programming-Commercial Web Site Maintenance
Item Class Service Service
Description for Sales HTML programming for
commercial web site Maintenance for personal web site
List Price 45.00 60.00
Personal 40.50 54.00
Commercial 33.75 45.00
GL Sales Acct 40400-C 40500-P
GL Salary/Wages Acct 77500 77500
GL Cost of Sales Acct 50000 50000
Item Tax Type 2 2
Stocking U/M Hour Hour
. . . . . .
S E T T I N G U P I N V E N T O R Y Entering Inventory Beginning Balances
5
. . . .
E N T E R I N G I N V E N T O R Y B E G I N N I N G B A L A N C E S
Click the Beginning Balances arrow on the General tab to enter beginning balances for inventory. The total beginning balances amount should equal the amount entered as the beginning balance in the General Ledger inventory account. Inventory beginning balances can be updated until the fiscal year is closed.
I n v e n t o r y B e g i n n i ng B a l a n c e s W i n d o w
Enter information regarding the current quantity on hand and cost of each inventory item in the Inventory Beginning Balances window.
A C T I V I T Y 1 3 - E N T E R I N G I N V E N T O R Y B E G I N N I N G B A L A N C E S Abracadabra’s book inventory was counted at the end of January. This count will be used to enter the beginning balances for inventory. Follow these steps to enter inventory beginning balances:
1 Select Maintain, Inventory Items.
2 Click the Beginning Balances arrow button on the General tab.
3 Click bintro1 in the list of items shown.
4 Enter a Quantity of 10.00 and a Unit Cost of 22.00.
5 Click bsurf1 in the list of items shown.
6 Enter a Quantity of 12.00 and a Unit Cost of 24.00.
7 Click OK to save these two beginning balances; then click Close.
S E T T I N G U P I N V E N T O R Y Entering Inventory Beginning Balances