Hi all, I am currently taking BA 515 accounting class. And I could use a good tutor for an assignment that is due the morning of Saturday, August 6th, 2016. Thank you in advice. Please find the question attached as well as the slide that was referred in the question. Please endeavor to use the excel sheet attached.

Key Assumptions Sales Price Per Unit Forcasted Number of Units Sold - Year 1 Forecasted Number of Units Sold - Year 2 Beginning Inventory at beginning of Year 1 Number of Units Produced in Year 1 Number of Units Produced in Year 2 Yearly Prouduction Capacity of Manufacturing Plant Marketing Expense for Year 1 & 2 Management Salary for Year 1 & 2 Supervisor Salary for Year 1 & 2 Number of Managers Number of Supeverisors Tax Rate on Income Sales Commission Average Collection Days for A/R Average Payment Days for A/P No Expansion Expansion $ 33,000 $ 31,000 2,100 2,700 2,600 3,000 1,000 1,000 1,800 2,200 2,400 2,700 2,462 3,078 1,500,000 1,500,000 $ 100,000 $ 100,000 $ 75,000 $ 75,000 1 1 5 5 35% 35% 5% 5% 60 60 30 30 Additional Notes (1) Assume all account balances are zero at the Beginning Year 1 (2) Assume that fixed assets are drepeciated over 5 years using the straight line method Incremental Balance Sheet No Expansion End of Year 1 End of Year 2 Expansion End of Year 1 Assets Cash Accounts Receivable Inventory Total Current Assets PP&E Accumulated Depreciatio Total Fixed Assets Total Assets - - - 100,000,000 (20,000,000) 80,000,000 - - 80,000,000 - - Liabilities Accounts Payable Long Term Debt Total Liabilities 25,000,000 ### 20,000,000 ### 75,000,000 ### 80,000,000 80,000,000 80,000,000 80,000,000 80,000,000 80,000,000 105,000,000 100,000,000 155,000,000 Equity Stock Retained Earnings Total Equity Total Equity & Liabilities Incremental Income Statement No Expansion End of Year 1 End of Year 2 Total Net Revenue Expense Expansion End of Year 1 Cost of Goods Sold General Adminstrative Depreciation Earnings Before Interest & Taxes Interest Expense 1,500,000 Taxes (1) Net Income (1,500,000) - - 1,200,000 4,500,000 (1,200,000) (4,500,000) (1) Current tax laws allow corporations to carry forward any losses from prior years to the current year thereby reducing the taxes that corporations pay on profits in the current year. While this is important to take into account when projecting a company's income statment, for this business case, I want you to ignore this rule when calculating taxes. Tax regulation is material that is covered in corporate tax law classes and will not be covered in this class. Expansion End of Year 2 - - 65,000,000 ### 80,000,000 80,000,000 145,000,000 Expansion End of Year 2 3,900,000 (3,900,000) ses from prior years to the n profits in the current ng a company's income when calculating taxes. asses and will not be Key Data Points and Assumptions - Part 2 Orginal Cost of Manufacturing Equipment at the lower 2,462 yearly unit capacti New Invesmtent to Expand Production (1) Marketing Expense - over 5 years Number of Operations Manager Yearly salary expense of Operations Manager Number of Supervisors Yearly salary expense of shift supervisors Material cost per unit under no expansion scenario Material cost per unit under expansion scenario Hourly wage for Assembly Technician Sales Commission Assume that you have no beginning inventory 1. All manufacturing equipment has a 5 year life $ $ $ $ $ $ $ $ $ 100,000,000 50,000,000 20,000,000 1 100,000 5 75,000 19,000 16,000 25.00 5% Scenario Analysis 3 Thermo Fisher Product Launch Background Information: Based on the ThermoFisher mini-business case from this week's lecture, \"Breakeven Analysis\