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
Sadler Corporation purchased equipment to be used in manufacturing. The purchase was made at the beginning of 2015 by paying cas
il63 [147K]

Answer:

The journals entry to record depreciation on the equipment for 2016 will be:

Debit Depreciation expense $14,000

Credit Accumulated depreciation $14,000

<em>(To record depreciation expense for Year 2016)</em>

Explanation:

Under straight-line method, depreciation expense is (cost - residual value) / Estimated useful life = ($150,000 - $10,000) / 10 years = $14,000 yearly depreciation expense. This applies to Years 2015 and 2016.

The change in the estimate in Year 2017 will not affect the depreciation expense for 2016 based on the previous parameters,

6 0
3 years ago
The differences between the two are that ________ involve(s) both manufacturing and procurement with multiple manufacturers, sup
maks197457 [2]

The differences between the two are that <u>supply chain </u>involve(s) both manufacturing and procurement with multiple manufacturers, suppliers, and retail companies.<u> logistics </u> refers to distribution activities in one company.

<h3>What is Supply chain and logistics?</h3>

Supply chain has to do with production or manufacturing and distribution of goods produce to suppliers, retailers or customers while logistics has to do transporting or distribution of goods or products.

Supply chain involve the following:

  • Manufacturer
  • Supplier
  • Warehouses
  • Distribution
  • Retailers

Logistics involve:

  • Warehouse
  • Distribution

Inconclusion <u>supply chain </u>involve(s) both manufacturing and procurement with multiple manufacturers, suppliers, and retail companies.<u> logistics </u> refers to distribution activities in one company.

Learn more about supply chain and logistics here:brainly.com/question/25160870

4 0
2 years ago
Job descriptions often include the following information related to the job
Vilka [71]

Resume, school transcript, professional certifications, awards, memberships in professional organizations. Letters of recommendation, "thank you" notes, newspaper/website articles about you.

7 0
1 year ago
Who were some of the first big business capitalists in America?
irina [24]

Answer:

Railroads were the first "big businesses" in the United States.

Explanation:

8 0
3 years ago
Who wanna buy essay?
VLD [36.1K]
Me I want to buy essay
3 0
3 years ago
Read 2 more answers
Other questions:
  • Blossom Company reports operating expenses of $100,000, excluding depreciation expense of $17,000 for 2022. During the year, pre
    13·1 answer
  • Suppose you are a T-shirt producer in a market without price controls. You are charging a price that is below the equilibrium pr
    8·2 answers
  • The following errors occurred in posting from a two-column journal:
    9·1 answer
  • Explain the importance of elasticity​
    10·2 answers
  • Currency traders buy on margin so they can do which of the following
    11·1 answer
  • PLEASE HELP ASAP
    15·1 answer
  • When a company pays a dividend, it isn't as simple as getting a paycheck from one's employer. There are several critical dates i
    9·1 answer
  • The price of mangoes is currently $5.00 per pound. At this price, producers are supplying 4,000 pounds of mangoes. Point C on th
    9·2 answers
  • . In the step-by-step deployment of MIS in a business, which (and why) of the following will you consider as a Foundation Step f
    10·1 answer
  • The First National Bank of Nelsonville has no excess reserves when a new deposit of $10,000 is made. The required reserve ratio
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!