Microsoft Excel 15.0 Answer Report
Worksheet: [P05_55.xls]Sheet1
Report Created: 17-11-2015 05:29:55
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
I

Microsoft Excel 15.0 Answer Report
Worksheet: [P06_42.xls]Sheet1
Report Created: 23-11-2015 03:49:03
Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
I

Microsoft Excel 15.0 Answer Report
Worksheet: [P06_52.xls]Sheet1
Report Created: 23-11-2015 08:18:21
Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
I

Microsoft Excel 15.0 Answer Report
Worksheet: [P06_56.xls]Sheet1
Report Created: 23-11-2015 08:41:22
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
I

Microsoft Excel 15.0 Answer Report
Worksheet: [P06_63.xls]Sheet1
Report Created: 23-11-2015 08:56:50
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
I

Inputs
Development cost
Cost for one night
Number of shows per week
Expected number of weeks
Selling Price
Average profit per ticket
Number of seats
Percentage of full seats
Number of filled seats
$5,000,000
$1,000
8
100
$50
$1.50
800
80% Profit by this t

Inputs
Renting cost
Variable cost
Fixed cost per month
Average charge
Number of copies per year
Number of working days
Daily demand
Number of copiers
Copies made
Total fixed cost
Total variable cost
Total cost
Total revenue
Profit
$5,000
$0.03
$400
$0.10

Inputs
Year
Cash flows
Discount rate
1
-$400.00
15%
NPV(beg)
NPV(end)
NPV(mid)
$430.91
$375.06
$431.01
Date range at beg of year
1/1/08
1/1/09
1/1/10
1/1/11
1/1/12
1/1/13
1/1/14
2
$200.00
Date range for mid year
6/30/08
6/30/09
6/30/10
6/30/11
6/30/12
6/3