Question: Purpose This assignment is designed to develop Graduate Attribute 5 , which consists of engineering methods, skills, and tools, including information technology. Upon completion of

Purpose

This assignment is designed to develop Graduate Attribute

5,

which consists of engineering

methods, skills, and tools, including information technology. Upon completion of the assignment,

you should demonstrate competence in using appropriate engineering methods, skills, and tools,

including those based on information technology.

Instructions

Develop an Excel spreadsheet to solve the problem set out below. The spreadsheet must

show all calculations

(

automated

)

and relevant data sourced and given.

Provide a brief outline

/

description of how the spreadsheet works such that a fellow student

can be able to use it to solve a problem with different pipe sizes and pipe fittings. The

description must include all the equations used. The equations must be created using the

'insert equation' in Excel.

Completed Excel document must be submitted through the assignment link on Blackboard.

No email submissions will be allowed.

Problem statement

Kerosene at

25 C

is flowing in the system shown in Fig.

1 .

The total length of

49.8 m m

ID galvanized

iron tubing is

30 m .

The two

90

bends are standard elbows and tank B is open at the top. Calculate

the volume flow rate

(\frac{m^{3}}{s})

into tank

B

if a pressure of

150

kPa is maintained above the kerosene in

tank A

.

Graduate Attribute Assessment

The following indicators will be used to assess the student's competency in using appropriate

engineering tools to solve a broadly defined engineering problem. The assessment rubric can be

found on page

3 .

Indicator

1 -

Understand Tools

Explain how the spreadsheet works. In your explanation, include what information is required as

input and what the output is

.

Include all the equations used in calculations and references used.

Indicator

2 -

Identify and Use Tools

Solve the question using Excel solver or Goal seek function.

Indicator

3 -

Create Tools

Create a spreadsheet with a layout that shows Input parameters, calculated values, and constants.

Ensure the calculated values change when input parameters are changed.

Indicator

4 -

Evaluate Tools

Explain the error

(

)

that can be expected in the spreadsheet. Indicate how the error

(

)

can be

resolved. Explain the limitations of the used tool

(

solver or goal seek

) .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

100% Satisfaction Guaranteed-or Get a Refund!

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!

Calculate the concentration of the acid (or base) remaining in solution when 10.7 mL of 0.211 M HNO3 are added to 16.3 mL of 0.258 M NaOH.

The following information is available for a company's maintenance cost over the last seven months. Using the high-low method, estimate both the fixed and variable components of its maintenance cost....

11-8: What has research taught us about sexual orientation?

Rhodes parked his car in the self-service park-and-lock lot of Pioneer Parking Lot, Inc. The ticket that he received fromthe ticketmeter stated the following: NOTICE. THIS CONTRACT LIMITS OUR...

Purpose This assignment is designed to develop Graduate Attribute 5 , which consists of engineering methods, skills, and tools, including information technology. Upon completion of the assignment,...

Part a.) Part b.) Solve both parts. Dove, Inc., had additions to retained earnings for the year just ended of $638,000. The firm paid out $65,000 in cash dividends, and it has ending total equity of...

[The following information applies to the questions displayed below.] XYZ is a calendar-year corporation that began business on January 1, 2023. For the year, it reported the following information in...

a) Show that = 0 n 1 b) Show that = (i.e., mean of predicted values is equal to sample mean of Yi ) n c) Show that TSS = ESS+RSS

1.Hanker Company had the following department data on physical units: Work in Process, beginning1,000 Completed and transferred out4,000 Work in Process, ending800 Materials are added at the...

Apply different yield (revenue) management techniques to a variety of scenarios in hotel industry.

Polinezo Industries' balance sheet reflects an equity of $650 million, the stock price is $90 per share, and its aggregate market value (MVA) is $60 million. Determine the common stock outstanding.

Nine months ago, Sandra Tucker purchased a computerized sewing machine by mail order from Kunkel Enterprises. The sewing machine was sold with a six-month limited warranty. Sandra has returned the...

Jonathon Green has been a good employee until the past six months. During this time, he has accumulated at least one absence a week and has clocked in tardy 30 times. His productivity has fallen, and...

Write a form letter from the local city government director of solid waste to city residents notifying them that as of January 1, garbage service will change from twice a week to once a week. Explain...

Ask a Question and Get Instant Help

Question: Purpose This assignment is designed to develop Graduate Attribute 5 , which consists of engineering methods, skills, and tools, including information technology. Upon completion of

Step by Step Solution

Students Have Also Explored These Related Chemical Engineering Questions!

Related Book