1 answer

Freight car loadings over an 18-week period at a busy port are as follows: Week Number...

Question:

Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 13 230 250 2

a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predic

b. Use trend-adjusted smoothing with a 2 and B 1 to smooth the new account data in part a. What is the forecast for period 16

Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 13 230 250 270 7 320 510 2 8 370 14 520 3 420 15 560 16 4 250 400 580 270 11 450 17 600 12 18 6 280 500 620 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) 10.42 305.2 b. Use the above tre nd equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) The forecasted demand for Week 20 Is 674.42 699.5 and for Week 21 is c. The manager intends to install new equipment when the volume exceeds 810 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.) It should reach 810 loadings in Week 25.40 un up
a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) Period New Accounts Period New Accounts Period New Accounts 200 239 11 281 275 2 213 7 246 12 3 211 250 13 287 260 267 224 14 288 5 235 10 15 315 Y 6.95 196.2 t Y16 307.32 Y17 = Y18 Y19 314.27 321.21 328.16 NmstL
b. Use trend-adjusted smoothing with a 2 and B 1 to smooth the new account data in part a. What is the forecast for period 16? Compute the initial trend estimate (T) for Period 5 as follows: (Period 4 data Period 1 data) /3. Then compute the initial trend- adjusted forecast (TAF) for Period 5 as follows: Period 4 data Initial trend estimate for Period 5. Then compute all remaining values (including the St value for Period 5) using the textbook formulas or Excel template. (Round the "Trend"values (Tt) to 3 decimal places and all other intermediate forecast values (TAFt and St) to 2 decimal places. Round your final answer to 2 decimal places.) Forecast for period 313.16 16

Answers

(a) The euation from the excel is

Y = 25.077x+172.88

2 M AB AC AD AE AF AG AH AI AJ AK AL AM Week Number 1 Number 2 250 y 25.077 17288... SEEDS 98 Q ENG UK 22/09 op

Y20 = 674.42

Y21 = 699.49

When Yt = 810, t will be

810-172.88 / 25.077 = 25.4

2

(a)

The euation is Y =7.3107x+194.25 from excel

Number y=7.3107x + 194.25... 2 4 6 8 10 12 14 16

Y16 = 311.22

Y17 =318.53

Y18 =325.84

Y19 = 333.15

.

Similar Solved Questions

