All categories

3 years ago

How do u calculate the bill total for the week by summing the daily bill amounts

Business

1 answer:

tino4ka555 [31]3 years ago

3 0

Answer:

Calculating the bill total for the week:

The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.

Explanation:

In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.

You might be interested in

Currency held outside banks is $200 billion, money market mutual funds (retail) are $10 billion, small-denomination time deposit

ratelena [41]

Answer:

M2 = $470 billion.

Explanation:

M2 = Currency + Money market mutual fund + Time deposits + Saving deposits

M2 = 200 billion + 10 billion + 40 billion + 220 billion

M2 = $470 billion.

M2 is a calculation of the money supply that includes all elements of M1 as well as "near money"

3 0

3 years ago

What is the name of the experimental task in which an infant interacts with an adult who first engages in normal social interact

Komok [63]

The still-face interaction paradigm

An experimental task was introduced in 1978 to prove that infants actively contribute to social interaction. It is called the Still-Face Paradigm or SFP.

In the experiment, 3 phases of face-to-face interaction of infants with an adult were tested: the normal interaction, the still-face (where the adult becomes unresponsive and maintains a neutral facial expression), and a reunion where the adult resumes normal interaction.

Indeed, the still-face paradigm showed effects like increased gaze aversion and less smiling.

4 0

3 years ago

Astro Co. sold 20,000 units of its only product and incurred a $50,000 loss (ignoring taxes) for the current year as shown here.

Alexandra [31]

Answer:

Required 1.

Break even point (dollar sales) = $750,000

Required 2.

Break even point (dollar sales) = $1,250,000

Required 3.

ASTRO COMPANY

Forecasted Contribution Margin Income Statement

For Year Ended December 31, 2016

Sales $ 1,000,000

Variable costs ($ 400,000 )

Contribution margin $ 600,000

Fixed costs ($ 450,000 )

Net loss $ 150,000

Required 4.

Sales to meet target profit (dollar sales) = $1,833,333

Sales to meet target profit (unit sales) = 73,334

Explanation:

Break even point is the level of activity where a Company neither makes a profit nor a loss.

Break even point (dollar sales) = Fixed Cost / Contribution Margin Ratio

Where,

Contribution Margin Ratio = Contribution / Sales

= $ 200,000 / $ 1,000,000

= 0.20

Therefore,

Break even point (dollar sales) = $250,000 / 0.20

= $1,250,000

Assuming the machine is installed

Contribution Margin Ratio = ($ 1,000,000 - $400,000) / $ 1,000,000

= $600,000 / $1,000,000

= 0.60

Therefore,

Break even point (dollar sales) = ($250,000 + $200,000) / 0.60

= $750,000

Sales to meet target profit of $200,000

Sales to meet target profit (dollar sales) = Fixed Cost + Target Profit / Contribution Margin Ratio

= ($450,000 + $200,000) / 0.60

= $1,833,333

Sales to meet target profit (unit sales) = $1,833,333 / $25

= 73,334

4 0

3 years ago

Which of the following statement shows the financial position of a business entity as on date

svlad2 [7]

Answer:

b) balance sheet

Explanation:

Balance sheet: The assets liabilities and stockholder equity are reported in the balance sheet. The accounting equation that is displayed below is used in this:

Total assets = Total liabilities + stockholder equity

The balance sheet debit and credit side should always be equal and balanced.

In addition, it is always prepared on the date specified plus it is also reflects the financial position, financial performance of the company.

8 0

3 years ago

Weighted Average Method, Unit Cost, Valuing Inventories Applegate Enterprises produces premier raspberry jam. Output is measured

iris [78.8K]

Answer:

1. 780,000 pints

2. $1

3. $780,000

Explanation:

1. The computation of the equivalent units of production is shown below:

= Units completed and transferred out + completed units in ending inventory × completion percentage

= 700,000 pints + 200,000 pints × 40%

= 780,000 pints

2. The computation of the unit cost for January month is shown below:

= (Beginning Work in process + Costs added during January) ÷ equivalent units

= ($156,000 + $624,000) ÷ (780,000 pints)

= $1

3. The computation of the assigned units is shown below:

= Units completed and transferred out × unit cost + completed units in ending inventory × completion percentage × unit cost

= 700,000 pints × $1 + 200,000 pints × 40% ×$1

= $780,000

3 0

3 years ago