Any help will be highly appreciated. Thanks
Activities LibreOffice Calc 13.3 C Jun 3 13:13138 Summer 2019 Module 5 Excel Workbook Assignment.xlsx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help ab AL 2:& A EE % 74 00 00 BIU A Calibri 11 f, = 131 A D E N C H 6 7ignored) for the current year below. During a planning session for year 2019's activities, the manager notes that variable costs can be reduced 35 % by installing a machine that automates several operations, To obtain these savings, the company must increase its annual fixed costs by $132,000. The maximum output capacity of the company is 36,000 units per A 1 Break-Even Point in Dollar Sales for 2018: ear 10 for 11 Shark Co. 12 Contribution Margin Income Statement 13 For the Year Ending December 31, 2018 2 Predicted Break-Even Point in Dollar Sales for 2019: 14 15 $1,596,000 Sales 16 Variable Costs 1,117,200 17 Contribution Margin 478,800 18. Fixed Costs 500,000 19 3 Forcasted Contribution Margin Income Statement for 2019: (21,200) Pre Tax Loss 21 22 Required 23 Compute the break-even point in dollar sales for year 2018. (2 points) 24 2 Compute the predicted break-even point machine is installed and no change occurs in the unit selling price. (Round all numbers to the nearest dollar.) (3 points) dollar sales for year 2019 assuming the 25 26 27 3 Prepare a forecasted contribution margin income statement for 2019 that shows the expected results with the machine installed. Assume that the unit selling price and the number of units sold will not change, and no income taxes will be due. (5 points) 4 Sales level required in Dollars for 2019 to earn target pretax income: 29 30 4 Compute the sales level required in both dollars and units to earn $630,000 of target 2019 with the machine installed and no change in unit sales price. (Round pretax income 3 all numbers to the nearest dollar and to whole units 1 (5 noints Problem U Probiem Probiem A Problem E Fho 1of |FageStle Pom A T- | English USA asoN Arage;Sum: 0 Activities LibreOffice Calc 13.3 C Jun 3 13:1348 Summer 2019 Module 5 Excel Workbook Assignment.xlsx- LibreOffice Calc File Edit View Insert Format Styles Shert Data Tacls Wincow Help abs AL 2: A % 74 00 00 Calibri BIUA 11 fx A43 A Q Contribution Margin 478,800 19 A Fixed Costs 500,000 19 Pre-Tax Loss 3 Forcasted Contribution Margin Income Statement for 2019: (21,200) n0. 22 Required: for 1 Compute the break-even point dollar sales for year 2018. (2 points) 2 Compute the predicted break-even point machine is installed and no change occurs in the unit selling price. (Round all numbers to the nearest dollar.) (3 points) dollar sales for year 2019 assuming the 26 3 Prepare a forecasted contribution margin income statement for 2019 that shows the expected results with the machine installed. Assume that the unit selling price and the number units sold will change, and no income taxes will be due. (5 points) 4 Sales level required in Dollars for 2019 to earn target pretax income: Compute the sales level required in both dollars and units to earn $630,000 of target pretax income in 2019 with the machine installed and no change in unit sales price. (Round Il numbers to the nearest dollar and to whole units.) (5 points) .. 3 5 Prepare a forecasted contribution margin income statement that shows the results at the sales level computed in part . Assume no income taxes will be due. (5 points) Sales level required in Units for 2019 to earn target pretax income: 33 Check Figures: Item 3: Pre-Tax Income $237,820; Item 5: Contribution Margin $1,262,000 5 Forecasted Contribution Margin Income Statement at Sales Level computed in Item 4: 39 40 41 42 43 Probjem C Preblem U. Problem i Problem A Fo 1 of d FrgeSale Probiem A T-I LasoN Engliah (USA fustage Sum: 0
