Question: Use Vba to code this: NanoTech makes circuit boards through four different manufacturing processes (A, B, C, or D). The fixed cost and the variable
Use Vba to code this:

NanoTech makes circuit boards through four different manufacturing processes (A, B, C, or D). The fixed cost and the variable cost to process a batch are displayed in the following table: Process A B C Fixed Cost $50 $60 $40 $55 Variable Cost | $10 $5 $15 $8 Alternatively, the company can subcontract production to another firm for no fixed cost and a variable cost of $100 per unit. Design a user-friendly form to help NanoTech input data about orders. The form must meet the following requirements: 1. One text box to input the name of the company that placed the order. 2. Four option buttons to select the process (A, B, C, or D), default is A. 3. Two option buttons for subcontract production or not (default is not to subcontract). 4. One spin button to input the order (batch) size, ranging from 10 to 500 in increments of 10 (default is 10). 5. One button entitled "Compute Cost" such that when the user presses the button, the program will compute the cost of processing the order. The program should output the name of the company that placed the order and the cost of the order using a message box. 6. Add a button to "Sheet1" to run the form directly from the sheet. NanoTech makes circuit boards through four different manufacturing processes (A, B, C, or D). The fixed cost and the variable cost to process a batch are displayed in the following table: Process A B C Fixed Cost $50 $60 $40 $55 Variable Cost | $10 $5 $15 $8 Alternatively, the company can subcontract production to another firm for no fixed cost and a variable cost of $100 per unit. Design a user-friendly form to help NanoTech input data about orders. The form must meet the following requirements: 1. One text box to input the name of the company that placed the order. 2. Four option buttons to select the process (A, B, C, or D), default is A. 3. Two option buttons for subcontract production or not (default is not to subcontract). 4. One spin button to input the order (batch) size, ranging from 10 to 500 in increments of 10 (default is 10). 5. One button entitled "Compute Cost" such that when the user presses the button, the program will compute the cost of processing the order. The program should output the name of the company that placed the order and the cost of the order using a message box. 6. Add a button to "Sheet1" to run the form directly from the sheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
