All categories

3 years ago

Question 9 of 20

Business

1 answer:

Aleksandr [31]3 years ago

7 0

Answer:

C. The formula is =500-SUM(B2:B3).

<u>Multiple-choices</u>

A. The formula is EADD(B2:B3).

B. The formula is =SUM(B2:B3)-500

C. The formula is =500-SUM(B2:B3).

D. The formula is =500-ADD(B2 B3).

Explanation:

An excel formula must start with =

The formula needs to express the answer of subtracting the total of screws and nails from 500. If the required total is 500, Jerry needs to order 500 minus the total number screws and nails.

i.e., 500 -(no. of nails + screws)

Using excel commands

=500 - sum(B3,B5)

You might be interested in

Stuart wishes to have $14,000 to buy a used car three years from now. He plans to accomplish this, through an account with a nom

nataly862011 [7]

Answer:

The smallest Q that will suffice is 409.86

Explanation:

Since Future value of payments = 14000

300*[(1 + 3%/12)^12 - 1]/3%/12*(1 + 3%/12)^24 + Q*[(1 + 3%/12)^24 - 1]/3%/12 = 14000

Q*[(1 + 3%/12)^24 - 1]/3%/12 = 14000 - 300*[(1 + 3%/12)^12 - 1]/3%/12*(1 + 3%/12)^24

Q = 409.86

Therefore, The smallest Q that will suffice is 409.86

8 0

3 years ago

Online companies create a ________consumers gain information that turns them into sophisticated customers, opportunities to cust

Ganezh [65]

Answer:

a value exchange

Explanation: Hope this help:)

3 0

3 years ago

Simon Company’s year-end balance sheets follow.

Salsk061 [2.6K]

Answer and Explanation:

The computations are given below:

As we know that

(1) The Account receivable turnover ratio is

= Net sales ÷ average account receivable

For 2015, it is

= $673,500 ÷ ($89,500 + $62,500) ÷ 2

= 8.86 times

For 2014, it is

= $532,000 ÷ ($62,500+$50,200) ÷ 2

= 9.44 times

(2) The inventory turnover ratio is

= Cost of goods sold ÷ average inventory

For 2015

= $411,225 ÷ ($112,500 + $82,500) ÷ 2

= 4.22 times

For 2014

= $345,500 ÷ ($82,500 + $54,000) ÷

= 5.06 times

(3) The days sales in inventory is

= Ending inventory ÷ cost of goods sold × 365

For 2015, it is

= $112,500 ÷ $411,225 × 365

= 99.85 days

For 2014, it is

= $82,500 ÷ $345,500 × 365

= 87.16 days

6 0

3 years ago

Which of the following factors affect the breakeven point for both absorption costing and variable costing? 1. Fixed (manufact

sertanlavr [38]

Answer:

B) 1. and 2.

Explanation:

Both variable costing and absorption costing are affected by fixed costs (both manufacturing overhead and administrative overhead) and contribution margin per unit.

Cost absorption costs are also affected by production levels and the denominator level chosen to set the fixed manufacturing cost rate.

7 0

3 years ago

In one to three sentences, describe reliable financial information.

Karolina [17]

Reliability requires that the information should be accurate and true and fair, neutral and unbiased, verifiable and using the same method would come up with similar results or numbers. Reliable information includes information from experts in the field , information from recognized and reputable organizations and information that can be verified by other sources.It's important to use information that is both reliable and relevant when making financial decisions.

5 0

3 years ago

Read 2 more answers