Neco 2021 Data Processing Question 26

A spreadsheet records monthly sales data for three products (P1, P2, P3) across four regions (R1-R4). The units sold and unit prices (in \(\text{₦}\)) are:\n- R1: P1 = 120, P2 = 80, P3 = 150\n- R2: P1 = 200, P2 = 150, P3 = 100\n- R3: P1 = 90, P2 = 110, P3 = 130\n- R4: P1 = 160, P2 = 140, P3 = 120\nUnit prices are P1 = \(5{,}000\), P2 = \(7{,}500\), P3 = \(6{,}000\).\nEach region applies a single discount percentage to the total revenue of that region. The discounted revenue for R2 is \(2{,}200{,}000\) and for R4 is \(2{,}100{,}000\).\nAssuming the discount percentages for R2 and R4 are applied uniformly to all products in those regions, (a) determine the discount percentage for R2 and for R4, (b) assume the remaining regions use the average of these two discount rates, and (c) compute the total discounted revenue for the whole quarter.