Computer Science · May / June 2024 · Paper 2 SL · Question 6

6. A supermarket has set up a spreadsheet model to compare its sales for each quarter during the financial year 2020 to 2021. This model, for each of the eight departments, shows the: y quantity of units sold each quarter y average units sold per quarter y highest quarterly sales y lowest quarterly sales. Figure 4: The supermarket’s sales by department A B C D E F G H I 1​ Sales (in thousands of units) 2​ 2020 - 2021 Apr–Jun Jul–Sept Oct–Dec Jan–Mar Whole year Quarter average Highest quarter Lowest quarter 3​ Bakery 9.4 10.2 14.7 10.2 44.4 11.1 14.7 9.4 4​ Dairy 9.7 10.4 11.5 10.3 41.8 10.5 11.5 9.7 5​ Delicatessen 6.1 7.8 5.7 6.1 25.7 6.4 7.8 5.7 6​ Frozen 7.4 6.9 6.7 6.4 27.4 6.9 7.4 6.4 7​ Fruit 11.6 14.3 19.6 17.7 63.3 15.8 19.6 11.6 8​ Grocery 64.7 48.1 77.0 69.2 259.0 64.8 77.0 48.1 9​ Meat 8.1 8.5 10.6 5.7 33.0 8.3 10.6 5.7 10​ Seafood 13.2 8.7 17.7 9.1 48.6 12.2 17.7 8.7 11​ 12​ Target increase (%) 13​ 14​ Target sales (in thousands of units) 15​ 2020 - 2021 Apr–Jun Jul–Sept Oct–Dec Jan–Mar Whole year Quarter average Highest quarter Lowest quarter 16​ Bakery 17​ Dairy 18​ Delicatessen (Option B continues on the following page) (Option B, question 6 continued) The manager of the supermarket plans to use this model in meetings with the eight department heads so that they can set targets for future sales.

Read automatically from the paper; the printed page above is exact.