Supermarket customers load their carts with goods totaling

Assignment Help Finance Basics
Reference no: EM13616889

Supermarket customers load their carts with goods totaling between $5 and $200 uniformly (continuously) distributed; call this the raw order amount. Assume that customers purchase independently of each other. At checkout 63% of customers have a loyalty card that gives them 4% of their raw order amount. Also at checkout, 18% of customers have coupons that give them 7% of their raw order amount. These two discounts occur independently of each other, and a given customer could have one or the other of them, both of them or neither of them, to get to their net order amount (what they actually pay). Construct a spreadsheet simulation to simulate 100 customers and collect statistics on the net order amount; these statistics should include the average, standard deviation, minimum, maximum, and a histogram to describe the distribution of the net amounts between $0 and $200. (HINT: to decided whether a customer gets a loyalty discount, explore the Excel IF function with the first argument's being a random number RAND() distributed uniformly between 0 and 1; do similarily to decide on a coupon discount.

Reference no: EM13616889

Questions Cloud

Can it at the 001 level of significance be concluded that : a sample of 15 graduates from eastern university showed that the mean time until they received their first job
Two identical charges are fixed to diagonally opposite : two identical charges are fixed to diagonally opposite corners of a square 0.5m on the side. each charge is 3x10-9c how
Harry jones has invested onethird of his funds in share 1 : q1. since 1 august 2005 adam smiths investment policy has been to lodge fixed term deposits at his local bank. the bank
Bilbo baggins wants to save money to meet three objectives : bilbo baggins wants to save money to meet three objectives. first he would like to be able to retire 30 years from now
Supermarket customers load their carts with goods totaling : supermarket customers load their carts with goods totaling between 5 and 200 uniformly continuously distributed call
The magnetic field is in the negative x direction and has a : a proton travels through uniform magnetic and electric fields. the magnetic field is in the negative x direction and
Forecasting services numerous exchange rate forecasting : forecasting services. numerous exchange rate forecasting services exist. tridents cfo maria gonzalez is considering
What is the magnitude of the vertical component of earths : an astronaut is connected to her spacecraft by a 29-m-long tether cord as she and the spacecraft orbit earth in a
Todd is able to pay 360 a month for 6 years for a car if : todd is able to pay 360 a month for 6 years for a car. if the interest rate is 6.7 percent how much can todd afford to

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the implied treasury bond rate

Looking at The Wall Street Journal you observe that the settlement price on a hypothetical 15-year, semiannual payment, 6% coupon bond is 81-21. If the bond has a $1,000 par value, what is the implied Treasury bond rate?

  Create an ms powerpoint presentation in which you evaluate

create an ms powerpoint presentation in which you evaluate the current state of the process you selected in week two

  What rate of return is built into the annuity

You just won the state lottery. The state gives you the choice of $1,000,000 today or a 20-year annuity of $75,000, with the first payment coming one year from today. What rate of return is built into the annuity?

  Determining effective financing rate

Suppose the U.S. interest rate is 7.5%, the New Zealand interest rate is 6.5%, the spot rate of NZ$ is $.52, and the one? Year forward rate of the NZ$ is $.52. At the end of the year, the spot rate is $.48

  Calculation of npv and irr and mirr

Calculation of NPV and IRR and MIRR and Profitability Index and Besides future cash flows what other financial criteria would you consider in making your decision between two or more alternatives

  When we observe the capital structure of many firms we

when we observe the capital structure of many firms we find that they tend to utilize lower levels of debt than that

  The spot price of the sampp 500 index is the risk-free rate

the spot price of the sampp 500 index is .the risk-free rate is and the dividend yield on the index is . the time to

  If you can earn 13 on similar-risk investments what is the

elk county telephone has paid the dividends shown in the following table over the past 6 years.year dividend per

  Why would a company prefer cross-sectional research

Why would a company prefer cross-sectional research rather than longitudinal research?

  What are the profit variance revenue variance and cost

b. What are the profit variance, revenue variance, and cost variance?

  What is the accounting profit break-even in units

Mary and John is considering a project with total sales of $16,400, total variable costs of $8,800, total fixed costs(excluding depreciation) of $4,500, and estimated production of 400 units. The depreciation expense is $2,200 a year.

  What amount be used as the initial cash flow

What amount should be used as the initial cash flow for this 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