Make sure to add the code lines for the VBA please

This assignment can be worked either as a team (two students per team) or individually. Prepare your answers in one Excel file, and submit your file via Husky CT, no later than 11:59 p.m. on the due date. Email submissions are not acceptable. By submitting the assignment, you are confirming that this represents your team's work, and that no part of the work submitted has been copied from others. Consequences for cheating can be quite serious. It can lead to not only failing the course but also dismissal from the program. If determined that more than two students have worked on the same assignment submission, the participants will only get a fraction of the assignment's grade or not grade at all. Problem 1. Zodiac Furniture must determine the cost of producing a batch of metal office chairs every month. This will depend on the estimated demand (in number of chairs) for the month and the production method. The company can choose from two in-house processes (A or B). The chairs can also be purchased from an outside supplier. These are the costs associated with the in-house processes and supplier: Process A Process B Outside Supplier Fixed Cost $20,000 $30,000 $0 Variable Cost $30 $15 $50 To help the firm, write a VBA sub to recommend the lowest cost method to produce a batch. To do so, the sub will ask the user for an estimated demand (batch size), then compute the production cost based on the batch size for each of the three methods (process A, process B, and outside supplier). Finally, the sub will recommend the method with the lowest production cost of the batch. For example, if the estimated demand (batch size) is 100, then process A will cost $23,000, process B will cost $31,000, and the outside supplier will cost $5,000. Therefore, the sub will recommend the outside supplier in this case. The sub must also report the production cost (in currency format) of the lowest method ($5,000 in our example)