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

See similar textbooks

Concept explainers

Pressure Vessels

The term pressure vessel refers to a closed container that contains gas or liquid at a different pressure than environment pressure. The pressure vessels have a wide scale of applications in our day-to-day lives and other industrial places. Some common e…

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:

Chapter 10, Problem 8ICA, The worksheet shown was designed to calculate the cost of material that must be purchased to produce 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

See solution

Chapter 10, Problem 7ICA

Chapter 10, Problem 9ICA

Students have asked these similar questions

I submitted the below question and received the answer i copied into this question as well. Im unsure if it is correct, so looking for a checkover. i am stuck on the part tan-1 (0.05) = 0.04996 radians. Just unsure where the value for the radians came from. Just need to know how they got that answer and how it is correct before moving on to the next part. If any of the below information is wrong, please feel free to give me a new answer or an entire new explanation. An Inclining experiment done on a ship thats 6500 t, a mass of 30t was moved 6.0 m transvesly causing a 30 cm deflection in a 6m pendulum, calculate the transverse meta centre height. Here is the step-by-step explanation: Given: Displacement of the ship (W) = 6500 tonnes = 6500×1000=6,500,000kg Mass moved transversely (w) = 30 tonnes=30×1000=30,000kg The transverse shift of mass (d) = 6.0 meters Pendulum length (L) = 6.0 meters Pendulum deflection (x) = 30 cm = 0.30 meters Step 1: Formula for Metacentric Height…

Answer the assignment question, expert only

A 1 inch rod diameter B 3/4 inch rod diameter C 1/2 inch rod diameter D 3/8 inch rod diameter

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. 8CC 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 - 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. 14ICA Ch. 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. 2RQ Ch. 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.