Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

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.)

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91766710

Have any Question?


Related Questions in Operation Management

Entrepreneurship and diversitywhat is the meaning of this

Entrepreneurship and diversity What is the meaning of this relationship regarding weight discrimination for the many individuals who are fat and to your organizational policy? How will your organization address weight-ba ...

Woodco manufactures tables and chairs each table and chair

Woodco manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 180 board feet of oak and 280 board feet of pine are available. A table requiere either 18 ...

This is a project management class we are on the 4th step

This is a project management class, we are on the 4th step of the project management process and i need to write an essay of 500 words of the following (please if you are not typing, legible writting and I will rate) Sum ...

Jeff picks up a drink he scans the item and pays by

Jeff picks up a drink. He scans the item and pays by inserting a credit card into the machine. The machine then says "thank you for your purchase". Was a contract created? and if so what express and implied terms might b ...

Healthcare policywhat are the pro and con arguments for

Healthcare Policy What are the pro and con arguments for patient cost sharing as a cost control strategy? Find at least one recent article that supports your response to this question and be sure to include a link to the ...

Evaluating your businessthe required of the question

Evaluating Your Business? the required of the question above -You are working for a fashion company as an E-Commerce consultant. -Suppose you have been asked to design an online store for the company. -How do you promote ...

1 what are the most effective leadership styles why are

1. What are the most effective leadership styles? Why are they effective? In your opinion, what are the least effective leadership styles? Explain. (150 words) 2. Why are innovation and entrepreneurial spirit important t ...

1 carl starts up and assumes the financial risk of

1. Carl starts up, and assumes the financial risk of, DataWorks, a new Web marketing enterprise. Carl and DataWorks must meet legal requirements relating to a. occupational licensing b. business name and state tax regist ...

1 list 4 advantages and 4 drawbacks an international

1. List 4 advantages and 4 drawbacks an international company (brewery) will have if it decides to cooperate with another company to enter and expend in this company's market. 2. When would a salesperson find the complim ...

You are president of a 50m metal component

You are President of a $50M metal component fabrication/assembly business. –100% Family Owned: Dad just retired (with a lot of knowledge), two kids (youngest is a sales rep) –The market is very competitive. Product is of ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As