Problem $13-7($Algo$)$

Trexoid Incorporated makes a popular video game console. Demand varies each month, with highest demand coming in the last quarter of the year. Regular production costs are $\backslash (\backslash$$ $360\backslash )$ per unit and inventory carrying cost is $\backslash (\backslash$$ $4\backslash )$ per unit per quarter. Overtime production cost is $\backslash (\backslash$$ $390\backslash )$ per unit. Assume that the $25$ current Trexoid employees can produce a total of $50,000$ units per quarter in regular production and can work enough overtime hours to produce the amount required if a chase plan is employed. On the other hand, hiring cost is $\backslash (\backslash$$ $6,000\backslash )$ per employee and firing cost is $\backslash (\backslash$$ $13,500\backslash )$ per employee. Trexoid currently has zero inventory on hand, and it would like to have zero inventories at the end of the year. Assume that hiring and layoff$/$firing$,$ if necessary, occur at the beginning of the quarter. Forecast demand is as follows:

Click here for the Excel Data File

a$.$ Given the above demand estimate, develop a production plan based on level production.

b$.$ Determine the cost of the level production plan.

c$.$ Given the planning information, develop a production plan based on chase production.

d$.$ Determine the cost of the chase production plan.

Given the planning information, develop a production plan based on chase production.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Complete this question by entering your answers in the tabs below.

Required A

Required $\backslash ($ B $\backslash )$

Required C

Required D

Determine the cost of the chase production plan.

Total cost if overtime production used is

Total cost if workforce size adjusted is Complete this question by entering your answers in the tabs below.

Determine the cost of the level production plan. Complete this question by entering your answers in the tabs below.

Required A

Required B

Required C

Given the above demand estimate, develop a production plan based on level production.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

$\backslash$begin$\{$tabular$\}\{|$c$|$r$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{1\}\{|$l$|\}\{$ Level Production Plan $\}\backslash \backslash$

$\backslash$hline Quarter & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ Demand $\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Regular $\backslash \backslash$

Production

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Ending $\backslash \backslash$

Inventory

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$c$\}$

Number of $\backslash \backslash$

Workers

$\backslash$end$\{$tabular$\}$ & Hire & Fire $\backslash \backslash$

$\backslash$hline $1$ & $40,000$ & & & & $\backslash \backslash$

$\backslash$hline $2$ & $20,000$ & & & & $\backslash \backslash$

$\backslash$hline $3$ & $72,000$ & & & & $\backslash \backslash$

$\backslash$hline $4$ & $164,000$ & & & & $\backslash \backslash$

$\backslash$hline Total & $296,000$ & & & & $\backslash \backslash$

$\backslash$hline $\backslash$hline

$\backslash$end$\{$tabular$\}$