Question: if anyone coukd help at all that would be amazing :) please code in Excel VBA Like before, each container is assigned a code that
Like before, each container is assigned a code that indicates the sequence of stations in which the items in the batch must be processed through the shop. Each character in the code represents a workstation. Codes will never exceed 10 characters (the program does not need to check for this). Modify the user form from the previous problem to add a spin button to enter the batch size, ranging from 100 to 2,000 in increments of 10. Also, re-label the "Next Station" button on the form as "Remaining Work". When this button is pressed the program will compute (1) the remaining time to complete a batch (in hours rounded to two digits) and (2) the total cost of the remaining work (in currency format). Like before the user can choose the speed from "normal", "accelerated", or "fast". If the user selects "accelerated" speed, all the remaining setup times should be 90% of the normal times, but the costs of the setup times will increase by 10%. If the user selects "fast" speed, all the remaining setur times should be 80% of the normal time, but the costs of the setup times will increase by 20%. Place a button on a sheet to run your program. Finally, also check if the container has reached the end of the sequence to display the message "BATCH PRODUCTION COMPLETED", and check that the selected current step does not exceed the steps in the sequence. For example, if the code is ABEACD, the batch size is 100 , the current step in the sequence is 2 , and the speed is "accelerated", then the remaining tasks are EACD. The remaining setup time to complete the batch =0.9(60+60+80+100)=270 minutes, the remaining variable time =100(2+2+2+1.5) =750 seconds, so that the remaining time =270/60+750/3600=4.71 hours. The remaining cost will be =1.1(8+10+12+15)+100(0.1+0.1+0.2+0.15)=49.5+55=$104.50. Hint: Use a for-loop to check one by one the stations in each code. In each iteration of the for-loop, use the "Mid" function to access the next station in the sequence
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
