Prepare a report for the determination and analysis of the breakeven points for 2013, 2014and 2015. What sales revenues level would MicroTiles need to achieve, to satisfy a target profit objective of $300,000 before tax and $400,000 before tax.

Using the Breakeven Template above add What sales revenues level would MicroTiles need to achieve to satisfy a target profit objective of $300,000 before tax and $400,000 before tax. Prepare a report for the same.

Please and thank you.

1 Break-Even Analysis Using the PV Ratio 2 3 2013 2014 2015 1,564,000 630,000 44,000 396,750 47,000 2,052,000 825,000 74,000 498,750 68,000 1,117,750 1,465,750 0 446,250 586,250 0 132,250 41.000 107,000 26,000 26,000 16,000 348,250 3,000 351,250 166,250 65,000 117,000 52,000 31,000 17,000 448,250 5,000 453,250 0 0 5 Revenue 6 Purchases 7 Freight in 8 Cost of sales (labour) (75%) 9 Commissions 10 11 12 Variable costs 13 14 Contribution margin 15 16 Cost of sales (labour) (25%) 17 Distribution costs - salaries 18 Administrative expenses - salaries 19 Advertising/travelling 20 Administrative expenses - leasing 21 Interest and other charges 22 Cash fixed costs 23 Depreciation/amortization 24 Fixed costs 25 26 Profit (loss) 27 28 PV ratio 29 30 Break-even point (in revenue) 31 Regular break-even 32 % of sales 33 Cash break-even 34 % of sales 35 36 Profit objective 37 to make 38 you need to sell 39 to make 40 you need to sell 41 to make 42 you need to sell 43 44 45 46 95,000 133,000 0 0.29 0.29 #DIV/0! 1,231,048 79% 1,220,533 78% 1,586,472 77% 1,568,971 76% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 1,231,048 0 1,231,048 0 1,231,048 0 1,586,472 0 1,586,472 0 1,586,472 300 #DIV/0! 350 #DIV/0! 400 #DIV/0! A7 1 Break-Even Analysis Using the PV Ratio 2 3 2013 2014 2015 1,564,000 630,000 44,000 396,750 47,000 2,052,000 825,000 74,000 498,750 68,000 1,117,750 1,465,750 0 446,250 586,250 0 132,250 41.000 107,000 26,000 26,000 16,000 348,250 3,000 351,250 166,250 65,000 117,000 52,000 31,000 17,000 448,250 5,000 453,250 0 0 5 Revenue 6 Purchases 7 Freight in 8 Cost of sales (labour) (75%) 9 Commissions 10 11 12 Variable costs 13 14 Contribution margin 15 16 Cost of sales (labour) (25%) 17 Distribution costs - salaries 18 Administrative expenses - salaries 19 Advertising/travelling 20 Administrative expenses - leasing 21 Interest and other charges 22 Cash fixed costs 23 Depreciation/amortization 24 Fixed costs 25 26 Profit (loss) 27 28 PV ratio 29 30 Break-even point (in revenue) 31 Regular break-even 32 % of sales 33 Cash break-even 34 % of sales 35 36 Profit objective 37 to make 38 you need to sell 39 to make 40 you need to sell 41 to make 42 you need to sell 43 44 45 46 95,000 133,000 0 0.29 0.29 #DIV/0! 1,231,048 79% 1,220,533 78% 1,586,472 77% 1,568,971 76% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 1,231,048 0 1,231,048 0 1,231,048 0 1,586,472 0 1,586,472 0 1,586,472 300 #DIV/0! 350 #DIV/0! 400 #DIV/0! A7