Fig8-6 v2 optimal

Fig8-6 v2 optimal - 0.00 Purchasing Analysis Page 2 Annual...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Fig8-6.xls]Purchasing Analysis Report Created: 10/15/2008 8:05:50 PM Target Cell (Min) Cell Name Original Value Final Value $D$9 Order Quantity 2000.00 1.00 Adjustable Cells Cell Name Original Value Final Value $D$9 Order Quantity 2000.00 1.00 Constraints Cell Name Cell Value Formula Status Slack $D$9 Order Quantity 1.00 $D$9>=1 Binding
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.00 Purchasing Analysis Page 2 Annual Demand 24,000 Cost per Unit $35 Cost per Order $50 Holding Cost 18% Order Quantity 617.21 Purchasing Cost $840,000 Cost of Ordering $1,944 Inventory Cost $1,944 Total Cost $843,888 MetroBank Minimize: D14 By changing: D9 Subject to: D9>=1 A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
View Full Document

This note was uploaded on 04/19/2011 for the course CBA 0060 taught by Professor Barrymitnick during the Spring '09 term at Pittsburgh.

Page1 / 2

Fig8-6 v2 optimal - 0.00 Purchasing Analysis Page 2 Annual...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online