All categories

2 years ago

1. Read the following data regarding payroll deductions, and answer the questions that follow:

Business

1 answer:

garri49 [273]2 years ago

4 0

The hours generated are:

Lydia - 20
Thomas - 40
Bruce - 30

The Net Amount Payable are:

Lydia - $176.70

Thomas - $465.00
Bruce - $237.15

<h3>What is a Nested IF THEN ELSE Statement</h3>

This is a function/formula within Microsoft Excel Spreadsheet that allows one to carry out conditional calculations such as the one explained in the question. Please see the attached spreadsheet.

Learn more about formulas in spreadsheets in the link below:

brainly.com/question/25879801

Download xlsx

You might be interested in

A produce distributor uses 774 packing crates a month, which it purchases at a cost of $12 each. The manager has assigned an ann

ki77a [65]

Answer:

$444.42

Explanation:

For computing the saving amount, first need to calculate the economic order quantity, total cost etc

The economic order quantity is

$= \sqrt{\frac{2\times \text{Annual demand}\times \text{Ordering cost}}{\text{Carrying cost}}}$

where,

Annual demand is

= 774 packaging crates × 12 months

= 9,932 crates

And, the carrying cost is

= $12 × 34%

= $4.08

$= \sqrt{\frac{2\times \text{9,288}\times \text{\$29}}{\text{\$4.08}}}$

= 363.37 crates

Now the total cost is

= Annual ordering cost + Annual carrying cost

= Annual demand ÷ Economic order quantity × ordering cost per order + Economic order quantity ÷ 2 × carrying cost per unit

= 9,288 ÷ 363 × $29 + 363 ÷ 2 × $4.08

= $742.02 + $740.52

= $1,482.54

Now the total cost in case of 774 packing crates is

= Annual ordering cost + Annual carrying cost

= Annual demand ÷ Economic order quantity × ordering cost per order + Economic order quantity ÷ 2 × carrying cost per unit

= 9,288 ÷ 774 × $29 + 774 ÷ 2 × $4.08

= $348 + $1,578.96

= $1,926.96

So, the annual saving cost is

= $1,926.96 - $1,482.54

= $444.42

6 0

3 years ago

The exercise price of the options is $100 per share, all options are European and the stock does not pay any dividend. The call

Ber [7]

Answer:

Stock Price is $98.70

Explanation:

given data

exercise price = $100 per share

call price = $25 per share

put price = $17 per share

mature time = 2 years

annual rate of interest = 5%

to find out

What is the stock price today

solution

we will use here Put Call Parity for find out Stock Price that is express as

C + $\frac{100}{(1+r)^t}$ = S + P .....................1

here C is call price and r is rate and t is time and S is Stock Price and P is put price so put all value in equation 1

C + $\frac{100}{(1+r)^t}$ = S + P

25 + $\frac{100}{(1+0.5)^2}$ = S + 17

solve it we get

P = $98.70

so Stock Price is $98.70

6 0

3 years ago

Here are the comparative income statements of Ayayai Corp..

Georgia [21]

Answer:

Ayayai Corp.

Horizontal Analysis:

2020 Increase 2019

Net sales $632,600 $110,700 21.2% $521,900

Cost of goods sold 463,600 53,200 13.0% 410,400

Gross Profit 169,000 57,500 51.6% 111,500

Operating expenses 79,300 32,100 68.0% 47,200

Net income $ 89,700 25,400 39.5% $64,300

Explanation:

a) Data and Calculations:

AYAYAI CORP.

Comparative Income Statement For the Years Ended December 31

2020 2019

Net sales $632,600 $521,900

Cost of goods sold 463,600 410,400

Gross Profit 169,000 111,500

Operating expenses 79,300 47,200

Net income $ 89,700 $64,300

Percentage increase or decrease = (Increase/Decrease)/Base Year's Value

3 0

3 years ago

Your manager has asked for your help to make a decision on an important issue within 24 hours. the outcome of this decision will

exis [7]

The best thing that you should do in this scenario would be :

- Gather as much as information as you can regarding the issue (maybe by asking input from your associates)

- analyze the issue completely thoroughly

- Believe in yourself and create the best decision based on your analytic

hope this helps

8 0

3 years ago

Jerry, a partner with 30% capital and profit interest, received his Schedule K-1 from Plush Pillows, LP. At the beginning of the

Kisachek [45]

Answer:

The Jerry's adjusted basis in his partnership interest at the end of the year is $45,500

Explanation:

The adjusted basis of Jerry in his partnership is shown below:

= Partnership interest - Ordinary loss + long term capital gain + dividend - non deductible expense + cash contribution - share reduction

= $50,000 -$15,000 + $3,000 + $2,000 - $500 + $10,000 -$4,000

= $45,500

The ordinary loss, share reduction, and non deductible expense would decrease the Jerry interest in partnership firm while all other cost would increase his interest. That's why the amount is added and subtracted.

Hence, the Jerry's adjusted basis in his partnership interest at the end of the year is $45,500

5 0

4 years ago