1 answer
Help needed in andwering this full question Question Three a. For each chiral centre in the...
help needed in andwering this full question Question Three a. For each chiral centre in the following molecules, assign an Ror S configuration. For full marks, you must clearly indicate the order of priority of the groups attached to each chiral centre, OH OH CH3 CH(OCH3)2 CHO b. Draw all stereoi...
1 answer
Murgatroyd Co. purchased equipment on January 1, 2016, for $520,000, estimating a four-year useful life and...
Murgatroyd Co. purchased equipment on January 1, 2016, for $520,000, estimating a four-year useful life and no residual value. In 2016 and 2017, Murgatroyd depreciated the asset using the sum-of-years'-digits method. In 2018, Murgatroyd changed to straight-line depreciation for this equipment. W...
1 answer
Jellico Inc.'s projected operating income (based on sales of 450,000 units) for the coming year is...
Jellico Inc.'s projected operating income (based on sales of 450,000 units) for the coming year is as follows: Total Sales $ 12,150,000 Total variable cost 7,654,500 Contribution margin $ 4,495,500 Total fixed cost 2,719,278 Operating income $ 1,776,222 Required: 1(a). Compute variable cost per ...
1 answer
Prelab Assignment Prior to the laboratory, complete the following Pre-lab Question(s): 1. Cis and Trans isomers...
Prelab Assignment Prior to the laboratory, complete the following Pre-lab Question(s): 1. Cis and Trans isomers of 1,2-dichlorocyclohexane, 1,3-dichlorocyclohexane and 1,4- dichlorocyclohexane - Draw the perspective, Chair and mirror image (if applicable) of each isomer. Perspective (Wedge dash) Cha...
1 answer
Problem 3 (30 points). The beam shown below has an internal hinge at point C: (a)...
Problem 3 (30 points). The beam shown below has an internal hinge at point C: (a) [10 points] Draw the influence line for the reaction at B, RB. (b) [10 points] Draw the influence line for the moment at E, Mg. (C) [10 points] Determine the maximum bending moment generated by the moving truck load sh...
1 answer
Identify the transfer function 10/; of the RL circuit shown below. Express the transfer function using...
Identify the transfer function 10/; of the RL circuit shown below. Express the transfer function using Wo= RIL. i(t) R ele L O H (@) II = WO j + 1 O H(@) = 1+ Wo O H (0) jo 1+ W0 1 O H(0) = 00 1+....
1 answer
Q4. If the flywheel is rotating with an angular velocity of 04 = 5 rad/sec, determine...
Q4. If the flywheel is rotating with an angular velocity of 04 = 5 rad/sec, determine the angular velocity of rod BC at the instant shown. Use the relations of Relative Motion Analysis: Velocity. (Note: Use and show the units throughout the solution. Work in SI units. Show all the steps in detail) W...
1 answer
Please i need a good answer and a perfect answer.. i need unique answer use your...
please i need a good answer and a perfect answer.. i need unique answer use your own words. don't use handwriting 1-What is the difference between sunblock and sunscreen cream? (i need 3 to 5 sentences) 2-What is SPF? (i need 3 to 5 sentences) 3-Which is better SPF30+ or 50+?    (...
1 answer
Don’t use my handwriting in the calculations is the 12v a supernode? Find V, in the...
Don’t use my handwriting in the calculations is the 12v a supernode? Find V, in the circuit using nodal analysis. 12 V 0 2...
1 answer
Q1: Here we consider finding the length of the shortest path between all pairs of nodes...
Q1: Here we consider finding the length of the shortest path between all pairs of nodes in an undirected, weighted graph G. For simplicity, assume that the n nodes are labeled 1; 2; : : : ; n, that the weight wij of any edge e = (i; j) is positive and that there is an edge between every pair of node...
1 answer
Find the p-value for the hypothesis test. A random sample of size 5s is taken. Type...
Find the p-value for the hypothesis test. A random sample of size 5s is taken. Type num He is taken Type numbers in the boxes. The sample has a mean of 38o and a standard deviation of 82. 10 points Ho: u = 400 H.: u< 400 The p-value for the hypothesis test is Your answer should be rounded to 4 de...
1 answer
A large semitrailer truck and a small car have equal momentum. How do their speeds compare?  The...
A large semitrailer truck and a small car have equal momentum. How do their speeds compare?  The truck has a much higher speed than the car.  The truck has a much lower speed than the car.  The truck has only a slightly lower speed than the car.  The truck has...
1 answer
PATIENT: Herbert Humphrey SURGEON: Marvin Elhart, M.D. RADIOLOGY: Morton Monson, M.D. INDICATIONS: Aortic valve evaluation; considering...
PATIENT: Herbert Humphrey SURGEON: Marvin Elhart, M.D. RADIOLOGY: Morton Monson, M.D. INDICATIONS: Aortic valve evaluation; considering that the stenosis was not well-documented angiographically PROCEDURE PERFORMED: Transesophageal echocardiogram DESCRIPTION OF PROCEDURE: The patient received 2 mg o...
1 answer
Part II. Short answer Question 1: Consider the following GDP equation, consumption function, exports, imports and...
Part II. Short answer Question 1: Consider the following GDP equation, consumption function, exports, imports and investment function and use them to answer the following questions Y = C +1+G + EX, - IM, * = ä– Õ(Re – ); > 0 A =ão G=ā,Y, EX=0 IM = 0 (a) Derive ...
1 answer
Problem 4: In a sample of 1000 Yuba College students, it was found that they consumed...
Problem 4: In a sample of 1000 Yuba College students, it was found that they consumed on average 23 grams of sugar with a standard deviation of 4 grams and that 230 planned to transfer to Chico State. a) (7 points) Can we conclude with 99% confidence that Yuba College students consume on average ove...
1 answer
How do you simplify #sqrt(972)#?
How do you simplify #sqrt(972)#?...
1 answer
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured b...
1 answer
The _________ represents the expected change in Y per unit change in X. A. slope of...
The _________ represents the expected change in Y per unit change in X. A. slope of the line B. Y intercept C. X intercept D. Independent variable...