Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

excel for operation management, Exercises of Management Information Systems

it is excel for data in operation management

Typology: Exercises

2019/2020

Uploaded on 10/01/2021

trang-pham-5
trang-pham-5 🇺🇸

1 document

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1

Partial preview of the text

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