Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
a portfolio manager in charge of a portfolio worth 10 million is concerned that the market might decline rapidly during
A portfolio is expected to return 15 percent in a booming economy, 9 percent in a normal economy, and -3 percent in a recessionary economy. The probability a booming economy is 15 percent while the probability of a recession is 5 percent. What is ..
Computation of partner's return on equity and Asset value & Partner's Capital and Beginning equity balance
Assume that U.S. six-month Treasury bills have an annualized rate of 6.2% while default-free Japanese bonds that mature in six months have an annualized rate of 5.0% and that interest rate parity holds. Find the six-month forward exchange rate in ..
discuss whether or not apple fairly presented according to fasb information in their financial statement and footnote
dan and cheryl are married file a joint return and have no children. dan age 45 is a pharmaceutial salesman and
What is the duration of the bank's Treasury note portfolio?
suppose the us dollar and euro interest rate for the next one year are 1.5 and 2 respectively. both are annually
The lease terms, call for a $10,000 lease payment (4 payments total) at the beginning of each year. DTC's tax rate is 40%. Should the firm lease or buy?
Given an estimate of machine hours for the next year, the coating department' s projected cost per machine hour is computed. Here are data for the last three operating years. Expected coating machine hours for 2012 are 16,000 hours.
Computing the present value of the mortgage loan and How much do you owe on the mortgage
You purchase a bond with an invoice price of $1,210. The bond has a coupon rate of 7.6 percent, and there are 2 months to the next semiannual coupon date. What is the clean price of the bond?
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd