1. Enterprise Resource Planning (ERP)
Find a news item within the past 6 months about a company that has benefitted from enterprise resource planning.
(i) Describe the company briefly - product/services, locations, customers
(ii) Describe the company's operations briefly - type of process
(iii) Describe how ERP has benefitted the company
2. MRP
Specialty Bikes Inc (SBI) assembles road bikes for recreational use. There has been a surge in road cycling with the baby boom generation. The assembly of the bike has the following BOM:
A = Finished assembled bike
HB = Handle bars
W = Wheels
C = Chain set with pedals
G = Gear set
The assembly department already has the frame which includes the seat. Orders for bikes and parts schedules to be received are as follows:
|
Orders for Bikes
|
|
Week
|
Bikes Ordered
|
|
5
|
300
|
|
6
|
200
|
|
7
|
400
|
| Current on Order |
|
HB
|
300 in week 3
|
|
W
|
200 in week 4
|
The inventory status is as follows:
|
Inventory Status
|
|
|
|
|
|
|
Part
|
A
|
HB
|
W
|
C
|
G
|
|
On Hand
|
100
|
50
|
150
|
200
|
300
|
|
Lead Time (Weeks)
|
2
|
2
|
2
|
0
|
0
|
|
Lot Size
|
LFL
|
300
|
LFL
|
250
|
LFL
|
|
Safety Stock
|
0
|
0
|
0
|
100
|
0
|
Requirement: Complete the MRP Records
|
Part
|
Lot
|
Lead
|
On
|
Safety
|
|
|
|
|
|
|
|
|
|
No.
|
Size
|
Time
|
Hand
|
Stock
|
Weeks
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
|
|
|
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected on Hand
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Releases
|
|
|
|
|
|
|
|
|
Part
|
Lot
|
Lead
|
On
|
Safety
|
|
|
|
|
|
|
|
|
|
No.
|
Size
|
Time
|
Hand
|
Stock
|
Weeks
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
|
|
|
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected on Hand
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Releases
|
|
|
|
|
|
|
|
|
Part
|
Lot
|
Lead
|
On
|
Safety
|
|
|
|
|
|
|
|
|
|
No.
|
Size
|
Time
|
Hand
|
Stock
|
Weeks
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
|
|
|
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected on Hand
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Receipts
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Planned Order Releases
|
|
|
|
|
|
|
|