The comparative financial statements of Norfolk Cosmetic Supply for 2018, 2017, and

2016 include the data shown here:

2018 2017 2016

Balance sheet—partial

Current Assets:

Cash

Short-term investments

Accounts Receivable, Net

Merchandise Inventory

Prepaid Expenses

Total Current Assets

Total Current Liabilities

Income statement—partial

Net Sales (all on account)

\( 70,000

140,000

280,000

355,000

70,000

915,000

560,000

5,890,000

\) 60,000

170,000

240,000

330,000

35,000

835,000

630,000

5,130,000

$ 50,000

120,000

260,000

310,000

35,000

775,000

640,000

4,210,000

Requirements

1. Compute these ratios for 2018 and 2017:

a. Acid-test ratio (Round to two decimals.)

b. Accounts receivable turnover (Round to two decimals.)

c. Days’ sales in receivables (Round to the nearest whole day.)

2. Considering each ratio individually, which ratios improved from 2017 to 2018 and

which ratios deteriorated? Is the trend favorable or unfavorable for the company?

Short Answer

Expert verified

Answer:

(1) The ratios are calculated as follows:

Ratios

Year 2017

Year 2018

Acid-test ratio

0.75

0.88

Accounts receivable turnover

20.52

22.65

Accounts receivable turnover

18 Days

16 Days

(2) All the company’s ratios are improved, which is a good trend.

Step by step solution

01

Definition of the acid-test ratio

Acid-test ratio is the ratio that calculates the ability of the company to pay its current liabilities.

02

Ratio for 2018

  1. Acid-test Ratio-Acid-testRatio=QuickAssetCurrentLiabilities=$490,000$56,000=0.85
  1. Accounts receivable turnover:AccountReceivableTurnover=SalesAverageAccountReceivable=$5,890,00$240,600+$280,0002
  1. Day’s SalePaysScale=365AccountReceivableTurnoverRatio=36520.65=16days
03

Ratios for 2017

  1. Acid-test RatioAcid-TestRatio=QuickRestCurrentLiabilities=$470,000$630,000=0.75
  1. Accounts receivable turnover:AccountReceivableTurnover=SalesAverageAccountsReceivables=$5,130,000$260,00+$240,0002=20.52
  1. Day’s Sale:Day'sScale=365AccountReceivableTurnoverRatio=36520.52=18days
04

Analysis of the ratios

Company is able to increase its liquidity from 0.75 to 0.88. In terms of increasing the efficiency of credit and collecting it, the performance has improved from 20.52 to 22.65. Now company is able to collect cash from the accounts receivable within 16 days which is less as compared to 18 days in previous year.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Miller Company sells several products. Sales reports show that the sales volume of its most popular product has increased the past three quarters while overall profits have decreased. How might production cost reports assist management in making decisions about this product?

Billy Davidson operates Billy’s Worm Farm in Mississippi. Davidson raises worms for fishing. He sells a box of 20 worms for \(12.60. Davidson has invested \)400,000 in the worm farm. He had hoped to earn a 24% annual rate of return (net income divided by total assets), which works out to a 2% monthly return on his investment. After looking at the farm’s bank balance, Davidson fears he is not achieving this return. To evaluate the farm’s performance, he prepared the following production cost report. The Finished Goods Inventory is zero because the worms ship out as soon as they reach the required size. Monthly operating expenses total \(2,000 (in addition to the costs below).

BILLY’S WORM FARM

Production cost report – BROODING DEPARTMENT

Month Ended June 30, 2018


Equivalent units

Units

Physical units

Transferred in

Direct materials

Conversion costs

Units to account for:

Beginning WIP

9,000

Transferred in

21,000

Total units to account for

30,000

Units accounted for:

Completed and transferred out

20,000

20,000

20,000

20,000

Ending WIP

10,000

10,000

6,000

3,600

Total units accounted for

30,000

30,000

26,000

23,600

COSTS

Transferred in

Direct materials

Conversion costs

Total costs

Cost to account for:

Beginning WIP

\)21,000

