Student

Answer to Q6
Order Point Ordering Techniques
Perpetual Inventory Record
Order Point
Part number
Part Description
Storage Location
1200
Red Bull
Goodie Baskets Warehouse
Order Quantity
Order Point or Target
10000
DDLT+SS=
9300
Usage
Lead Time
Safety Stock or Min
Max or Review Period
2325
3
2325

Date
Reference
Ordered
Received
Issued
On hand
Allocated
Available
Opening Inventory

10500 10500
Week1
WO#01

-2325
8175

8175
Week1
PO#01
10000

8175 8175
Week2
WO#02

-2325
5850

5850
Week3
WO#03

-2325
3525

3525
Week4
WO#04

-2325
1200

1200
Week4
Rec#01/PO#01 10000 11200 11200
Week5
WO#05

-2325
8875

8875
Week5
PO#02
10000

8875 8875
Week6
WO#06

-2325
6550

6550
Week7
WO#07

-2325
4225

4225
Week8
WO#08

-2325
1900

1900
Week8
Rec#02/PO#02 10000 11900 11900

Min & Max Ordering Techniques
Perpetual Inventory Record
Min & Max
Part number
Part Description
Storage Location
3100
Apples
Goodie Baskets Warehouse
Order Quantity
Order Point or Target
Max-Inventory
DDLT+Max=
7580
Usage
Lead Time
Safety Stock or Min
Max or Review Period
1395
4
2000
15000
Date
Reference
Ordered
Received
Issued
On hand
Allocated
Available
Opening Inventory

8000 8000
Week1
WO#11

-1395
6605

6605
Week1
PO#11
8395

6605 6605
Week2
WO#12

-1395
5210

5210
Week3
WO#13

-1395
3815

3815
Week4
WO#14

-1395
2420

2420
Week5
WO#15

-1395
1025

1025
Week5
Rec#11/PO#11 8395 9420 9420
Week6
WO#16

-1395
8025

8025
Week7
WO#17

-1395
6630

6630
Week7
PO#12
8370

6630 6630
Week8
WO#18

-1395
5235

5235
Week9
WO#19

-1395
3840

3840
Week10
WO#20

-1395
2445

2445
Week11
WO#21

-1395
1050

1050

Bibliography: James H. Greene. Production & Inventory Control Handbook Third Edition. New York: McGraw-Hill, 1997. Kaye Cee McKay, and Maryanne Ross. “Inventory Accuracy: The Elusive Butterfly!.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014). Roger B. Brooks, and Larry W. Wilson. Inventory Record Accuracy Unleashing the Power of Cycle Counting. Toronto: John Wiley & Son, Inc., 1995. Paul Deis. Production and Inventory Management in the Technological Age. Toronto: Prentice-Hall Canada, Inc., 1983. Janet Steiner Soukup. “How Small Businesses Can Use a Cycle-Count Program to Control Inventory.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014). Anne Haberkorn. “Say”Good-bye” to a Yearly Ritual.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014). J.R. Tony Arnold, Stephen N. Chapman, and Lloyd M. Clive. Introduction to Materials Management Seventh Edition. New Jersey: Prentice Hall, 2012. Ed White. “The Root of the Problem.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014). Dan G. Salley. “Reduce the Non-Value-Added Elements of Cycle Counting.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014). Jack S. Cook, and Laura Cook. “RFID: Revolutionizing Inventory Management Across the Supply Chain.” APICS. http://www.apics.org/industry-content-research/industry-resources/publications-database (accessed April 4, 2014).