Caselet on WizardWorks - Excel

Case #1 – WizardWorks

Andrew Howe owns and operates WizardWorks, an online seller of fireworks based in Peterborough, Ontario.  Andrew wants you to help him use Excel to develop an order form for his business.  The form needs to contain formulas to calculate the charge for each order.  The total charge is based on the quantity and type of items ordered plus the shipping charge and the 5% sales tax.  Orders can be shipped using standard 3 to 5 day shipping for $4.99 or overnight for $12.99.  Andrew is also offering a 3% discount for orders that exceed $200.  Both the shipping option and the discount need to be calculated using formulas based on values entered into the worksheet. 

Summary:

The case study is about WizardWorks,a fireworks store based in Peterborough, Ontario. The proprietor, Andrew Howe wants an order form to be created. This order form must contain formulas which can calculate the total charge based on the size of the order, sales tax, shipping charges, discount for purchases exceeding $200 must also be added. This order form has been created using MS Excel.