Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
3rd Edition
ISBN: 9780133593211
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 5ICA
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, in cell B26 to 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
The following sample worksheet is shown for comparison.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
State the following laws a) v/t = constant, (b) pv=constant c) pv^n=constant
Define Gas Constant and Universal Gas Constant
state Boyle's Law.
A receiver contains 0.25 m³ of air at a pressure of 1700 kPa and a temperature of 18 ° C . Calculate the final pressure after 2.5 kg of air is added if the final temperature is 20.5 ° C . Take R for air = 0.287 kJ / kg / ° K
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Ch. 10.1 - Type "5" in cell E22 and "9" in cell E23; type...Ch. 10.1 - Type “20” into cell G22 and “=$G$22 + 10” in cell...Ch. 10.1 - Prob. 3CCCh. 10.1 - Type “=$A28 + 5” in cell G28. Copy cell G28 down...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 - Continue the example in CC 10-6 above. The...Ch. 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 - 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. 10ICACh. 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. 3RQCh. 10 - 4. 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 - 16. A substance used to remove the few remaining...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 18RQ
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
What is an uninitialized variable?
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
The solid steel shaft AC has a diameter of 25 mm and is supported by smooth bearings at D and E. It is coupled ...
Mechanics of Materials (10th Edition)
Write a summary list of the problem-solving steps identified in the chapter, using your own words.
BASIC BIOMECHANICS
Why is the study of database technology important?
Database Concepts (8th Edition)
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)
The job of the _____ is to fetch instructions, carry out the operations commanded by the instructions, and prod...
Starting Out With Visual Basic (8th 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
- Heat energy is transferred to 1.36 kg of air which causes its temperature to increase from 40" CO 468°C. Calculate, for the two separate cases of heat transfer at (a) constant volume, (b) constant pressure: the quantity of heat energy transferred, (ii) the external work done, (iii) the increase in internal energy. Take cv and cp as 0.718 and 1.005 kJ/kgK respectivelyarrow_forwardA flat circular plate is 500 mm diameter. Calculate the theoretical quantity or heat radiated per hour when its temperature is 215°C and the temperature of its surrounds is 45°C. Take the value of the radiation constant to be 5.67 × 10^11 kJ/m2s K4.arrow_forwardDescribe Atmospheric Air and how it reacts with carbon in combustionarrow_forward
- 0.5 kg of ice at —5°C is put into a vessel containing 1.8kg of water at 17°C and mixed together, the result being a mixture of ice and water at 0°C. Calculate the final masses of ice and water, taking the water equivalent of the vessel to be 0.148 kg, specific heat of ice 2.04 kilkg K and latent heat of fusion 335 kJ/kg.arrow_forwardA condenser vacuum gauge reads 715 mmHg when the barometer stands at 757 mmHg. State the absolute pressure in the condenser in kN/m2 and bars.arrow_forwardSketch and Describe a timing diagram for a 2 stroke diesel enginearrow_forward
- Manipulate the formula for converting temperature from Fahrenheit to Celsiusarrow_forwardDefine Temperature, Pressure, and Absolute Temperature.arrow_forwardAn air reservoir contains 20 kg of air at 3200 kN/m2 gauge and 16°C. Calculate the new pressure and heat energy transfer if the air is heated to 35°C. Neglect any expansion of the reservoir, take R for air = 0.287 kJ/kgK, specific heat at constant volume c, = 0.718 kJFg K, and atmospheric pressure = 100 kN/m2arrow_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