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.
Assess the impact on security prices. Would prices of risky securities be affected more or less than those of risk-free securities with a similar maturity? Why?
Prepare a direct materials budget for the first quarter that shows both the number of computer chips needed and the dollar amount of the of the purchases in the budget.
Assume that for a period of time, long-term corporate bonds had an average return of 7.1 percent with a standard deviation of 10.2 percent. What is the 95 percent probability range of returns?
Your laste deposit, which will occur at the end of year 6 will be for less than $1500 if less is needed to reach $10000. How large will your last payment be?
How would the asset allocation differ between a 25 year-old who is saving for retirement and a 67 year-old who is beginning retirement? Give a reasonable stock-to-bond ratio for each investor
What is PM Company's optimal organizational structure? How does it impact PM Company's international market expansion plans?
whats the present value of a 1000 bond that matures in 2 years and pays coupons at the rate of 2 per eyargt one coupon
Assuming the strike price is $30, stock price is $30, the risk free rate is 2%, and it is a 6 month option, the call premium is $3.59, determine the price of implementing a straddle position and explain when the option position will make money and..
Question 1: Determine the primary manner in which ORION has increased your business knowledge in the related subject area.
1. the present value of 100 to be received 10 years from today assuming an opportunity cost of 9 percent is . please
Assume George invests $83,497 in a 2 year CD with an Annual (Nominal) Interest Rate of 3.8% and 4 compoundings per year. Calculate the APY (Annual Percentage Yield/Effective Rate). Enter your response rounded to the nearest thousandth percent.
Brushy Mountain Mining Corporation's ore reserves are being depleted, so its sales are falling. Also, its pit is getting deeper each year, so its costs are increasing.
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