Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data sheet: Aggregate planning sheet: Using the following information shown above, can you please help me solve the aggregate planning sheet in excel. Thank you
Data sheet:
Aggregate planning sheet:
Using the following information shown above, can you please help me solve the aggregate planning sheet in excel. Thank you
\begin{tabular}{c|c|c|c|c|c|} \multicolumn{2}{c}{ Decision Variables } \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Period & \begin{tabular}{c} Wt \\ \# Workforce \end{tabular} & \begin{tabular}{c} Ot \\ Overtime \end{tabular} & \begin{tabular}{r} Ht \\ \# Hired \end{tabular} & \begin{tabular}{c} Lt \\ \# Laid off \end{tabular} & \begin{tabular}{|c|} It \\ Inventory \end{tabular} & \begin{tabular}{c} Stt \\ Stockout \end{tabular} & \begin{tabular}{c|} Pt \\ Production \end{tabular} & Demand \\ \hline 0 & & & & & & & & \\ \hline 1 & & & & & & & & 1200 \\ \hline 2 & & & & & & & & 1450 \\ \hline 3 & & & & & & & & 1900 \\ \hline 4 & & & & & & & & 1400 \\ \hline 5 & & & & & & & & 1150 \\ \hline 6 & & & & & & & & 800 \\ \hline 7 & & & & & & & & 1100 \\ \hline 8 & & & & & & & & 1600 \\ \hline 9 & & & & & & & & 2100 \\ \hline 10 & & & & & & & & 1300 \\ \hline 11 & & & & & & & & 1050 \\ \hline 12 & & & & & & & & 900 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Workfoce Constraints & Production Constraints & Inventory Constraints & Overtime Constraints \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} Sum \begin{tabular}{|l|l|l|l|l|l|l|} \hline Regular Time & Overtime & Hiring & Lay off & Carrying & Stockout & Material \\ \hline & & & & & & \\ \hline \end{tabular} Type your objective finction here : Type your constraints here: t=1123750Wt+t=11230Ot+t=1122000Ht+t=1124000Lt+ \begin{tabular}{c|c|c|c|c|c|} \multicolumn{2}{c}{ Decision Variables } \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Period & \begin{tabular}{c} Wt \\ \# Workforce \end{tabular} & \begin{tabular}{c} Ot \\ Overtime \end{tabular} & \begin{tabular}{r} Ht \\ \# Hired \end{tabular} & \begin{tabular}{c} Lt \\ \# Laid off \end{tabular} & \begin{tabular}{|c|} It \\ Inventory \end{tabular} & \begin{tabular}{c} Stt \\ Stockout \end{tabular} & \begin{tabular}{c|} Pt \\ Production \end{tabular} & Demand \\ \hline 0 & & & & & & & & \\ \hline 1 & & & & & & & & 1200 \\ \hline 2 & & & & & & & & 1450 \\ \hline 3 & & & & & & & & 1900 \\ \hline 4 & & & & & & & & 1400 \\ \hline 5 & & & & & & & & 1150 \\ \hline 6 & & & & & & & & 800 \\ \hline 7 & & & & & & & & 1100 \\ \hline 8 & & & & & & & & 1600 \\ \hline 9 & & & & & & & & 2100 \\ \hline 10 & & & & & & & & 1300 \\ \hline 11 & & & & & & & & 1050 \\ \hline 12 & & & & & & & & 900 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Workfoce Constraints & Production Constraints & Inventory Constraints & Overtime Constraints \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} Sum \begin{tabular}{|l|l|l|l|l|l|l|} \hline Regular Time & Overtime & Hiring & Lay off & Carrying & Stockout & Material \\ \hline & & & & & & \\ \hline \end{tabular} Type your objective finction here : Type your constraints here: t=1123750Wt+t=11230Ot+t=1122000Ht+t=1124000Lt+Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started