Answer:We use the Large Function. the general formula is =LARGE(first cell:last cell,3) .Please refer to the explanation section for details
Explanation:
Let us assume
A 1 = $1,250, A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600
Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;
=LARGE(A1:A2,3)
This implies that 2%/15 net 30 is a method of giving cash discounts on
purchases. What this means is that if the bill is paid within 15 days, there is
a 2% discount. Or else, the total amount is payable within 30 days. For instance,
if "$1000 2/15 net 30" is printed on a bill, the buyer can take a 2% discount ($1000
x .02 = $20) and make a payment of $980 within 15 days or pay the whole $1000 in
30 days.
Answer:
May; cannot do anything
Explanation:
In the short run, the aggregate supply curve will react to price level, which means it is upward sloping rather than vertical. If the price level increases, quantity supplied will increase. If the price level decreases, the quantity supplied will decrease.
Answer:
The company's turnover rounded to the nearest tenth: C) 9.5
Explanation:
Asset turnover helps investors understand how effectively companies are using their assets to generate sales. Asset turnover is calculated by using following formula:
Asset Turnover = Total Sales or Revenue/ Average Total Assets
where:
Average Total Assets = (Beginning Assets + Ending Assets )/2 = (Assets at the beginning of year +Assets at end of year )/2
In the House of Orange:
Average Total Assets = ($84,000 + $90,000)/2 = $87,000
Asset Turnover = $826,650/$87,000 = 9.5
Answer:
The Margin of safety is $100,000
Explanation:
Price = Sales / number of units = $1,700,000 / 8500 = $200
Contribution margin ratio is the ratio of contribution margin to the sales value. It measure the ratio that contributes in the recovery of fixed cost and making profit.
Contribution margin ratio = Contribution margin / Sale price = $60 / $200 = = 0.3 = 30%
Break-even is the level of sales at which business has no profit no loss situation.
Break-even point = Fixed cost / Contribution margin ratio = $480,000 / 30% = $1600,000
Margin of safety is the level of sales at which the business is safe from making loss. Margin of safety measures the profit after the break-even point.
Margin of Safety = Total sales - Break-even point = $1,700,000 - $1,600,000
= $100,000
