Joan felt that a useful approach for determining the cost of alternative production

plans was to develop a simulation based on the $2013$ sales forecast. The forecast of the

monthly sales for $2014$ is presented in Table A$\mathrm{.}2.$ For simplicity in the simulation, she

decided to use $12$ average months to represent the year rather than actual months of

varying length. This enabled her to use $1,000$ pounds per month as the production rate

for a worker on regular time for a month. Each employee on the payroll in any month

would be paid the $$1,800$ base wage. Overtime would be limited to $25$ percent of regular

time and would be compensated for at a premium rate of $50$ percent.

The two variables in the production plan are the number of workers and the monthly

production rate. Idle time could be specified as a part of the production plan. As an

example, if $100$ workers are specified to produce $90,000$ pounds in a month with all

workers receiving their full base wage equivalent. On the other hand, overtime could be

scheduled, up to $25$ percent over regular time, by specifying production in excess of the

production capability on regular time. Joan also knew that she must meet the demand

requirements and maintain the minimum inventory for each month in the plan.

There were $100$ production employees on the payroll in December $2013,$ and Joan

wondered whether any of those should be laid off for January. With the current production

schedule, the company would end up at the end of December with very close to the

$10,000-$pound minimum inventory requirement. Joan was most interested in comparing please submit the asnwer as $3$ spreadsheets comparing the pure level

production strategy, pure chase strategy and hybrid plan with a total cost for each one