Neco 2019 Computer Studies Question 32
Practice objective / multiple choice question 32 from the 2019 Neco Computer Studies examination.
In a spreadsheet, cells A2:A4 contain units sold for products P1, P2 and P3: 120, 85 and 60 respectively. Cells B2:B4 contain the unit selling price (in Naira): 2500, 3400 and 4100. Cells C2:C4 contain the variable cost per unit (in Naira): 1500, 2000 and 2500. The company gives a revenue discount: if total revenue exceeds 500,000 N, a 5 % discount is applied; if it exceeds 800,000 N, an 8 % discount is applied; otherwise no discount. Fixed overhead is 120,000 N. Compute the net profit (in Naira) after applying the appropriate discount, subtracting variable costs and overhead.
Answer Options
About This Question
This is Neco 2019 Computer Studies Question 32. It is one of the objective questions from the 2019 Neco Computer Studies 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.