All categories

3 years ago

You manage the worksheet shown below and it contains information for the company's 1500 employees,

2 answers:

5 0

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.

kvv77 [185]3 years ago

3 0

Answer:

Explanation:

You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year.

You might be interested in

Palmer Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an ann

Bas_tet [7]

Answer:

25%

Explanation:

Accounting rate of return =( Net income from investment ÷ Cost of investment ) × 100

Net income from investment = $100,000

Cost of investment = $400,000

Required rate of return = ($100,000 / $400,000 ) × 100

= 0.25 × 100

= 25%

7 0

3 years ago

In a bad news message the reasons for the decision

zmey [24]

Answer:

should be long and roundabout to cushion the negative aspects

if you are delivering bad news if it is directly affecting them they would most likely like to know why and if they can help this issue

Explanation:

mrk me brainliest please.

3 0

3 years ago

UA Hamburger Hamlet (UAHH) places a daily order for its high-volume items (hamburger patties, buns, milk, and so on). UAHH count

Assoli18 [71]

Answer:

730 items

Explanation:

The objective of the given information is to determine the number of hamburgers UAHH should order for the following conditions:

Average daily demand 600

Standard deviation of demand 100

Desired service probability 99%

Hamburger inventory 800

The formula for a given order quantity in a fixed period of time can be expressed as :

$q = \overline d(L+T)+ z \sigma_{L+T}-I$

where;

$q$ = order quantity = ???

$\overline d$ = daily demand average = 600

L = lead time in days = 1

T = time taken = 1

z = no of standard deviation = ???

$\sigma_{L+T}$ = standard deviation of usage in lead time and time taken = ???

I = present inventory level = 800

$\sigma_{L+T}$ = $\sqrt 2$ × standard deviation of daily demand

$\sigma_{L+T}$ = $\sqrt{2} *100$

$\sigma_{L+T}$ = 1.4142 * 100

$\sigma_{L+T}$ = 141.42 items

From the Desired service probability 99% = 0.99; we can deduce the no of standard deviation by using the excel function (=NORMSINV (0.99))

z = 2.33

From $q = \overline d(L+T)+ z \sigma_{L+T}-I$

$q =600(1+1)+ 2.33*(141.42)-800$

$q =600(2)+ 2.33*(141.42)-800$

$q =1200+329.5086-800$

q = 729.5086 items

q ≅ 730 items

Therefore; the number of hamburgers UAHH should order from the following given conditions = 730 items

6 0

3 years ago

Consider the single factor APT. Portfolio A has a beta of 1.3 and an expected return of 21%. Portfolio B has a beta of .7 and an

svetoff [14.1K]

Answer:

Portfolio A and Portfolio B

Explanation:

In this question, we apply the Capital Asset Pricing Model (CAPM) formula which is shown below

Expected rate of return = Risk-free rate of return + Beta × (Market rate of return - Risk-free rate of return)

The Market rate of return - Risk-free rate of return) = Market risk premium

Let us assume the market risk premium be X

For Portfolio A:

21% = 8% + 1.3 × X

13% = 1.3 × X

So, the X = 10%

For Portfolio B:

17% = 8% + 0.7 × X

9% = 0.7 × X

So, the X = 12.86%

Based on the market risk premium calculations, we can conclude that Portfolio A should be in short position while Portfolio B should be in long position as portfolio B has higher market risk premium than B

3 0

3 years ago

What is the expected value when a $1 lottery ticket is bought in which the purchaser wins exactly $10 million if the ticket cont

Nadusha1986 [10]

We expect to lose $0.37 per lottery ticket

<u>Explanation:</u>

six winning numbers from = { 1, 2, 3, ....., 50}

So, the probability of winning:

$P(win) = \frac{ no of favorable outcomes}{no of possible outcomes}$

$P(win) = \frac{1}{^5^0C_6} \\\\P (win) = \frac{6! X (50 - 6)!}{50!} \\\\P(win) = \frac{6! X 44!}{50!} \\\\P(win) = \frac{1}{15,890,700}$

The probability of losing would be:

P(loss) = 1 - P(win)

$P(loss) = 1 - \frac{1}{15,890,700} \\\\P(loss) = \frac{15,890,699}{15,890,700}$

According to the question,

When we win, then we gain $10 million and lose the cost of the lottery ticket.

So,

$10,000,000 - 1 = $9,999,999

When we lose, then we lose the cost of the lottery ticket = $1

The expected value is the sum of the product of each possibility x with its probability P(x):

E(x) = ∑ xP(x)

$= 9,999,999 X \frac{1}{15,890,700} + ( -1 ) X \frac{15,890,699}{15,890,700} \\\\=- \frac{5,890,700}{15,890,700} \\\\= - \frac{58,907}{158,907} \\\\= - 0.37$

Thus, we expect to lose $0.37 per lottery ticket

7 0

3 years ago