Question: Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values. ing bility O 01 N 01

Simkin's Hardware Store (Using Crystal Ball)

Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values.

Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model

ing bility O 01 N 01 01 01 WN + OOOOOO AVON 01 OOON O O O O 1974 ON w w 01 oo o W 01 10 5 Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values. Dem Distribution End Place Lea Arrive Hold- Stock- Begi Units Avail Dem- Deman End Stock inv + order d on out Orde Total Deman Proba- Day niny rec inv and d filled iny out Order ? time day cost cost r cost cost d 1 7 7 2 2 5 0 5 1 3 5 $0.10 $0 $20 $20.10 0 0.05 2 5 5 3 3 2 12 0 0 $0.04 $0 $0 $0.04 1 0.10 2 2 1 1 11 0 0 0 $0.02 $0 $0 $0.02 2 0.20 4 1 3 1 0 2 10 0 0 $0.00 $16 $0 $16.00 3 0.40 5 10 10 3 3 7 0 0 0 $0.14 $0 $0 $0.14 4 0.15 6 7 7 3 3 4 0 1 1 8 $0.08 $0 $20 $20.08 0.10 7 4 0 4 3 3 1 11 0 0 0 $0.02 $0 $0 $0.02 8 1 10 11 5 5 6 0 6 0 0 0 $0.12 $0 $0 $0.12 Order quantity, Q 6 0 6 3 3 0 3 2 12 $0.06 $0 $20 $20.06 Reorder point, R 10 3 0 3 3 3 0 0 10 0 0 0 $0.00 $0 $0 $0.00 11 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 Min leadtime 12 0 10 10 3 7 0 7 0 0 0 $0.14 $0 $0.14 Max leadtime 13 7 0 7 3 3 4 0 4 1 2 16 $0.08 $0 $20 $20.08 14 4 0 4 3 3 1 0 11 0 0 0 $0.02 $0 $0 $0.02 Holding cost 15 1 0 1 1 1 0 0 10 0 0 0 $0.00 $0 $0.00 (per unit per day) 16 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 17 7 0 7 4 4 3 0 3 1 1 19 $0.06 $0 $20 $20.06 Stockout cost 18 3 0 3 4 3 0 1 10 0 0 0 $0.00 $8 $0 $8.00 (per unit) 19 10 10 1 1 9 0 9 0 0 0 $0.18 $0 $0 $0.18 20 0 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.121 Order cost 21 6 0 6 4 4 2 0 2 1 1 23 $0.04 $0 $20 $20.04 (per order) 22 2 0 2 2 0 3 10 0 0 0 $0.00 $24 $0 $24.00 23 10 10 2 2 8 0 8 0 0 0 $0.16 $0 $0 $0.16 24 8 3 3 5 0 5 1 2 27 $0.10 $0 $20 $20.10| 25 5 0 1 1 4 0 14 0 0 0 $0.08 $0 $0 $0.08 Total per month = $1.70 $80 $140 $221.70 O DO ON 3 $0 1 3 $0.02 $0 $8 c 01 00 ON O O OVO $20 01 OOONOW O NN A 01 ONO O O AO CO O NO O o ing bility O 01 N 01 01 01 WN + OOOOOO AVON 01 OOON O O O O 1974 ON w w 01 oo o W 01 10 5 Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values. Dem Distribution End Place Lea Arrive Hold- Stock- Begi Units Avail Dem- Deman End Stock inv + order d on out Orde Total Deman Proba- Day niny rec inv and d filled iny out Order ? time day cost cost r cost cost d 1 7 7 2 2 5 0 5 1 3 5 $0.10 $0 $20 $20.10 0 0.05 2 5 5 3 3 2 12 0 0 $0.04 $0 $0 $0.04 1 0.10 2 2 1 1 11 0 0 0 $0.02 $0 $0 $0.02 2 0.20 4 1 3 1 0 2 10 0 0 $0.00 $16 $0 $16.00 3 0.40 5 10 10 3 3 7 0 0 0 $0.14 $0 $0 $0.14 4 0.15 6 7 7 3 3 4 0 1 1 8 $0.08 $0 $20 $20.08 0.10 7 4 0 4 3 3 1 11 0 0 0 $0.02 $0 $0 $0.02 8 1 10 11 5 5 6 0 6 0 0 0 $0.12 $0 $0 $0.12 Order quantity, Q 6 0 6 3 3 0 3 2 12 $0.06 $0 $20 $20.06 Reorder point, R 10 3 0 3 3 3 0 0 10 0 0 0 $0.00 $0 $0 $0.00 11 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 Min leadtime 12 0 10 10 3 7 0 7 0 0 0 $0.14 $0 $0.14 Max leadtime 13 7 0 7 3 3 4 0 4 1 2 16 $0.08 $0 $20 $20.08 14 4 0 4 3 3 1 0 11 0 0 0 $0.02 $0 $0 $0.02 Holding cost 15 1 0 1 1 1 0 0 10 0 0 0 $0.00 $0 $0.00 (per unit per day) 16 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 17 7 0 7 4 4 3 0 3 1 1 19 $0.06 $0 $20 $20.06 Stockout cost 18 3 0 3 4 3 0 1 10 0 0 0 $0.00 $8 $0 $8.00 (per unit) 19 10 10 1 1 9 0 9 0 0 0 $0.18 $0 $0 $0.18 20 0 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.121 Order cost 21 6 0 6 4 4 2 0 2 1 1 23 $0.04 $0 $20 $20.04 (per order) 22 2 0 2 2 0 3 10 0 0 0 $0.00 $24 $0 $24.00 23 10 10 2 2 8 0 8 0 0 0 $0.16 $0 $0 $0.16 24 8 3 3 5 0 5 1 2 27 $0.10 $0 $20 $20.10| 25 5 0 1 1 4 0 14 0 0 0 $0.08 $0 $0 $0.08 Total per month = $1.70 $80 $140 $221.70 O DO ON 3 $0 1 3 $0.02 $0 $8 c 01 00 ON O O OVO $20 01 OOONOW O NN A 01 ONO O O AO CO O NO O o

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Id lower transporte ntories because of the supplier to multiple $150 per delivery CASE STUDY Designing the Distribution Network for Michael's Hardware store. Using larger trucks would lower Ellen...

