complete E3-19 from your book in Excel. You must use proper formatting, and for calculations, you must use the functions in the Excel spreadsheet. If you have the correct numerical answer but just type in the number rather than the calculation funciton, you will not get full credit.

• 

Word File Edit View Insert Format Tools Table Window Help S " 22%. Sun 8:36 AM Q E NSU Canvas Learning Ma x Chapter 3 Excel mbe Enroll | myBusinessCours X *Homework Help - Q&A frc x Managerial Accounting, 8 x https://www.coursehero.com/tutors/homework-help/ Find Cat Instant Corp by untitled folder Course Hero Find study resources AutoSave @ OFF W E3-...- - Saved... Q ~ Search in Document Home Insert Design Layout References Mailings Review View Share Earn better grad Calibri (Body) - 12 Paste U . abe X2 X2 A Styles Styles Pane Get step- In the year 2017, Pyramid Consulting had the following contribution income statement: PYRAMID CONSULTING Contribution Income Statement For the Year 2017 MBC You have 39 Tutor Questions available. Upload study doc Sales revenue. . . . . $1,300,000 Variable costs ott Cost of services . . . . . $420,000 Selling and administrative. . 200,000 (620,000) BIU x2x2 = =fx Ix Contribution margin . . . Fixed costs- . . . . . . . 680,000 -selling and administrative 285,000) complete E3-19 from your book in Excel. You must use proper formatti Before-tax profit. . 395,000 numerical answer but just type in the number rather than the calculatio Income taxes (36%) . . . . (142,200) After-tax profit . . . . . Required a. Determine the annual break-even point in sales revenue. b. Determine the annual margin of safety in sales revenue. c. What is the break-even point in sales revenue if management makes a decision that increases fixed costs by $57,000? Managerial Accounting d. With the current cost structure, including fixed costs of $285,000, what dollar sales revenue is re- quired to provide an after-tax net income of $200,000? e. Prepare an abbreviated contribution income statement to verify that the solution to requirement (d) will provide the desired after-tax income. Page 1 of 1 0 words English (United States) Focus + 158% Why get homework help from Course Hero? DOCX pmework 1 Part 2 P W X ISCO