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
Use your weight in pounds (while standing on the surface of the Earth) to calculate your mass in the following units (1 kg weighs approx. 2.205 lb on the surface of the Earth). Show all your calculation, how you cancel the units and use the correct number of digits to get credit. Use scientific notation. Weight in pounds = 200 mass in grams = mass in kilograms = mass in teragrams = mass in picograms =
2. A certain metal has a volume of 0.025 cu.m and when immersed in water, it weighs 500 N. Calculate the mass of the object.
What is the specific volume if the mass of an object is 120 lbs and the volume is 1250 ft3.
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
- When applying the principles of work and force, work is accomplished when force is applied to an object that does not move in the metric system the measurement for work is cubic centimeters no work is accomplished when an object is stopped by mechanical force if a 50-pound object is moved 10 feet, 500 ft.-lb of work are producedarrow_forwardThe answers for question 1 ie. Volume of each tank is given and attached here. But you need to still show the calculations for itarrow_forwardAnswer in 3 decimal places Two animals were placed on both end of a hydraulic lift system as show below. A mouse with a mass of m=9 g is placed on a smaller piston with a diameter of 10 cm. If an elephant with a mass of 4 000 kg is placed on the larger piston, how wide should the diameter of the larger piston be so that pressures at both ends are equal?arrow_forward
- The small piston of hydraulic jack has a radius of 2 cm. If a force of 50 Lb. is applied to the small piston raises a weight of 2000 Lb., what is the radius of the large pistonarrow_forwardFor the objects shown below sketch the object in the space provided after rotating it about the axis by the indicated amount.arrow_forwardConvert 500 meters squared per second squared to BTU per pound-mass. Answer to the third decimal place.arrow_forward
- A piece of lead with specific gravity of 11.3 is tied to a 130 cubic centimeters of cork whose specific gravity is 0.25. They float just submerged in water. What is the weight of the lead in grams?arrow_forwardHow did you calculated for the area of the sphere used in Q total and as well as Ai and Ao , please show the calculation for are separately. (Only show the computation for areas of the sphere used)arrow_forward3. The specific gravity of a certain alcohol is 0.8. Calculate its specific weight and mass density (in both English and SI units) (3 DECIMAL IN FINAL ANSWER PLS!!)arrow_forward
- If the specific gravity of gold is 19.0, what is the weight of a cubic inch of gold?arrow_forward8. you’ve just won the $12 million cash lottery, and you go topick up the prize. What is the approximate weight of the cash ifyou request payment in quarters and in dollar bills?arrow_forwardUsing only Table A (Conversion of Units), calculate the values asked. All answers must be given with the primary dimensions and units of the SI system. 33 lbm of a substance has a specific volume of 80 dm3/kg , determine the absolute volumearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Automotive Technology: A Systems Approach (MindTa...Mechanical EngineeringISBN:9781133612315Author:Jack Erjavec, Rob ThompsonPublisher:Cengage Learning
Automotive Technology: A Systems Approach (MindTa...
Mechanical Engineering
ISBN:9781133612315
Author:Jack Erjavec, Rob Thompson
Publisher:Cengage Learning
Pressure Vessels Introduction; Author: Engineering and Design Solutions;https://www.youtube.com/watch?v=Z1J97IpFc2k;License: Standard youtube license