Assignment Question: Prepare a production plan for your plant based on YOUR sales estimate? Also, estimate your total end-of-season costs. (100 points) Lamson Case Assignment Explanation: Lamson Case is an exercise for creating a basic production plan for two products i.e. 18 tiles and 36 tiles. Both products are manufactured in the same plant at the same time. You have to assume that the season has not started yet. Your main task is to complete Exhibit 2 in the excel file (i.e. fill out rows for Period 1 to Period 12). The following will help you prepare your production plan for the season: In order to create a production plan, you will need Exhibit 1 and 2. Exhibit 1 has the nine production options for your plant and you can ONLY choose from the nine available production options. For example, if you choose Option 2 from Exhibit 1, you will produce 4,000 18 tiles and 600 36 tiles. Exhibit 2 has a template that will help you plan your production for the season. You job is to fill out the production numbers (using options from Exhibit 1) in Column A (for 18 tiles) and Column I (for 36 tiles) of Exhibit 2. (Both Columns A and I are highlighted in blue) However, in order to complete the production plan, you will need sales numbers, which are NOT provided. Hence, YOU will have to ESTIMATE sales yourself. Use Figure 1 in the case and the following numbers to estimate sale for this year: Forecast for maximum no. of 18 tiles sold = 4,500 tiles Forecast for maximum no. of 36 tiles sold = 2,000 tiles Helpful Tips: The sales are NOT provided but I have provided you a forecast of the peak sales. You have to ESTIMATE the rest using your OWN judgment and using Figure 1. In a real-life scenario, the production of all products is carried out before actual sales. Fill out Column D (for 18 tiles) and Column L (for 36 tiles) of Exhibit 2 with your sales estimate. I have highlighted the two columns in Yellow.