Question: make sure to add the code lines please Problem 2. Kaizer Plastics produces a variety of customized plastic items for packaging and distribution. Items are

make sure to add the code lines please Problem 2.

make sure to add the code lines please

Problem 2. Kaizer Plastics produces a variety of customized plastic items for packaging and distribution. Items are produced in batches, but each batch might require a different sequence of production steps. Each batch is placed in one container, and the container is assigned a code that indicates the sequence of steps in which the items in the batch must be processed through the shop. The code is alphabetic and contains at least 5 characters, but no more than 10 characters. Each character (letter) represents a label for a workstation on the production floor. For example, the code AGSAYY indicates that the container should go through workstations A -> G->S->A -> Y -> Y in that order. To help the operators at each workstation, write a VBA sub that will take two inputs: (1) an alphabetic code as described above, and (2) the current step number in the sequence. The sub will display a message indicating the next station where the container should go. For example, if the code is AGSAYY and the MEM 3231 Computers in Manufacturing current step in the sequence is 2, then the sub will display a message indicating that the container should go to station S next. If the container has reached the end of the sequence, so that the production of the batch has been completed, then the sub will display a message such as "BATCH PRODUCTION COMPLETED. The sub must also check that the code has a valid number of characters; if not, it should display an error message to the operator indicating that the code is invalid. (Hint: input the code as a string and use the MID function to extract the character in the code that corresponds to the next station in the sequence)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!