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 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:
The company reported that it used $579.4M 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.)
QUARTER 1 QUARTER 3 QUARTER 4 QUARTER 2 (JANUARY (JULY (OCTOBER (APRIL THROUGH THROUGH THROUGH THROUGH JUNE) MARCH) SEPTEMBER) DECEMBER) All amounts in millions of u.s. dollars Sales (total quarter): United states Canada Europe 422 91 74 480 125 35 460 101 41 376 94 18 Cost of goods sold (total quarter) 417 456 432 352 Raw materials at the Louisville plant (end-of-quarter) 67 44 82 83 Work-in-process and finished goods at the Louisville plant (end-of-quarter) 108 121 141 191 Distribution center inventory (end-of-quarter): United states Canada Europe 60 15 ܘ ܗ ܗ 39 17 7 46 16 10 ܘ ܩ ܩ мол 58 26 7
U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!