You will now calculate and analyze data based on information provided in the scenario to inform and support the decisions necessary to resolve the organizational challenges. Your analysis will explore the production schedule and vendor optimization by running a linear programming model and sensitivity analysis. You will submit this section as an Excel spreadsheet to show your programming. Please refer to your syllabus for instructions on how to access your case study.

Specifically, you must address the critical elements listed below.

1. Data Analysis:
   1. Calculate the labor stages and material requirements for each product.
   2. Based on the results of your calculation, develop a summary table for linear programming analysis.
   3. Next, calculate the production schedule, determining what will be produced, the quantity, and when the output will be produced.
   4. Conduct a sensitivity analysis on the cost of the products using a decision tree.
   5. Generate labeled graphs to demonstrate changes, if any, in product cost.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ SHIFT DETAILS } \\ \hline \multirow[t]{8}{*}{ Face Cream, Shift 1} & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Face Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost ($) \\ \hline & Labor Stage 1 & 1.50 & & & & Labor Stage 1 & 1.50 & & \\ \hline & Labor Stage 2 & 0.80 & & & & Labor Stage 2 & 0.80 & & \\ \hline & Water & 8.00 & & & & Water & 8.00 & & \\ \hline & Oils & 1.00 & & & & Oils & 1.00 & & \\ \hline & Scents/Colors & 0.50 & & & & Scents/Colors & 0.50 & & \\ \hline & Emulsifiers & 0.50 & & & & Emulsifiers & 0.50 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \multirow{9}{*}{ Body Cream, Shift 1} & & & & & & & & & \\ \hline & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Body Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost ($) \\ \hline & Labor Stage 1 & 1.80 & & & & Labor Stage 1 & 1.80 & & \\ \hline & Labor Stage 2 & 1.00 & & & & Labor Stage 2 & 1.00 & & \\ \hline & Water & 6.00 & & & & Water & 6.00 & & \\ \hline & Oils & 3.00 & & & & Oils & 3.00 & & \\ \hline & Scents/Colors & 0.30 & & & & \begin{tabular}{l} Scents/Colors \\ \end{tabular} & 0.30 & & \\ \hline & Emulsifiers & 0.70 & & & & Emulsifiers & 0.70 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \multirow{9}{*}{ Hand Cream Shift 1} & & & & & & & & & \\ \hline & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Hand Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) \\ \hline & Labor Stage 1 & 1.00 & & & & Labor Stage 1 & 1.00 & & \\ \hline & Labor Stage 2 & 0.50 & & & & Labor Stage 2 & 0.50 & & \\ \hline & Water & 7.00 & & & & Water & 7.00 & & \\ \hline & Oils & 2.00 & & & & Oils & 2.00 & & \\ \hline & Scents/Colors & 0.40 & & & & Scents/Colors & 0.40 & & \\ \hline & Emulsifiers & 0.60 & & & & Emulsifiers & 0.60 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ SHIFT DETAILS } \\ \hline \multirow[t]{8}{*}{ Face Cream, Shift 1} & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Face Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost ($) \\ \hline & Labor Stage 1 & 1.50 & & & & Labor Stage 1 & 1.50 & & \\ \hline & Labor Stage 2 & 0.80 & & & & Labor Stage 2 & 0.80 & & \\ \hline & Water & 8.00 & & & & Water & 8.00 & & \\ \hline & Oils & 1.00 & & & & Oils & 1.00 & & \\ \hline & Scents/Colors & 0.50 & & & & Scents/Colors & 0.50 & & \\ \hline & Emulsifiers & 0.50 & & & & Emulsifiers & 0.50 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \multirow{9}{*}{ Body Cream, Shift 1} & & & & & & & & & \\ \hline & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Body Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost ($) \\ \hline & Labor Stage 1 & 1.80 & & & & Labor Stage 1 & 1.80 & & \\ \hline & Labor Stage 2 & 1.00 & & & & Labor Stage 2 & 1.00 & & \\ \hline & Water & 6.00 & & & & Water & 6.00 & & \\ \hline & Oils & 3.00 & & & & Oils & 3.00 & & \\ \hline & Scents/Colors & 0.30 & & & & \begin{tabular}{l} Scents/Colors \\ \end{tabular} & 0.30 & & \\ \hline & Emulsifiers & 0.70 & & & & Emulsifiers & 0.70 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \multirow{9}{*}{ Hand Cream Shift 1} & & & & & & & & & \\ \hline & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) & Hand Cream, Shift 2 & Item & \begin{tabular}{l} Resource \\ Required \end{tabular} & \$/Unit & Cost (\$) \\ \hline & Labor Stage 1 & 1.00 & & & & Labor Stage 1 & 1.00 & & \\ \hline & Labor Stage 2 & 0.50 & & & & Labor Stage 2 & 0.50 & & \\ \hline & Water & 7.00 & & & & Water & 7.00 & & \\ \hline & Oils & 2.00 & & & & Oils & 2.00 & & \\ \hline & Scents/Colors & 0.40 & & & & Scents/Colors & 0.40 & & \\ \hline & Emulsifiers & 0.60 & & & & Emulsifiers & 0.60 & & \\ \hline & Total & & & 0.00 & & Total & & & 0.00 \\ \hline \end{tabular}