WordDocDiff Results (All In One Report)

Date and Time:3/21/2002 1:42:29 PM

Master File: D:\Temp\SII\SOLVSAMP1.XLS
Source File: D:\Temp\SII\SOLVSAMP2.XLS

Compare File Results:
5 Change Found
0 Addition Found
0 Deletion Found

 #

[Master] D:\Temp\SII\SOLVSAMP1.XLS <------------> [Source] D:\Temp\SII\SOLVSAMP2.XLS

 #
Quick Tour of Microsoft Excel Solver Spreadsheet  
Month , Q1 , Q2 , Q3 , Q4 , Total  
Seasonality , 0.9 , 1.1 , 0.8 , 1.2  
,  
Units Sold , "3 , 592 " , "4 , 390 " , "3 , 192 " , "4 , 789 " , "15  
Sales Revenue , "$89 "$143 , 789 662 " , "$175 , 587 " , "$127 , 700 " , "$191 , 549 " , "$584 "$638  
Cost of Sales , "89 , 789 " , "109 , 742 " , "79 , 812 " , "119 , 718 " , "399  
Gross Margin , 0 "53 , 873 " , "65 , 845 " , "47 , 887 " , "71 , 831 " , "185 , 564 " "239  
,  
10  Salesforce , "8 , 000 " , "8 , 000 " , "9 , 000 " , "9 , 000 " , "34   10 
11  Advertising , "10 , 000 " , "10 , 000 " , "10 , 000 " , "10 , 000 " , "40   11 
12  Corp Overhead , "13 "21 , 468 549 " , "26 , 338 " , "19 , 155 " , "28 , 732 " , "87 "95   12 
13  Total Costs , "31 "39 , 468 549 " , "44 , 338 " , "38 , 155 " , "47 , 732 " , "161 "169   13 
14  ,   14 
15  Prod. Profit , "($31 "$14 , 468)" 324 " , "$21 , 507 " , "$9 , 732 " , "$24 , 099 " , "$23 "$69   15 
16  Profit Margin , -35% 10% , 12% , 8% , 13% , 4% 11%   16 
17  ,   17 
18  Product Price , $40.00   18 
19  Product Cost , $25.00   19 
20  ,   20 
21  The following examples show you how to work with the model above to solve for one value or several   21 
22  "values to maximize or minimize another value , enter and change constraints , and save a problem model."   22 
23  ,   23 
24  Row , Contains , , Explanation   24 
25  3 , Fixed values , , "Seasonality factor: sales are higher in quarters 2 and 4 , "   25 

WordDocDiff Results (Side By Side Report)

Date and Time:3/21/2002 1:33:38 PM

Master File: D:\Temp\SII\SOLVSAMP1.XLS
Source File: D:\Temp\SII\SOLVSAMP2.XLS

Compare File Results:
5 Change Found
0 Addition Found
0 Deletion Found

 # [Master] D:\Temp\SII\SOLVSAMP1.XLS [Source] D:\Temp\SII\SOLVSAMP2.XLS  #
Quick Tour of Microsoft Excel Solver   Quick Tour of Microsoft Excel Solver Spreadsheet  
Month , Q1 , Q2 , Q3 , Q4 , Total   Month , Q1 , Q2 , Q3 , Q4 , Total  
Seasonality , 0.9 , 1.1 , 0.8 , 1.2   Seasonality , 0.9 , 1.1 , 0.8 , 1.2  
,   ,  
Units Sold , "3 , 592 " , "4 , 390 " , "3 , 192 " , "4 , 789 " , "15   Units Sold , "3 , 592 " , "4 , 390 " , "3 , 192 " , "4 , 789 " , "15  
Sales Revenue , "$143 , 662 " , "$175 , 587 " , "$127 , 700 " , "$191 , 549 " , "$638   Sales Revenue , "$89 , 789 " , "$175 , 587 " , "$127 , 700 " , "$191 , 549 " , "$584  
Cost of Sales , "89 , 789 " , "109 , 742 " , "79 , 812 " , "119 , 718 " , "399   Cost of Sales , "89 , 789 " , "109 , 742 " , "79 , 812 " , "119 , 718 " , "399  
Gross Margin , "53 , 873 " , "65 , 845 " , "47 , 887 " , "71 , 831 " , "239   Gross Margin , 0 , "65 , 845 " , "47 , 887 " , "71 , 831 " , "185 , 564 "  
,   ,  
10  Salesforce , "8 , 000 " , "8 , 000 " , "9 , 000 " , "9 , 000 " , "34   Salesforce , "8 , 000 " , "8 , 000 " , "9 , 000 " , "9 , 000 " , "34   10 
11  Advertising , "10 , 000 " , "10 , 000 " , "10 , 000 " , "10 , 000 " , "40   Advertising , "10 , 000 " , "10 , 000 " , "10 , 000 " , "10 , 000 " , "40   11 
12  Corp Overhead , "21 , 549 " , "26 , 338 " , "19 , 155 " , "28 , 732 " , "95   Corp Overhead , "13 , 468 " , "26 , 338 " , "19 , 155 " , "28 , 732 " , "87   12 
13  Total Costs , "39 , 549 " , "44 , 338 " , "38 , 155 " , "47 , 732 " , "169   Total Costs , "31 , 468 " , "44 , 338 " , "38 , 155 " , "47 , 732 " , "161   13 
14  ,   ,   14 
15  Prod. Profit , "$14 , 324 " , "$21 , 507 " , "$9 , 732 " , "$24 , 099 " , "$69   Prod. Profit , "($31 , 468)" , "$21 , 507 " , "$9 , 732 " , "$24 , 099 " , "$23   15 
16  Profit Margin , 10% , 12% , 8% , 13% , 11%   Profit Margin , -35% , 12% , 8% , 13% , 4%   16 
17  ,   ,   17 
18  Product Price , $40.00   Product Price , $40.00   18 
19  Product Cost , $25.00   Product Cost , $25.00   19 
20  ,   ,   20 
21  ,   ,   21 
22  You can also use Solver to solve for several values at once to maximize or minimize another value. For   You can also use Solver to solve for several values at once to maximize or minimize another value. For   22 
23  "example , you can solve for the advertising budget for each quarter that will result in the best profits for"   "example , you can solve for the advertising budget for each quarter that will result in the best profits for"   23 
24  the entire year. Because the seasonality factor in row 3 enters into the calculation of unit sales in row 5   the entire year. Because the seasonality factor in row 3 enters into the calculation of unit sales in row 5   24 
25  "as a multiplier , it seems logical that you should spend more of your advertising budget in Q4 when the "   "as a multiplier , it seems logical that you should spend more of your advertising budget in Q4 when the "   25