Supermarket customers load their carts with goods totaling

Assignment Help Operation Management

Reference no: EM131042262

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 (Monte Carlo Simulation) 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 is being a random number RAND() distributed uniformly between 0 and 1; do similarly to decide on a coupon discount.)

Reference no: EM131042262

Questions Cloud

Does the business plan tell a coherent and compelling story : Entrepreneurship and Management: P’kolino is a children’s furniture company that was launched in 2005. As you read the businessplan, keep the following questions in mind: Does the business plan tell a coherent and compelling story? Does the plan capt..

A company that wishes to alter its benefit plans : A company that wishes to alter its benefit plans such that its employees may choose the benefit plans they prefer most will most likely offer _____.

About competitive advantage gained from innovations : How much has been said about competitive advantage gained from innovations such as the internet, high-technology gadgets, and apps. The chapter points out, however, that low-technology innovations such as razor-razor-blade business model can also cre..

E-business distribution network with their brick and mortar : Briefly describe one example of a firm that appears to have done a good job in balancing their e-business distribution network with their “brick and mortar” distribution store network. Use at least four criteria from the e-business scorecard in the t..

Supermarket customers load their carts with goods totaling : 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 loyal..

Define the human resource management function : Define the human resource management function. What is it, and why does it exist? Why is the HRM function important to organizations? Provide three reasons along with justification for each.

Think of the prison as a criminal justice organization : Think of the prison as a criminal justice organization. How does political power play out among line staff, supervisors and administrators? Do inmates participate in the political structure?

Explain the diffeence between a bugget in financial plan : Explain the diffeence between a bugget in a financial plan? when are each useful? how can you see yourself using them now and in the future?

Changes in the strategic landscape : Imagine you are the top executive of a small chain bookstore. Given recent changes in the strategic landscape, what would you do to position your company for success in an industry seemingly dominated by Amazon?

User Account

All Pages