How are logical operators used?

What are some Excel functions that a financial planner might use or need?

alexandr1967 [171]

1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs

7 0

3 years ago

Hache Corporation uses the weighted-average method in its process costing system. Data concerning the first processing departmen

Greeley [361]

Answer:

The cost of ending work in process inventory in the first processing department according to the company's cost system is closest to: d) $21,797

Explanation:

Calculation of Equivalent Units of Production

<u>Materials </u>

Units transferred to the next department (5,800 × 100%) = 5,800

Units in ending Work In process (1,850 × 50%) = 925

Total Equivalent Units of Production for Materials = 6,725

<u>Conversion</u>

Units transferred to the next department (5,800 × 100%) = 5,800

Units in ending Work In process (1,850 × 20%) = 370

Total Equivalent Units of Production for Conversion Costs = 6,170

Calculation of Cost per Equivalent units of Production

Materials

Cost per equivalent unit = Total Material Cost ÷ Total Equivalent Units of Production for Materials

= ($ 8,700 + $ 91,000) ÷ 6,725

= $14.825

Cost per equivalent unit = Total Material Cost ÷ Total Equivalent Units of Production for Materials

= ($ 8,500 + $ 126,300) ÷ 6,170

= $21.848

Calculation of cost of ending work in process inventory

Materials ( 925 × $14.825) = $13,713.12

Conversion Cost ( 370 × $21.848) = $8,083.76

Total = $21,796.88

Thus,

The cost of ending work in process inventory in the first processing department according to the company's cost system is closest to: d) $21,797.

5 0

3 years ago

A(n) is a long-term contract under which a borrower agrees to make payments of interest and principal on specific dates. There a

LenaWriter [7]

Answer:

Bond,treasury

Explanation:

A bond refers to the contract between borrower and lender stipulating that the borrower must pay periodic interests and principal on specified dates .

The interest is also known as coupon payment has fixed rate usually quoted in the bond agreement which could be paid annually or semi-annually to te lenders.

Treasury refers to the bond issued by the national government such as the U.S government and carries a lower rate of return as the risk attached too is low ,hence lower risk brings about lower return since the government is not likely to default in discharging its obligations

8 0

3 years ago

Ortions of the financial statements for Myriad Products are provided below.

bonufazy [111]

Answer:

Net cash provided from Operating Activities $301

Explanation:

MYRIAD PRODUCTS COMPANY

Cash flow from Operating Activities:

Net Income $150

Adjustment for non cash effects:

Depreciation $84

Amortization $5

Loss on sale of land $4

Total $243

Changes in operating assets and liabilities :

Decrease in Accounts receivable $17

Decrease in Inventory $18

Increase in Accounts Payable $14

Decrease in Salaries Payable ($14)

Increase in Interest Payable $13

Increase in Income tax Payable $10

Net cash provided from Operating Activities $301

5 0

3 years ago

Suppose the revenue from producing (and selling) x units of a product is given by Upper R (x )equals 10 x minus . 04 x squared

Volgvan

Answer:

marginal revenue is -6

and production levels 200, 50

Explanation:

given data

R(x) = 10 x - 0.04 x²

solution

we have given

R(x) = 10 x - 0.04 x²

so here R'(x) is

R'(x) = 10(1) - 0.4 (2x)

R'(x) = 10 - 0.8 x ....................1

so here at x is 20 marginal revenue will be

R'(20) = 10 - 0.8(20)

R'(20) = 10 - 16

R'(20) = - 6

and

when revenue is $400

R(x) = 400

400 = 10 x - 0.04 x²

x= 200, 50

7 0

3 years ago