please answer this asap
EaselyDoesIt Pty Ltd, trading as EaselyDoesIt, makes four kinds of easels: small child, large child, adult, and super adult. These casels are purchased directly by schools, kindergartens, adult education centres and other centres where painting and drawing takes place. As well, the easels are sold to retail centres where members of the public can buy them. The small child, large child and adult easels are all a relatively simple design, but the super adult easel has a variety of extra features. The special feature that makes EaselyDoesit easels different from other easels is that the EaselyDoesit easel frame is made of a specially treated metal that is easy to clean, very hard to damage, and impervious to paint stains. EaselyDoesit easels are, effectively, indestructible. The cost accountant has observed that EaselyDoesit sells these easels units in a consistent proportion as summarised in the Table B1 below. It is now October 2023, and planning for the 2024 calendar year has commenced, with the expectation that, during the 2024 calendar year, EaselyDoesIt will sell 12,500 small child easels, 25,000 large child easels. 10,000 adult easels and 2,500 super adult easels. The variable costs for each easel consist of four items: labour, treated metal, other material, and other variable costs. Information about the 2024 selling price and variable costs for each type of easel is set out below: Table B1: Sales, Selling price and Cost breakdown. The budgeted variable labour cost is $24 per hour and the budgeted treated metal cost is $8 per metre. The projected income statement for EaselyDoesit for the calendar year 1 January 2024 to 31 December 2024 has been developed and is set out below in the Table below. Table B2: Projected Income Statement Please note carefully: While you may use Excel to solve these questions any tables / solutions that you develop in Excel must be copied into your Word answer document. 1. Assuming that the proportion of total sales in units of the four easel types remains constant as set out above in the Table 12, what is the break-even number of small child, large child, adult and super adult for the year 1 January 2024 - 31 December 2024 for EaselyDoesit Pty Ltd.? (7 marks) 2. Assuming that the proportion of total sales in units of the four easel types remains constant as set out above in the Table 12, how many of each of the four products does EaselyDoesit Pty Ltd need to sell in the year 1 January 2024- 31 December 2024 for EaselyDoesit Pty Ltd. to reach an after-tax profit of $2,000,000 ? (4 marks) 3. In the current economic climate, with rising prices for labour and for materials, the cost accountant is concerned that the budgeted income statement she has prepared may be too optimistic. Industry advice she has just received suggests that a variable labour cost of $25.60 per hour would be more realistic and that the fixed labour estimate should be increased by 4%. Moreover, the cost of the treated metal is likely to be $8.40 per meter. Assuming: I. the ratio of sales (in units) of the four easel types remains constant as set out above i.e., 25% of easels sold are small child, 50% of easels sold are large child, 20% of easels sold are adult, and 5% of easels sold are super adult, and II. EaselyDoesIt does not increase its sale prices, and III. all other costs remain as set out in the original budget. a. Determine the break-even number of easels that need to be produced and sold given these new conditions. EaselyDoesIt Pty Ltd, trading as EaselyDoesIt, makes four kinds of easels: small child, large child, adult, and super adult. These casels are purchased directly by schools, kindergartens, adult education centres and other centres where painting and drawing takes place. As well, the easels are sold to retail centres where members of the public can buy them. The small child, large child and adult easels are all a relatively simple design, but the super adult easel has a variety of extra features. The special feature that makes EaselyDoesit easels different from other easels is that the EaselyDoesit easel frame is made of a specially treated metal that is easy to clean, very hard to damage, and impervious to paint stains. EaselyDoesit easels are, effectively, indestructible. The cost accountant has observed that EaselyDoesit sells these easels units in a consistent proportion as summarised in the Table B1 below. It is now October 2023, and planning for the 2024 calendar year has commenced, with the expectation that, during the 2024 calendar year, EaselyDoesIt will sell 12,500 small child easels, 25,000 large child easels. 10,000 adult easels and 2,500 super adult easels. The variable costs for each easel consist of four items: labour, treated metal, other material, and other variable costs. Information about the 2024 selling price and variable costs for each type of easel is set out below: Table B1: Sales, Selling price and Cost breakdown. The budgeted variable labour cost is $24 per hour and the budgeted treated metal cost is $8 per metre. The projected income statement for EaselyDoesit for the calendar year 1 January 2024 to 31 December 2024 has been developed and is set out below in the Table below. Table B2: Projected Income Statement Please note carefully: While you may use Excel to solve these questions any tables / solutions that you develop in Excel must be copied into your Word answer document. 1. Assuming that the proportion of total sales in units of the four easel types remains constant as set out above in the Table 12, what is the break-even number of small child, large child, adult and super adult for the year 1 January 2024 - 31 December 2024 for EaselyDoesit Pty Ltd.? (7 marks) 2. Assuming that the proportion of total sales in units of the four easel types remains constant as set out above in the Table 12, how many of each of the four products does EaselyDoesit Pty Ltd need to sell in the year 1 January 2024- 31 December 2024 for EaselyDoesit Pty Ltd. to reach an after-tax profit of $2,000,000 ? (4 marks) 3. In the current economic climate, with rising prices for labour and for materials, the cost accountant is concerned that the budgeted income statement she has prepared may be too optimistic. Industry advice she has just received suggests that a variable labour cost of $25.60 per hour would be more realistic and that the fixed labour estimate should be increased by 4%. Moreover, the cost of the treated metal is likely to be $8.40 per meter. Assuming: I. the ratio of sales (in units) of the four easel types remains constant as set out above i.e., 25% of easels sold are small child, 50% of easels sold are large child, 20% of easels sold are adult, and 5% of easels sold are super adult, and II. EaselyDoesIt does not increase its sale prices, and III. all other costs remain as set out in the original budget. a. Determine the break-even number of easels that need to be produced and sold given these new conditions