Purchase Solution

# Ratio Analysis and Statement for Manufacturing Firms

Not what you're looking for?

Problem 1. The following information applies to Barnhart Company:

• Net Credit Sales = \$220,000
• Beginning Accounts Receivable = \$10,000
Solutions:
a) Quick ratio = Quick Assets/Current Liabilities =
(Cash + Accounts Receivable)/(Accounts Payable + Salaries Payable)
(\$12,000+5000)/(\$9,000+4,000) = 17,000/13,000 = 1.31
b) Current ratio = Current Assets/Current Liabilities
(Cash + Accounts Receivable + Inventory)/ (Accounts Payable + Salaries Payable)
\$32,000/13,000 = 2.46

c) Working capital = Current Assets - Current Liabilities
\$32,000 - 13,000 = \$19,000

d) Accounts receivable turnover = Net Sales / Average Accounts Receivable
Average Accts Rec = [Acct Rec at beginning of year/Accts Rec a end of year] / 2
Average Accts Rec = (\$12,000 + 10,000)/2 = 11,000
Accounts Rec Turnover = 220,000/11000 = 20

e) Average days to collect receivables = 365/Acct Receivable Turnover
365/20 = 18.25

Problem 2. The Jiffy Manufacturing Company started operations in 2012 when it acquired \$100,000 from its owners. During the year, the company incurred the following costs:
The company placed 12,000 units into production, completed 10,000 units, and sold 8,000 units. The average selling price was \$17 per unit.

Required:

1) Prepare a schedule of cost of goods manufactured and sold for the year ended December 31, 2012.
2) Prepare an income statement for the year ended December 31, 2012.

Schedule of cost of goods manufactured
Beginning Work in process inventory \$0
Manufacturing costs:
Direct Materials \$40,000
Direct Labor 50,000
Less: Ending Work in process Inventory (\$110,000/12,000)*2000 (18,333)
Cost of Finished Goods Manufactured \$91,667
Schedule of cost of goods Sold
Beginning inventory of Finished Goods \$0
Add: Cost of Finished goods manufactured 91,667
Less: Ending inventory of finished goods [(\$91,667/10,000)*2,000] 18,333
Cost of Goods Sold 73,334

Income Statement
Sales Revenue (8,000 * \$17) \$136,000
Less: Cost of Goods Sold 73,334
Gross Profit 62,666
Less: Selling and Administrative Costs 30,000
Net Income 32,666

##### Solution Summary

Ratio analysis for a manufacturing firm.....Step by step detailed analysis

##### Solution Preview

Problem 1. The following information applies to Barnhart Company:

â?¢ Net Credit Sales = \$220,000
â?¢ Beginning Accounts Receivable = \$10,000
Solutions:
a) Quick ratio = Quick Assets/Current Liabilities =
(Cash + Accounts Receivable)/(Accounts Payable + Salaries Payable)
(\$12,000+5000)/(\$9,000+4,000) = 17,000/13,000 = 1.31
b) Current ratio = Current Assets/Current Liabilities
(Cash + Accounts Receivable + Inventory)/ (Accounts Payable + Salaries Payable)
\$32,000/13,000 = 2.46

c) Working capital = Current Assets - Current Liabilities
\$32,000 - 13,000 = \$19,000

d) Accounts receivable turnover = Net Sales / Average Accounts Receivable
Average Accts Rec = [Acct Rec at beginning of ...

##### MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

##### Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

##### Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.