INCOME STATEMENTS Blue Font = Direct Input Data Black Font - Should be Programmed with Formulae...

Transcribed Image Text:

INCOME STATEMENTS Blue Font = Direct Input Data Black Font - Should be Programmed with Formulae Number of units sold Price/Revenues Cost of Goods Sold Direct Materials Direct Labor Allocated Variable MOH Allocated Fixed MOH Gross Margin Selling, General, & Admin Variable SG&A Fixed SG&A Profit before Taxes AUTOMATED PROCESS Total Per Unit Per Unit $ 50,000 22,000 1,650 1,800 4,617 $ 19,933 3,900 10,100 $ 5,933 STATUS QUO Total 300,000 $ 15,000,000,000 $ 6,600,000,000 495,000,000 540,000,000 1,385,000,000 $ 5,980,000,000 1,170,000,000 3,030,000,000 1,780,000,000 RELEVANT (YES or NO) [Input your recommendation for which alternative (Status Quo or Automated Process) here. Include both quantitative and qualitative considerations to support your recommendation] INCOME STATEMENTS Blue Font = Direct Input Data Black Font - Should be Programmed with Formulae Number of units sold Price/Revenues Cost of Goods Sold Direct Materials Direct Labor Allocated Variable MOH Allocated Fixed MOH Gross Margin Selling, General, & Admin Variable SG&A Fixed SG&A Profit before Taxes AUTOMATED PROCESS Total Per Unit Per Unit $ 50,000 22,000 1,650 1,800 4,617 $ 19,933 3,900 10,100 $ 5,933 STATUS QUO Total 300,000 $ 15,000,000,000 $ 6,600,000,000 495,000,000 540,000,000 1,385,000,000 $ 5,980,000,000 1,170,000,000 3,030,000,000 1,780,000,000 RELEVANT (YES or NO) [Input your recommendation for which alternative (Status Quo or Automated Process) here. Include both quantitative and qualitative considerations to support your recommendation]

Answer rating: 100% (QA)

Based on the provided income statements lets compare the Status Quo and the Automated Process options Status Quo Total Revenues 15000000000 Total Cost ... View the full answer