I want this assignment to be done. The assignment must be done in an excel. I am ready to pay 20.

ACCT5203 – Assignment 2 Total value – 15 points Assignments are to be submitted on an group basis. Files are to be submitted on Moodle in either Microsoft Word or Microsoft Excel. Question 1 ( 5 points): Pluto's Piano Company sells music books. The following is data associated with last year's sales: Total Per unit Sales (10,000 units) 50,000 5 Variable costs 20,000 2 Contribution margin 30,000 3 Fixed expenses 16,000 Operating income 14,000 Consider each case independently. 1. Using the contribution approach, what would the revised operating income be if the number of units increased 25%? 2. Using the contribution approach, what would the revised operating income be if variable costs decreased by $0.50? 3. Using the contribution approach, what would the revised operating income be if the number of units increased 10%, the sales price decreased 5%, and fixed expenses increased by $5,000. Question 2 (4 points): Daisy Bikes Inc. is a small manufacturing company that makes bicycles. The company has 2 buildings, one building contains the factory where bicycles are produced, the other building is split between a retail shop where customers can come in to purchase bikes an d the administrative offices. The following costs were incurred for the year ended June 30, 202 4: Direct labour 135,000 Indirect labour 50,000 Raw material purchases 140,000 Maintenance, factory equipment 6,500 Advertising expense 18,000 Insurance, factory equipment 1,500 Sales staff salaries 70,000 Rent, factory facilities 24,000 Rent, retail store 12,000 Supplies, factory 5,000 Depreciation, office equipment 2,500 Depreciation, factory equipment 4,000 Additionally, the company had the following inventory balances at the beginning and end of the fiscal year: Inventories Beginning Ending Raw materials 10,000 8,000 Work in process 7,000 12,500 Finished goods 9,000 20,500 4. Prepare a Schedule of Cost of Goods Manufactured for the year ended June 30, 202 4 5. Calculate the cost of goods sold for the year ended June 30, 202 4. Question 3 ( 2 point s): Belle Supply Ltd. is a merchandising company that sells art supplies. The company reported the following income and expenses for the year ending December 31, 2023: Sales 400,000 Cost of goods sold 240,000 Selling expenses (variable) 20,000 Selling expenses (fixed) 60,000 Administrative expenses (fixed) 35,000 Prepare an income statement in good form using the contribution approach. Question 4 ( 4 points) Cinderella Cleaners Ltd. provides cleaning services for office buildings. They have collected the following data showing the total number of hours spent cleaning and the total costs for the past 6 months. Total hours Total cost January 1,550 44,500 February 1,400 41,200 March 1,850 50,000 April 1,300 39,800 May 1,900 50,600 June 1,700 46,900 1. Using the high -low method estimate the variable cost per hour. 2. Estimate the total fixed cost per month 3. Provide the cost formula using the amounts calculated abo ve. 4. For the month of July , the company is expecting total hours of 1,600. Estimate the total costs that will be incurred for July.