Question: Worksheet 4: Measuring Supply Chain Performance; Inventory Measures The cost of goods sold last year at ZIP Corporation was$3,069,000(i.e., annual sales, at cost). The company
Worksheet 4: Measuring Supply Chain Performance; Inventory Measures The cost of goods sold last year at ZIP Corporation was$3,069,000(i.e., annual sales, at cost). The company operates 48 weeks per year (it shuts down for a 4-week planned vacation period every summer). ZIP carries 10 items in its inventory: 4 raw materials, 3 WIP items, and 3 finished goods. The table below shows last year's average inventory level, by part number or SKU, along with its value. This table is available in the Excel file; "ZIP Corporation - Inventory Measures". What are the average weekly sales, at cost? What is the average aggregate inventory value? How many weeks of supply does ZIP maintain? What was the inventory turnover last year? The best inventory turnover in ZIP's industry is 5.0. What should the company do?
Step by Step Solution
There are 3 Steps involved in it
Okay lets dive into the analysis for ZIP Corporations inventory measures 1 Average Weekly Sales at Cost Total Cost of Goods Sold Last Year 3069000 Num... View full answer
Get step-by-step solutions from verified subject matter experts
