Pe DO of format 49 % -AA B!-- O.AC- To A f BUDGET ASSUMPTIONS AND ACTUALS % a Com D Sort AL C D c BUDGET ASSUMPTIONS AND ACTUAL 0 . OUTPUT SUTAMINS Sandra w D ha mutta Vantar Spord 13 Vuurwa 1.500 00 Van Van 2 died and wat tud 22 ATLAS Ante De 24 Atlas Produto 25 AM 2 adults 27 AM 20 w M. TH Total LON 21 South 11 mm SS recha LIO retabonate SO atural Instructions Excel Assignment2 1925 923717 S320 De LL Wapest - EA Eiget - 97 4 frontal 9 Sed 1V so BUDGET ALUMINIONS AND CRIALS DUDGETAISATIONS AND ACTUALS LIPUTANA OGLASUMS and we al ad Die Mad WAY th 15 smp Ver Mad Main ned TH MW w Well Art 25 Mei 2 eur Artual rette DO www La SC ed De West Lan SI 1 500 w Det Dan ruction Excel Assignment 2 607 PM M N 0 P Variance Calculations Year 2020 Direct materials spending variance Direct materials price variance Direct materials quantity variance Direct labor spending variance Direct labor rate variance Direct labor efficiency variance Variable manufacturing overhead spending variance Variable manufacturing overhead rate variance Variable manufacturing overhead efficiency variance mpleted after end of 2020 + Income Statement at Year-End Year 2020 Sales Cost of goods sold Gross margin Selling and administrative expense Net operating income Performance Evaluation Year 2020 Margin Turnover Return on investment Residual income ITTI Pe DO of format 49 % -AA B!-- O.AC- To A f BUDGET ASSUMPTIONS AND ACTUALS % a Com D Sort AL C D c BUDGET ASSUMPTIONS AND ACTUAL 0 . OUTPUT SUTAMINS Sandra w D ha mutta Vantar Spord 13 Vuurwa 1.500 00 Van Van 2 died and wat tud 22 ATLAS Ante De 24 Atlas Produto 25 AM 2 adults 27 AM 20 w M. TH Total LON 21 South 11 mm SS recha LIO retabonate SO atural Instructions Excel Assignment2 1925 923717 S320 De LL Wapest - EA Eiget - 97 4 frontal 9 Sed 1V so BUDGET ALUMINIONS AND CRIALS DUDGETAISATIONS AND ACTUALS LIPUTANA OGLASUMS and we al ad Die Mad WAY th 15 smp Ver Mad Main ned TH MW w Well Art 25 Mei 2 eur Artual rette DO www La SC ed De West Lan SI 1 500 w Det Dan ruction Excel Assignment 2 607 PM M N 0 P Variance Calculations Year 2020 Direct materials spending variance Direct materials price variance Direct materials quantity variance Direct labor spending variance Direct labor rate variance Direct labor efficiency variance Variable manufacturing overhead spending variance Variable manufacturing overhead rate variance Variable manufacturing overhead efficiency variance mpleted after end of 2020 + Income Statement at Year-End Year 2020 Sales Cost of goods sold Gross margin Selling and administrative expense Net operating income Performance Evaluation Year 2020 Margin Turnover Return on investment Residual income ITTI