The following is information for Palmer Co. 2017 2016 2015 Cost of goods sold $ 563,825...

The following is information for Palmer Co.

	2017		2016		2015
Cost of goods sold	$	563,825	$	346,650	$	311,300
Ending inventory		104,400		94,750		99,500

Use the above information to compute inventory turnover for 2017 and 2016, and its days' sales in inventory at December 31, 2017 and 2016.

Solutions

Expert Solution

Solution :

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

Day's Sales in Inventory = 365 Days / Inventory Turnover Ratio

(a) Inventory Turnover Ratio and its days sales in Inventory for 2017 :

	Numerator	/	Denominator	=	Ratio
Inventory Turnover Ratio	$ 563,825	/	$ 99,575	=	5.66 Times
Day's Sales in Inventory*	365 Days	/	5.66	=	64.49 Days

(b) Inventory Turnover Ratio and its days sales in Inventory for 2016 :

	Numerator	/	Denominator	=	Ratio
Inventory Turnover Ratio	$ 346,650	/	$ 97,125	=	3.57 Times
Day's Sales in Inventory	365 Days	/	3.57	=	102.24 Days

Working :

(a)

Average Inventory = (Opening Inventory + Ending Inventory) / 2

= ($ 94,750 + $ 104,400) / 2

= $ 99,575

(b)

Average Inventory = (Opening Inventory + Ending Inventory) / 2

= ($ 99,500 + $ 94,750) / 2

= $ 97,125

* if table doesn't accept Day's Sales in Inventory in Two decimal place please round off it to One Decimal Place.

Please vote up and write your doubts in comment section. Would be glad to help you further.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Cullumber Company Oriole Company 2017 2016 2017 2016 Net sales $1,856,000 $596,000 Cost of goods sold...

Cullumber Company Oriole Company 2017 2016 2017 2016 Net sales $1,856,000 $596,000 Cost of goods sold 1,079,000 298,000 Operating expenses 263,000 83,000 Interest expense 7,000 2,800 Income tax expense 75,000 34,000 Current assets 590,015 $565,462 150,838 $ 143,835 Plant assets (net) 953,508 905,000 252,908 227,720 Current liabilities 120,048 137,225 63,980 54,809 Long-term liabilities 206,322 162,900 53,612 45,250 Common stock, $10 par 905,000 905,000 217,200 217,200 Retained earnings 312,153 265,337 68,954 54,296 Compute the 2017 return on assets and the return...

The following information for Vision Company is given: 2016 Sales 9,000 Cost of goods sold 1,500...

The following information for Vision Company is given: 2016 Sales 9,000 Cost of goods sold 1,500 Accounts receivable 1,000 Inventory 250 Calculate the Accounts Receivable Turnover, Inventory Turnover and Day’s Sales in Inventory for 2016. Calculate Day’s Sales in Inventory for 2016. What this ratio attempt to measure? Calculate the Day’s Sales in Receivables for 2016. (1 mark) How long did it take on average for credit customers to pay off their accounts during the past year?

Schedule of Cost of Goods Manufactured and Sold The following amounts are available for 2016 for...

Schedule of Cost of Goods Manufactured and Sold The following amounts are available for 2016 for Bourne Manufacturing Company: Administrative salaries (non-factory) $210,000 Administrative rent (non-factory) 105,000 Advertising and promotion expense 123,000 Depreciation-administrative 66,000 Depreciation-factory 90,000 Depreciation-selling 51,000 Direct labor 525,000 Factory rent 54,000 Factory supplies used 36,000 Finished goods inventory (January 1) 171,000 Finished goods inventory (December 31) 156,000 Indirect material used 42,000 Indirect labor 57,000 Materials inventory (January 1) 39,000 Materials inventory (December 31) 60,000 Net delivered cost...

IMT Co. reported the following selected information for 2010: Sales revenue .......................................................................................... $865,000 Cost of goods sold......................................

