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
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started