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
Kipish [7]
2 years ago
11

Marla made a spreadsheet in Excel showing the projected costs for a concert she was putting on. What can Marla enter into cell A

11 to find out how much money is left in her budget and to make sure the cell is updated whenever she changes any of the other costs?
=A2-A4-A6-A8-A10
+A2-A4-A6-A8-A10
=A4-A6-A8-A10+A2
+A4-A6-A8-A10=A2

Business
1 answer:
aliina [53]2 years ago
4 0

Marla will use the formula to find the updated cost.

=A2-A4-A6-A8-A10

Because A2 is budget and A4, A6, A8 and A10 all are expenses. So she has to budget-all expenses.

So option A=A2-A4-A6-A8-A10 is true.

<h3>What is a spreadsheet?</h3>

A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns. Spreadsheets are one of the most popular tools available with personal computers.

A single spreadsheet can be used as a worksheet to compile data for a purpose, or multiple sheets can be combined to create an entire workbook.

Learn more about spreadsheet here,

brainly.com/question/10509036

#SPJ1

You might be interested in
Hardy Inc. has two operating departments (1 and 2) and is considering renting a new machine to help automate the printing proces
gayaneshka [121]

Answer:

$6,900

Explanation:

When you use the incremental cost allocation method, you must rank cost activities and how they will be allocated. In this case, department 2 is the primary user, and therefore, rental costs must be allocated first to them. Rental costs will be allocated at a $25/hour rate.

Since department 1 is the next user, 100 hours will be allocated using the same rate as department 2, but the next 200 hours will be allocated at the lower $22/hour rate. Total rental cost allocation to department 1 = (100 x $25) + (200 x $22) = $2,500 + $4,400 = $6,900

5 0
3 years ago
Peyton sells an office building and the associated land on May 1 of the current year. Under the terms of the sales contract, Pey
Westkost [7]

Answer:

$2,466,000

Explanation:

Given that,

Cash Received = $1,600,000

Mortgage assume by purchaser = $950,000

Broker's commission = $75,000

points paid by seller = $9,000

Peyton's amount realized:

= Cash Received + Mortgage assume by purchaser - broker's commission - points paid by seller

= $1,600,000 + $950,000 - $75,000 - $9,000

= $2,466,000

Therefore, the amount realized by Peyton is $2,466,000.

4 0
3 years ago
Suppose that a risk-free investment will make three future payments of $100 in one year, $100 in two years, and $100 in three ye
olya-2409 [2.1K]

Answer:

The answer is $ 257.70

Explanation:

PV= Σ  of  discounted payments

PV = 100(1.08^-1) + 100(1.08^-2) + 100(1.08^-2)= <u>$ 257.70</u>

7 0
3 years ago
Consider the owner of a local boutique. She is deciding if she should upgrade the storage and display containers. The total cost
miv72 [106K]

Answer:

a) $3077

b) The owner should make this investment because the marginal benefit is greater than the marginal cost

Explanation:

Given data :

Total cost = $2000

depreciation rate = 8% per year

expected increase in revenue (CF ) = $400

interest rate = 5%

a) Determine the present value of the stream of revenue due to the upgrades

= CF / ( 1 + r ) ^t      where ( 1 + r )^t = 13%

= 400 / 13%

= $3077

b) The owner should make this investment because the marginal benefit is greater than the marginal cost

8 0
3 years ago
Fill in the missing amounts.
aleksandrvk [35]

<u>Solution</u>

                                                         Yoste Company Noone Company

Sales revenue($100,000 + $5,000)             $90,000      $105,000

Sales returns and allowances                        ($6,000)         ($5,000)

Net sales                                                         $84,000   $100,000

Cost of goods sold($100,000 - $40,000)          ($58,000) ($60,000)

Gross profit($84,000 - $58,000)                         $26,000            $40,000

Operating expenses($40,000 - $17,000)         ($14,380)           ($23,000)

Net income($26,000 - $14,380)                          $11,620          $17,000

  • Net Income divide by Net Sales = Profit Margin Ratio
  • Gross Profit divide by Net Sales = Gross Profit Rate

<u>Yoste Company : </u>

Profit Margin Ratio = $11,620 divide by $84,000 = 13.83%

Gross Profit Rate = $26,000 divide by $84,000 = 30.95%

<u>Noone Company:</u>

Profit Margin Ratio = $17,000 divide by $100,000 = 17%

Gross Profit Rate = $40,000 divide by $100,000 = 40%

6 0
3 years ago
Other questions:
  • An algebra class has 20 students and 20 desks. for the sake of variety, students change the seating arrangement each day. how ma
    5·1 answer
  • Reese, a calendar-year taxpayer, uses the cash method of accounting for her sole proprietorship. In late December, she received
    8·1 answer
  • Katie wants to order a new shirt online. What should she do once she gets to the store's website?
    15·1 answer
  • LaRoe Lawns’ inventory increased during the year by $6.7 million. Its accounts payable increased by $6.6 million during the same
    12·1 answer
  • Mediflow, a medium-sized medical technology company, has been successful in its research and development, but needs improvement
    5·1 answer
  • You are in charge of a project that has a degree of operating leverage of 1.24. What will happen to the operating cash flows if
    6·1 answer
  • What is it called whenever there<br> is no shortage or surplus in the<br> market?
    8·2 answers
  • Think about an organizational change that recently affected you. This could be a change at work in which jobs or procedures were
    13·1 answer
  • If you get into a car accident, your _______________ may increase because you will be considered riskier for insurance companies
    13·2 answers
  • Which of the following is NOT a function of a distribution channel?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!