Unit 6 powerpoint

profileSkylerreybrasil
ManufacturingResults-Q4.xlsx

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