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
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 8ICA
The worksheet shown was designed to calculate the cost of material that must be purchased to produce a given number of parts. The user will enter the specific gravity of the material, the diameter of the cylindrical part in units of inches, the cost of the raw material in dollars per pound-mass, and the number of parts to be manufactured. All user input is shown in red. The worksheet will calculate the radius of the cylindrical part in units of centimeters and the density of the fluid in grams per cubic centimeter. All conversions are shown in orange.
The worksheet will determine the volume and mass of a single part for a given height. Finally, the worksheet will determine the total mass of material needed to produce the desired number of parts in units of pounds-mass, and the total material cost.
The total material cost appears twice. In cells E13 to E20, a formula is written to determine the cost. In cells B26 to B33, the cells simply reference the corresponding cell in the table above. For example, B26 the formula = E13 appears.
In the bottom table, the total cost for N parts is determined by the formula:
Total Cost = Total Material Cost + (Energy Cost + Labor Cost) × Number of Parts
- a. What should be typed into cell C9 to determine the radius in the correct units?
- b. What should be typed into cell B13 that can then be copied down column B to determine the volume of a cylindrical part in units of cubic centimeters?
- c. What should be typed into cell C13 that can then be copied through down column C to calculate the mass of each part in unit of grams?
- d. What should be typed into cell D13 that can then be copied down column D to calculate the total mass needed to produce N parts in units of pounds-mass?
- e. What should be typed into cell E13 that can then be copied down column E to calculate the total material cost?
- f. What should be typed into cell C26 that can then be copied from C26 to F33 given the energy cost in row 25 and labor cost in cell C22 to calculate the total cost of producing N parts?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Solve this problem and show all of the work
I tried to go through this problem but I don't know what I'm doing wrong can you help me?
Generate the kinematic diagram of the following mechanisms using the given symbols. Then, draw
their graphs and calculate their degrees of freedom (DoF) using Gruebler's formula.
PUNTO 2.
PUNTO 3.
!!!
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
A nozzle at A discharges water with an initial velocity of 36 ft/s at an angle with the horizontal. Determine ...
Vector Mechanics For Engineers
Assume a telephone signal travels through a cable at two-thirds the speed of light. How long does it take the s...
Electric Circuits. (11th Edition)
What are the design issues for character string types?
Concepts Of Programming Languages
17–1C A high-speed aircraft is cruising in still air. How does the temperature of air at the nose of the aircra...
Thermodynamics: An Engineering Approach
How are relationships between tables expressed in a relational database?
Modern Database Management
Porter’s competitive forces model: The model is used to provide a general view about the firms, the competitors...
Management Information Systems: Managing The Digital Firm (16th Edition)
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
- Create a schematic representation of the following mechanisms using the given symbols and draw their graphs. Then, calculate their degrees of freedom (DoF) using Gruebler's formula. PUNTO 6. PUNTO 7.arrow_forwardhow the kinematic diagram of the following mechanisms would be represented using the given symbols? PUNTO 0. PUNTO 1. °arrow_forwardCreate a schematic representation of the following mechanisms using the given symbols and draw their graphs. Then, calculate their degrees of freedom (DOF) using Gruebler's formula. PUNTO 4. PUNTO 5. (0) Groundarrow_forward
- Draw the graph of ALL the mechanisms and calculate their DoF using Gruebler's formula. PUNTO 0. PUNTO 1.arrow_forwardAn adjustable support. Construction designed to carry vertical load and is adjusted by moving the blue attachment vertically. The link is articulated at both ends (free to rotate) and can therefore only transmit power axially. Analytically calculate the force to which the link is subjected? Calculate analytically rated voltage in the middle of the link.? F=20kN Alpha 30 deg Rel 225 Mpans:5arrow_forwardA swivel crane where the load is moved axially along the beam through the wagon to which the hook is attached. Round bar with a diameter of ∅30 mm. The support beam is articulated at both ends (free to rotate) and can therefore only transmit force axially. Calculate reaction force in the x-direction at point A? Calculate analytical reaction force in the y-direction of point A? Calculate nominal stress in the middle of the support beam?Lengt 5 mAlfa 25 degX=1.5mIPE300-steelmass:1000 kgarrow_forward
- got wrong answers help pleasearrow_forwardA crate weighs 530 lb and is hung by three ropes attached to a steel ring at A such that the top surface is parallel to the xy plane. Point A is located at a height of h = 42 in above the top of the crate directly over the geometric center of the top surface. Use the dimensions given in the table below to determine the tension in each of the three ropes. 2013 Michael Swanbom cc00 BY NC SA ↑ Z C b B У a D Values for dimensions on the figure are given in the following table. Note the figure may not be to scale. Variable Value a 30 in b 43 in 4.5 in The tension in rope AB is 383 x lb The tension in rope AC is 156 x lb The tension in rope AD is 156 x lbarrow_forwardA block of mass m hangs from the end of bar AB that is 7.2 meters long and connected to the wall in the xz plane. The bar is supported at A by a ball joint such that it carries only a compressive force along its axis. The bar is supported at end B by cables BD and BC that connect to the xz plane at points C and D respectively with coordinates given in the figure. Cable BD is elastic and can be modeled as a linear spring with a spring constant k = 400 N/m and unstretched length of 6.34 meters. Determine the mass m, the compressive force in beam AB and the tension force in cable BC. Z C D (c, 0, d) (a, 0, b) A B y f m cc 10 BY NC SA 2016 Eric Davishahl x Values for dimensions on the figure are given in the following table. Note the figure may not be to scale. Variable Value a 8.1 m b 3.3 m с 2.7 m d 3.9 m e 2 m f 5.4 m The mass of the block is 68.8 The compressive force in bar AB is 364 × kg. × N. The tension in cable BC is 393 × N.arrow_forward
- The airplane weighs 144100 lbs and flies at constant speed and trajectory given by 0 on the figure. The plane experiences a drag force of 73620 lbs. 0 a.) If 11.3°, determine the thrust and lift forces = required to maintain this speed and trajectory. b.) Next consider the case where is unknown, but it is known that the lift force is equal to 7.8 times the quantity (Fthrust Fdrag). Compute the resulting trajectory angle and the lift force in this case. Use the same values for the weight and drag forces as you used for part a. 20. YAAY' Farag Ө Fthrust CC + BY NC SA 2013 Michael Swanbom Flift Fweight The lift force acts in the y' direction. The weight acts in the negative y direction. The thrust and drag forces act in the positive and negative x' directions respectively. Part (a) The thrust force is equal to 101,855 ☑ lbs. The lift force is equal to 141,282 ☑ lbs. Part (b) The trajectory angle 0 is equal to 7.31 ✓ deg. The lift force is equal to 143,005 ☑ lbs.arrow_forwardsimply supported beam has a concentrated moment M, applied at the left support and a concentrated force F applied at the free end of the overhang on the right. Using superposition, determine the deflection equations in regions AB and BC.arrow_forwardwhat is heat exchanger, what are formulas, and their importance, define the diagram, and give me a script on how to explain the design of heat exchanger, and how did values end up in that number. based on standards . what is dshellarrow_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
Pressure Vessels Introduction; Author: Engineering and Design Solutions;https://www.youtube.com/watch?v=Z1J97IpFc2k;License: Standard youtube license