Create spreadsheet model for performing computer simulation

Reference no: EM13131042

Jessica William, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before revising the inventory policy for stoves, she records the number sold each day over a period of 25 days, as summarized below.

2 stoves in 4 days
3 stoves in 7 days
4 stoves in 8 days
5 stoves in 5 days
6 stoves in 1 day

a) Use these data to estimate the probability distribution of daily sales.
b) Calculate the mean of the distribution obtained in part a.
c) Use the random numbers 0.3544, .08766, and .05478 to simulate daily sales over three days.
d) Compare the average with the mean obtained in part b.
e) Formulate a spreadsheet model for performing a computer simulation of the daily sales. Perform 250 replications and obtain the average of the sales over the replications.

Reference no: EM13131042

Questions Cloud

Illustrate what is the journal entry at the end of current : At the end of the current fiscal year, the raw material to be purchased under this contract had a market value of $2.2 million. Illustrate what is the journal entry at the end of the current fiscal year?

Probability of six dandelions in area by poison distribution : Use the Poison distribution to find the indicated probabilites. Find the probability of 6 dandelions in an area of 1 m ²

What are the tax consequences of each option : Second Church is going to operate a gift and book shop that will include only religious articles in its inventory. The shop will be staffed by employees who are not church members.

Calculate an estimate of the ending balance of accounts : Calculate an estimate of the ending balance of accounts receivable from customers that should appear in the ledger and any apparent shortages. Assume that all sales are made on account.

Create spreadsheet model for performing computer simulation : Formulate a spreadsheet model for performing a computer simulation of the daily sales. Perform 250 replications and obtain the average of the sales over the replications.

Information about charity contribution : A certain club is collecting money for a charity. A local company has agreed to contribute $1 to the charity for every $3 collected by the club. How much money must the club collect in order for the total amount for the charity,

What is the concentration of a ions at equilibrium : What is the concentration of A^3- ions at equilibrium for a 0.10 M solution of a hypothetical triprotic acid H3A, with Ka1 = 6.0 x 10^-3, Ka2 = 2.0 x 10^-8, Ka3 = 1.0 x 10^-14 ?

Compute the target selling price : Talia Corp. produces digital cameras. For each camera produced, direct materials are $24, direct labor is $16, variable manufacturing overhead is $12, fixed manufacturing overhead is $28, variable selling and administrative expenses are $10, and f..

Percent of the invoices : A study of a company's practice regarding payment of invoices revealed that an invoice was paid an average of 20 days after is was received. The standard deviation equaled five days.Assuming that the distribution is normal, what percent of the inv..

User Account

All Pages