MIS 1
Management Information Systems
Chapter 8 Homework
1. Calculate the Bill of Materials. Fill in the table below assuming that 100 Wagons need to be produced
|
Part Number |
Description |
Inventory Level |
Amount to Order |
|
2 |
Handle Bar |
30 |
-- |
|
3 |
Bar Grip |
100 |
? |
|
4 |
Bar Tang |
50 |
? |
|
5 |
Wagon Body, Metal |
10 |
? |
|
6 |
Front Wheel Assembly |
20 |
-- |
|
7 |
Front Wheels |
50 |
? |
|
8 |
Axel |
80 |
? |
|
9 |
Front Wheel Retainer |
80 |
? |
|
10 |
Rear Wheel Assembly |
150 |
-- |
|
11 |
Rear Wheels |
20 |
? |
|
12 |
Axel |
10 |
? |
|
13 |
Wheel Retainer |
20 |
? |
|
14 |
Bar Stock |
150 |
? |
2. Lab: Create a BOM database to query the required number of materials.
Follow the instruction shown on in “LabBOM.doc” and paste your result table below. Two tables are required:
a. Table showing all required materials and quantity when wagon order quantity = 100 and inventory level = 0.
<paste your resulting screenshot here>
b. Table showing all required materials and quantity when wagon order quantity = 500 and inventory level = 100.
<paste your resulting screenshot here>