Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ABC Manufacturing uses certain coding system to label jobs. Each job requires processing of a batch of parts, and batches vary in size. A

 

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Automation Production Systems and Computer Integrated Manufacturing

Authors: Mikell P.Groover

3rd edition

132393212, 978-0132393218

More Books

Students also viewed these Programming questions