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]
2 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]2 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
A manufacturer shipped units of a certain product to two locations. The equation above shows the total shipping cost TTT, in dol
andriy [413]

Answer: 2,200 units.

Explanation:

The complete exercise is:

T = 5c + 12 f

A manufacturer shipped units of a certain product to two locations. The equation above shows the total shipping cost T, in dollars, for shipping c units to the closer location and shipping f units to the farther location. If the total shipping cost was $47,000 and 3,000 units were shipped to the farther location, how many units were shipped to the closer location?

Given the following equation:

T = 5c + 12 f

You know that "T" is the total shipping cost (in dollars), "c" is the number of units shipped to the closer location and "f" is the number of units shipped to the farther location.

Based on the information given in the exercise, you can identify that, in this case:

T=47,000\\\\f=3,000

Then, knowing those values, you need to substitute them into the given equation:

47,000 = 5c + 12(3,000)

And finally, you must solve for "c" in order to calculate the number of units that  were shipped to the closer location.

You get that this is:

47,000 = 5c + 12(3,000)\\\\47,000-36,000 = 5c\\\\11,000=5c\\\\\frac{11,000}{5}\\\\c=2,200

3 0
3 years ago
Read 2 more answers
____ includes) the application of knowledge, skills, and tools to achieve a specific business objective
nlexa [21]

<u>Project management</u> includes the application of knowledge, skills, and tools to achieve a specific business objective.

Project management refers to the use of specific knowledge, tools, skills, and techniques in order to deliver something of value to people. For instance, developing software for an improved business process, relief effort after a natural disaster, construction of a building, the expansion of sales.

Project management goals are set to achieve a specific business objective through a successful development of the project's procedures of planning, initiation, execution, regulation and closure as well as the guidance of the project team's operations.

Hence, project management achieves a specific business objective.

To learn more about project management here:

brainly.com/question/4475646

#SPJ4

4 0
1 year ago
Graham Corp. has 1,000 cartons of oranges that were harvested at a cost of $30,400. The oranges can be sold as is for $36,400. T
Readme [11.4K]

Answer:

c. $3,600

Explanation:

The total cost of orange juice = $30,400 + $13,000

The total cost of orange juice = $43,400

So, the profit on the orange juice = $53,000 - $43,400 = $9,600

Profit when oranges are sold without juice = $36,400 - $30,400

Profit when oranges are sold without juice =  $6,000

So, extra income = $$9,600 - $6,000 = $3,600

Thus, the net benefit (additional income) from processing the oranges into orange juice instead of selling as is would be is $3,600

5 0
2 years ago
Gomez Corp. uses the allowance method to account for uncollectibles. On January 31, it wrote off an $2,800 account of a customer
laila [671]

Explanation:

The Journal entry is shown below:-

On Jan 31

Allowance for doubtful accounts $2,800

                     To Accounts receivable - C. Green $2,800

(Being the uncollectible amount is recorded)

Mar 09

Accounts receivable - C. Green $2,300

               To  Allowance for doubtful accounts $2,300

(Being the written off amount is recorded

Mar 09

Cash $2,300

              To Accounts receivable -  C. Green $2,300

(Being the payment is received is recorded)

7 0
3 years ago
Read 2 more answers
the main purpose of writing a business plan is to a. prepare a "blueprint" for the development of your business. b. meet a state
erastova [34]
D because if your employees don't know about anything then you will have a sloppy business

5 0
3 years ago
Read 2 more answers
Other questions:
  • Income allocation in a partnershipKramer and Knox began a partnership by investing $60,000 and $80,000, respectively. During its
    5·1 answer
  • A manufacturer of small copiers makes a profit of $200 on a deluxe model and $250 on a standard model. The company wants to prod
    5·1 answer
  • Kansas Enterprises purchased equipment for $73,500 on January 1, 2018. The equipment is expected to have a five-year life, with
    6·1 answer
  • When vertical analysis is performed: a. ratios are used to detect fraud b. changes in significant balance totals are examined c.
    15·1 answer
  • What is the proper preparation sequencing of the following budgets? 1. Budgeted Balance Sheet 2. Sales Budget 3. Selling and Adm
    8·1 answer
  • In Year 1, Costello Company performed work for a customer and billed the customer $14,000. In Year 2, the customer pays Costello
    12·1 answer
  • Kathy has $50,000 to invest today and would like to determine whether it is realistic for her to achieve her goal of buying a ho
    10·1 answer
  • Suppose that in 2014, currency in circulation was $950 billion, required reserves were $60 billion, and excess reserves were $84
    13·1 answer
  • Can someone define these will mark as brainliest
    13·1 answer
  • The sequence of suppliers that contribute to creating and delivering a product, from raw materials to production to final buyers
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!