Make The GradeIntroductionSam And Sonia Who
Make the Grade
Introduction:
Sam and Sonia, who are two teachers, have formed a company called 'Make the Grade'. They sell revision guides for GCSE course to schools. They produce paper-based student workbooks and interactive revision guides sold on DVDs.
At the point when schools buy a DVD they can either purchase it with a single-user license, which permits them to utilise it on only one computer at once, or with a site license, which permits them to use the item on any computer inside the school. Student workbooks are priced £10 less than DVDs with a single-user license. DVDs with a site license are valued at 20 times the cost of a single-user licence, rounded up to the most proximate pound.
A word-processed template is currently used for Sam and Sonia's invoices, they use the template to list school address details and prices of products. They also use a calculator to calculate the costs. Quotes and invoices are produced by these manual methods but calculation errors occasionally occur. They are searching for a more efficient process as their product range and their sales increase. They have been advised that they have to use a spreadsheet, yet they don't have a whole lot of understanding in operating this program.
Sam and Sonia would like you to produce a spreadsheet model that would empower them to reserve product details and prices and when new products become available they can simply add them onto the list. They would also like the spreadsheet model to store customer details and enables them to form and print invoices for placed orders.
Sam and Sonia have given you the accompanying electronic documents which you will need to finish, this includes their price list which also includes current delivery charges and discount rates. You will also need to complete an example invoice and a spreadsheet with some sample customer information to demonstrate to you the details they store about the schools who buy their revision guides.
Demonstrating
Introduction:
Sam and Sonia, who are two teachers, have formed a company called 'Make the Grade'. They sell revision guides for GCSE course to schools. They produce paper-based student workbooks and interactive revision guides sold on DVDs.
At the point when schools buy a DVD they can either purchase it with a single-user license, which permits them to utilise it on only one computer at once, or with a site license, which permits them to use the item on any computer inside the school. Student workbooks are priced £10 less than DVDs with a single-user license. DVDs with a site license are valued at 20 times the cost of a single-user licence, rounded up to the most proximate pound.
A word-processed template is currently used for Sam and Sonia's invoices, they use the template to list school address details and prices of products. They also use a calculator to calculate the costs. Quotes and invoices are produced by these manual methods but calculation errors occasionally occur. They are searching for a more efficient process as their product range and their sales increase. They have been advised that they have to use a spreadsheet, yet they don't have a whole lot of understanding in operating this program.
Sam and Sonia would like you to produce a spreadsheet model that would empower them to reserve product details and prices and when new products become available they can simply add them onto the list. They would also like the spreadsheet model to store customer details and enables them to form and print invoices for placed orders.
Sam and Sonia have given you the accompanying electronic documents which you will need to finish, this includes their price list which also includes current delivery charges and discount rates. You will also need to complete an example invoice and a spreadsheet with some sample customer information to demonstrate to you the details they store about the schools who buy their revision guides.
Demonstrating