Case study-wizardworks

Assignment Help Finance Basics
Reference no: EM13828446

Problem:

Case Study- 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.

1. Open Excel and create a new workbook.

2. Enter your name as the customer name and enter a date function that will always display the current date (ie. if the worksheet is opened tomorrow, it will display tomorrow's date).

3. Enter an Order Number (in the appropriate location) and enter an address for the customer in the area for the Shipping Address.  Enter a type of shipping in the spot you have designated (ie. enter either "standard" or "overnight").

4. Be sure to fill in the Shipping Option information and the possible Discount amount (using the case information provided above (ie. Standard = $4.99, Overnight = $12.99, Discount = 3%).

5. Enter details for a customer order.  Make up Item Numbers, Names of the items, Unit Prices, Quantity, and Total Item Charge information.  Be sure to include at least 2 items in your order

6. Enter an appropriate formula/function that will calculate the Total Item Charge (ie. it will use the Unit Price and the Quantity fields to determine the total charge for a particular item) for each item you entered.

7. Enter a formula/function that will calculate the Subtotal of the order.

8. Enter an appropriate function in the space for the Discount that will determine whether or not a discount of 3% applies and if so, it will display the value in dollar amounts, if not it will display "0".  (see the case information above for the conditions of a discount).

9. Enter a formula that will calculate the After Discount amount.

10. Enter a formula that will calculate the Sales Tax amount.

11. Enter an appropriate function that will determine the Shipping cost (based on the type of shipping method that was entered for the order back in instruction #5).

12. Enter a formula that will calculate the total of the order.

Additional Information:

The case study is about WizardWorks, a fireworks store located in Peterborough, Ontario. The proprietor, Andrew Howe desires an order form to be created. This order form must have formulas which can compute the total charge based upon 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.

Reference no: EM13828446

Questions Cloud

List out the vision and mission statements of companies : List out the Vision and Mission statements of companies
Case study: wal-mart takes on the world : Case Study: Wal-Mart Takes on the World
Finance capital structure question : Individual Project Deliverable Length: 4 slides each with 300 words of speaker notes Details:
Prospective business in kuwait senior care services : Prospective Business In Kuwait Senior Care Services
Case study-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.
Onda: innovation the chinese way : onda: Innovation The Chinese Way
Asian agri and the future of palm oil : Asian Agri and the Future of Palm Oil
Describe the deterministic model and stochastic model : Describe the deterministic model and stochastic model and Describe function, linear function and non-linear function. Give an example of linear and nonlinear function, respectively.
Swot analysis and porters five force model on harley davids : SWOT Analysis and Porter's Five Force Model on Harley Davidson

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd