Response:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
Justification:
Below is the formula intended to be entered in cell C8:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
This formula computes the bonus based on the provided data, utilizing the IF function. The formula begins with an equal sign, followed by IF and the application of all relevant terms.
Answer:
$311,100
Explanation:
Solution
Let's remember the following details:
The assumption is that Chester Corp has reduced its workforce by = %
The estimated cost of exit interviews = 100
Normal separation expenses = $5000
Now,
The total number of employees = 305
The reduction in workforce = 20%
So,
The number of employees being laid off = 305 x 20% = 61 individuals
Thus,
The separation expense per employee = $5000
Cost for exit interviews = $100
Total expense per individual = $5,100
Now,
The overall separation cost = 61 individuals x total separation cost per employee
That is,
= 61 x 5100 = $311,100
The suitable staffing strategy for an international corporation aiming to cultivate a strong corporate culture and informal management network is geocentric. This approach prioritizes hiring top professionals for specific roles, irrespective of their nationality. It helps the organization reinforce and unify its values across varied cultures and information, which is crucial in a globally standardized strategy.
Answer:
The answer is $59.50.
Explanation:
The calculations based on the scenario are as follows:
Profit on futures price = After futures price - before futures price
$63.50 - $59
= $4.50
Thus, the effective price that the company pays can be calculated using this formula:
Effective price paid = Spot price in July - Gain on futures price
= $64 - $4.50
= $59.50
Answer:
$9.71
Explanation:
The calculations for the share price are outlined below:-
Current EPS = Net Income ÷ Total Common Shares
= $9,250,000 ÷ 5,500,000
= $1.68
Current P/E ratio = Current stock price ÷ Current EPS
= $12 ÷ $1.68
= 7.14
Projected EPS for next year = $9,250,000 × 1.25 ÷ 8,500,000
= $1.36
Forecasted stock price for next year = $1.36 x 7.14
= $9.71
