Case-wizardworks

Assignment Help Finance Basics
Reference no: EM13828473

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. 

Additional Information:

The case study is about WizardWorks,a fireworks store based in Peterborough, Ontario. The proprietor, Andrew Howe desires an order form to be created. This order form should 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: EM13828473

Questions Cloud

Question regarding the financial reporting and analysis : You are required to review a specific Company called Gunns Limited listed on the Australian Stock Exchange (ASX), and operating substantively in Tasmania. Your review is to be based on a historical analysis of that company, the application of acco..
Which structure do you think will work best for abraham why : What are some of the advantages and disadvantages you see for the two types of structures? Which structure do you think will work best for Abraham's why
Report on the corporate strategy of dell computers inc. : Report On The Corporate Strategy Of Dell Computers Inc.
Discuss compounding and discounting by comparing : Discuss compounding and discounting by comparing and contrasting the two. In your discussion, state why these concepts are important for both managers and investors to understand.
Case-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.
Impact of corporate governance on corporate strategy : Impact Of Corporate Governance On Corporate Strategy
Caselet on analysing the implications to a firm : Task Name: Phase 2 Individual Project Deliverable Length: 4 slides each with 300 words of speaker notes Details: Your meeting is with Toto Matsui, the head of treasury, to discuss the international impact to the firm's capital structure.
Strategic planning longitudinal study strategic development : Strategic Planning Longitudinal Study In Strategic Development
Case study-bill miller-value trust : Description: The case study will combine elements of problem solving as well as requiring students to make a series of recommendations to the client.

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