Please use Excel to solve the following MRP calculation . DO NOT USE AI Tools please

3. Southern Coffee prepares instant coffee packs for small hotels and bed \& breakfast residences in Thailand. Each pack has three types of coffee: Caf Mocha (20g), Black (10g), and Decaf (10 g). Caf Mocha consists of black coffee and chocolate powder, Black consists of black coffee and sugar, and Decaf consists of decaf coffee and sugar. Bill of material below shows the ingredients in detail: Complete the following MRP records for Southern Coffee's instant coffee pack. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline SUGAR (UNIT: GRAMS) & WEEK & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline Required: 10 & \multirow{2}{*}{\begin{tabular}{l} Gross requirements \\ scheduled receipts \end{tabular}} & & 39,400 & & & 40,000 & & \\ \hline \multirow[t]{3}{*}{ LT (weeks): 1} & & & & & & & & \\ \hline & \multirow{2}{*}{\begin{tabular}{l} Projected ending inventory: 9,000 \\ Net requirements \end{tabular}} & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline & & & & & & & 0 & 0 \\ \hline \multirow[t]{2}{*}{ Min. order: 20kg} & \multirow{2}{*}{\begin{tabular}{l} Planned receipts \\ Planned orders \end{tabular}} & & & & & & 0 & 0 \\ \hline & & & & & & & 0 & 0 \\ \hline \begin{tabular}{c} DECAF COFFEE \\ POWDER (UNIT: GRAMS) \end{tabular} & WEEK & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline \multirow{4}{*}{\begin{tabular}{l} Required: 5 \\ LT (weeks): 1 \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Gross requirements \\ Scheduled receipts \end{tabular}} & & 19,900 & & & 20,000 & & \\ \hline & & & & & & & & \\ \hline & \multirow{2}{*}{\begin{tabular}{l} Projected ending inventory: 9,000 \\ Net requirements \end{tabular}} & & & & & & 0 & 0 \\ \hline & & & & & & & 0 & 0 \\ \hline \multirow[t]{2}{*}{ Min. order: 15kg} & \multirow{2}{*}{\begin{tabular}{l} Planned receipts \\ Planned orders \end{tabular}} & & & & & & 0 & 0 \\ \hline & & & & & & & 0 & 0 \\ \hline \end{tabular}