please ignore question1

2. Prepare a segmented income statement for March 2022. Show the data for each region and the

Total column. (30 marks)

3. Analyse the statement you prepared in (2) above.

a) Which of the three segments is (are) not doing well? (5 marks)

b) Propose some action(s) that the company can take to improve the segment(s)

performance? (5 marks)

please if possible solving it via excel

Lat Munh 2025 tae she nugn Case 2 (Segmental Reporting): Qdairy Company is a wholesale distributor of dairy products in Qatar. The company sclls its products throughour three Qatar regions (Al-Khor, Doha, and Al-Wakrah). Unfortunately, the company's profits have been declining, which has caused considerable concems to the management. To help understand the condition of the company, Mr Salim, the managing director of the company has requested that the monthly income statement be segmented by sales region. Accordingly, Miss, Safa, the managerial accountant, has prepared the following income statement for March 2022. The company considers the cost of goods sold and shupping expenses as a variable; all other costs are fixed. Qdairy produces dairy at its farms in Al-Khot city in Qatar, and it distributes its peoducts to the three regions listed above. The company assigns a manager and some sales staff to each of the three regions. Dairy products vary widely in profitability, some have a hight manyin, and some have a kow margin, Lat Munh 2025 tae she nugn Case 2 (Segmental Reporting): Qdairy Company is a wholesale distributor of dairy products in Qatar. The company sclls its products throughour three Qatar regions (Al-Khor, Doha, and Al-Wakrah). Unfortunately, the company's profits have been declining, which has caused considerable concems to the management. To help understand the condition of the company, Mr Salim, the managing director of the company has requested that the monthly income statement be segmented by sales region. Accordingly, Miss, Safa, the managerial accountant, has prepared the following income statement for March 2022. The company considers the cost of goods sold and shupping expenses as a variable; all other costs are fixed. Qdairy produces dairy at its farms in Al-Khot city in Qatar, and it distributes its peoducts to the three regions listed above. The company assigns a manager and some sales staff to each of the three regions. Dairy products vary widely in profitability, some have a hight manyin, and some have a kow margin