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
Listed below are some items found in the financial statements of Tony Gruber Co. Indicate in which financial statement(s) the fo
ss7ja [257]

Answer:

The correct financial statement for the respective items is:

a) Service Revenue - Income statement.

b) Equipment - Statement of financial position.

c) Advertising expense - Income statement.

d) Accounts receivable - Statement of financial position.

e) Owner’s capital - Statement of financial position.

f) Salaries and wages payable - Statement of financial position.

Explanation:

a) Service Revenue - Service revenue refers to the sales generated from the services provided/offered by the business to its customers. Service revenue is an item of the income statement and appears on the credit side amongst revenues/incomes list.

b) Equipment - Equipment in accounting is used to refer tangible items such as plant, property and motor vehicle which are expected to be used for production for longer than one accounting period. They are tangible items and form part of the statement of financial position under the non-current assets.

c) Advertising expense - Advertising expense refers to operating expense incurred by the business in advertising its products/services. It is an item of the of the income statement and appears on the debit side amongst expenses list.

d) Accounts receivable - The term accounts receivable refers to all the payments a business is expecting for goods or services it provided to its customers on credit. It is a part of the statement of financial position and appears under the current accounts.

e) Owner’s capital - Also known as the owner's equity, owners capital  refers to all the investment the owner has put into the business.This maybe in the form of funds or assets. It is a part of the statement of financial position and appears under the Capital  and retained earnings / losses accounts.

f) Salaries and wages payable - Salaries and wages payable refers to salaries and wages due/owed to the business's employees for prior periods.It is part of the statement of financial position and appears under the current liabilities accounts.

6 0
3 years ago
SONAD COMPANY Income Statement For Year Ended December 31 Sales $ 1,828,000 Cost of goods sold 991,000 Gross profit 837,000 Oper
Snowcat [4.5K]

Answer:

                      Statement of Cash Flows (partial)

<u>Cash flows from operating activities </u>

Net income                                                           $481,540

Adjustments to reconcile net income to

net cash provided by operating activities

<u>Income statement items not affecting cash</u>

Depreciation expense                   $44,200

Gain on sale of equipment           -$6,200

Amortization expenses–Patents   $4200

<u>Changes in current operating </u>

<u>assets and liabilities </u>

Decrease in accounts payable    -$12,500

Decrease in salaries payable       -$3,500

Increase in accounts receivable  -$30,500

Increase in Inventory                    -$25,000

Net changes                                                          -<u>$29,300</u>

Cash flows from operating activities                  <u>$452,240</u>

3 0
3 years ago
The rise of Walmart as one of the world's largest corporations has brought the concept of:
Georgia [21]

Answer:

correct option is E) everyday low pricing

Explanation:

solution

Rise of Walmart brought the concept of Everyday low pricing  as we all aware everyone need good quality product in low price and Walmart is one the world largest corporation that give almost everyday attractive offer to their customers Incredible Prices on many different quality brands

they giver offer according to trends for autumn winter to attract all customers

so we can that here correct option is E) everyday low pricing

5 0
3 years ago
In strict liability, if a company sells a beverage in a can that has sharp edges and injures several consumers, it will be held
tiny-mole [99]
False because if it paid someone to make them then the people who made them at least knew about it. but no they are liable whether or not they knew of the problem. this is why things are recalled Is bc they found out about it.
3 0
3 years ago
Which of the following is NOT a category of barriers to interpersonal communication?a. individual differences among employeesb.
inysia [295]

Answer:

d. informal communication networks, such as the grapevine

Explanation:

Barriers to interpersonal communication are arises when a perosn has lack of self-awareness, Sensitivity, and flexibility. These barriers affect the teamwork and efficiency of each team member and a whole team as well. individual differences among employees, situational factors such as outside noise, and transmission problems, such as telephone static are examples of barriers to interpersonal communication.

4 0
3 years ago
Other questions:
  • Which of the following is NOT a core component of the Federal Reserve Bank?
    7·1 answer
  • From 2001 to 2004, the U.S. government went from a budget surplus to a budget deficit. According to the open-economy macroeconom
    9·1 answer
  • HURRY!!!!!!!!!!!!!!!!!!!!
    14·2 answers
  • Quota in a small country Suppose a small country imposes a quota that reduces imports of a good by 50 units and raises the price
    5·2 answers
  • Which type of portfolio might a young investor who is not afraid of risk choose? A
    6·1 answer
  • On January 1, 2018, Ogleby Corporation signed a five-year noncancelable lease for equipment. The terms of the lease called for O
    11·1 answer
  • After Mario completes his monthly report, his boss reviews it to see if the standards were met. If there are errors, Mario is to
    5·1 answer
  • HELP IM BEGGiNG YALLL
    11·1 answer
  • The Sales Operations team notices an increase in Opportunities without Products. Which configuration change should the System Ad
    14·1 answer
  • ASAP Please help and thank you!
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!