Problem #2 (Adapted) The following selected data were taken from the records of Delta Company: Beginning Ending Accounts P60,000 P40,000 Receivable - net 55,000 65,000 Inventory Sales (all on credit) 600,000 Cost of Goods Sold 360,000 Required: A. Compute the following ratios. Show your solution. 1. Accounts receivable turnover 2. Average collection period 3. Inventory turnover 4. Days sales in inventory Delta's credit term is 2/10, n/30. The industry average inventory turnover is 8 times. Comments on Delta's efficiency in managing its accounts receivable and inventory. В.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 44E: Whalen Company had net sales of 125,500,250,000. Whalen had the following balances: Required: Note:...
icon
Related questions
Question

Please answer in excel form

Problem #2 (Adapted)
The following selected data were taken from the records of Delta
Company:
Beginning
Ending
Accounts
Р60,000
P40,000
Receivable - net
55,000
65,000
Inventory
Sales (all on credit)
600,000
Cost of Goods Sold
360,000
Required:
A. Compute the following ratios. Show your solution.
1.
Accounts receivable turnover
2.
Average collection period
3.
Inventory turnover
4.
Days sales in inventory
Delta's credit term is 2/10, n/30. The industry average inventory turnover is 8
times. Comments on Delta's efficiency in managing its accounts receivable and
inventory.
В.
Transcribed Image Text:Problem #2 (Adapted) The following selected data were taken from the records of Delta Company: Beginning Ending Accounts Р60,000 P40,000 Receivable - net 55,000 65,000 Inventory Sales (all on credit) 600,000 Cost of Goods Sold 360,000 Required: A. Compute the following ratios. Show your solution. 1. Accounts receivable turnover 2. Average collection period 3. Inventory turnover 4. Days sales in inventory Delta's credit term is 2/10, n/30. The industry average inventory turnover is 8 times. Comments on Delta's efficiency in managing its accounts receivable and inventory. В.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Investment in Stocks
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College