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
Each bar chart should show the distribution of energy across the categories as well as the total energy for the initial- red and final- blue state.
The system includes 3 units of heat energy, and 2 units of radiant energy. All of the energy in the final state will be converted into mechanical energy.
Please help me find the mass of the weights.
Please Full answer and make sure to use the formulas provided and draw the sketches.
Make sure to write all the units in the steps, please
Handwriting CLEAR & BIG, please
Please please no copy from other answers , need new correct one with all steps, please
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
5.1 through 5.9
Locate the centroid of the plane area shown.
Fig. P5.1
Vector Mechanics for Engineers: Statics and Dynamics
How is the hydrodynamic entry length defined for flow in a pipe? Is the entry length longer in laminar or turbu...
Fluid Mechanics Fundamentals And Applications
What types of polymers are most commonly blow molded?
DeGarmo's Materials and Processes in Manufacturing
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: Dynamics
Convert the following quantities from English to SI units: a. 98 Btu/(hr-ft-F) b. 0.24 Btu/(lbm-F) C. 0.04 Ibm/...
Heating Ventilating and Air Conditioning: Analysis and Design
23.23 A highly oxidized and uneven round bar is being turned on a lathe. Would you recommend a small or a large...
Manufacturing Engineering & Technology
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
- Hi, I need help with the first part of the problem below because I'm very confused about how P1 and P2 should be calculated. If you look at my notes to solve the problem there is already a formula in place as I always thought the Patm should also be multiplied by the Area in the numerator, but it's not if I look at this specific tutorial solution given by my course but it's not explained why. I have done a while ago a very similar problem with using that formula in my notes and it gave me the right results, but it's not working for this one. Could you please help me understand why as I have a test coming soon? Figure Q3 (see image attached) shows a cylinder and pistonenclosing air, the movement of the pistonbeing restrained by a compression spring ofstiffness 20 kN/m. The air is heated andexpands, the piston moving 0.3 m. Thefree length of the spring is 1.0 m.Calculate the work done by the air duringthe process.If the pressure , volume and internal energyof air are related by the…arrow_forward1.3 Please help. Written on paper not typed on computer or keyboard please. Need help both questions. Please include all units, steps to the problem and information such as its direction or if it is in compression or tension. Thx.arrow_forwardPlease ANSWER ALL of the given questions. I will rate you with “UPVOTE/LIKE” if you answer every question. I will rate you with “DOWNVOTE/DISLIKE”, if you don’t answer every question. THANK YOU.arrow_forward
- Measure the vertical distance from the ground floor to the landing and from the landing to the 1st floor as shown below (convert to feet). Record this value on the data sheet, column B. Note: Your stairs might not have a landing – that’s ok. Just measure the vertical height from the bottom to the top of the stairs. Record your weight (pounds) in column A of the data sheet. Multiply column A and column B. Record this value in column C. Measure the time it takes to walk (at a normal pace) up the stairs from the ground floor to the first floor – use the hand rail for support. Measure 3 times and calculate the average time. Record these values in column D. Measure the time it takes to briskly walk (not run) up the stairs from the ground floor to the 1st floor – use the hand rail for support. Measure 3 times and calculate the average time. Record these values in column E. Calculate the power it took to walk and to hurry from the ground floor to the 1st floor. Enter your…arrow_forwardPlease do the last two questions (3 and 4)! Thank you in advance! A seesaw that weights 45lbs and its 5m long is balanced on the fulcrum in the center. 1- Two children are sitting on opposite sides of each other on the seesaw. One child weights 50lbs and is sitting 0.7m on the left end. Where should the other child sit in order to be balanced on the seesaw if they weigh 42lbs? 2- Now, a third child wants to sit on the seesaw and weighs 30lbs and is sitting 1.25m in front of them and is closer to the fulcrum on the right side. What are the CW and CCW moment of the seesaw now? What is the net moment and direction? 3- Then, a fourth child wants to play on the seesaw and is on the left side of the plank in order to bring the system to equilibrium. How much does the child weigh (Calculate the pounds of force needed in order for rebalance?) 4- Now the fourth child leaves the other three children sitting on the plank. If the three children are sitting in the same potions as they did in…arrow_forwardPlease do the last three questions (2, 3 and 4)! Thank you in advance! A seesaw that weights 45lbs and its 5m long is balanced on the fulcrum in the center. 1- Two children are sitting on opposite sides of each other on the seesaw. One child weights 50lbs and is sitting 0.7m on the left end. Where should the other child sit in order to be balanced on the seesaw if they weigh 42lbs? 2- Now, a third child wants to sit on the seesaw and weighs 30lbs and is sitting 1.25m in front of them and is closer to the fulcrum on the right side. What are the CW and CCW moment of the seesaw now? What is the net moment and direction? 3- Then, a fourth child wants to play on the seesaw and is on the left side of the plank in order to bring the system to equilibrium. How much does the child weigh (Calculate the pounds of force needed in order for rebalance?) 4- Now the fourth child leaves the other three children sitting on the plank. If the three children are sitting in the same potions as they did…arrow_forward
- The second picture is continuation of first image.arrow_forwardHANDWRITTEN. answer 4 5 6 then box the final answersarrow_forwardIn the blank space within your drawing template, draw the 3rd angle orthographic projection layout of the object shown. Also redraw the object shown in the top right hand corner of your page. You can use the scale markings to determine your own scale that fits appropriately on your paper. You can use mm or inches.arrow_forward
- Oo.33. Subject:- Mechanical engineeringarrow_forwardSolve it correctly please. I will rate accordingly.arrow_forwardPlease answer question with as much detail as possible Please Use the “NCEES FE Reference Handbook 10.0.1” which can be downloaded for Free from https://ncees.org/ as your Reference for tables and formulasarrow_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