CONSTRUCTION PLANNING ASSIGNMNET Problem 2: using any software( MS Excel/Matlab) determine the linear relation between Profit and number of Units Unit SoldProfit (100S)Unit SoldProfit (100S) Unit SoldProfit (1005)310639.25469957.25468955.25428875.25294607.25451921.25312643.25482983.25250519.254931005.25264547.2562143.2566149.25374765.2546109.25395807.25398813.25305627.25304625.25267551.25399815.25341699.2573163.25385787.25295607.25109235.25283583.251649.253791.25452921.2595207.25254525.25164345.25455927.25184385.25430877.25318655.2577173.25406831.253385.2590199.254991017.25425869.25266551.255001019.25444907.25316651.25183385.25353723.2578173.25314645.2545107.2566149.25243503.25113243.25393S03.25464945.25336689.2583183.2557131.25317651.25302621.25442901.2554125.25170357.25106229.25222461.25249515.25343703.25172361.25156329.25221459.25485989.25322663.25349717.25390799.25290599.25408835.25261541.25228475.2591201.25329677.25251521.2564147.25289595.25233483.2563143.2544105.25407831.25149315.2573163.2561139.252363.25394805.25442901.25411839.25405827.25179375.25420857.252465.25188393.2589195.25165347.2549115.25246509.25372761.2579175.25283583.25427873.25412843.25408835.25447913.25485989.25225469.25485989.258 8 8 * 3

Given : To find: Linear relation between profit and units using MS EXCEL

Answered: CONSTRUCTION PLANNING ASSIGNMNET

Engineering

Civil Engineering

CONSTRUCTION PLANNING ASSIGNMNET

Structural Analysis

6th Edition

ISBN:9781337630931

Author:KASSIMALI, Aslam.

Publisher:KASSIMALI, Aslam.

Chapter2: Loads On Structures

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: A simply supported steel beam with a moment of inertia of 60 x 10^6 mm^4 of length 7 m has a…

Q: Q18. Draw the plan and elevation of the residential building with the following dimensions. Assume…

Q: Design the reinforcement for the following short braced column: Depth, h=500mm Design Axial Load,…

A: Solution: Given: h= 500 mm b=500 mm P=2500 kN h'=437mm M=630 kNm bar size = 40mm

Q: Q3. (a) The following results are obtained from a Standard Proctor compaction test: Mass of soil…

A: Given data, Specific gravity = 2.70 Volume V = 0.945×10-3 m3

Q: A closed traverse has the following lengths and bearings: Line Length Bearing АВ 200.0m Roughly East…

Q: An observer (P) is standing on the deck of a ship just sees another observer (Q) whose eye is 12 m…

Q: Provide all necessary solutions. Do not round off unless it is the final answer. The 3 bars are…

A: To solve this question, first we will relate the deflections in the bar AB, AC and AD. All the…

Q: اسم الطالب الشعبة Q1: Determine the magnitude of the vertical force P that must be applied at the…

Q: Problem 5.6 Determine the force in each member of the truss. Set P = 3.1kN and P2 = 2.3kN . 30 30 3…

Q: Part E Consider the beam shown in (Figure 1). Suppose that the distributed load intensities wi = 100…

A: ASKED- To determine the internal shear and moment at point D. We can determine the internal shear…

