Balance Sheet:
The balance sheet concludes the assets invested in by the company as well as reports the liabilities and equity taken up thus showing the economic or financial status of the company.
Inventory:
Inventory refers to the stock or goods which will be sold in the near future and thus is an asset for the company. It comprises of the raw materials which are yet to be processed, the stock which is still going through the process of production and it also includes completed products that are ready for sale. Thus inventory is the biggest and the important source of income and profit for the business.
End inventory:
Period end inventory refers to the units remaining at the end of the fiscal year which are yet to be sold.
Current Assets:
It comprises of all the assets which gets converted into cash in less than a year. Example: inventory, other current assets, etcetera.
Inventory Turnover Ratio:
It depicts the fraction of inventory sold or used by the company within a fiscal year. It states a ratio which shows the number of times goods were sold during an accounting period which thereby states the productivity or the efficiency level of the company regarding the inventory which apparently is the biggest asset for the company.
Days’ sales in inventory:
It indicates the days taken up by the company to convert the stock items into actual sales.
1.
Amount of inventories as a part of current assets on September 26, 2015 and on September 27, 2014.
Explanation of Solution
- The ending inventory as a part of the current assets as on September 26, 2015 accounts for $2,349.
- And the ending inventory as a part of the current assets as on September 27, 2014 accounts for $2,111.
2.
To compute: Inventories as a percentage of total assets on September 26, 2015 and.
September 27, 2014.
2.
Explanation of Solution
Given info,
2015
The ending inventory is $2,349.
Total assets account for $290,479.
2014
The ending inventory is $2,111.
Total assets accounts for $231,839.
Inventory as a percentage of total assets as on September 26, 2015:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,349 for inventory and $290,479 for total assets.
Therefore, the inventory as a percentage of total assets as on September 26, 2015 is 0.81%.
Inventory as a percentage of total assets as on September 27, 2014:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,111 for inventory and $231,839 for total assets.
Therefore, the inventory as a percentage of total assets as on September 27, 2014 is 0.91%.
3.
To explain: Relative size of inventories compared to its other types of assets.
3.
Explanation of Solution
- The inventory in both the years accounts for very low amount as compared to other assets of the company.
- Long-term marketable securities comparatively is very high than the inventory.
- Whereas,
goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
The accounting method used to compute inventory amounts.
4.
Explanation of Solution
The company accounts inventory as per the lower of cost or market (LCM) approach. The notes to statement also mention that the method of
5.
To compute: Inventory turnover and days’ sales in inventory for the year ended September 26, 2015.
5.
Explanation of Solution
Given info,
Cost of sales is $140,089.
The ending inventory is $2,349.
A’s inventory turnover:
Computation of the inventory turnover for 2015:
Formula to calculate the inventory turnover is,
Substitute $140,089 for cost of sales (given) and $2,230 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 62.8 times.
Working Notes:
Calculation of the average inventory,
A’s days’ sales in inventory:
Formula to calculate the days’ sales in inventory is,
Substitute $2,349 for ending inventory (given) and $140,089 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 6.12 days.
6.
Information for the year ended September 26, 2015.
6.
Explanation of Solution
Given info,
2016
The ending inventory is $2,132.
The total assets are $321,686.
The cost of sales is $131,376.
2017
The ending inventory is $4,855.
The total assets are $375,319
The cost of sales is $141,048.
Year 2016
1.
Ending inventory
Ending inventory as on September 24, 2016 amounts to $2,132.
2.
Inventory as a percentage of total assets as on September 24, 2016:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,132 for inventory and $321,686 for total assets.
Therefore, the inventory as a percentage of total assets as on September 24, 2016 is 0.66%.
3.
Inventory relative size compared to other assets
- The inventory in both the years accounts for very low amount as compared to other assets of the company.
- Long-term marketable securities comparatively is very high than the inventory.
- Whereas goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
Method of inventory valuation:
- The company accounts inventory as per the lower of cost or market (LCM) approach.
- The notes to statement also mention that the method of inventory valuation used is first in, first out method. The inventory mainly consists of the finished goods.
5.
A’s inventory turnover:
Computation of the inventory turnover for 2016:
Formula to calculate the inventory turnover is,
Substitute $131,376 for cost of sales (given) and $2,240.5 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 58.64 times.
Working notes:
Calculation of the average inventory,
A’s days’ sales in inventory:
Formula to calculate the days’ sales in inventory is,
Substitute $2,132 for ending inventory (given) and $131,376 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 5.92 days.
Year 2017
1.
Ending inventory
Ending inventory as on September 30, 2017 amounts to $4,855.
2.
Inventory as a percentage of total assets as on September 30, 2017:
Formula to calculate inventory as a percentage of total assets is,
Substitute $4,885 for inventory and $375,319 for total assets.
Therefore, the inventory as a percentage of total assets as on September 30, 2017 is 1.3%.
3.
Inventory relative size compared to other assets
The inventory in both the years accounts for low amount as compared to other assets of the company but has increased comparatively and is more than the intangible assets. Whereas goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
Method of inventory valuation:
The company accounts inventory as per the lower of cost or market (LCM) approach. The notes to statement also mention that the method of inventory valuation used is first in, first out method. The inventory mainly consists of the finished goods.
5.
A’s inventory turnover:
Computation of the inventory turnover for 2017:
Formula to calculate the inventory turnover is,
Substitute $141,048 for cost of sales (given) and $3,493.5 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 40.3 times.
Working Notes:
1. Calculation of the average inventory:
A’s days’ sales in inventory:
Computation of the days’ sales in inventory for 2017:
Formula to calculate the days’ sales in inventory is,
Substitute $4,855 for ending inventory (given) and $141,048 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 12.56 days.
Observation:
- Inventory as a percentage of total assets has fallen over the years though in the year 2017 it has shown a rise trend.
- In the year 2017 the company has been most efficient as per the inventory turnover when compared to the previous years.
- Whereas in case of days’ sales in inventory the results suggests that the company in the year 2017 held inventory in store for a bit longer time whereas it is least in the year 2016.
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCIAL ACCT.FUNDAMENTALS <CUSTOM LL>
- Bannister Company, an electronics firm, buys circuit boards and manually inserts various electronic devices into the printed circuit board. Bannister sells its products to original equipment manufacturers. Profits for the last two years have been less than expected. Mandy Confer, owner of Bannister, was convinced that her firm needed to adopt a revenue growth and cost reduction strategy to increase overall profits. After a careful review of her firms condition, Mandy realized that the main obstacle for increasing revenues and reducing costs was the high defect rate of her products (a 6 percent reject rate). She was certain that revenues would grow if the defect rate was reduced dramatically. Costs would also decline as there would be fewer rejects and less rework. By decreasing the defect rate, customer satisfaction would increase, causing, in turn, an increase in market share. Mandy also felt that the following actions were needed to help ensure the success of the revenue growth and cost reduction strategy: a. Improve the soldering capabilities by sending employees to an outside course. b. Redesign the insertion process to eliminate some of the common mistakes. c. Improve the procurement process by selecting suppliers that provide higher-quality circuit boards. Required: 1. State the revenue growth and cost reduction strategy using a series of cause-and-effect relationships expressed as if-then statements. 2. Illustrate the strategy using a strategy map. 3. Explain how the revenue growth strategy can be tested. In your explanation, discuss the role of lead and lag measures, targets, and double-loop feedback.arrow_forwardThe Home Depot is a leading specialty retailer of hardware and home improvement products and is the second-largest retail store chain in the United States. It operates large warehouse-style stores. Despite declining sales and difficult economic conditions in 20X1 and 20X2, The Home Depot continued to invest in new stores. The following table provides summary hypothetical data for The Home Depot. REQUIRED a. Use the preceding data for The Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in 20X2. b. Assume that The Home Depot will add 100 new stores by the end of Year +1. Use the data from 20X2 to project Year +1 sales revenues, capital spending, and ending inventory. Assume that each new store will be open for business for an average of one-half year in Year +1. For simplicity, assume that in Year +1, Home Depots sales revenues will grow, but only because it will open new stores.arrow_forwardBryce Company manufactures pet supplies. However, Bryces electronic accounting system recently crashed and, unfortunately, only a partial recovery of the companys year-end accounting records (which included several profitability ratios) was possible. As a result, Bryces controller, a bright young CMA named Jeanette, must compute various lost financial account balances using the recovered information listed below. Long-term liabilities: 1,500,000 Ending inventory is the same as beginning inventory. Gross margin: 3,000,000 Net sales: 8,000,000 Accounts receivable turnover: 50 Ending accounts receivable is the same as beginning accounts receivable. Total liabilities: 2,000,000 Current ratio: 2.5 Cash: 600,000 Quick ratio: 2.0 Inventory turnover in days: 3.65 Required: 1. Calculate current liabilities. 2. Calculate current assets. 3. Calculate average accounts receivable 4. Calculate marketable securities. 5. Calculate average inventory.arrow_forward
- Diamond Computers, which is owned and operated by Dale Diamond, manufactures and sells different types of computers. The company has reported profits every year since its inception in 2002 and has applied for a bank loan near the end of 2021 to upgrade manufacturing facilities. These upgrades should significantly boost future productivity and profitability. In preparing the financial statements for the year, the chief accountant, Sandy Walters, mentions to Dale that approximately $80,000 of computer inventory has become obsolete and a write-down of inventory should be recorded in 2021. Dale understands that the write-down would result in a net loss being reported for company operations in 2021. This could jeopardize the company’s application for the bank loan, which would lead to employee layoffs. Dale is a very kind, older gentleman who cares little for his personal wealth but who is deeply devoted to his employees’ well-being. He truly believes the loan is necessary for the company’s…arrow_forwardThom Lutz started a retail clothing business two years ago. Lutz’s first year was very successful, but sales dropped 50 percent in the second year. A friend who is a business consultant analyzed Lutz’s business and came up with two basic reasons for the decline in sales: (1) Lutz has been placing orders late in each season, and (2) shipments of clothing have been arriving late and in poor condition. What measures can Lutz take to improve his business and persuade customers to return?arrow_forwardXYZ Bakery's general manager was puzzled by the results of the income statement for the month which showed a net loss for the bakery. The owner is puzzled because of the volume of customers who flood the bakery each day for baked goods. The owner calculated the cost of direct materials and direct labor and was sure the prices were set right and overhead was estimated based on prior year expenses. How is it possible that volumes could be high but the store could lose money? What are other factors the owner should consider to make sure next year's financial statements report net income?arrow_forward
- Sizemo Elektroniks sells semiconductors that are used in games and small toys. The company has been extremely successful in recent years, recording an increase in earnings each of the past six quarters. At the end of the current quarter, Jay Shulz, the company's staff accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Hayden X537 model had not changed during the quarter. Jay confirmed his calculation with the inventory control manager, who indicated that sales of the Hayden 537X had stopped when the Hayden 637X semiconductor was released early in the quarter. Jay researched the issue further and found that the Hayden 637X semiconductor has the same applications as the Hayden 537X, but has more computing power and a lower cost than the 537X. Jay emailed this information to Tina Vereen, the chief financial officer, and recommended that the company apply the lower-of-cost-or-market method to the Hayden 537X semiconductors…arrow_forwardSizemo Elektroniks sells semiconductors that are used in games and small toys. The company has been extremely successful in recent years, recording an increase in earnings each of the past six quarters. At the end of the current quarter, Jay Shulz, the company’s staff accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Hayden 537X model had not changed during the quarter. Jay confirmed his calculation with the inventory control manager, who indicated that sales of the Hayden 537X had stopped when the Hayden 637X semiconductor was released early in the quarter. Jay researched the issue further and found that the Hayden 637X semiconductor has the same applications as the Hayden 537X, but has more computing power and a lower cost than the 537X. Jay e-mailed this information to Tina Vereen, the chief financial officer, and recommended that the company apply the lower-of-cost-or market method to the Hayden 537X semiconductors…arrow_forwardSizemo Elektroniks sells semiconductors that are used in games and small toys. The company has been extremely successful in recent years, recording an increase in earnings each of the past six quarters. At the end of the current quarter, Jay Shulz, the company’s staff accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Hayden 537X model had not changed during the quarter. Jay confirmed his calculation with the inventory control manager, who indicated that sales of the Hayden 537X had stopped when the Hayden 637X semiconductor was released early in the quarter. Jay researched the issue further and found that the Hayden 637X semiconductor has the same applications as the Hayden 537X, but has more computing power and a lower cost than the 537X. Jay e-mailed this information to Tina Vereen, thechief financial officer, and recommended that the company apply the lower-of-cost-ormarket method to the Hayden 537X semiconductors…arrow_forward
- Margie Johnson is a staff accountant at ToolEx Company, a manufacturer of tools and equipment. The company is under pressure from investors to increase earnings, and the president of the company expects the accounting department to "make this happen." Margie's boss, who has been a mentor to her, is concerned that if earnings do not increase, he will be terminated. Shortly after the end of the fiscal year, the company performs a physical count of the inventory. When Margie compares the physical count to the balance in the inventory account, she finds a significant amount of inventory shrinkage. The amount is so large that it will result in a significant drop in earnings this period. Margie's boss asks her not to make an adjusting entry for shrinkage this period. He assures her that he will get "caught up" on shrinkage in the next period, after the pressure is off to reach this period's earning goal. Margies boss asks her to do this as a personal favor for him. What should Margie…arrow_forwardIn the current year, Big Burgers, Inc., expanded its fast-food operations by opening several new stores in Texas. The company incurred the following costs in the current year: market appraisal ($50,000), consulting fees ($72,000), advertising ($47,000), and traveling to train employees ($31,000). The company is willing to incur these costs because it foresees strong customer demand in Texas for the next several years. What amount should Big Burgers report as an expense in its income statement associated with these costs?arrow_forwardElectronics, Inc. is a high-volume, wholesale merchandising company. Most of its inventory turns over four or five times a year. The company has had 50 units of a particular band of computers on hand for over a year. These computers have not sold and probably will not sell unless they are discounted 60 to 70%. The accountant is carrying them on the books at cost and intends to recognize the loss when they are sold. This way, she can avoid a significant write-down in inventory on the current year's financial statements. Is the accountant correct in her treatment of the inventory? Why or why not? can you help me explain this?arrow_forward
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning