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: 63% (11 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,...
-
Most hospitals are reimbursed according to diagnostic-related groups (DRGs). Each DRG has a specified standard length of stay. If a patient leaves the hospital early, the hospital is financially...
-
Allocate costs to products or services and use the physical units, relative sales value, and net realizable value methods to allocate joint costs.
-
Lynn Parsons is considering investing in either of two outstanding bonds. The bonds both have $1,000 par values and 11% coupon interest rates and pay annual interest. Bond A has exactly 5 years to...
-
Question 8 The proof shows that opposite angles of a parallelogram are congruent. D Statements ABCD is a parallelogram with diagonal AC. ABCD and AD || BC 22 = 23 21 #24 m 2 m 3 and m21=m24 m1+m2=m...
-
Luthan Company uses a predetermined overhead rate of $23.40 per direct labor-hour. This predetermined rate was based on 11,000 estimated direct labor-hours and $257,400 of estimated total...
-
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...
-
How does the balanced scorecard concept help guide logistics managers in the development of a performance measurement system?
-
Why do companies issue share dividends?
-
What responsibility does the auditor have for communicating internal control structure related matters?
-
What factors affect the size of a companys cash dividend?
-
a. List five steps in completing preliminary planning before specifying the substantive tests to be included in an audit program, b. List six steps in the general framework for specifying substantive...
-
What is the relationship between the acceptable level of detection risk and the extent of substantive tests?
-
Explore elderly people's health needs in the Asia Pacific region using interpretive and critical qualitative research
-
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.
-
4. Qu tipo de empresas podran emplear un mercado de empresas privadas? Qu tipo de empresas podra participar en el mercado de una empresa privada? Cmo es un mercado de empresas privadas diferente de...
-
Camby Corp. can make one of the following four products: Product 1 Product 2 Product 3 Product 4 Selling price per unit $109.00 $186.00 $306.00 $45.00 Variable cost per unit $38.00 $120.00 $191.00...
-
If the order quantity (Q) for raw materials is increased, how does it affect ordering cost and/or holding cost? Group of answer choices Holding cost decreases No impact on ordering and holding costs...
Study smarter with the SolutionInn App