Calculations go from year 1 to year 6, screen isn't big enough to show all calculations.
present worth is $76273.60
1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs
I think policymakers would link social security payments to inflation to help the recipients with the increased cost of living due to inflation of prices also. I don't think small increases due to a low rate of inflation is a downside because the low rate of inflation means goods and services will not increase much in price so will still be relatively affordable.
Answer:
C :Job 1000, $1,860; Job 1001, $3,100
Explanation:
The computation of the total cost is shown below:
For Job 1000:
= Direct materials + Direct labor hours × wage rate per hour × Direct labor hours × overhead rate per hour
= $1,200 + 30 × $15 + 30 × $7
= $1,200 + $450 + $210
= $1,860
For Job 1001:
= Direct materials + Direct labor hours × wage rate per hour × Direct labor hours × overhead rate per hour
= $2,000 + 50 × $15 + 50 × $7
= $2,000 + $750 + $350
= $3,100
