-
+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 needed help writing the solution to the assignment on how to derive the equilibrium constant expression for a protein crosslinking reaction using mass spectrometry. But i just did not know where to get the relevant solution material. Thanks to the chemical equilibrium assignment expert at HwA I was able to write the assignment with all the relevant research work and also get the accurate solution.
Karen Zimmerman Student
Writing Algorithm is not an easy job! Especially for a third semester student! I was really lost and was not sure about what exactly to do. I was seriously thinking of quitting the course and returning home when I came across TheReliableTutor.com. Since then it is a wonderful experience. Not only that I know the difference between a Java code and MSQL one but also I got good grades and things are looking very positive."
Michel Obi Student
I was doing fine with the smaller assignments given in my class but when it came to a research paper, I stumbled. Thankfully I came across HwA who not only helped me to write the paper but also at the same time enlightened me about the process of writing a proper research paper. I understood the basic difference between an essay and a research paper, thanks to the research paper writing experts of HelpwithAAssignment.com
Matt Dillon Student
I had to choose my own research topic for my final year dissertation during my post graduate management course and I was really confused. I was not sure from where I can get a standard response matching the requirements of my New Zealand based university. I must admit that I was lucky to come across HwA as they have experts located in New Zealand who helped me with the assignment and more importantly helped me achieve grades, beyond expectation.
Fiona Nash Student
When I saw the prices for civil engineering online tutoring with HwA I was not really sure what the quality of the tutoring would be like. But I was very impressed by the panel of civil engineering tutors at HwA and have already greatly benefited from the online tutoring sessions on Urban Engineering and Structural Analysis.
Rosamund Hailey 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.