Complete the exercise that asks you to compute the average fill rate for Simkins Hardware Store as
Question:
Complete the exercise that asks you to compute the average fill rate for Simkin’s Hardware Store as described under “Analyzing the Results” for the Data Table for Figure 10.10.
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 BICIOIEL F 1 Simkin's Hardware Store G/H VMX Data Table KIL NO POR Z AA Demand Distribution RN intvl RN intvi lower upper 2 End Place Arrive Hold- Stock- Hold- Stock- Begin Units Avail Dem- Demand End Stock inv order Lead filed out Order Total cost out Order Total cost Proba- ing Run cost $1.46 $104 $140 $245.46 on ing 3 Day inv rec inv and 0 7 inv out Order ? time day cost cost cost Demand bilty imit imit cost cost $0 14 s0 $20 $20.04 s0 $16.00 $0.14 $0 $20 $20.0e $0.06 $0.02 s0 $24.00 so $20 $20.10 $0.04 $0.00 Min leadtime s0 $24.00 Max leadtime $0.16 so $20 $20.10 Holding cost 4 $0.14 $0.04 S0.00 0.05 0.10 0.20 0.05 5 2 3 0.05 0.15 $16 $140 $158 48 7. $2.46 2 10 4 0.15 0.35 2 $1.28 $128 $120 $249. 28 $1.90 $1.46 $120 $120 $241.46 $1.72 $1.58 $1.88 6 7 4 8. 2 2 4. $16 $0.14 $0.06 $56 $140 $197. 90 10 10 3 3 13 0.40 0.15 0.10 0.35 0.75 0.75 0.90 1.00 4 3 4. $88. $120 $209.72 596 $120 $217.58 598 $120 $217.88 3 $0.06 $0.02 6 3 0.90 10 3 2 1. 11 $0 7. 1 10 10 Order quantity, a Reorder point, R 10 $0.00 $0.10 $24 10 $1.58 $128 5120 $249.58 10 $2.18 in 13 6. $48 $140 $190. 18 S88 $120 S209.90 13 10 3 2 12 $0.04 2 2 10 $0.00 $0.00 $1.90 $1.76 $136 $120 $257.76 14 11 11 15 12 3. 10 $24 3 12 13 $1.70 $112 $120 $233.70 14 S1.90 15 $1.12 $168 $140 $308.12 16 $1.74 17 $1.88 18 S1.44 $152 $120 $273.44 19 S1.40 S104 $140 $245.40 20 s1. 46 $168 $120 $289.46 21 $1.78 $112 $120 $233.78 22 $1.80 23 $2.04 16 13 17 10 10 2 2 $0.16 14 2 17 $0.10 S0.02 $24 $120 $145.90 18 15 10 $0.00 Liper unit per day) $0.00 $0.00 $0. 12 $0.02 $16 $0 $16.00 $0.12 $20 $20.02 Lper unit) $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 20 17 10 10 4 6 6 so Stockout cost $8 21 18 20 22 19 1. 1. 3 10 $0.00 $24 $20 23 20 24 21 25 22 26 23 6 10 10 5 22 lOrder cost $0.10 $0.02 1 11 $96 $140 S237.80 S80 $120 S202.04 $S6 S120 $177 94 10 11 8 S0. 16 $0. 12 Based on 200 replications: $1.79 $98.64 $122.20 $222 63 6 $0.12 27 24 28 25 $0.06 $0.00 S0 $20 $20.06e $0.00 1 Average holding cost- Average stockout cost= Total per month = $1.48 $104 $140 $24S.48 Average order cost = 24 $1.94 25 $1.84 $168 $120 $289.84 6 3 3 28 3 3. 10 26 52.00 27 $1.86 199 51.56 $152 $100 $253.56 200 $1.84 $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: 87% (8 reviews)
To compute the average fill rate for Simkins Hardware Store we need to analyze the data i...View the full answer
Answered By
User l_917591
As a Business Management graduate from Moi University, I had the opportunity to work as a tutor for undergraduate students in the same field. This experience allowed me to apply the theoretical knowledge I had gained in a practical setting, while also honing my teaching and communication skills.
As a tutor, I was responsible for conducting tutorial sessions, grading assignments and exams, and providing feedback and support to my students. I also assisted with the preparation of course materials and collaborated with other tutors and professors to ensure consistency in teaching and assessment.
0.00
0 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
-
Complete the exercise that asks you to compute other output measures for Simkins Hardware Store and include them in the Scenario Manager as described under Analyzing the Results for the Scenario...
-
Your boss asks you to compute the companys cash conversion cycle . Looking at the financial statements, you see that the average inventory for the year was $26,300, accounts receivable were $17,900,...
-
For any question below that asks you to draw something, please ensure that you attach the graph as an answer to this problem. D2L has just released the ability for you to attach things directly to a...
-
Consider the heat pump described in Example 9.14. The heat pump now operates between 0.60 MPa and 1.4 MPa. Plot the vapor-compression cycle in Ts coordinates (use NIST) and determine the cycle...
-
The following values of the rate constant were obtained for the decomposition of hydrogen iodide at various temperatures. Plot the logarithm of k versus 1/T and from the graph obtain the energy of...
-
X Plc manufactures specialist insulating products that are used in both residential and commercial buildings. One of the products, Product W, is made using two different raw materials and two types...
-
Which of the following events will not appear in the cash flows from financing activities section of the statement of cash flow? a. Borrowing cash from a bank b. Issuance of stock in exchange for...
-
The statement of cash flows for Riker Company (prepared using the indirect method) follows. Consider the following additional information: (a) Sales for the year totaled $812,350. Cost of goods sold...
-
You have a normal distribution from a sample of 100 test scores with a mode of 50. What is the frequency of scores below P50? Psy230
-
Wade has a beginning basis in a partnership of $23,000. His share of income and expense from the partnership consists of the following amounts: Ordinary income.$43,000 Guaranteed payment12,000...
-
An alternative to using Excels built-in functions to generate live random numbers that change each time that a model is recalculated is to use Excels Random Number Generator tool found under Data |...
-
Modify the Executive Furniture example of Section 5.3 to include another potential factory in Little Rock, Arkansas. Unit costs from Little Rock are $4 to Albuquerque, $6 to Boston, and $4 to...
-
The following information has been adapted from the annual financial statements of General Mills, Inc. 1. What are the total amounts of accounts receivable for the two years given before considering...
-
Simplify. 3 x-8x +16x x-4x2
-
There are two basic elements required for any crime: actus rea and mens rea. A crime must be the result of a voluntary act and it must have the evil intent at the time of the crime. This is...
-
a) Resolve the forces into their x-y components. b) Add the respective components to get the resultant vector. c) Find magnitude and angle from the resultant components.
-
in C++ we discussed how to create a class that models the operation of a data structure known as stack, which operates according to the Last-In-First-Out (LIFO) rule. In this problem, we will create...
-
A car is speeding up uniformly at a rate of 0.700 m/s while traveling counterclockwise around a circular track of radius 525 m. At the instant the car is moving due north, its speed is 8.00 m/s. What...
-
Why is an insurable interest required for the enforcement of an insurance contract?
-
A fast-food restaurant averages 150 customers per hour. The average processing time per customer is 90 seconds. a. Determine how many cash registers the restaurant should have if it wishes to...
-
How can a promotion manager aim a message at a certain target market with electronic media (like the Internet) when the customer initiates the communication? Give an example.
-
What promotion blend would be most appropriate for producers of the following established products? Assume average- to large-sized firms in each case and support your answer. a. Chocolate candy bars....
-
A small company has developed an innovative new spray-on glass cleaner that prevents the buildup of electrostatic dust on computer screens and TVs. Give examples of some low-cost ways the firm might...
-
While this is a useful design to use to examine many research questions, there are times when the within-subjects design might fall victim to order effects, carry-over effects, or regression toward...
-
169 199 000, 1202 yd 926919b iw 21200 10del betaal 109jong srb ali bns 000, var 1200 lliw driemaiupe ed assy000,12 yd 9269oni lliw 29aneqx9 gnide1900 4. A $68,000 machine with a 8-year class life was...
-
Describe the 5 most factors necessary for selecting a comparable sale (in relation to the its similarity with the subject property)
Study smarter with the SolutionInn App