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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly...

Finance
Q

Explain the cellular and metabolic pathways involved in the uptake of glucose from the blood by...

Medical Sciences
Q

Enumerate the benefits of using authentic materials in language teaching. Select one authentic material to teach...

Psychology
Q

type mc cable is a factory assembly of one or more insulated circuit conductors with or...

Electrical Engineering
Q

Question 2 2.1       A brass rod of 25 mm in diameter is enclosed in a steel tube....

Mechanical Engineering
Q

A body is cooling under Newton s law of cooling Temperature difference between body and...

Physics
Q

25 In a gas discharge tube if 3 x 1018 electrons are flowing pe sec...

Physics
Q

A pulley system consists of a 10 inch wheel and another whose radius is unknown...

Geometry
Q

Out of a random sample of 65 freshmen at State University, 31 students have declared...

Basic Math
Q

a. What are the total expected cash collections for the year under this revised budget?...

Accounting
Q

Evidence that would not be of help in recording a transaction would be

Accounting
Q

During March, Randolf Corporation completed the following transactions: Purchased inventory for $36,000 on credit Issued...

Accounting