Q: Determine the station at the end of the tangent runout after the end of the curve (the point at…

A: Customer of T2 = Chainge of T1 + l hereT1 is start of curve, T2 is end of curve. l is length of…

Q: В 6.4 Determine the magnitude and direction of the moment about the hinge at point B 26.0 N 4.00 m…

Q: What is the Maximum moment in kN-m. Given: w 18, a 1, b 5, and c 1. %3D w kN/m Fam CA b m ст

A: To find out the maximum moment in kN-m.

Q: The three bars are made of steel and form a pin-connected truss. Each bar has a cross sectional area…

Q: A COD test was carried out on a batik factory wastewater. The relevant information is as follows,…

Q: S. List the following air pollution control devices in order of their decreasing efficiency settling…

A: step 1-

Q: Determine centroid Y-bar with respect to X-axis, Centroid gw rupect to x-axis Problem 2: Determine…

Q: 1450 kg/m³, Given the viscosity of honey µhoney = 10 Pa-s, density of honey Phoney and assuming the…

Q: A 5 m long simply supported beam carries a superimposed Iload of 20 kN/m. Design the midspan section…

Q: What is the volume in the cylinder after the temperature has been raised?

Q: View Policies Current Attempt in Progress Compound axial member ABC has a uniform diameter of d =…

Q: Q27. A Kaplan turbine working under a head of 18 metres develops 18390 kW at an overall efficiency…

Q: What is the threshold torsion (kN-m) of a rectangular beam with a width of 403 mm and an over-all…

A: Given Data: The width of a rectangular beam is b=403 mm. The overall-depth of a rectangular beam is…

Q: Light-grade channel is used as a purlin of a truss whose top chord is sloped at 15degrees from the…

Q: (b) The mass of moist sample collected from the field is 400 g and the dry mass is 349 g. The…

Q: 1. A thin walled cylinder whose diameter is 9.73 meters has a thickness of 18 mm. What is the…

A: Given data: Cylinder diameter, d= 9.73 m =9730 mm Thickness, t= 18 mm Internal pressure, p=1.42 MPa…

Q: For the given data of a close traverse, determine the missing distance of course CD and the bearing…

A: There are generally two types of methods to find the area of the traverse. They are: 1)Co-ordinate…

Q: 1. The blocks shown in Fig. P-522 are separated by a solid strut which is attached to the blocks…

Q: What is the Maximum moment in kN-m. Given: w = 39, a = 3, b = 4, and c = 2. w kN/m D. B. ст Rp am b…

A: Calculate maximum moment,Mmax=?

Q: 5. The following tacheometric observations were made on two points P and Q from station A. The…

Q: A transit with a stadia interval factor of 100.12 was set at C on the line between points A and B,…

Q: Determine the value of o for the rainfall hyetograph shown. Assume the depth of direct runoff is 2.5…

A: Answer:-

Q: Problem 5. Find member forces and reactions for the truss with loads shown. 800 N 600 N 500 N F. 2m…

Q: 1. Two tanks A and B have 70 m difference in water levels, and are connected by a pipe 0.25 m…

Q: 29. Figure shows the line drawing of a residential building, draw to a scale of the following, (a)…

Q: Briefly explain the (a) how and (b) why the size of elastic deformation changes as the thickness of…

Q: 6.4 Determine the magnitude and direction of the moment about the hinge at point B 26.0 N 4.00 m…

A: Given -

Q: 40KN/M 80KN 15KN/M B 21 1.51 Е 21 1.5/ 1.75/ 6.0 A D. Fl 6.0 4.0

Q: Determine the value of o for the rainfall hyetograph shown. Assume the depth of direct runoff is 2.5…

A: ANSWER:-

Q: Using Double Integration method

Q: Example 3 (H.W): Using Equivalent frame method for the reinforced concrete slab shown in figure…

Q: What is the Maximum moment in kN-m. Given: w= 37, a = 3, b = 3, and c = 1. w kN/m D. b m cm am Ro RA

Q: What is the Maximum moment in kN-m. Glven: W- 10, a - 3, b-8, and P- 90. PKN am W KN m b m Ry

Q: 39 kN 1 DROW the shean and A 5m 4m R. moment diegnom

Q: ) Given the Truss as shown below. Using Method of Joints, determine the forces at the members BC,…

Q: EXAMPLE 3.5 A recently irrigated field plot has on Day I the total available soil mois- ture at its…

A: Given data , Soil moisture on Day 1 = 10 cm Evapotranspiration = 5.0 mm/day Water depeletion…

Q: Q1) Water flows in through a 300 mm diameter pipe at an average velocity (V= 1.5 m/see). Find the…

Q: Calculate the normal discharge for a depth of 1.5 m in m³/s, to the nearest 100th.

Q: 3 kip 50 kip.ft A В 50° 5 ft 3 ft + -10ft-

Q: Draw the shear and moment diagrams for the loaded beam. After you have the diagrams, answer the…

A: Drawing of SFD and BMD###

Concept explainers

MATLAB

MATLAB software is a registered trademark, multi-model programming language, and numerical computing environmental system created by MathWorks. 'MATLAB' is the short-form of "Matrix Laboratory". The MATLAB software permits the utilization of matrix operations, graphical representation of data, execution of algorithms, development of user interface, and linking programs created in other languages. Even though MATLAB is developed mainly for numerical computing, there is an optional toolbox that uses a symbolic engine known as MuPAD giving access to all the symbolic computing abilities. In addition to this, a Simulink package delivers graphical multi-domain simulation and design that is model-based for embedded and dynamic systems. MATLAB users are spread worldwide across the world and use MATLAB extensively.

Question

CONSTRUCTION PLANNING ASSIGNMNET Problem 2: using any software( MS Excel/Matlab) determine the linear relation between Profit and number of Units

Unit Sold
Profit (100S)
Unit Sold
Profit (100S) Unit Sold
Profit (1005)
310
639.25
469
957.25
468
955.25
428
875.25
294
607.25
451
921.25
312
643.25
482
983.25
250
519.25
493
1005.25
264
547.25
62
143.25
66
149.25
374
765.25
46
109.25
395
807.25
398
813.25
305
627.25
304
625.25
267
551.25
399
815.25
341
699.25
73
163.25
385
787.25
295
607.25
109
235.25
283
583.25
16
49.25
37
91.25
452
921.25
95
207.25
254
525.25
164
345.25
455
927.25
184
385.25
430
877.25
318
655.25
77
173.25
406
831.25
33
85.25
90
199.25
499
1017.25
425
869.25
266
551.25
500
1019.25
444
907.25
316
651.25
183
385.25
353
723.25
78
173.25
314
645.25
45
107.25
66
149.25
243
503.25
113
243.25
393
S03.25
464
945.25
336
689.25
83
183.25
57
131.25
317
651.25
302
621.25
442
901.25
54
125.25
170
357.25
106
229.25
222
461.25
249
515.25
343
703.25
172
361.25
156
329.25
221
459.25
485
989.25
322
663.25
349
717.25
390
799.25
290
599.25
408
835.25
261
541.25
228
475.25
91
201.25
329
677.25
251
521.25
64
147.25
289
595.25
233
483.25
63
143.25
44
105.25
407
831.25
149
315.25
73
163.25
61
139.25
23
63.25
394
805.25
442
901.25
411
839.25
405
827.25
179
375.25
420
857.25
24
65.25
188
393.25
89
195.25
165
347.25
49
115.25
246
509.25
372
761.25
79
175.25
283
583.25
427
873.25
412
843.25
408
835.25
447
913.25
485
989.25
225
469.25
485
989.25
8 8 8 * 3

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3: Insert XY scatter plot

VIEW

Step 4: Insert trendline

VIEW

Step 5

VIEW

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.

Similar questions

I need the correct answers gor g1 = -2.00% and g2 = +2.00%
SUBJECT: static of rigid bodies 1.lxx(centroidal) choices a. 1642.67 b. 1752.5 c. 1987.6 d. 1612.7 2. Lyy(centroidal) choices a. 784.98 b. 832.5 c. 1012.27 d. 958.77
By Lacey's only or else skip proper explanation
P (kN)=80 L (m)=0.65 A1 (mm2)=540 A2 (mm2)= 650 Eal (GPa)=74 Est (GPa)=205
v8g87wty g87wy08g7y0w89y98w7y f89yhswu89gh08qw7erh098h90as8dfgy0as789d60879asdg
Convert 48°15'26" to centesimal units (Ans.: 53.6191)
Gs is assumed to be 2.72
11. Will upvote to anyone who will answer. Correct units pls. Thanks
Mu 0.7 Y=22.50 b1=1.25 b2=5.50 h1=12.05 h2=10.50
7.5Convert: *(a) 203∘26′48′′203∘26′48″ to grads (b) 1.789546 radians to degrees, minutes, and seconds (c) 156∘07′34′′156∘07′34″ to radians.
Determine C1. A.-54 B.0 C.54 D.36 Determine C2 A.-130 B.157 C.0 D.-148 Find h. A.810.67 mm B.724.33 mm C.708.21 mm D.618.67 mm
Convert 224 Psf to N/m2 * 72,102.51 25,304.80 10,721.51 17,528.42 Convert 726,000 lbs to MN * 7.21 3.23 3,230,000 5,480.000 Convert 903 joules/sec to Watts * 0.903 903 9,030.00 90,300, Convert 400 N-m/sec to HP * 298,280 0.000894 0.53640 5.3640 Convert 6,543.21 Pa to MN/m2 .065 .0065 654,321.00 65,432.10