Question: please show excel work Problem 1.5 Freight Cars Freight car loading over an 18 week period at a busy port are as follows. Week Leadings

please show excel work please show excel work Problem 1.5 Freight Cars

Problem 1.5 Freight Cars Freight car loading over an 18 week period at a busy port are as follows. Week Leadings Graph Loudings (Y) vs Woeks (X) 112 y 220 Forecast 227.16 245 246.12 3 280 265.08 4 275 5 300 284,04 303.00 321,96 6 7 140.92 8 359.88 378.84 9 10 397,80 11 310 350 360 400 380) 420 450 460 475 500 S10 416,76 435.72 12 13 454,68 473,64 IS 492.60 511.56 16 17 525 $30.52 F-bt 18 541 549,48 SUM b=n SUM(TV)-SUMOSUMY)= SUM(+2) ASUMOV 2 a-SUMIY)- 5 SUM- a Determine the trend line equation and show the graph b. Determe the forecast for weeks 20 and 21 6. The manager intends to install new equipment when the volume exceeds 800 loadings per week. When will this happen

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 1 . 5 Freight Cars Freight car loadings over an 1 8 week period at a busy port are as follows: Week Loadings Graph Loadings ( Y ) vs Weeks ( X ) t y ty t ^ 2 Forecast 1 2 2 0 2 2 7 . 1 6 2 2...

Check my work Problem 3-7 Freight car loadings over an 18-week period at a busy port are as follows: Week 1 2 3 4 Number 400 415 430 415 430 435 Week 7 8 9 10 11 12 Number 465 495 525 510 540 570...

step by step please Freight car loadings over an 18 -week period at a busy port are as follows: Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings....

Please answer the following questions The following equation summarizes the trend portion of quarterly sales of condominiums over a Iong cycle. Sales also exhibit season variations. Ft=574.7t+3.7t2...

can someone answer the three parts please A,B and C Problem 3-7 (Algo) Freight car loadings over an 18-week period at a busy port are as follows: Week 1 2 3 4 Number 310 330 350 330 350 365 Week 7 8...

Please show all work Freight car loadings over an 18 -week period at a busy port are as follows: Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings....

Please show work and highlight answers. Thank you Freight car loadings over an 18-week period at a busy port are as follows: Week Week Week Number 360 375 Number 430 13 450 14 390 15 375 390 400 BEBO...

Problem 3-7 (Static) Freight car loadings over an 18 wook period at a busy port are as follows: 13 460 475 220 245 200 275 100 10 11 12 350 VO 400 10 020 450 15 10 12 12 510 525 Click here for the...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

In a fluorescence-lifetime experiment, a very short pulse of light is used to excite a sample of dansyl fluorophore. Then the intensity of the fluorescence is recorded as a function of time....

The top management of your company, a manufacturer and marketer of laptop computers, has decided to pursue international expansion opportunities in Eastern Europe. To achieve economies of scale,...

which of the following must be true for a company to accept a special order? a ) incremental revenues must be greater than greater costs b ) opportunity cost must be greater than total revenue

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...