ABC Manufacturing uses certain coding system to label jobs. Each job requires processing of a batch...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Automation Production Systems and Computer Integrated Manufacturing
ISBN: 978-0132393218
3rd edition
Authors: Mikell P.Groover
Posted Date:
Students also viewed these programming questions
-
Complete the following tables for the lodgement schedule requirements for BAS/IAS lodgements. Choose the correct'Remittance due' timing for each type. (a) GST amounts: Taxpayer Type Report required...
-
can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
General Ledger Accounts Account: Cash Date Description Opening Balance Account: Date Petty Cash Description Opening Balance Account: Date Accounts Receivable Description Opening Balance Account: Date...
-
If you purchase an investment privately, how do you determine the maximum price you are prepared to pay
-
When lightning strikes, it can heat the air around it to more than 30 000 K, five times the surface temperature of the Sun. (a) What is this temperature on the Fahrenheit and Celsius scales? (b) The...
-
Ernie's Electronic Repair Shop has budgeted the following time and material for 2002. Ernie's budgets 5,000 hours of repair time in 2002 and will bill a profit of \($5\) per labor hour along with a...
-
Capital balances in Midway Co. are Mirko $40,000, Neil $30,000, and Grillini $18,000. Mirko and Neil each agree to pay Grillini $12,000 from their personal assets. Mirko and Neil each receive 50% of...
-
On September 30, Year 1, Hybrid Company purchases a new state-of-the art combine from a Japanese equipment manufacturer for 43,500,000 yen (JPY) payable March 31, Year 2. The JPY/USD exchange rates...
-
The market rate of interest for a bond issue which sells for more than its face value is Less than the interest rate stated on the bond. Independent of the interest rate stated on the bonds. Higher...
-
Some are doing so because of rising tensions between Beijing and Washington, on everything from trade, technology and security to Taiwan. The exodus of Chinese manufacturing The differences threaten...
-
The truss system supports the loading shown below. EA is constant for the truss members. Assume Different Values for s, h, P1, P2, P3 a. Find the vertical and horizontal displacements at point i...
-
Being the part of such a large TATA group is itself a competitive advantage. This affiliation provides the company with the needed knowledge and technology resources for taking their business to...
-
Find the plane tangent at the point (2,3,-1) to the surface defined implicitly by the equation In(xy + xz + yz) = 0 assuming z = f(x,y) is a differentiable function of x and y in some neighborhood of...
-
The bars, shown in sketches (a) and (b), are made from cold-drawn, AISI 1050 QT at 425 C medium carbon steel. For each of the bars determine The maximum static tensile load (P) causing fracture, The...
-
Acc. Dep. Store Equipment normal balance is and the financial statement Acc. Dep. Store Equipment is placed on is A Credit; Income Statement B Credit; Balance Sheet C Debit; Income Statement D Debit;...
-
What mass of KBr (in grams) should you use to make 350.0 mL of a 1.30 M KBr solution?
-
Why and how do tax authorities get involved in the transfer pricing situation?
-
Assume a VAT situation where the tax rate is 15 percent, with export sales exempt. The manufacturer does not purchase inputs on which VAT has been paid, and its net selling price to the wholesaler...
-
A Galex Com pain, a manufacturer of stereo systems, started its production in October 2002. For the preceding 3 years Galex had been a retailer of stereo systems. Alter a thorough survey ol stereo...
Study smarter with the SolutionInn App