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,00018$ tiles and $60036$ 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 NOTprovided. Hence, YOU will have to ESTIMATE sales yourself. Use Figure $1$ in the case and the following numbers to estimate sale for this year