Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

Aggregate planning sheet:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools for business decision making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

6th Edition

978-0470477144, 1118096894, 9781118214657, 470477148, 111821465X, 978-1118096895

More Books

Students also viewed these Accounting questions

Question

=+Describe the mechanics of sound production and demonstrate

Answered: 1 week ago