ABC Manufacturing uses certain coding system to label jobs. Each job requires processing of a batch...

 

Transcribed Image Text:

ABC Manufacturing uses certain coding system to label jobs. Each job requires processing of a batch of parts, and batches vary in size. A job code is always 15 characters long. The code for a job consists of the first three characters of the name of the company that placed the order, the batch size (two digits, ranging from 10 to 99), five characters to refer to the type of part to be made, and the expected delivery date in a format mm/dd. For example, code XYT23TOOLA10/17 means that a batch of 23 parts of type TOOLA ordered by XYT is expected to be delivered by 10/17 (i.e., October 17). a) Design a user form like shown on Figure 1 to input the respective values of a job. When the user presses the "Create Code" button, the program will create a 15-character code as described above. Assume that the user will enter all those inputs in the correct format, so that you do not need to worry about checking that the inputs are valid. After creating the corresponding code, the program will display it on a message box. b) Add another button labeled "Decode" to your form. When this button is pressed, the program will ask the user for a valid 15-character code (use InputBox) and the program will output (using one or more message boxes) the details of the order, such as the company name (three characters), part to be made (5 characters), the batch size, etc. c) Add a button to a sheet to open your form. ABC Manufacturing Company Name Batch Size Part Name Delivery Date (mm/dd) Create Code Figure 1. ABC Manufacturing uses certain coding system to label jobs. Each job requires processing of a batch of parts, and batches vary in size. A job code is always 15 characters long. The code for a job consists of the first three characters of the name of the company that placed the order, the batch size (two digits, ranging from 10 to 99), five characters to refer to the type of part to be made, and the expected delivery date in a format mm/dd. For example, code XYT23TOOLA10/17 means that a batch of 23 parts of type TOOLA ordered by XYT is expected to be delivered by 10/17 (i.e., October 17). a) Design a user form like shown on Figure 1 to input the respective values of a job. When the user presses the "Create Code" button, the program will create a 15-character code as described above. Assume that the user will enter all those inputs in the correct format, so that you do not need to worry about checking that the inputs are valid. After creating the corresponding code, the program will display it on a message box. b) Add another button labeled "Decode" to your form. When this button is pressed, the program will ask the user for a valid 15-character code (use InputBox) and the program will output (using one or more message boxes) the details of the order, such as the company name (three characters), part to be made (5 characters), the batch size, etc. c) Add a button to a sheet to open your form. ABC Manufacturing Company Name Batch Size Part Name Delivery Date (mm/dd) Create Code Figure 1.