Unit 6 powerpoint
Inventory Position
| Inventory Position - Number of Units | |||||||
| Brand | Starting Inventory | Units Produced | Available Inventory | Net Demand | Units Sold | Lost Sales Due to Stock-Outs | Ending Inventory |
| M4X Next | 0 | 1,706 | 1,706 | 3,086 | 1,706 | 1,380 | 0 |
| M4X Elite | 0 | 844 | 844 | 1,527 | 844 | 683 | 0 |
| M4X Supermax | 0 | 635 | 635 | 1,148 | 635 | 513 | 0 |
| Total | 0 | 3,185 | 3,185 | 5,761 | 3,185 | 2,576 | 0 |
| End of Worksheet |
Production Costs per Unit
| Production Costs per Unit | |||||
| Brand | Units Produced | Direct Materials | + Direct Labor | + Total Overhead | = Production Average |
| M4X Next | 1,706 | 1,461 | 307 | 56 | 1,824 |
| M4X Elite | 844 | 1,503 | 307 | 56 | 1,866 |
| M4X Supermax | 635 | 1,910 | 307 | 56 | 2,273 |
| End of Worksheet |
Inventory Position - Cost Unit
| Inventory Position - Cost / Unit | ||||
| Brand | Starting Inventory Average Cost / Unit | Production Average Cost / Unit | Average Costs per Unit of Goods Sold | Ending Inventory Average Costs / Unit |
| M4X Next | 1,508 | 1,824 | 1,824 | 1,824 |
| M4X Elite | 1,511 | 1,866 | 1,866 | 1,866 |
| M4X Supermax | 0 | 2,273 | 2,273 | 2,273 |
| End of Worksheet |
Operating Capacity Utilization
| Operating Capacity Utilization | |
| Operating Capacity | Value |
| Unspecified String totalOC | 3,185 |
| Used operating capacity | 3,185 |
| Operating capacity utilization | 100 |
| Excess Capacity | |
| Unused operating capacity | 0 |
| Excess operating capacity | 0 |
| Overhead costs and labor charged to excess operating capacity | 0 |
| End of Worksheet |