Homework 4 problem 8 PRINT

Homework 4 problem 8 PRINT - 14000 $D$6<=$F$6...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Homework 4 problem 8.xlsx]Sheet1 Report Created: 10/11/2010 8:40:26 PM Target Cell (Max) Cell Name Original Value Final Value $B$11 Profit Condos  $64,000.00   $67,000.00  Adjustable Cells Cell Name Original Value Final Value $B$9 Condos Condos 5 5 $B$10 Land Condos 4 4.5 Constraints Cell Name Cell Value Formula Status Slack $D$5 Cost per investment Invested 485000 $D$5<=$F$5 Not Binding 15000 $D$6 Maintance and upkeep per unit Invested
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: 14000 $D$6&lt;=$F$6 Binding $B$9 Condos Condos 5 $B$9=integer Binding $B$10 Land Condos 4.5 $B$10&gt;=0 Not Binding 4.5 Investment Investments Condos Land Profit per investme 8000 6000 Invested Constraint Budget Cost per investme 70000 30000 485000 &lt;= 500000 Maintance and upk 1000 2000 14000 &lt;= 14000 Investment decisions Condos 5 Acres of Land 4.5 Profit $67,000.00...
View Full Document

Page1 / 2

Homework 4 problem 8 PRINT - 14000 $D$6&amp;amp;lt;=$F$6...

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