Please provide clear response. Please use excel - thanks

Case Study:Pramini, R., & Ashutosh, D. (2019, April 22). Harsh electricals: Analyzing cost in search of profit. Ivey Publishing. Retrieved from https://www.iveypublishing.ca/s/product/harsh-electricals-analyzing-cost-in-search-of-profit/01t5c00000CwopWAAR

1. Cost of Goods sold statement
2. Projected income statement for the calendar year of 2014
3. Calculate Harsh Electricals' Break Even Point in terms of units and volume
4. Calculate the number of units that Harsh Electrical must sell to match the level of profit earned in financial year 2010-2011

Please use excel - thanks