if anyone can help that would be great! in excel vba please :)
in the batch must be processed through the that indicates the sequence of stations in which the items Codes will never exceed 10 charach the shop. Each character in the code represents a workstation. form from the previous problemacters (the program does not need to check for this). Modify the user in increments of 10. Also, re-labe to add a spin button to enter the batch size, ranging from 100 to 2,000 button is pressed the program wert "Ntation" button on the form as "Remaining Work". When this to two digits) and (2) the tot w compute (1) the remaining time to complete a batch (in hours rounded choose the speed from "normal", "accelerated", or "fast". If currency format). Like before the user can 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 setup 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. in the batch must be processed through the that indicates the sequence of stations in which the items Codes will never exceed 10 charach the shop. Each character in the code represents a workstation. form from the previous problemacters (the program does not need to check for this). Modify the user in increments of 10. Also, re-labe to add a spin button to enter the batch size, ranging from 100 to 2,000 button is pressed the program wert "Ntation" button on the form as "Remaining Work". When this to two digits) and (2) the tot w compute (1) the remaining time to complete a batch (in hours rounded choose the speed from "normal", "accelerated", or "fast". If currency format). Like before the user can 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 setup 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