\(39,940

\)5,020

\(65,960

Cost added during period

46,200

152,460

56,340

255,000

Total cost to account for

67,200

192,400

61,360

320,960

Divided by total EUP

30,000

26,000

23,600

Cost per equivalent units

\)2.24

\(7.40

\)2.60

Costs accounted for:

Completed and transferred out

\(44,800

\)148,000

\(52,000

\)244,800

Ending WIP

22,400

44,400

9,360

76,160

Total costs accounted for

\(67,200

\)192,400

\(61,360

\)320,960

Requirements

Billy Davidson has the following questions about the farm’s performance during June.

1. What is the cost per box of worms sold? (Hint: This is the unit cost of the boxes completed and shipped out of brooding.)

2. What is the gross profit per box?

3. How much operating income did Billy’s Worm Farm make in June?

4. What is the return on Davidson’s investment of \(400,000 for the month of

June? (Compute this as June’s operating income divided by Davidson’s \)400,000

investment, expressed as a percentage.)

5. What monthly operating income would provide a 2% monthly rate of return?

What sales price per box would Billy’s Worm Farm have had to charge in June to

achieve a 2% monthly rate of return?

PepsiCo, Inc. is a global food and beverage company that manufactures brands such as Frito-Lay, Gatorade, Pepsi-Cola, Quaker, and Tropicana. One of the products PepsiCo, Inc. manufactures is Mountain Dew. The first process in manufacturing Mountain Dew consists of clarifying the water to remove impurities such as organic materials and bacteria. The clarification process involves mixing the water with aluminum sulfate (an indirect material) to remove the impurities.

Assume PepsiCo uses the weightedaverage method of process costing.

Requirements

1. During the month of June, the Clarification Department incurred the following costs in processing 100,000 liters:

Wages of workers operating the clarification equipment

$20,000

Manufacturing overhead allocated to clarification

24,000

Water

160,000

PepsiCo had no beginning Work-In-Process Inventory in the Clarification Department in June. Compute the June conversion costs in the Clarification Department.

2. Assume that water is added at the beginning of the clarification process and conversion costs are added evenly throughout the process. The Clarification Department completed and transferred out 60,000 liters during June. The 40,000 liters remaining in Clarification’s ending Work-in-Process Inventory were 100% complete for direct materials and 60% complete for conversion costs. Compute the equivalent units of production for direct materials and conversion costs for the Clarification Department.

3. Compute the cost per equivalent unit for direct materials and conversion costs for the Clarification Department.

Carla Carpet manufactures broadloom carpet in seven processes: spinning, dyeing, plying, spooling, tufting, latexing, and shearing. In the Dyeing Department, direct materials (dye) are added at the beginning of the process. Conversion costs are incurred evenly throughout the process. Information for November 2018 follows:

UNITS

Beginning work-in-process inventory

70 rolls

Transferred in from spinning department during November

550 rolls

Completed during November

480 rolls

Ending work in process inventory (80% complete for conversion work)

140 rolls

COSTS

Beginning work in process inventory (transferred in costs, \(4,000, Materials costs, \)1,400 conversion costs, \(5,300)

\)10,700

Transferred in from the spinning department

23,280

Material costs added during November

14,100

Coversion cost added during November (manufacturing wages, \(8,725; manufacturing overhead allocated, \)43,991)

52,716

Requirements

1. Prepare the November production cost report for Carla’s Dyeing Department.

The company uses the weighted-average method.

2. Journalize all transactions affecting Carla’s Dyeing Department during November, including the entries that have already been posted. Assume labor costs are accrued and not yet paid.

Match each costing system characteristic to job order costing, process costing, or both.

1. Used by companies that manufacture identical items through a series of uniform production steps or processes

2. Transfers costs from Work-in-Process Inventory to Finished Goods Inventory to Cost of Goods Sold

3. Used by companies that manufacture unique products or provide specialized services

4. Has multiple Work-in-Process Inventory accounts

5. Tracks direct materials, direct labor, and manufacturing overhead costs

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free