You must edit (input) all cells that are yellow throughout the spreadsheet. Management assumptions to help you determine the inputs are gray throughout the spreadsheet Keep ar drop a product line (20 pointsit Members of the board of directors of Douglas' Furniture Co. have received the following operating income data for the year just ended: Members of the board are surprised that the living room fumiture line is losing money. They commission a study to determine whether the company should discontinue the line. \begin{tabular}{|l|lr|} \hline \multicolumn{2}{|c|}{ Company accountants estimate that discontinuing the living room line will: } \\ \hline Decrease fixed costs of goods sold by: & $ & 82,000 \\ \hline Decrease fixed SG\&A expense by & $ & 17,000 \\ \hline \end{tabular} 1. Prepare an incremental analysis to show whether Douglas' Furniture Co. should discontinue the living room product line. LSE EXCEL FORMULAS TO CALCULATE. \begin{tabular}{|l|l|} \hline & Total amount \\ \hline & \\ \hline & \\ \hline & \\ \hline \multicolumn{2}{|l|}{ Opcrating income gain (loss) if Living room fumiture is discontinucd } \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline & TotalsWITHlivingroomfurniture & WotalsWITHouTlivingromfurniture & Difference \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} Compare your answer from requirement \#1 and requirement \#2. What do you notice? Would you keep or drop the living room furniture line? You must edit (input) all cells that are yellow throughout the spreadsheet. Management assumptions to help you determine the inputs are gray throughout the spreadsheet Keep ar drop a product line (20 pointsit Members of the board of directors of Douglas' Furniture Co. have received the following operating income data for the year just ended: Members of the board are surprised that the living room fumiture line is losing money. They commission a study to determine whether the company should discontinue the line. \begin{tabular}{|l|lr|} \hline \multicolumn{2}{|c|}{ Company accountants estimate that discontinuing the living room line will: } \\ \hline Decrease fixed costs of goods sold by: & $ & 82,000 \\ \hline Decrease fixed SG\&A expense by & $ & 17,000 \\ \hline \end{tabular} 1. Prepare an incremental analysis to show whether Douglas' Furniture Co. should discontinue the living room product line. LSE EXCEL FORMULAS TO CALCULATE. \begin{tabular}{|l|l|} \hline & Total amount \\ \hline & \\ \hline & \\ \hline & \\ \hline \multicolumn{2}{|l|}{ Opcrating income gain (loss) if Living room fumiture is discontinucd } \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline & TotalsWITHlivingroomfurniture & WotalsWITHouTlivingromfurniture & Difference \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} Compare your answer from requirement \#1 and requirement \#2. What do you notice? Would you keep or drop the living room furniture line
