Supermarket customers load their carts with goods totaling

Assignment Help Operation Management

Reference no: EM131428189

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: EM131428189

Questions Cloud

Social class patterns use of physician services : Social class patterns use of physician services. Other than economic means (e.g., access to health insurace, adequate income to afford services, live in a neighborhood with services), discuss ways that class can inhibit, reduce, or lower the likeliho..

Contrast treatment of dividend by otter corporation-gerald : Marmot Corporation pays a dividend of $100,000 in the current year. Otter Corporation, which is in the 25% marginal bracket, owns 15% of Marmot’s stock. Gerald, an individual taxpayer in the 25% marginal bracket, also owns 15% of Marmot’s stock. Comp..

Electronics is large manufacturer of consumer electronics : ABC Electronics is a large manufacturer of consumer electronics including LED televisions, tablets, smartphones and electronic sound equipment. Describe some of the issues that operations managers must consider when applying forecasting methods. Be s..

Find the mean and median travel times : The 8 students in mrs Bennett class were asked how many minutes it takes them to get to school In the morning here is what they answered find the mean and median travel times for these students 3,6,10,9,4,7,10,13 find the mean and median travel ti..

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

What are the quantities of commodity : Consider a representative consumer with A budg et of $ 4 00 in world with two consumer goods X and Y. What are the quantities of commodity X and commodity Y that this consumer must purchase and consu me to maximize his/her utility?

Fraction in simplest form : A box is filled with 7 yellow cards 4 green cards and 3 blue cards a card is chosen at random from the box what is the probability that the card is not green write your answer as a fraction in simplest form.

What are three different training techniques : You Make the Call is your chance to apply what you're learning to a real-world scenario. For the You Make the Call, you will be presented with a scenario in which you are in charge of developing a training program. What are three different training t..

Weight-loss class lost the weights : The participants in a weight-loss class lost the following weights (in pounds) after three weeks of dieting:

User Account

All Pages