Brian Fry Products manufactures a variety of machine tools and parts used primarily in industrial tasks. To control production, the company requires the information listed below. Design an efficient record format for Brian Fry Products.
a. Order number (4 digits)
b. Part number to be manufactured (5 digits)
c. Part description (10 characters)
d. Manufacturing department (3 digits)
e. Number of pieces started (always less than 10,000)
f. Number of pieces finished
g. Machine number (2 digits)
h. Date work started
i. Hour work started (use 24-hour system)
j. Date work completed
k. Hour work completed
l. Work standard per hour (3 digits)
m. Worker number (5 digits)
n. Foreman number (5 digits)