Mira Tech Sdn Bhd is a company specializing in manufacturing electronic gadgets. The company produces and sells a variety of products, including smartphones, tablets, and smartwatches. The management team is interested in understanding the financial aspects of its operations, and has asked you, a financial analyst, to perform a Cost-Volume-Profit (CVP) analysis. The updated information for the year 2023 are as follows: Sales Information Cost Information (as a percentage of total sales) Product Information Total Sales Revenue: RM 5,000,000 Variable Costs: 40% Direct Materials: 20% Direct Labor: 10% Variable Overhead: 10% Fixed Costs: 30% Salaries and Wages: 15% Rent and Utilities: 8% Depreciation: 7% Average Selling Price per Unit: RM 500 Variable Cost per Unit: RM 200 Using Microsoft Excel, you are required to: 1. Prepare Contribution Margin Statement for Mira Tech Sdn Bhd. Calculate the Net Income. 2. Calculate Contribution Margin Ratio. Express the result as a percentage. 3. Break-Even Analysis a. Calculate the Break-Even Sales in Units b. Calculate the Break-Even Sales in Ringgit Malaysia 4. Construct Cost-Volume-Profit (CVP) Chart in Microsoft Excel. Label the axes appropriately and provide a legend. 5. Determine Margin of Safety. Express the result as a percentage of actual sales. 6. Calculate Operating Leverage. Interpret the result and discuss how changes in sales volume can impact profitability. 7. Summarize your findings and recommendations for the management of Mira Tech Sdn Bhd.