-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
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.
Download Full SolutionWHAT OUR STUDENTS SAY
I was stuck with my nursing case study and my friend refereed me the thereliabletutor.com website. Its been 2 yrs I have been associated with this team and they have never disappointed me. love u guys!!!
Brandon Student
Higher order simultaneous equation where I needed to find out values for 5 or 6 variables forming appropriate equations from a given problem, was really my weak area. However, when I came across HwA they helped me and also assisted me to understand how exactly from a problem statement, the equations can be formed and how they can be evaluated.
Bobby Thatcher Student
HwA turned me into a chemistry lover from a chemistry hater. It was in my final years of my high school when I first took their help with my chemical compounds assignments and how I am doing my B.E. in Chemical Engineering and still taking their help in the matter.
Jamie Reed Student
I was facing a lot of problems with finding the right and relevant material for my quantitative chemistry assignment and running out of time before the submission deadline. The chemistry assignment expert at HwA helped me find the right research material and also helped me finish the quantitative chemistry assignment on time.
Rebecca Taylor Student
I had missed the classes on Isometrics because I had to miss school for some family emergencies. With the existing course load I had not got time to catch up with the topic and so when time came to write the assignment on Isometrics I was absolutely clueless. Thanks to the basic mathematics assignment experts at HwA I was able to not only understand the assignment but also submit the essay on time. The quality of work provided is also very high and I have been noticing an upturn in my overall grades.
Jamal Akhtar Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.