Information Communication Technology ICT – 16 Graphs and charts | e-Consult
16 Graphs and charts (1 questions)
Login to see all questions.
Click on a question to view the answer
To add a second data series representing total revenue, the student would follow these steps:
- Set up the Spreadsheet: The spreadsheet should have the following columns:
- Month (e.g., January, February, March...)
- Units Sold - Product A
- Units Sold - Product B
- Revenue - Product A
- Revenue - Product B
- Enter Data for Units Sold: The student would enter the number of units sold for Product A and Product B for each month from January to June in their respective columns. For example:
Month Units Sold - Product A Units Sold - Product B January 100 150 February 120 180 March 110 160 April 130 200 May 140 220 June 150 240 - Calculate Revenue: The student needs to calculate the revenue for each product line. Assuming each unit of Product A is sold for £5 and each unit of Product B is sold for £6, the revenue calculations would be:
- Revenue - Product A = Units Sold - Product A * Price per unit (e.g., 100 * £5 = £500)
- Revenue - Product B = Units Sold - Product B * Price per unit (e.g., 150 * £6 = £900)
The student would enter these calculated values in the 'Revenue' columns.
Month Units Sold - Product A Units Sold - Product B Revenue - Product A Revenue - Product B January 100 150 500 900 February 120 180 600 1080 March 110 160 550 960 April 130 200 650 1200 May 140 220 700 1320 June 150 240 750 1440