AFM351 Lecture Notes - Lecture 14: Inventory Turnover
Get access
Related Documents
Related Questions
Analytical Data for Jones Manufacturing
Prior Period 000 omitted | % of Sales | Current Period 000 omitted | % of Sales | % Change | Industry Average as % of Sales | |
Sales | $10,000 | 100 | $11,000 | 100 | 10 | 100 |
Inventory | $2,000 | 20 | $3,250 | 29.5 | 57.5 | 22.5 |
Cost of goods sold | $6,000 | 60 | $6,050 | 55 | 0.83 | 59.5 |
Accounts payable | $1,200 | 12 | $1,980 | 18 | 65 | 14.5 |
Sales commissions | $500 | 5 | $550 | 5 | 10 | N/A |
Inventory turnover | 6.3 | â | 4.2 | â | (33) | 5.85 |
Average number of days to collect | 39 | â | 48 | â | 23 | 36 |
Employee turnover | 5% | â | 8% | â | 60 | 4 |
Return on investment | 14% | â | 14.3% | â | 2.1 | 13.8 |
Debt/Equity | 35% | â | 60% | â | 71 | 30 |
Assume that the auditor expected that the clientâs performancein the current year would be similar to its performance in theprior year.
Select the potential risk factor that matches the risk analysisdescribed.
Accounts payable increase
Average number of days to collect
Cost of goods sold decrease
Debt/equity ratio
Employee turnover
Inventory increase
Inventory turnover
Return on investments
Risk Analysis | Potential Risk Indicator | ||
a. | Has decreased by 33 percent. This points to and confirms theproblems identified by the increase in inventory and decrease incost of goods sold. There are substantial obsolescence problems,material items are not correctly recorded. Or the inventory hasbeen intentionally increased in anticipation of some unusual eventearly next year as mentioned in the accounts payable increase. | ||
b. | This ratio has increased substantially and is double theindustry average. The company has become highly leveraged. Theincreased leverage has three implications the auditor ought toaddress: the existence of new debt covenants that ought to beaddressed as part of the audit; a potential problem of remaining agoing concern should there be a downturn in operations or asignificant increase in interest rates; there may be concern withhow the debt proceeds have been utilized by the company. |
c. | The increase could reflect credit problems or other financingproblems. Such problems could make it difficult for the company tocarry out its on-going activities. It may simply reflect thepurchase of an unusual amount of inventory just beforeyear-end. |
d. | This ratio has increased by 23 percent over the previous yearand is 33 percent above the industry average. The increase in theratio could represent a number of problems: less stringent creditstandards; warranty problems; unrecorded returned items or asignificant lag in issuing credit memos associated with returneditems. |
e. | There is a substantial increase both in dollar terms and as apercentage of sales, which could indicate potential problems withnew products, with obsolescence, or with competitiveness with otherproducts. It may indicate an increase of just before year-end inanticipation of rise in cost, a strike, or unusually heavy demand.Could be overstated due to misstatements of quantities or prices.This could also affect the COGS change. |
f. | This ratio does not indicate a problem. In fact, the companyexceeds the industry average. An alert auditor should wonderhowever, how the company is able to maintain a superior return whenthere are problems with inventory and receivables. |
g. | Has decreased to 55 percent of sales at the same time inventoryhas increased. One explanation is that costs have not been bookedfor some significant sales. There may also be a change in productmix. |
h. | This is more difficult to interpret, but there is a 60 percentincrease over previous years to a rate that is double that of theindustry. This might indicate problems with morale, qualitycontrol, or other dissatisfaction with the manner in which thecompany is being run. |
Czar was authorized to issue 3,000,000 shares of $1 par Common Stock but has only issued 520,000 shares of common stock as of 12/31/2018. No new shares were issued during 2018.
1. On the âAdjusting Journal Entriesâ worksheet, prepare in journal entry form all adjusting and correcting journal entries based on the following information. All information was provided to you as of 12/31/2018. (Round all numbers to the nearest dollar). Label journal entries a through t.
P- On 2,1, 2018, Czar rented a portion of one store to Pellston Inc. The contract was for 15 months and Czar required all of the cash up front. The rent is being earned equally each month. This is the only item in which rent is being earned by the company.
Q- Czar started to lease some new retail space in 2018 and added shelving and fixtures to this leased space. Based on your review of invoices, the previous accountant capitalized the cost of fixtures but did not capitalize the shipping and installation costs of $2,815. These costs were expensed and recorded as a miscellaneous selling expense. Czar has decided to use double declining balance (DDB) depreciation for this item and to take a full year of depreciation in the year of acquisition. The leasehold improvements have a useful life of 15 years with a salvage value of $12,000.
R- Czar uses the FIFO Inventory Method in valuing inventory. The inventory balance of $340,000 was based on a physical count at 12/31/2018. Based on your analysis, you have noted that $10,000 of marketing games that belonged to Pellston Inc. was included in the account. You also note that $5,600 of goods shipped to Czar f.o.b. destination were in transit on December 31, 2018 and included in the physical count.
Czar Incorporated | ||||||
End of Period Worksheet | ||||||
For the Year Ended December 31, 2018 | ||||||
Unadjusted | Adjusted | |||||
Account Title | Trial Balance | Adjustments | Trial Balance | |||
DR | CR | DR | CR | DR | CR | |
Cash | 264,000 | - | ||||
Accounts Receivable | 555,984 | - | ||||
Allowance for Doubtful Accounts | - | 13,600 | ||||
Interest Receivable | - | - | ||||
Merchandise Inventory | 340,000 | - | ||||
Prepaid Insurance | - | - | ||||
LIFO Reserve | - | 25,600 | ||||
Prepaid Advertising | - | - | ||||
Prepaid Rent | 13,600 | - | ||||
Office Supplies | 4,800 | - | ||||
Note Receivable | 20,000 | |||||
Available for Sale Securities | 300,000 | - | ||||
Office Building | 3,000,000 | - | ||||
Accumulated Depreciation - Office Building | - | 70,000 | ||||
Storage Building | 1,020,000 | - | ||||
Accumulated Depreciation - Storage Building | - | - | ||||
Land | 600,000 | - | ||||
Leasehold Improvements | 180,000 | - | ||||
Accumulated Depreciation - Leasehold Improvements | - | - | ||||
Office Equipment | 260,000 | - | ||||
Accumulated Depreciation - Office Equipment | - | 52,000 | ||||
Patent | 120,000 | - | ||||
Accounts Payable | - | 276,000 | ||||
Sales Tax Payable | - | - | ||||
Salaries Payable | - | 113,600 | ||||
Payroll Taxes Payable | - | 20,000 | ||||
Interest Payable | - | - | ||||
Income Tax Payable | - | - | ||||
Unearned Rent Revenue | - | - | ||||
Loan Payable - First Trust | - | 520,000 | ||||
Loan Payable - Coldwell Bank | - | 1,600,000 | ||||
Common Stock | - | 520,000 | ||||
Additional Paid in Capital | - | 1,599,000 | ||||
Retained Earnings | - | 736,000 | ||||
Accumulated Other Comprehensive Income | - | 20,000 | ||||
Dividends | 67,800 | - | ||||
Sales | - | 3,622,560 | ||||
Sales Returns and Allowances | 33,800 | - | ||||
Sales Discounts | 15,400 | - | ||||
Cost of Goods Sold | 1,583,600 | - | ||||
Sales Salaries Expense | 349,120 | - | ||||
Office Salaries Expense | 219,200 | - | ||||
Advertising Expense | 12,800 | - | ||||
Depreciation Expense - Office Building | - | |||||
Depreciation Expense - Leasehold Improvements | - | - | ||||
Depreciation Expense - Office Equipment | - | - | ||||
Leasing Expense - Stores | 105,600 | - | ||||
Miscellaneous Selling Expense | 18400 | - | ||||
Research & Development Expense | 12,000 | |||||
Rent Expense - Storage Facility | - | - | ||||
Insurance Expense | 12,000 | - | ||||
Office Supplies Expense | 28,000 | - | ||||
Miscellaneous Administrative Expense | 7,336 | - | ||||
Rent Revenue | - | 60,000 | ||||
Interest Revenue on Note Receivable | - | - | ||||
Dividend Revenue on AFS Securities | - | 20,000 | ||||
Interest Expense | - | - | ||||
Bad Debt Expense | 28,000 | - | ||||
Amortization Expense | - | - | ||||
Income Tax Expense | - | - | ||||
Payroll Taxes Expense | 96,920 | - | ||||
Rebate Expense | - | - | ||||
Unrealized holding loss | - | - | ||||
Depreciation Expense-Storage Building | - | - | ||||
Loss on Impairment | - | - | ||||
Rebate Liability | - | - | ||||
Restricted Cash for Future Expansion | - | - | ||||
9,268,360 | 9,268,360 |