Concept explainers
a)
To determine: Weeks of supply for Company A.
Introduction:
a)
Answer to Problem 6P
Weeks of supply for Company A is 3.85.
Explanation of Solution
Given information:
Company A | |
Net revenue | $16,500.00 |
Cost of sales | $13,500.00 |
Inventory | $1,000.00 |
Total assets | $8,600.00 |
Formula to calculate week of supply:
Calculation of week of supply:
Sale per week is calculated by dividing the annual sales with the number of weeks in a year. Annual sales $13,500 is divided with 52 which give $259.60.
Week of supply is calculated by dividing inventory with sales per week. The inventory $1,000 is divided with $259.60 yields 3.85 as weeks of supply for company A.
Hence, weeks of supply for Company A is 3.85.
b)
To determine: Percentage of assets committed to inventory in Company A.
b)
Answer to Problem 6P
Answer: 11.63% of total assets of Company A is committed to inventory.
Explanation of Solution
Given information:
Company A | |
Net revenue | $16,500.00 |
Cost of sales | $13,500.00 |
Inventory | $1,000.00 |
Total assets | $8,600.00 |
Formula to inventory investment:
Calculation of inventory investment:
Percentage of assets committed to inventory can be calculated by computing inventory investment. Inventory investment is calculated by dividing inventory with the total assets. The inventory $1,000 is divided with total assets $8,600 which yields 11.63% of assets of Company A is committed to inventory.
Hence, 11.63% of total assets of Company A are committed to inventory.
c)
To determine: Inventory turnover of Company A.
c)
Answer to Problem 6P
The turnover of Company B is 13.5.
Explanation of Solution
Given information:
Company A | |
Net revenue | $16,500.00 |
Cost of sales | $13,500.00 |
Inventory | $1,000.00 |
Total assets | $8,600.00 |
Formula to calculate turnover:
Calculation of turnover:
The turnover is calculated by dividing cost of sales with inventory. The cost of sales $13,500 is divided with inventory $1,000 which yields turnover of 13.5 for company A.
Hence, the turnover of Company A is 13.5.
d)
To Compare: Performance of Company A with industry leaders.
d)
Answer to Problem 6P
Company A needs to improve its performance.
Explanation of Solution
Given information:
Company A | Company B | |
Net revenue | $16,500.00 | $27,500.00 |
Cost of sales | $13,500.00 | $21,500.00 |
Inventory | $1,000.00 | $1,250.00 |
Total assets | $8,600.00 | $16,600.00 |
Formula:
Comparison calculation of turnover and inventory investment:
Company A | Company B | |
Net revenue | $16,500.00 | $27,500.00 |
Cost of sales | $13,500.00 | $21,500.00 |
Inventory | $1,000.00 | $1,250.00 |
Total assets | $8,600.00 | $16,600.00 |
Turn over | 13.5 | 17.2 |
Inventory investment | 11.63% | 7.53% |
From the above calculation of turnover and inventory investment it can be inferred that Company A has a turnover of 13.5 when the turnover of Company B is 17.2. The inventory investment of Company A is 11.63% when the Company B has 7.53%.
In both the aspects, Company B is far ahead of Company A. So, the performance of Company A has to be better and the management team must look into the aspects to improve the performance.
Hence, Company A needs to improve its performance.
Want to see more full solutions like this?
Chapter 11 Solutions
Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+)
- The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.arrow_forwardMattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.53 million and inventory was $1.49 million. This year, costs of goods sold is $8.61 million and inventory investment is $1.58 million. a) What was its weeks of supply last year? weeks (round your response to two decimal places). b) What is its weeks of supply this year? weeks (round your response to two decimal places). c) Is Mattress Wholesalers making progress in its inventory reduction effort? Since the number of weeks that cover the supply has V, Mattress Wholesalers is making V in its inventory-reduction effort.arrow_forwardMattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.50 million and inventory was $1.50 million. This year, costs of goods sold is $8.60 million and inventory investment is $1.60 million. a) What was its weeks of supply last year? weeks (round your response to two decimal places). weeks (round your response to two decimal places). b) What is its weeks of supply this year? c) Is Mattress Wholesalers making progress in its inventory reduction effort? Since the number of weeks that cover the supply has Mattress Wholesalers is making no progress in its inventory-reduction effort. negative progress progressarrow_forward
- Use information in the case study and critically examine the process of receiving materials at the warehouse in a Retail. Enterprise in the Far South of Santa Catarina. Include relevant examples to support your answer.arrow_forwardMattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.48 million and inventory was $1.53 million. This year, costs of goods sold is $8.57 million and inventory investment is $1.64 million. a) What was its weeks of supply last year? weeks (round your response to two decimal places). b) What is its weeks of supply this year? c) Is Mattress Wholesalers making progress in its inventory reduction effort? Since the number of weeks that cover the supply has weeks (round your response to two decimal places). Mattress Wholesalers is making in its inventory-reduction effort.arrow_forwardMattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.52 million and inventory was $1.47 million. This year, costs of goods sold is $8.59 million and inventory investment is $1.57 million. a) What was its weeks of supply last year? (round your response to two decimal places).arrow_forward
- The bullwhip effect is used to describe how relatively small fluctuations in the market can cause increasing volatility further back in the chain. What is the main driver of this phenomenon O a. The creating of partnership relationships in the supply chain b. Collaborative Planning Forecasting and Replenishment (CPFR) C. Introduction of information systems linking all parts of the supply chain Od. The desire by the different links in the chain to manage their production rates and inventory levels sensibly.arrow_forwardArrow Distributing Corp. likes to track inventory by using weeks of supply as well as by inventory turnover. Arrow Distributing Corp. Net Revenue $16,100 Cost of sales $12,450 Inventory $1,100 Total assets $8,460 Part 2 a) What is its weeks of supply? enter your response here weeks (round your response to two decimal places). Part 3 b) What percentage of Arrow's assets are committed to inventory? enter your response here% (enter your response as a percentage rounded to two decimal places). Part 4 c) What is Arrow's inventory turnover? enter your response here times per year (round your response to two decimal places). Part 5 d) Suppose a manufacturer has an inventory turnover of 13.5 times per year. Arrow's supply chain performance relative to the manufacturer's, as measured by inventory turnover, is ▼ worse the same better .arrow_forwardMattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.46 million and inventory was $1.52 million. This year, costs of goods sold is $8.64 million and inventory investment is $1.61 million. a) What was its weeks of supply last year? Inventory Inventory = Sales per Week Cost of Sales/52 Weeks Weeks of Supply= - b) What is its weeks of supply this year? Inventory Inventory Sales per Week Cost of Sales/52 Weeks c) Is Mattress Wholesalers making progress in its inventory reduction effort? Since the number of weeks that cover the supply has Weeks of Supply = 10.60 (round your response to two decimal places). = 9.69 (round your response to two decimal places). F Mattress Wholesalers is making in its inventory-reduction effort.arrow_forward
- The bullwhip effect is used to describe how relatively small fluctuations in the market can cause increasing volatility further back in the chain. What is the main driver of this phenomenon a. The creating of partnership relationships in the supply chain b. Collaborative Planning Forecasting and Replenishment (CPFR) c. Introduction of information systems linking all parts of the supply chain d. The desire by the different links in the chain to manage their production rates and inventory levels sensibly.arrow_forwardMcMillan Sugar Limited is a supplier of sugar and other derivatives. The company wasestablished in 1931 in Eastern Europe and has since expanded to other parts of Europe, Asiaand America. The company has been growing steadily. From 1940 to 1985, the companyregistered 1.5 Trillion US dollars in revenues. These revenues were mainly generated throughthe genius design of its supply chain. The company managed to secure a constant supply ofsugar cane by co-opting major sugar cane producers (farmers) to become shareholders in thecompany. This enabled the company to control the inflation of sugar cane price. Indeed, themajor farmers were not willing to increase the price of sugar cane, which would have anadverse effect on the company in which they were shareholders. McMillan Sugar Limitedbecame a leading brand in the sugar industry and in 2003 it was listed as the best performingcompany in the Eastern Europe. This success came as result of various strategic decisions.Firstly, the company…arrow_forwardMcMillan Sugar Limited is a supplier of sugar and other derivatives. The company wasestablished in 1931 in Eastern Europe and has since expanded to other parts of Europe, Asiaand America. The company has been growing steadily. From 1940 to 1985, the companyregistered 1.5 Trillion US dollars in revenues. These revenues were mainly generated throughthe genius design of its supply chain. The company managed to secure a constant supply ofsugar cane by co-opting major sugar cane producers (farmers) to become shareholders in thecompany. This enabled the company to control the inflation of sugar cane price. Indeed, themajor farmers were not willing to increase the price of sugar cane, which would have anadverse effect on the company in which they were shareholders. McMillan Sugar Limitedbecame a leading brand in the sugar industry and in 2003 it was listed as the best performingcompany in the Eastern Europe. This success came as result of various strategic decisions.Firstly, the company…arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningContemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning