Question

i need to put the center of gravity into excel (correct answer in the word document).

AutoSave Off Saved AutoSave Вook1 - Excel Alaina Esparza mgmt3... Alaina Esparza Off АЕ AE O Search O Search Home Insert Draw Page La Formula Data Review View Help Foxit PD Power P Home Insert Draw Design Layout Referen Mailings Review View Help Foxit PC File File 12 Conditional Formatting X 11 AZ Calibri Times New Roman Format as Table В I A^ A U v ab х, х* Ао В IU Editing Editing Alignment Number Cells Paste Ideas Paste Styles Cell Styles A A- Aa A - A A Font Styles clipboard Styles Clipboard Paragraph Ideas Font Alaina Esparza fox E7 MGMT330 В с D E F G Н J y coordinate x coordinate ship load 27 October 2019 2 50 100 5 3 60 80 10 Assignment #7 40 90 15 5 90 50 5 X-coordinate: 50(5) 60(10) 40(15) 90(5) +70(15) 30(10) + 20(5)50(20) 5 + 10 15 5 15 10 5 20 6 70 90 15 7 30 20 10 8 20 60 5 x-coordinate = 51.18 9 50 70 20 10 y-coordinate: 100(5) +80(10) + 90(15) 15 515 10 520 50(5) 90(15) 20(10) 60(5) 70(20) 5 10 11 12 13 y-coordinate 72.35 14 15 So, the center of gravity coordinates for the new central hub should be (51.18, 72.35) 16 17 18 19 20 21 22 23 Q LL

Answer 1

Answer: X = 51.18, Y= 72.35

Explanation:

Location	X Coordinate	Y Coordinate	load	weighted X= load* X coordinate	weighted Y= load* Y coordinate
A	50	100	5	250	500
B	60	80	10	600	800
C	40	90	15	600	1350
D	90	50	5	450	250
E	70	90	15	1050	1350
F	30	20	10	300	200
G	20	60	5	100	300
H	50	70	20	1000	1400
SUM			85	4350	6150
				51.18	72.35
				X bar= sum of weighted X /total load	Y bar= sum of weighted Y /total load

Please ask, if you have any doubts through the comment section. Do rate the answer