Thinking Like an Engineer: An Active Learning Approach (4th Edition)
4th Edition
ISBN: 9780134639673
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. Ohland
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 17ICA
You are interested in analyzing different implant parts being made in a bioengineering production facility. The company can make nine different parts for shoulder, knee, or hip replacement.
On the worksheet shown, you have created a place for the user to choose the body location (shoulder, knee, or hip) in cell B5 using a data validation list. Once the body location is set, a list of material choices will appear in cells D5 to F5. The user can choose a material in cell B6 using a data validation list. If the material chosen does not match one of the possible choices in cells D5 to F5, a warning will be issued for the user to choose another material.
In cell B9, the user will choose if the part is size small (S), medium (M), or large (L) using a data validation list. Based upon body location and size, the part number will adjust automatically using a VLOOKUP function. After the part number has been determined, the material weight (cell B11) and part volume (cell B12) will adjust automatically using a VLOOKUP function.
The user will enter the number of desired parts in cell B14. If the user requests more than 250 parts, a warning of “Too Many” will be issued; if the user requests fewer than 20 parts, a warning of “Too Small” will be issued in cell C14.
The amount of material to be ordered will be determined in cell B16 by multiplying the number of pans and the material weight. The cost of the material to be ordered will be determined in cell B17. If the order cost is greater than $1000, a request to “Check with Purchasing” will appear, otherwise, the cost of the order will appear. Finally, in cell B18 the amount of boxes needed for shipping will appear determined by the number of parts requested and the number of pans per box, based on the pan number chosen in cell B10.
Lookup functions in Excel contain four parts.
=VLOOKUP (__ (1) __,__(2) __,__ (3) __,__ (4) __)
- a. Fill in the following information in the VLOOKUP function used to determine the third possible material choice in cell F5 based on the choice of body location in cell B5
An IF statement in Excel contains three pans. Fill in the following information in the IF function used to determine the following conditions:
= IF(__ (1) __,__ (2) __,__ (3) __)
- b. In cell C6, a warning is issued to the user if the material chosen in cell B6 does not match the list of materials provided in cells D5 to F5. Fill in the IF statement used to create this error message, containing a complex IF test using AND or OR.
A nested IF statement in Excel contains three parts per IF statement. Fill in the following information in the IF function used to determine the following conditions:
=IF (__ (1a) __,__ (2a) __, IF(__ (1b) __,__ (2b) __,__ (3b) __))
- c. In cell B14, the user can enter the number of parts needed in production. If this value is more than 250 parts, a warning will appear in cell C14 telling the user the quantity is too high; if the value is less than 20, a warring will tell the user the quantity is too small; otherwise, the cell remains blank.
- d. In order for Excel to display the correct number of boxes needed, the following functions are tried. Which one will correctly display the number of boxes needed to ship the parts?
- A. = B14/VLOOKUP(B10, J1:L10, 3, FALSE)
- B. = ROUND(B14/VLOOKUP(B10, J1:L10, 3, FALSE), 0)
- C. = ROUNDDOWN(B14/VLOOKUP(B10, J1:L10, 3, FALSE),0)
- D. = ROUNDUP(B14/VLOOKUP(B10, J1:L10, 3, FALSE), 0)
- E. = TRUNC(B14 VLOOKUP(B10, J1:L10, 3, FALSE), 0)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I downloaded this question multiple times but I had no answer.
A bacteria culture is known to grow at a rate proportional to the amount present. (a) Write down and solve a DE modeling this process. (Your solution will contain two unknown constants.) (b) After one hour, 1000 strands of the bacteria are observed in the culture; and after four hours, 3000 strands. Use this information to complete the determination of the DE. c) Find the approximate number of strands of the bacteria originally in the culture. (d) How long will it take to reach 10,000 strands of the bacteria in the culture.
Engineering Economy
A company has determined the price and the monthly demand of its products are related by the equation D = √775 - p, where p is the price per unit in dollar and D, is the monthly demand. The associated fixed costs are $2,125 per month and the variable costs are $100/ unit. Use this information to answer the following:
a)What is the optimal number of units that should be produced and sold each month?
b) What is the maximum profit?
c)Determine the value of D that represents the break-even point?
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Ch. 10.1 - Type 5 in cell E22 and 13 in cell E23; type =E22 +...Ch. 10.1 - Type 45 into cell G22 and =G22 + 10 in cell H22....Ch. 10.1 - Type 40 into cell A28 and =A28 + 10 in cell D28....Ch. 10.1 - Type 40 into cell A28 and =A28 + 5 in cell G28....Ch. 10.2 - Launch a new worksheet. Type the following Excel...Ch. 10.2 - As part of the design of a high-performance...Ch. 10.3 - Evaluate the following expressions. What is the...Ch. 10.3 - Prob. 8CCCh. 10.4 - This is a continuation of the worksheet you...Ch. 10.5 - Prob. 11CC
Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - ICA 10-5 The worksheet shown here was designed to...Ch. 10 - The worksheet provided was designed to calculate...Ch. 10 - Some alternate energy technologies, such as wind...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - Refer to the following worksheet. The following...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Refer to the following worksheet. In all...Ch. 10 - Prob. 14ICACh. 10 - A bioengineer conducts clinical trials on...Ch. 10 - Refer to the Worksheet shown, set up to calculate...Ch. 10 - You are interested in analyzing different implant...Ch. 10 - You have a large stock of several values of...Ch. 10 - We accidentally drop a tomato from the balcony of...Ch. 10 - You are interested in calculating the best place...Ch. 10 - 1. A history major of your acquaintance is...Ch. 10 - Prob. 2RQCh. 10 - 3. A phase diagram for carbon and platinum is...Ch. 10 - 4. A simplified phase diagram for cobalt and...Ch. 10 - 5. You enjoy drinking coffee but are particular...Ch. 10 - 6. In the 1950s, a team at Los Alamos National...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - 11. When liquid and vapor coexist in a container...Ch. 10 - 12. The ideal gas law assumes that molecules...Ch. 10 - One of the NAE Grand Challenges for Engineering is...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 16RQ
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Locate the centroid of the area. Prob. 9-17
Engineering Mechanics: Statics
Select a mechanical component from Part 3 of this book (roller bearings, springs, etc.), go to the Internet, an...
Shigley's Mechanical Engineering Design (McGraw-Hill Series in Mechanical Engineering)
Repeat Problem 4-6 except solve by the vector loop method.
DESIGN OF MACHINERY
Steady state conduction rate to the warm compressor to the net power produces theoretically by thermodynamic ba...
Introduction to Heat Transfer
What is the importance of modeling in engineering? How are the mathematical models for engineering processes pr...
Heat and Mass Transfer: Fundamentals and Applications
Define or describe each type of fluid: (a) viscoelastic fluid (b) pseudoplastic fluid (c) dilatant fluid (d) Bi...
Fluid Mechanics: Fundamentals and Applications
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.Similar questions
- The title of our study is "Design and Fabrication of an Agricultural Spraying Attachment for an Autonomous Rover" we need help in the machine design part of our study, specifically Pump selection, battery selection, and center of gravity computation I already sent you the image of the rover Rover weight capacity 35 kilo grams (payload) Rover measurements: Wheel distance - 14.5 inches and 8.5 inches Rover platform size (width & length) 14.4 inches x 10.4 inches Height- 15.8 inches. Water tank selection More or less 25 liters *For tank selection we need to justify the size with the center of gravity, proving that is the maximum dimension or liters of the tank because the center of gravity will be higher making the rover prone to toppling Pump selection *Our sprayer design has two nozzles which splits using a tee splitter, we need to find the size of the pump to obtain the same discharge rate of a normal sprayer. A normal sprayer has a 12V pump and a pressure from 0.2 to 0.45 mpa…arrow_forwardHartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectorsarrow_forwardI wanted to create two spheres that overlap each other in MATLAB. The image has my code and results. I only see one sphere in the results. Why is that? Can you give me the code that will create two overlaying spheres in one plot?arrow_forward
- Simulated Annealing How would Simulated Annealing perform if the temperature, T, is always equal or very close to 0, where we omit the termination test (except that we terminate the search when a goal node, either a local or global optimum, is met)? Please pick up one option from the following options and explain.(a) A random walk(b) Hill-Climbing(c) It would halt immediately(d) It would never haltarrow_forwardAfter years of asking, you finally were allowed to go on a joy ride in your uncle’s 1956 Mercedes-Benz 300 SL. A notable feature of this vehicle is the gullwing door design that opens from a hinge at the top of the car. Unfortunately, you are having so much fun driving the car that you end up submerged in a fresh water lake. You sink to the bottom of the lake, which has a depth of 10 m. For the sake of simplicity, you can model the door as a 1 m × 1 m square plate, inclined at 45° relative to the floor of the lake. Neglect the weight of the door and friction in the hinge. How much force will be required to open the door, assuming you push from its geometric center?arrow_forward2. (If relevant) A clearly labeled diagram (or diagrams) clearly pertaining to your analysis with a coordinate system and relevant labels. Final answer with appropriate units and significant figures. You can use the fprintf() command in MATLAB to format numerical results A 2-3 sentence reflection on your answer. Does it make sense? Why or why not? What are some implications?arrow_forward
- Engr 215 Matlab Fahrenheit to Celsius using multiple statements Given a Fahrenheit value temperatureFahrenheit, write a statement that assigns temperatureCelsius with the equivalent Celsius value. While the equation is C = 5/9 * (F - 32), as an exercise use two statements, the first of which is "fractionalMultiplier = 5/9;"]arrow_forwardNewton’s 2nd Law Lab (Modeling friendly lab) Go to the PhET simulation Forces & Motion. https://phet.colorado.edu/sims/html/forcesandmotionbasics/latest/forcesandmotionbasics_en.html Select “Acceleration” Click to show Forces, Sum of Forces, Values, Mass, and Acceleration. There are two experiments for this activity – make sure you include both. Experiment #1: Acceleration vs. Force In this lab you will determine the relationship between acceleration and net force. Choose a mass at the beginning, and keep it constant for this entire experiment. Set the friction to zero. This will make your Applied Force equal to the net force. Record data for five different values of Applied Force. Graph Acceleration vs. Net Force. Graph this in Google sheets(you want a line graph - it should only have one line). Make sure that Applied Force information is used as the x value Make sure that Acceleration information is used as the y value Add a trendline – see what fits best –…arrow_forwardLearning Goal: To use equilibrium to calculate the plane state of stress in a rotated coordinate system. In general, the three-dimensional state of stress at a point requires six stress components to be fully described: three normal stresses and three shear stresses (Figure 1). When the external loadings are coplanar, however, the resulting internal stresses can be treated as plane stress and described using a simpler, two-dimensional analysis with just two normal stresses and one shear stress (Figure 2). The third normal stress and two other shear stresses are assumed to be zero. The normal and shear stresses for a state of stress depend on the orientation of the axes. If the stresses are given in one coordinate system (Figure 3), the equivalent stresses in a rotated coordinate system (Figure 4) can be calculated using the equations of static equilibrium. Both sets of stresses describe the same state of stress. The stresses σx′and τx′y′ can be found by considering the free-body…arrow_forward
- PLEASE ANSWER THEM ALL FOR AN UPVOTE. THANK YOU. Given: Pi constant to be used: 3.14159 Capillary tube: radius = 0.02 cm; length = 9 cm; pressure = 0.7 mmHg Liquid sample: density = 4 ml; time of flow = 4.5 seconds Ans. the ff questions. •What is the pressure in MKS unit? •What is the pressure in CGS unit? •What is the viscosity of the liquid? • If the weight was given as 8.5 grams, what will be the density of the liquid? •What is the kinematic viscosity of the liquid? •What is the fluidity of the liquid?arrow_forwardA vertical chemical reactor undergone a maintenance in which its internals were subjected inspection from bottom to top before catalyst loading. A site engineer (63.00 kg) was tasked to do the inspection and he stopped from time to time at each portion to inspect. A safety officer monitored the engineer’s position while watching from the top and reported his position (Refer to the photo attached. CORRECTION for data table at t=70.00 min, position=725.0 cm): Solve for: (a) Power he exerted at t = 50.00 min (b) Power he exerted at t = 65.00 min (c) Total Work he exerted throughout the inspection (d) Average Power throughout the inspectionarrow_forwardPosted below is a picture of a data table and a diagram of an experiment. In the experiment you rolled a marble down a ruler ramp off the end of a coffee table to observe projectiles and conservation of energy. You do 3 trials for each initial height. Each height is measured in meters. h= initial height of marble off of table Y= height of table off floor X= horizontal distance marble goes from edge of table to where it strikes the floor a) use the table to find information you need to solve for theoretical range and % of error in measured range.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University Press
Mechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSON
Thermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEY
Mechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage Learning
Engineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license