Gce Model Questions Vol1 2021 Computer Studies Question 30

An accountant prepares a profit analysis spreadsheet. - Cell **B1** contains the target total profit: 6000. - Columns **A**, **B**, **C** list for each product: quantity sold, selling price per unit, and variable cost per unit. - Column **D** calculates the profit for each product with the formula `=(B2‑C2)*A2` (and copied down). - Cell **E1** sums the profits: `=SUM(D2:D5)`. The data entered are: | Row | Quantity (A) | Selling price (B) | Variable cost (C) | |-----|--------------|-------------------|-------------------| | 2 | 120 | 20 | 5 | | 3 | 80 | 30 | 12 | | 4 | 150 | 25 | 10 | | 5 | *x* (unknown) | 40 | 20 | What is the smallest integer value of *x* (the quantity of product 5) that will make the total profit in **E1** meet or exceed the target profit in **B1**?