The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air- conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: Sales (total quarter): United states Canada Europe Cost of goods sold (total quarter) Raw materials at the Louisville plant (end-of-quarter) Work-in-process and finished goods at the Louisville plant (end-of-quarter) Distribution center inventory (end-of-quarter): United states Canada Europe QUARTER 1 (JANUARY THROUGH MARCH) 438 154 49 494 84 156 56 16 7 QUARTER 3 (JULY THROUGH JUNE) SEPTEMBER) All amounts in millions of U.S. dollars QUARTER 2 (APRIL THROUGH 388 142 34 435 53 118 38 13 6 552 90 23 517 81 145 46 19 9 QUARTER 4 (OCTOBER THROUGH DECEMBER) a. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) 438 95 21 433 83 315 55 21 7 b. If you were given the assignment to increase inventory turnover, what would you focus on? O Reduce the amount of inventory or reduce sales or both O Reduce the amount of inventory or increase sales or both O Increase the amount of inventory or increase sales or both c. The company reported that it used $500M worth of raw material during the year. On average, how many weeks of supply of raw material are on hand at the factory? (Round your answer to 2 decimal places.) The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air- conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: Sales (total quarter): United states Canada Europe Cost of goods sold (total quarter) Raw materials at the Louisville plant (end-of-quarter) Work-in-process and finished goods at the Louisville plant (end-of-quarter) Distribution center inventory (end-of-quarter): United states Canada Europe QUARTER 1 (JANUARY THROUGH MARCH) 438 154 49 494 84 156 56 16 7 QUARTER 3 (JULY THROUGH JUNE) SEPTEMBER) All amounts in millions of U.S. dollars QUARTER 2 (APRIL THROUGH 388 142 34 435 53 118 38 13 6 552 90 23 517 81 145 46 19 9 QUARTER 4 (OCTOBER THROUGH DECEMBER) a. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) 438 95 21 433 83 315 55 21 7 b. If you were given the assignment to increase inventory turnover, what would you focus on? O Reduce the amount of inventory or reduce sales or both O Reduce the amount of inventory or increase sales or both O Increase the amount of inventory or increase sales or both c. The company reported that it used $500M worth of raw material during the year. On average, how many weeks of supply of raw material are on hand at the factory? (Round your answer to 2 decimal places.)
Expert Answer:
Answer rating: 100% (QA)
a To calculate the average inventory turnover for the firm we need to divide the cost of goods sold ... View the full answer
Related Book For
Operations and Supply Chain Management
ISBN: 978-0078024023
14th edition
Authors: F. Robert Jacobs, Richard Chase
Posted Date:
Students also viewed these general management questions
-
U. S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air- conditioning systems. These filters are made in a single plant located in...
-
In this thread, you will create a 1 5 0 word minimum post and a 1 0 0 word minimum reply dealing with your assigned employment law topic currently in the news. The links below take you to a simple...
-
According to Hostels.com. The average room rate for a New York City hotel was $204 in 2011. Suppose the Chamber of Commerce of New York City would like to test if this rate has changed recently by...
-
Explicitly show that the integration of Eq. (9.1.35) yields the j surface forces given by Eq. (9.1.36)?
-
In Chapter 16, the formula for the optimal order quantity of an item, Q, given its demand, D, ordering cost, Co, and the cost of holding, or carrying, an item in inventory, Cc, is as follows: The...
-
A \(0.50-\mathrm{kg}\) wood block slides \(0.50 \mathrm{~m}\) on a horizontal floor before colliding elastically with a wall and reversing its direction of travel. If the block has an initial speed...
-
On January 1, 2017, Eddy Corporation had retained earnings of $650,000. During the year, Eddy had the following selected transactions. 1. Declared cash dividends................... $120,000. 2....
-
i. As at 30th June 2013, the following information was available from the records of SGR Limited. ii. Acheque of sh 2,720,000 drawn on 30th June was presented to the bank for payment on 16th July,...
-
How might one employee coach or train another employee by use of Twitter and text messaging?
-
(12 33) Find a least-squares solution of the system Ax=bifA= 31 -2 and ()- 12 1 2 b= 231 35
-
Sean and Evan are seling rol's of wrapping paper to raise maney for new foothal uniforms. Evan has sold seven more than one-half the number of rolls that sean has. Ir they have sold a total of 121...
-
An assignment instruction on how to evaluate a financial annual report for any chosen company is: 1. Choose a company that you are interested in and find its most recent annual report online. You can...
-
The database system should be designed to support the business goals and objectives of the organization. An important part of ensuring that this occurs involves the level of initial and ongoing...
-
Harlan Enterprises manufactures smartphones. Currently, Harlan has $14,000 in raw materials and $25,000 in finished goods in its warehouse. It also has $18,600 in work-in-process goods on its...
-
Silvestri's Steak and Seafood is an exquisite, fine dining restaurant off Broadway in NYC. Customers often spend $180 or more per plate for the food and ambience! For an enterprise like this,...
-
Laura's adopted son Jack is 12. He is a citizen of the United States and lived with Laura for the entire tax year, during which time Laura provided full financial support. Is Jack a qualifying child...
-
Should U.S. antidumping laws be stated in terms of average total costs or average variable costs?
-
Management may choose to build up capacity in anticipation of demand or in response to developing demand. Cite the advantages and disadvantages of both approaches.
-
Suppose that AlwaysRain Irrigations marketing department will undertake an intense ad campaign for the bronze sprinklers, which are more expensive but also more durable than the plastic ones....
-
Daves Auto Supply custom mixes paint for its customers. The shop performs a weekly inventory count of the main colors that are used for mixing paint. Determine the amount of white paint that should...
-
Two dice are rolled. The red die has been loaded. Its probabilities are \(P(1)=P(2)=P(3)=P(4)=\frac{1}{5}\) and \(P(5)=P(6)=\frac{1}{10}\). The green die is fair. Let the event \(A\) be the sum of...
-
Suppose there is a medical screening procedure for a specific cancer that has sensitivity \(=.90\), and specific city \(=.95\). Suppose the underlying rate of the cancer in the population is .001 ....
-
Suppose there is a medical diagnostic test for a disease. The sensitivity of the test is .95 . This means that if a person has the disease, the probability that the test gives a positive response is...
Study smarter with the SolutionInn App