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,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 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.

$$ You only need to read the first three pages of the case to complete this assignment.

You ONLY have to submit the Excel file for this project and it has to be submitted on CANVAS before

the class starts.