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
Assessments of how a diversified company's subsidiaries compare in competitive strength should be based on such factors as:
larisa86 [58]

Complete Question:

Assessments of how a diversified company's subsidiaries compare in competitive strength should be based on such factors as;

A. vulnerability to seasonal and cyclical downturns, vulnerability to driving forces, and vulnerability to fluctuating interest rates and exchange rates.

B. relative market share, the ability to match or beat rivals on key product attributes, brand image and reputation, costs relative to competitors, and the ability to benefit from strategic fits with sister businesses.

C. the appeal of its strategy, the relative number of competitive capabilities, the number of products in each business's product line, which businesses have the highest/lowest market shares, and which businesses earn the highest/lowest profits before taxes.

D. the ability to hurdle barriers to entry, value chain attractiveness, and business risk.

E. cost reduction potential, customer satisfaction potential, and comparisons of annual cash flows from operations.

Answer:

B. relative market share, the ability to match or beat rivals on key product attributes, brand image and reputation, costs relative to competitors, and the ability to benefit from strategic fits with sister businesses.

Explanation:

Assessments of how a diversified company's subsidiaries compare in competitive strength should be based on such factors as;

1. Relative market share: this measures the subsidiaries position in a market in relation to its competitors in the same industry. It is a measure of the percentage of the market they control.

2. The ability to match or beat rivals on key product attributes: this is really important in the assessment of competitive strengths because it represents the level of acceptance of their products by consumers in comparison with rivals.

3. Brand image and reputation: if the subsidiary is well accepted by the consumers, it simply suggests that they have a good brand image and reputation in the market. A good brand image and reputation is competitive strength.

4. Costs relative to competitors: the higher the price a company is selling its products relative to rival companies, the lesser its sales would be because consumers would naturally go for cheaper products or lower prices.

5. The ability to benefit from strategic fits with sister businesses: companies should be able to achieve their set goals and objectives from opportunities presented by their sister company.

<em>Hence, the competitive strength of a diversified company and its subsidiaries should be assessed based on the aforementioned factors</em>.

8 0
3 years ago
In the context of the strategies for reaching global markets, a(n) _____ is a firm that is offered the right to produce and mark
VladimirAG [237]

A licensing firm is a firm that is offered the right to produce and market another firm's products if it agrees to specific operating requirements.

<h3>What is a licensing firm?</h3>

A firm, which does not have a product of its own, but specializes in production and marketing of its client firms' products by the way of obtaining a licensed agreement, it is known as a licensing firm.

For example, in India, Varun Beverages Ltd. is a licensing firm that has been offered the rights to produce and market the products for PepsiCo.

Hence, the significance of a licensing firm is aforementioned.

Learn more about a licensing firm here:

brainly.com/question/1236640

#SPJ1

4 0
2 years ago
____ consumption occurs when consumers "set apart" objects and events from normal activities and treat them with respect. ____ c
solong [7]

Answer:

  • Sacred consumption
  • Profane consumption

Explanation:

This differentiation is based on special religious events (e.g. religious holidays) that considered some goods as sacred, while profane had to do with everyday life.

Some modern marketing strategies try to build sacred brands. For example, Google has become our God of all knowledge and no one even dares to challenge that almost religious belief. Anyone can make their own coffee or buy coffee at any coffee shop, but Starbucks is different, it has built a sense of emotional connection with the public. It's not any coffee that we need or want.  

6 0
4 years ago
On June 1, Greendale Corp. issued $700,000, five-year bonds at 8%, with interest payable annually on May 31. The bonds sold for
elena-14-01-66 [18.8K]

Answer:

$23,709

Explanation:

Data provided in the question:

Amount of bond issued = $700,000

Duration = 5 years

Interest rate = 8%

Selling amount of bond = $728,700

Market rate of interest = 7%

Now,

Interest paid = Amount of bond issued × Interest rate

= $700,000 × 0.08

= $56,000

Interest expense = Amount of bond sold × Market Interest rate

= $728,700 × 0.07

= $51,009

unamortized premium = Selling amount of bond -  Amount of bond issued

= $728,700 - $700,000

= $28,700

Amortized amount = Interest paid - Interest expense

= $56,000 - $50,009

= $4,991

Balance  of the premiums on bonds payable account immediately following the first interest payment

= unamortized premium - Amortized amount

= $28,700 - $4,991

= $23,709

5 0
4 years ago
Which of the following is not a step in the strategic training and development process?a. determining strategic initiatives base
Ronch [10]

Answer:

a. determining strategic initiatives based on business strategy translating initiatives into concrete learning activities facilitating

Explanation:

  • The strategic training and the development is a similar to the strategy planning process and in general identification of the needs and evaluation of the alternative and incentives and the assigning the right audience and implementation
3 0
3 years ago
Other questions:
  • A combination of news covered by the media that boosts sales without having to pay is best described by the term ________.
    11·1 answer
  • If the mpc is 0.70 and investment increases by $3 billion, the equilibrium gdp will
    6·1 answer
  • How much does it cost to send a letter to russia from the usa?
    15·1 answer
  • Which type of air mass forms over the ocean near the equator
    15·1 answer
  • The Action Toy Company has decided to manufacture a new train​ set, the production of which is broken into six steps. The demand
    14·1 answer
  • Abbot Corporation reported a net operating loss of $400,000 in 20X3, which the corporation elected to carry forward to 20X4. Inc
    13·1 answer
  • If the constructor function is a machine to create object instances, then the _____ is the blueprint for the objects that are cr
    15·1 answer
  • The ______ process consists of the analyses, decisions, and actions an organization undertakes in order to create and sustain co
    14·1 answer
  • Which of the following would be added to the balance per books on a bank reconciliation?
    12·1 answer
  • Which customer behavior has motivated retailers to reduce the amount of stock kept on hand, rent or lease smaller spaces, and ra
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!