Answer:
For such a report , the sql query required would be:
SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;
Explanation:
For such a report , the sql query required would be:
SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;
In the above sql query employee id is emp_id , curr_salary is the current salary column. "curr_salary*1.03" is been made because an increment of 3% means salary + salary*3% , that is , salary*1.03.
Answer:
The inventory TO is 3.6875
Explanation:

where:

Considering there is not sufficient information to calculate the begining inventory <u>we are going to work only with the ending inventory </u>so:

The inventory TO is 3.6875 This means the company sales their inventory almost 4 times per year.
Answer: I must invest <u>$85424.14</u> today in order to buy a Ferrari nine years from now on the day I turn 30.
We have
Price of the Ferrari nine years from now (Future Value - FV) $215000
Expected Rate of return on the mutual fund (r) 10.8%
Time until I turn 30 (n) 9 years
We can calculate the Present Value (PV) or the money to be invested today as



To find the value of the inventory to the nearest cent:
Estimated costs are: $18,750
Storage costs: 12%
Interest costs: 12%
Transportation costs: 5%
Let's add the costs up: 12% + 12% + 5% = 29%
We are solving for the value of inventory so in this case we will make that X.
X = estimated costs/interest amounts
X = $18,750/29%
X = $18,750/0.29
X = $64,655.17
The value of the inventory is $64,655.17
To check your work you can take $64,655.17 and multiply it by 29%
= $18,750