Answer:
Total loss = 3,592.1053
Explanation:
Given:
Income from rent (For 45 days) = $9,000
Personal use = 12 days
Mortgage = $8,000
Property taxes = $2,000
Utilities = $1,200
Maintenance = $750
Depreciation = $4,000
Computation:
Total Allocated expenses = 45 days / 57 days [$8,000 + $2,000 + $1,200 + $750 + $4,000]
Total Allocated expenses = 45 / 57 [15,950]
Total Allocated expenses = $12,592.1053
Total loss = Total Allocated expenses - Income from rent
Total loss = $12,592.1053 - $9,000
Total loss = 3,592.1053
<span>Answer: Sheet1:Sheet4
Explanation:
The symbol : is used in Excel to refer to the range. So Sheet1: Sheet4 denotes,
FROM sheet1 TO sheet4 of the workbook.</span>
Answer:
y = 7.678X + 357.614 ;
518.852 ; 526.53 ;
Week 78;
Explanation:
Given the data :
Week Number Week Number Week Number
1 370 7 415 13 450
2 380 8 425 14 455
3 390 9 435 15 475
4 380 10 425 16 485
5 390 11 435 17 495
6 395 12 445 18 505
The linear trend line for expected freight car loading obtained using a linear model calculator is :
y = 7.678X + 357.614
y = expected freight car loading
X = week
m = slope = 7.678 ;
c = intercept = 357.614
B.)
predicted loading for week 21:
X = 21
y = 7.678(21) + 357.614 = 518.852
Predicted loading for week 22:
y = 7.678(22) + 357.614 = 526.53
C.)
Week loading volume should exceed 950:
y = 950
950 = 7.678X + 357.614
950 - 357.614 = 7.678X
592.386 = 7.678X
X = 592.386 / 7.678
X = 77.153685
X = 78 (should exceed 950)
Currently, in the United States, the greatest volume of goods and services are shipped by rail.
The type of analysis that she should conduct is exploratory.
This is involved of experimenting or exploring in a way of finding out the
answer to the problem or the study that the researcher is trying to figure out
in which Marteena is involved of.