Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 1. use appropriate formulas to calculate the follo

1. Use appropriate formulas to calculate the following amounts in the column indicated: Gross profit...

70.2K

Verified Solution

Question

Accounting

1. Use appropriate formulas to calculate the following amounts in the column indicated: Gross profit (Column D), Cost of divided by Sales (Column E), Gross profit divided by Sales (Column F), and cost of goods sold divided by gross profit (Colum G).
2. Use Excel's conditional formatting ability to format each added column as follows: Column D, Top 10%, Column E, Greater than 25%, Column F, Green solid fill data bar, Column G Below Average.
3. Explain how conditional formatting could be useful in thr sales/collection process. Consider the data below and for DSC corporation's recent sales.
\table[[\table[[Transaction],[number]],\table[[Sales],[revenue]],\table[[Cost of goods],[sold]]],[1,$,4,818,$,973],[2,,1,070,,411],[3,,3,783,,817],[4,,4,862,,979],[5,,1,510,,477],[6,,4,419,,913],[7,,3,269,,740],[8,,2,477,,622],[9,,2,409,,611],[10,,3,643,,796],[11,,4,163,,874],[12,,1,926,,539],[13,,4,659,,949],[14,,4,421,,913],[15,,1,120,,418],[16,,1,107,,416],[17,,3,320,,748],[18,,4,955,,993],[19,,3,568,,785],[20,,2315,,597]]
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

A ball of radius 17 has a round hole of radius 7 drilled through its center....

Biology
1.2K views

Suggest a risk assessment model for enzymes to be used for food purposes.

Physics
1.2K views

An object has a relativistic momentum that is 7.3 times greater than its classical momentum. What is...

Biology
1.2K views

When the antibiotic against a preexisting infection kills normal microbiota yielding proliferation of antibiotic resistant...

Physics
1.2K views

A circular wire of radius R placed on a horizontal smooth surface is made t...

Basic Math
1.2K views

A book store manager observes that the number of calendars sold seems to vary inversely...

Statistics
1.2K views

PREVIOUS ANSWERS hr The authors of a paper were interested in estimating the mean time...

Calculus
1.2K views

The lengths of a particular snake are approximately normally distributed with a given mean 15...

Algebra
1.2K views

2 4 2x 10

Accounting
1.2K views

Jurvin Enterprises is a manufacturing company that had no beginning inventories. A subset of the...

Accounting
1.2K views

@heck my Won 2 Problem 07-03 (algo) 10 points Suppose the own price elasticity of...

Accounting
1.2K views

The Hampshire Company manufactures umbrellas that sell for $12.50 each. In 2014, the company made...