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...

90.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