IMT Co. reported the following selected information for 2010: Sales revenue .......................................................................................... $865,000 Cost of goods sold.................................................................................. 360,000 Depreciation expense ............................................................................. 43,000 Salaries & wages expense ……………………………………………... 178,000 Rent Expense ………………………………………………………….. 95,000 Beginning of Year End of Year Accounts receivable ..................................... $ 15,000 $ 35,000 Prepaid rent ................................................... 21,000 15,000 Salaries & wages payable ............................. 33,000 18,000 Required:Use the above information to calculate: The cash collected from customers ii)The cash paid for depreciation iii)The cash paid to employees iv)The cash paid for rent

Cost of Goods Sold, Cost of Goods Manufactured Gauntlet Company has the following information for January:...

Cost of Goods Sold, Cost of Goods Manufactured Gauntlet Company has the following information for January: Cost of direct materials used in production $ 37,000 Direct labor 46,000 Factory overhead 20,000 Work in process inventory, January 1 22,000 Work in process inventory, January 31 30,000 Finished goods inventory, January 1 24,000 Finished goods inventory, January 31 18,000 a. For January, determine the cost of goods manufactured. $ b. For January, determine the cost of goods sold. $

Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April:...

Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April: Cost of direct materials used in production $54,000 Direct labor 66,000 Factory overhead 20,000 Work in process inventory, April 1 45,000 Work in process inventory, April 30 50,000 Finished goods inventory, April 1 25,000 Finished goods inventory, April 30 17,000 a. For April, determine the cost of goods manufactured. Using the data given, prepare a statement of Cost of Goods Manufactured. Glenville Company Statement...

Please calculate the ratios for 2017 from the following information: 2017 2016 2015 Industry Standard Quick...

Please calculate the ratios for 2017 from the following information: 2017 2016 2015 Industry Standard Quick Ratio 2.2 2.8 1.75 Gross Margin 0.55 0.7 0.7 Net Margin 0.22 0.32 0.24 Return on Equity 0.9 0.78 0.8 Peyton Approved Balance Sheet As of December 31, 2017 Assets Liabilities and Owners' Equity Current Assets: Current Liabilities: Cash 64,713.72 Accounts Payable 27,325.00 Baking Supplies 27,850.00 Wages Payable 1,468.75 Merchandise Inventory (FIFO) 25,750.00 Interest Payable 22,800.00 Prepaid Rent 7,500.00 Total Current Liabilities 51,593.75 Prepaid...

2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000...

2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000 Income Tax Expense 27,000 30,000 Net Income 61,000 52,000 Cash Flow from Operations 65,000 55,000 Capital Expenditures 65,000 55,000 Acc Receivable (net) 31 Dec 126,000 120,000 Inventory 31 Dec 196,000 160,000 Stockholders' Equity 31 Dec 450,000 400,000 Total Assets 31 Dec 750,000 675,000 Required: Calculate the following ratios for 2016. The 2015 results are given for comparative purposes. Round answers to one (1) decimal...

Exercise 4-16 Sheridan Co. reports the following information for 2017: sales revenue $762,800, cost of goods...

Exercise 4-16 Sheridan Co. reports the following information for 2017: sales revenue $762,800, cost of goods sold $524,200, operating expenses $82,000, and an unrealized holding loss on available-for-sale securities for 2017 of $56,700. It declared and paid a cash dividend of $14,660 in 2017. Sheridan Co. has January 1, 2017, balances in common stock $368,700; accumulated other comprehensive income $87,500; and retained earnings $95,830. It issued no stock during 2017. Prepare a statement of stockholders’ equity.

Cocoa Company * 2016 2017 Cash 100 75 Cost of Goods Sold 1000 1100 Debt (LT)...

Cocoa Company * 2016 2017 Cash 100 75 Cost of Goods Sold 1000 1100 Debt (LT) 10000 12000 Depreciation 2000 2200 Equity (total) 5300 5125 Interest Expense 600 720 Inventories 400 400 Payables 1200 1350 Property, Plant, Equipment 16000 18000 Revenues 6500 7500 Salaries 2200 2100 Share Capital 4964 4491 * All values given are in 1000s of dollars. 1. Construct a statement of comprehensive income for Cocoa Co. up through Earnings-Before- Taxes (EBT) for both 2016 and 2017. Use...

Subjects