The best way for you to create the list of those who make more than $45000 a year and are full time is by using the filter option.
The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 45000.
The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.
The sorting method helps to arrange data based on ascending order or descending order.
Read more on brainly.com/question/15358155?referrer=searchResults
Answer:
$788.35
Explanation:
For computing the fair present value we need to apply the present value formula which is to be shown in the attachment below:
Given that,
Future value = $1,000
Rate of interest = 14% ÷ 4 = 3.5%
NPER = 4 years × 4 = 16 years
PMT = $1,000 × 7% ÷ 4 = $17.5
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after applying the formula, the fair present value is $788.35
Answer:
$225,000
Explanation:
Federal corporate income tax (21% flat rate)
$1,000,000 x 21% = $210,000
Federal dividend tax (15%).
$100,000 x 15% = $15,000
Dividens are neither expenses nor deductible, so they do not reduce the amount of corporate taxable income. Therefore we must add up the two quantities.
$210,000 + $15,000 = $225,000
Answer:
75%
Explanation:
Since the production center is available for 8 hours per day in a factory, and the worker operating it is required to lubricate these rotary parts once each day.
If it takes 2 hours to remove these parts from the equipment, lubricate them, and re-assemble them and the production center is not available for production during these times;
Then the availability of the production center is 75% which is derived by : [8 hours total - 2 hours downtime / 8 hours total availability] x 100 = 75%
Answer: A service concession arrangement (D)
Explanation:
A service concession arrangement is an agreement whereby the government contracts with a private enterprise in order to operate, develop and maintain an infrastructural facility such as a tunnel, bridge, road, hospital, airport or prison. The government regulates and controls the kind of services the operator must provide, to whom the services are provided and at the price the services will be provided.
Concession agreements can also be between a non-governmental owner and a concessionaire, whereby the non-governmental owner gives the operator the exclusive rights to use and maintain the business for a stipulated period of time under specified conditions.