Instructions 1. Familiarize yourself with the contents of this booklet before you begin. 2. Read through the chart of accounts. 3. Prepare the entries using the list of transactions. Put them in the...

Can you please explain or show me how to complete this! I need help or answers! No. Date Transaction 17/1 Kyle opened two accounts at Pioneer State Bank, using 53,000 of his own money. He deposited...

Two buildings are located in the same area of comparable size, both under long-term leases. One is leased to the government for a post office and the other for a hardware store. Using the income...

Prepare the following journal entries and adjusting journal entries No. Date Transaction 1 7/1 Jay opened two accounts at Union State Bank, using S3,000 of his own money. He deposited $2.500 in a...

How do I prepare a General journal given these instructions and chart of accounts. How do I prepare a General Journal Entry for these two instructions and including the chart of accounts No. Date...

NARRATIVE OF TRANSACTIONS Note: Unless stated otherwise, assume that all cash in and out is checking account related) . Date Transaction Kyle opened two accounts at Pioneer State Bank, using $3,000...

NON-PARAMETRIC STATISTICS: solve 2. A sample: The sign test (Weighting 5 points) The following table reports the sales of a new tool in a sample of 12 hardware stores in a given month. The shape of...

Question The Lawn Ranger Landscaping Service The Lawn Ranger Landscaping Service Instructions1.Familiarize yourself with the contents of this booklet before you begin. 2.Read through the chart of...

When you first met Julian, he was a sole trader with a recycling and second-hand business, which he has now registered as a company, Retrofit Pty Ltd. The company does not have a constitution. The...

Trent Ltd bought a laptop computer for its business that cost 2,000 and it has a net book value of 1,200 after one year. If Trent sells the laptop for 700 at that time, the profit/ (loss) on disposal...

Which of the following factors determine the demand for an asset? a . wealth, risk and liquidity. b . wealth, expected return and investment. c . government deficit, expected inflation and risk. d ....

This type of conflict says people do not understand each other's positions and actually agree A . Relational Conflict B . Ego Conflict C . Simple Conflict D . Pseudo Conflict

Many consider Jobs to have been an emotional person. How should you deal and not deal with emotional outbursts?

Which of the implied behaviors (passive, aggressive, or assertive) has Travis Kalanick been known to employ in his interactions and transactions with others?

What style or styles of conflict do you believe Steve employed at Apple? Explain your answer.