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
iVinArrow [24]
3 years ago
13

In cell g5, construct a formula to calculate the percent of total by dividing the annual total for salaries and benefits by the

annual total for totals by quarter. use absolute cell references as necessary, format the result in percent style, and then center. fill the formula down through cell g9
Business
1 answer:
bearhunter [10]3 years ago
7 0

Answer & Explanation:

Formula for Annual total for salaries and benefit is given by

=sum(B5:E5) this can be duplicated vertically by copying it down

Formula for totals by Quarter 1 is given by

= sum(B5:B9) this also can be duplicated horizontally in adjacent cells by copying it to the right

Formula for percent totals is done as follows

=F5/$F$10

input the above,copy it down vertically then go to home tab and under number and click the percent tab

done

attached below is a copy of the finished work excel

Download xlsx
You might be interested in
Angus Company agreed to sell goods for Longhorn Company on consignment, but wasn't willing to take ownership of the goods in cas
vladimir2022 [97]

Answer: D. Longhorn owns the inventory and should report it on its balance sheet.

Explanation:

Goods to be sold on consignment for a company means a company is selling goods for another company and will be paid for their services.

In that case, the company being sold for will retain the ownership of the goods because the company that is selling it for them is simply providing a service.

Angus in this scenario are simply holding the goods to sell it and so do not own the goods. Longhorn should therefore record it in their own books as inventory.

3 0
3 years ago
You want to save $98,000 to buy an boat by making an equal, end of year payment into a brokerage account for the next 9 years. I
malfutka [58]

Answer:

Annual deposit= $7,930.11

Explanation:

Giving the following information:

FV= $98,000

n= 9 years

i= 0.0775

<u>To calculate the annual deposit, we need to use the following formula:</u>

<u></u>

FV= {A*[(1+i)^n-1]}/i

A= annual deposit

Isolating A:

A= (FV*i)/{[(1+i)^n]-1}

A= (98,000*0.0775) / [(1.0775^9) - 1]

A= $7,930.11

6 0
3 years ago
Read 2 more answers
A company makes $200,000 in a year and has $150,000 in production costs, leaving them with $50,000. The $200,000 represents
NeX [460]

Answer:

The $200,000 represents the revenue and the $50,000 represents the profit.

Explanation:

4 0
2 years ago
Joseph Marcantuone and Robert Gieson owned a shopping center in which one of the spaces was always leased as a dry cleaner. Even
Lina20 [59]

Answer:

Right now marcantuone and robert gieson ought not be held at risk for what the drycleaner inhabitants did.Because there was no release of perilous substance during their ownership.The chlorinated dissolvable pollution issue right now the aftereffect of dry cleaning activity led preceding the condemnee's acquisition of the property.There was no proof of a release of unsafe substance during the time of condemnee's ownership.The sullying was not found until after the condemner had procured the title to the property in the judgement activity.  

As indicated by the spill demonstration the obligation is vested on a condemner who bought debased property and didn't attempt any assessment or examination at the hour of procurement.

4 0
3 years ago
Money owed for products and services purchased on credit to be paid at a later date is known as _____.
shepuryov [24]

Accounts Payable

Hope it helps!

6 0
1 year ago
Other questions:
  • Galaxy Products is comparing two different capital structures, an all-equity plan (Plan I) and a levered plan (Plan II). Under P
    10·1 answer
  • In calculating cash flows from operating activities using the indirect method, a loss on the sale of equipment will appear as a(
    12·1 answer
  • "In the context of international trade, _____ is defined as selling goods in a foreign market at a price below their costs of pr
    12·1 answer
  • When the economy grows, the market grows, most likely because
    5·2 answers
  • The payroll register of Konrath Co. indicates $13,200 of social security withheld and $3,300 of Medicare tax withheld on total s
    12·1 answer
  • Three reasons why people might accidentally overdraw are:
    7·1 answer
  • Omar is a school superintendent who is trying to improve the selection process for teachers in his school district. Before imple
    13·1 answer
  • Velvo Inc., an automobile manufacturing company, designs its products in such a way that they can be easily dismantled after use
    12·1 answer
  • Daves Inc. recently hired you as a consultant to estimate the company's WACC. You have obtained the following information: the f
    10·1 answer
  • A company has average demand of 30 units per day. Lead time from the supplier averages seven days. Assume that the combined stan
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!