Neco 2019 Data Processing Question 12
Practice objective / multiple choice question 12 from the 2019 Neco Data Processing examination.
A spreadsheet records monthly sales (in units) of three products A, B and C for the first six months. The sales of A and B are fixed: \(A: 1200, 1300, 1250, 1400, 1350, 1500\); \(B: 800, 850, 900, 950, 1000, 1100\). The total sales recorded for each month (column D) are \(3000, 3200, 3400, 3600, 3800, 4000\) respectively.\n\n(i) Determine the sales of product C for each month.\n(ii) From month 4 onward a promotion increases product C sales by 5%. After this increase, in which month does the overall total first exceed 3800 units?
Answer Options
About This Question
This is Neco 2019 Data Processing Question 12. It is one of the objective questions from the 2019 Neco Data Processing examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.