A

B

C

D

E

F

G

H

$L$

M

Excel Phone assembles celllalar phones with integrated cameras for distribution to

Beginning Workers

$41$

Verizon and US Cellular. In the past year, Excel Phone assembled $88,560$ phones

using $41$ employees.

Excel Phone has hired you as an extemal consultant for your expertise in ageregate planning. Your bonus at the end of the year is based on production costs savings you recommend. You have gathered extensive dita from the company, which you summarize as follows:

The forecast is provided below. In addition, the company would like to ensure that $600$ units are in inventory at the end of May.

$\backslash$table$[[\backslash$table$[[$$Holding$],[$Cost$]],$$Backorder Cost,$\backslash$table$[[$$Layoff$],[$Cost$]],\backslash$table$[[$$ Hire$],[$Cost$]],$Net Profit$],[0,$$ $10,491,000\mathrm{.}00,$$$110,700\mathrm{.}00,$$$,0\mathrm{.}001]]$

$(1)$ Video Part A: Discuss in video three Aggregate Planning strategies $($Optimal$,$ Level, and Chase$)$

Show an Aggregate Plan sheet for each of the three strategies.

Show profitability in Aggregate Plan sheet for each of the three strategies

Discuss which strategy works best for your corporate goals and objectives