Consider Figure 10.10 for Simkins Hardware Store. Column J in the spreadsheet indicates a value of 1
Question:
Consider Figure 10.10 for Simkin’s Hardware Store. Column J in the spreadsheet indicates a value of 1 if an order is placed and a value of 0 if an order is not placed. Modify the spreadsheet to make it more “manager-friendly” by having “Yes” indicate that an order is placed and “No” indicate that an order is not placed. Make all necessary adjustments to other formulas in the spreadsheet to accommodate this change.
Figure 10.10
Transcribed Image Text:
Columns A through P are the same as in Figure 10.9. Values in cells W5:AA203 are automatically filled in by Data Table. Formula in cell AA4: -P29 BICIOEF 1 Simkin's Hardware Store GH U VVX Data Table NO POR Z AA Demand Distribution RN intvl RN intvi lower upper imit 2 End Place Arrive Hold- Stock- Hold- Stock- out Order Total Begin Units Avail Dem- Demand End Stock inv. order Lead filed out Order Total cost cost on ing Proba- ing Run cost $1.46 $104 $140 $245.46 $2.46 $1.28 $128 $120 $249. 28 $1.90 $1.46 $120 $120 $241.46 $1.72 $1.58 3 Day inv rec inv and 0 7 inv out Order? time day cost cost cost cost Demand bilty imit cost $0.14 s0 $20 $20.04 s0 $16.00 $0.14 $0 $20 $20.0e $0.06 $0.02 $0 $24.00 so $20 $20.10 Reorder point,R $0.04 $0.00 Min leadtime s0 $24.00 Max leadtime $0.16 so $20 $20.10 Holding cost 4 7 0 $0.14 $0.04 S0.00 0.05 0.10 0.20 0.05 52 3 0.05 0.15 $16 $140 $158 48 7. 2 10 4 1 0.15 0.35 6 7 4 8. 2 2 4. 2. $16 $0.14 $0.06 $56 $140 $197. 90 10 10 3. 3 3 13 0.40 0.15 0.10 0.35 0.75 0.75 0.90 1.00 4 4. $88. $120 $209.72 596 $120 $217.58 598 $120 $217.88 3 3 3 $0.06 $0.02 0.90 10 3 3 2 11 $0 1 10 10 Order quantity, a 10 $0.00 $0.10 $24 10 $1.88 6. $1.58 $128 $120 $249.58 10 $2.18 11 $1.90 $1.76 $136 $120 $257.76 13 $1.70 $112 $120 $233.70 14 S1.90 15 $1.12 $168 $140 $308.12 16 $1.74 17 $1.88 18 $1.44 $152 $120 $273.44 19 $1.40 $104 $140 5245.40 20 s1.46 $168 $120 $289.46 21 $1.78 $112 $120 $233.78 22 $1.80 23 52.04 24 $1.94 25 $1.84 $168 $120 $289.84 26 $2.00 27 $1.86 199 51.56 $152 $100 $253.56 200 $1.84 13 $48 $140 S190.18 S88 $120 S209.90 10 3 2 12 $0.04 2 2 10 $0.00 $0.00 14 11 15 12 3. 10 $24 3 12 16 13 10 10 2 2 $0.16 17 14 2 17 $0. 10 S0.02 $24 $120 $145.90 18 15 10 $0.00 $0.00 Liper unit per day) $0.00 $0. 12 $0.02 $0 $16.00 $0.12 s0 $20 $20.02 (per unt) $0 $24.00 $20 $20.10 S0.02 Liper order) $0.16 $40 $140 S181.74 s80 $120 $201.88 19 16 2. 2 10 $16 20 17 21 18 10 10 4 6 so Stockout cost $8 1 20 22 19 1. 3 10 $0.00 $0.10 $0.02 1. $24 $20 23 20 24 21 25 22 26 23 6 10 10 5 1. 22 SO lOrder cost 1 11 S0. 16 $0.12 $96 $140 S237.80 S80 $120 S202.04 $S6 S120 $177 94 10 11 8 6 1 $0. 12 Based on 200 replications: $1.79 $98.64 $122.20 $222 63 2 27 24 28 25 Average holding cost- Average stockout cost= Total per month = $1.48 $104 $140 $24S.48 Average order cost = $0.06 $0.00 S0 $20 $20.06e $0.00 6 3 3 3 3 28 3 3. 10 $80 $120 $202.00 S84 $120 $185 88 29 30 Average total cost= Hidden rows 202 203 580 $140 $221.84 Results based on current replication Results based on 200 replications Select cells W4:AA203 before clicking Data| What-lf Analysis| Data Table.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 70% (10 reviews)
To make the indicated spreadsheet more managerfriendly as described you would need to alter any form...View the full answer
Answered By
Utsab mitra
I have the expertise to deliver these subjects to college and higher-level students. The services would involve only solving assignments, homework help, and others.
I have experience in delivering these subjects for the last 6 years on a freelancing basis in different companies around the globe. I am CMA certified and CGMA UK. I have professional experience of 18 years in the industry involved in the manufacturing company and IT implementation experience of over 12 years.
I have delivered this help to students effortlessly, which is essential to give the students a good grade in their studies.
3.50+
2+ Reviews
10+ Question Solved
Related Book For
Managerial Decision Modeling Business Analytics With Spreadsheet
ISBN: 9781501515101
4th Edition
Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson
Question Posted:
Students also viewed these Business questions
-
1. Why did Facebook decide to make it more difficult for users to control who has access to the personal information they post on the Web site? 2. Which type of control is of concern to the Facebook...
-
Does "microscopic slush" in water tend to make it more dense or less dense?
-
When an order is placed with a company, there is a probability of 0.2 that it is an express order. Estimate the probability that 90 or more of the next 400 orders will be express orders.
-
Let Find x , y , xy , and yx , and state the domain for each partial derivative. f(x, y) = [y, y = 0 1-y, y < 0.
-
You can write the rate law for the decomposition of azomethane as when n is the order of the reaction. When you divide the rates at various times by the concentrations raised to the correct power n,...
-
Why are tax credits rather than a deduction used to provide tax relief?
-
A long, straight wire carrying a current of \(2.5 \mathrm{~A}\) to the left is placed directly below and parallel to the central axis of a solenoid that has 1000 windings per meter of length and a...
-
Regina has finally landed her dream job at Abercroanie & Fetch. After just a couple of days on the job, we find out why. Often, when people return merchandise, Regina will ring up on the register...
-
3. As. Mr. Cartwright's financial advisor, would you urge him to go ahead with, or to reconsider, his anticipated expansion and his plans for additional debt financing? As the banker, would you...
-
The Morton Ward Company is considering the introduction of a new product that is believed to have a 50-50 chance of being successful. One option is to try out the product in a test market, at an...
-
If you look carefully at the formulas in this chapter for all four unlimited population models, you can verify that for each one, L = W and Lq = Wq. These are instances of the more general...
-
The newsvendor model is a classic inventory problem based on the situation of newsstand owner who must determine how many newspapers to order early in the morning to satisfy that days demand. She has...
-
A common lab experiment is the dehydration of cyclohexanol to cyclohexene. (a) Explain how you could tell from the IR spectrum whether your product was pure cyclohexene, pure cyclohexanol, or a...
-
4. Base your code on the following linked list and its pointer values. startLoc A 0+ ptrl ptr2 a. Give the lines of code that disposes the node containing the letter 'O' without creating any orphans....
-
Describe the process by which the consumer comes to experience satisfaction or dissatisfaction. Illustrate each result with your own experience.
-
Explain why a little inflation is always necessary to grease the wheels of the economy.
-
Imagine a PPF for two goods: guns and butter. A natural disaster hits and reduces our ability to produce both weapons and butter. What will be the effect?
-
How did Western domination affect South Asia, the Islamic heartland, and Africa in the 19th century? Explain
-
Prove: If A is an n x n matrix with complex entries, then det (A)det(A)
-
A local politician is concerned that a program for the homeless in her city is discriminating against blacks and other minorities. The following data were taken from a random sample of black and...
-
Explain how adjusting the customer service level could improve a marketing mix. I l lustrate.
-
Briefly explain which aspects of customer service you think would be most important for a producer that sells fabric to a firm that manufactures furniture.
-
Briefly describe a purchase you made where the customer service level had an e f fect on the product you selected or where you purchased it.
-
Based on the given information, what are all possible outcomes for this project? How would you suggest dealing with the uncertainty in the estimations? uncertainty change your decision to accept or...
-
What is the Modified IRR for this project is they can invest their intermediate flows at 11%? Assume BLTD requires a 12% payback on MIRR, would you accept the project?
-
Answer in detail, "Elaborate the word "research" and what salient features make a scientific inquiry more meaningful and valid? Be specific, use your own words and avoid direct copy-paste".
Study smarter with the SolutionInn App