1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
cestrela7 [59]
2 years ago
10

Your lobster fishing business is straightforward, and you run your accounting in Excel. You maintain separate workbooks for each

year, and each workbook has a spreadsheet for every month. The monthly spreadsheets are identical except for their names, which are January, February, etc. You have found that you need to sum your diesel fuel expenditures, which are always recorded in cell D18, for the months of August through December. What three-dimensional formula would give you that result
Business
1 answer:
Oksana_A [137]2 years ago
7 0

Answer:

The three-dimensional formula that would give you the required result, that is suming the diesel fuel expenditures, which are always recorded in cell D18 for the months of August through December is:

=SUM(August:December!D18).

Explanation:

First, enter the excel starting formula "=SUM(". Type "August" or  left-click on the August sheet with the mouse. Type in colon and December or hold the Shift key and left-click on the December sheet. Then, select the cell C3 in the December sheet.  Before pressing "Enter," add a closing bracket.  The sum formula looks exactly like this: "=SUM(August:December!D18)." This formula can completely be typed manually. The formula sums up cell D18 across each of the sheets from August to December, returning a value.

You might be interested in
NewDigger Inc. makes backhoes for digging ditches and trenches. It has developed an environmental-friendly liquid that, when pou
Vinvika [58]

Answer: breakthrough                    

Explanation: In simple words, breakthrough project refers to a project which results or has a potential to result as a sudden and huge development for the organisation.

In the given case, the new chemical product by the organisation is a new invention and can ease the job of the field workers.

Hence it can prove as a breakthrough for new digger.

5 0
3 years ago
Magic Company adds materials at the beginning of the process in Department A. The following information on physical units for De
Dvinal [7]

Answer:

Equivalent units

a) Weighted average =  523,200 units

b)  FIFO =  480,000 units

Explanation:

<em>FIFO Method.</em>

<em>Fully worked units</em><em>: These represent units of inventory that were started in a current period and completed that same period. The fully worked units are calculated in order to separate the opening inventory from  the the newly introduced when accounting for completed units under the FIFO.</em>

For magic company , fully worked units is

= 480,000 - 72,000 = 408,000 units

Equivalent units using Weighted Average

<em>Here, there are no distinction between opening inventory and the newly introduced</em>.

                                                            <em>            Equivalent Units</em>

Completed unit                    (100%× 480,000) = 480,000

Closing inventory                (60% × 72,000) = <u>     43,200</u>

Total equivalent units                                       <u>523,200</u>

Equivalent Units using FIFO

Item                                                               <em>Equivalent Units</em>

Opening inventory              (40% × 72,000) =  28,800

Fully worked                        (100%× 408,00) = 408,000

Closing inventory                (60% × 72,000) = <u> 43,200</u>

Total equivalent units                                     <u>480,000 </u>

<u />

Equivalent units

a) Weighted average =  523,200 units

b)  FIFO =  480,000 units

8 0
3 years ago
What are the implications of sharing confidential material information?
Norma-Jean [14]
The implication of sharing confidential material information is about having to keep a certain thing private in a way that it should be remained secret and hidden unless it has been given consent by the person who holds the privacy to be told to another party. It is not release carelessly and should be handled with care as it should be kept by the person withholding the information.
5 0
2 years ago
Explain how the basic economic problems are solved under capitalism?​
Brums [2.3K]

Answer:

Under capitalistic economy, allocation of various resources takes place with the help of market mechanism. Price of various goods and services including the price of factors of production are determined with help of the forces of demand and supply. Free price mechanism helps producers to decide what to produce.

The goods which are more in demand and on which consumers can afford to spend more, are produced in larger quantity than those goods or services which have lower demand. The price of various factors of production including technology helps to decide production techniques or methods of production. Rational producer intends to use those factors or techniques which has relatively lower price in the market.

Factor earnings received by the employers of factors of production decides spending capacity of the people. This helps producers to identify the consumers for whom goods could be produced in larger or smaller quantities. Price mechanism works well only if competition exists and natural flow of demand and supply of goods is not disturbed artificially.

Explanation:

7 0
2 years ago
You want to start an organic garlic farm. The farm costs $230,000, to be paid in full immediately. Year 1 cash inflow will be $2
Nostrana [21]

Answer:

13.8%

Explanation:

IRR is the discount rate that equates the after tax cash flows from an investment to the amount invested.

IRR can be calculated using a financial calculator:

Cash flow in year 0 =  $-230,000

Cash flow in year 1 =  $25,000

Cash flow in year 2 =  $25,000 x 1.05 = $26,250

Cash flow in year 3 =  $26,250 × 1.05 = $27,562.50

Cash flow in year 4 = $27,562.50 × 1.05 = $28,940.63

Cash flow in year 5 = $28,940.63 × 1.05 = $30,387.66 + $260,000 = $290,387.66

Irr = 13.84%

To find the IRR using a financial calacutor:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.

I hope my answer helps you

5 0
2 years ago
Other questions:
  • A salesman receives a fixed salary of $500 per week. In addition he is paid 12% of all sales over $1000. Write the formula that
    5·1 answer
  • The nation's total wealth almost tripled between 1920 and 1930, while wage workers enjoyed record-breaking increases in average
    10·1 answer
  • When completing a worksheet, the
    11·1 answer
  • Researchers have found that before buying a new car, consumers tend to look at ads for all makes and models of cars. However, on
    11·1 answer
  • Inflation is best understood as the rate at which __________.
    12·1 answer
  • Firms typically repurchase office supplies (paper, ink cartridges, pens, etc.) through straight rebuys on their supplier's websi
    7·1 answer
  • Assume the market for ball bearings is purely competitive. Currently, each of the firms in this market is earning positive econo
    13·1 answer
  • Janet is shopping for bottles and formula for her four-month old baby. Last month, the price of her favorite brand of formula wa
    12·1 answer
  • An investment has the following characteristics: ATIRRP: After-tax IRR on total investment in the property: 9.0% BTIRRE: Before-
    6·1 answer
  • The value proposition for the AARP brand is seen in what kinds of benefits for the members? (Select 3)
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!