excel for operation management, Exercises of Management Information Systems

Download excel for operation management and more Exercises Management Information Systems in PDF only on Docsity!

Part 1 - Indicators Home Depot Lowe's End of fiscal year (date) 1/31/21 1/29/21 Net sales (NS, millions of $) $132,110 $89,597 Cost of goods sold (COGS, millions of $) $87,257 $60,025 Gross profit (GP, millions of $) $44,853 $29,572 Merchandise Inventory (INV, millions of $) $16,627 $16,193 Gross profit margin (GPM, %, 2 decimals) 33.95% 33.01% Annual inventory cost rate (AIHCR, %, 2 decimals) 25% 25% Part 2 - Inventory Turns Home Depot Lowe's Inventory duration (days, 2 decimals) 69.55 98.47 Inventory turns (turns per year, 2 decimals) 5.25 3.71 Part 3 - Inventory Cost Home Depot Lowe's Cost of a cordless drill (C, $) $90 $90 Per-unit inventory holding cost rate (PUIHCR, %, 2 decimals) 4.76% 6.74% Inventory holding cost (HC, $) $4.29 $6.07 Inventory holding cost difference (Lowes - Home Depot, $) 5.73 Gross profit (GP-item, $) $46.26 $44.34 Immediate gross profit (IGP, $) $41.98 $38.27 Expected Selling Price $136.26 $134.34