Question Completion:
Production Information
Primary Units Unit
Name Segment Sold Inventory
Baker Trad 1,391 898
Bead Low 1,899 873
Bid High 212 558
Bold Pfmn 572 108
Buddy Size 483 0
Answer:
1. Number of months of additional inventory that was produced for each product:
Primary Units Unit Number of
Name Segment Sold Inventory Months of inventory
Baker Trad 1,391 898 7.75 (898/1,391 * 12)
Bead Low 1,899 873 5.52 (873/1,899 * 12)
Bid High 212 558 31.58 (558/212 * 12)
Bold Pfmn 572 108 2.27 (108/572 * 12)
Buddy Size 483 0 0 (0/483 * 12)
2. Team Baldwin's forecasting skills are lacking in exactness and require more refining.
3. The product that had the best unit forecast is Bold with less than 3 months of inventory at the end of the year (2.27 months).
Explanation:
a) Data and Calculations:
Production Information
Primary Units Unit Number of
Name Segment Sold Inventory Months of inventory
Baker Trad 1,391 898 7.75 (898/1,391 * 12)
Bead Low 1,899 873 5.52 (873/1,899 * 12)
Bid High 212 558 31.58 (558/212 * 12)
Bold Pfmn 572 108 2.27 (108/572 * 12)
Buddy Size 483 0 0 (0/483 * 12)
