The following data are pulled from a recent Walsh Manufacturing annual report.
Assets
Raw material inventory $130,000
Work-in-process inventory $60,000
Finished goods inventory $310,000
Property, plant & equipment $500,000
Other assets $200,000
Total assets $1,200,000
Condensed Income Statement
Revenue $2,000,000
Cost of goods sold $600,000
Other expenses $1,000,000
Net income $400,000
Calculate:
(a) Percent invested in inventory
(b) Inventory turnover
(c) Weeks of supply.
Please provide detail work on each calculation.
A) Percent Invested in Inventory can be computed by dividing the total inventory by total assets.
Raw Material Inventory = $130,000
WIP Inventory = $60,000
Finished Goods Inventory = $310,000
Total Inventory = 130,000 + 60,000 + 310,000
= $500,000
Total assets = $1,200,000
Percent Invested in inventory = Total Inventory / Total Assets
= 500,000 / 1,200,000
= 0.4167 = 41.67%
B) Inventory Turnover = Cost of Goods Sold / Average Inventory
Also,
Inventory Turnover = Sales / Total Inventory
= 2,000,000 / 5,00,000
= 4 Times
C) Weeks of Supply =Number of working weeks in a year / Inventory Turnover ratio
= 52 / 4
= 13 Weeks
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory ...
The following data are pulled from a recent Walsh Manufacturing annual report. Assets Raw material inventory $150,000 Work-in-process inventory $50,000 Finished goods inventory $330,000 Property, plant & equipment $500,000 Other assets $140.000 Total assets $1,170,000 Condensed Income Statement Revenue $2,000,000 Cost of goods sold $700,000 Other expenses $1,000,000 Net income $300,000 Calculate the weeks of supply. O 0.47 O24.51 39 37 Assets Raw material inventory Work-in-process inventory Finished goods inventory Property, plant & equipment Other assets Total assets $150,000 $50,000...
Yummy's is a restaurant chain operating in select cities in the Carolinas. Select financial data is presented below to provide you with the necessary content for performance evaluation purposes. Charlotte Greenville Columbia Restaurant Restaurant Restaurant Total Sales revenue 3,185,000 1,400,000 1,200,000 5,785,000 Variable costs 995,000 375,000 310,000 1,680,000 Fixed costs 1,680,000 725,000 650,000 3,055,000 Operating income 510,000 300,000 240,000 1,050,000 Interest costs on long-term debt at 10% 450,000 Income before income taxes 600,000 Income taxes at 30% 180,000 Net income...
Question 6 (2 points) Carly Manufacturing Company's accounting records reflect the following amounts: Raw Materials Inventory, Jan 1, 2008 - $260,000 Raw Materials Inventory, Dec 31, 2008 - $310,000 Work in Process Inventory, Jan 1, 2008 - $160,000 Work in Process Inventory, Dec 31, 2008 - $300,000 Finished Goods Inventory, Jan 1, 2008 - $150,000 Finished Goods Inventory, Dec 31, 2008 - $190,000 Raw materials purchased during 2008 - $500,000 Direct labor costs during 2008 - $600,000 Manufacturing overhead incurred...
The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are as follows: The condensed bala Spartan Inn Condensed Balance Sheets December 31, 20X1 and 20X2 20X1 Assets Current Assets: 20X2 Cash $ $ Marketable Securities Accounts Receivable Inventory Total Current Assets Investments Property and Equipment: 30,000 50,000 100,000 20,000 200,000 100,000 40,000 50,000 95,000 25,000 210,000 60,000 500,000 5,000,000 1,000,000 (1,600,000) 4,900,000 $5,200,000 500,000 6,000,000 1,100,000 (2,000,000) 5,600,000 $5,870,000 Land Building Equipment Accumulated Depreciation...
II. Problem solving question- Design works International manufactures custom tiles. The following information relates to the fiscal year ending December 31, 2015 Beginning balance in raw material inventory Purchases of raw material Ending balance in raw material inventory Beginning balance in work-in-process Ending balance in work-in-process Direct labor cost Manufacturing overhead applied Beginning balance in finished goods Ending balance in finished goods Sales Selling expenses General and administrative expenses 200,000 800,000 100,000 400,000 200,000 1,000,000 500,000 600,000 300,000 4,000,000 250,000...
Calculate the accounts receivable turnover, average collection period (days), inventory turnover, fixed asset turnover, and total asset turnover for each period. X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME...
Comparative Balance Sheets For 20X1 and 20X2 Year-End Year-End Assets 20X1 20X2 Current assets: Cash $ 70,000 $100,000 Accounts receivable (net) 300,000 350,000 Inventory 410,000 430,000 Prepaid expenses 50,000 30,000 Total current assets 830,000 910,000 Investments (long-term securities) 80,000 70,000 Plant and equipment 2,000,000 2,400,000 Less: Accumulated depreciation 1,000,000 1,150,000 Net plant and equipment 1,000,000 1,250,000 Total assets $1,910,000 $2,230,000 Liabilities and Stockholders’ Equity Current liabilities: Accounts payable $ 250,000 $ 440,000 Notes payable 400,000 400,000 Accrued expenses 70,000 50,000...
Determining ending consolidated balances in the third year following the acquisition—Equity method Assume that your company acquired a subsidiary on January 1, 2017. The purchase price was $900,000 in excess of the subsidiary’s book value of Stockholders’ Equity on the acquisition date, and that excess was assigned to the following [A] assets: [A] Asset Original Amount Original Useful Life Patent $600,000 10 years Goodwill 300,000 Indefinite $900,000 The [A] assets with a useful life have been amortized as part of...
Consider the following information for Butler Manufacturing Inc. for the year ended December 31, 2019: Accumulated depreciation $ 400,000 Depreciation expense (90%-Plant) 200,000 Direct labor – Wages 600,000 Direct materials inventory, Dec. 31, 2019 50,000 Direct materials inventory, Jan. 1, 2019 30,000 Direct material purchases 200,000 Finished goods inventory, Dec. 31, 2019 20,000 Finished goods inventory, Jan. 1, 2019 40,000 Heat, light & power (90%-Plant) 60,000 Indirect labor 40,000 Property taxes (90%-Plant) 60,000 Sales representatives’ salaries 800,000 Sales...
Liquidity Ratios Mike Sanders is considering the purchase of Kepler Company, a firm specializing in the manufacture of office supplies. To be able to assess the financial capabilities of the company, Mike has been given the company's financial statements for the 2 most recent years. Kepler Company Comparative Balance Sheets This Year Last Year Assets Current assets: Cash $ 50,000 $100,000 Accounts receivable, net 300,000 150,000 Inventory 600,000 400,000 Prepaid expenses 25,000 30,000 Total current assets $ 975,000 $680,000 Property...