Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help in these two questions. Please solve in excel and show formulas.. If possible. Please upload excel on dropbox so i can download
I need help in these two questions. Please solve in excel and show formulas.. If possible. Please upload excel on dropbox so i can download it.
Why need of text book? the balance sheet is given actually
1) What is the (a) breakeven in units and (b) margin of safety in units for (1) 2017. (11) 2018, and (111) 2019? (25 points) 2) A new piece of manufacturing equipment is being considered for purchase. This machine is projected to reduce total cost of goods sold by 18% (based on 2019 actual results) and have a useful life of 5 years. If the machine costs $2,500,000 should it be purchased? Explain. (20 points) Midwest Manufacturing Statement of Income 2017 $ 5,645,357 2018 2019 $ 5,814,718 $ 6,163,601 Sales Cost of Goods Sold: Variable Costs Fixed Costs Total Cost of Goods Sold 1,467,793 395,175 1,862,968 1,395,532 523,325 1,918,857 1,787,444 369,816 2,157,260 Gross Profit 3,782,389 3,895,861 4,006,341 Administrative & Selling Expenses: Variable Administrative & Selling Costs Fixed Administrative & Selling Costs 395,175 959,711 523,325 1,104,796 523,906 1.016.994 1,354,885 1,628,121 1,540,900 Total Administrative Costs $ 2,427,504 $ 2,267,740 $ 2,465,440 Net Income Supplemental Information 2017 2018 2019 Unit Costing Summary: Units Sold Direct Labor Hours 100,810 75,607 107,680 75,376 118,531 77,045Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started