How to use Gross Margin before VC to calculate for Sales Mix Variance and Sales Qty Variance?
Exhibit 7a (continued) INCOME STATEMENT (cont.) AR $ 000s 2004 Monthly Results 2004 Annual Results Jan Feb Mar Apr May June Year-to-Date Year-End Projections Actual Budget Var. Actual Budget Var. Forecast Budget Var. Gross Margin before Variable Costs 1,665 1,712 2,019 2,099 2,200 2,386 2,311 103% 12,080 11,631 104% 29,359 28,923 102% CDs & Cassettes 912 856 940 929 900 894 1,069 84% 5,430 5,738 95% 12,796 15,018 85% Videos (DVD & VHS) 103 155 196 227 194 221 197 112% 1,095 775 141% 2,746 2,325 118% Electronics 163 206 303 336 442 494 382 129% 1,945 1,488 131% 5,063 3,648 139% Hardware 38 46 124 115 120 159 101 158% 602 514 117% 1,384 1, 129 123% Software 71 76 80 86 93 102 87 118% 507 432 117% 1,226 1,128 109% Accessories 259 243 283 292 312 360 312 116% 1,751 1,781 98% 4,100 3,738 110% Books 119 129 93 107 125 139 164 85% 713 904 79% 1,790 1,937 92% Extended Warranties 7 13 16 36 238 Tickets 1 1 2 16 % of Revenues 21.4% 20.6% 19.6% 19.6% 18.4% 18.1% 19.6% 19.4% 20.3% 19.4% 20.5%SALES DETAIL 2004 Monthly Results 2004 Annual Results Jan Feb Mar Apr May June Year-to-Date Actual Budget Var. Actual Budget Var. Units Sold 495,834 494,666 541,460 575,522 581,763 598,342 641,695 93% 3,287,545 3,494,250 94% CDs & Cassettes 270,501 268,602 275,869 283,463 267, 180 277,952 290,000 96% 1,643,567 1,635,000 101% Videos (DVD & VHS) 31,360 27,402 32,276 38,469 45,780 56,906 53,578 106% 232,229 208,011 112% Electronics 6,772 7,182 9,835 10,910 11,539 17, 180 13,578 127% 63,517 59,055 108% Hardware 1,358 1,692 3,432 3,668 3,701 4,064 2,858 142% 18,042 14,623 123% Software 19,971 20, 130 24,773 27,828 29,668 29,792 26,734 111% 151,795 130,962 116% Accessories 125,763 127,728 146,703 156,559 165,229 168,705 205,910 82% 890,690 1,172,822 76% Books 40, 108 39,215 33,097 36,066 38,400 41,693 49,038 85% 228,642 273,777 84% Extended Warranties 405 733 928 2,066 Tickets 2,715 15,474 18, 154 19,534 1,122 56,999 Average Unit Price (AR $) 15.7 16.8 19.0 18.6 20.6 22.1 18.4 120% 18.9 16.4 116% CDs & Cassettes 12.9 12.7 13.3 13.1 13.6 13.5 13.9 98% 13.2 13.6 97% Videos (DVD & VHS) 22.9 28.6 29.4 29.3 27.1 24.9 22.5 111% 26.9 23.3 115% Electronics 208.5 247.9 255.2 248.8 323.0 243.9 252.6 97% 257.2 221.5 116% Hardware 217.3 210.0 273.1 231.2 246.0 304.7 269.8 113% 254.1 265.1 96% Software 22.0 21.5 19.0 18.5 18.8 20.4 18.1 113% 19.9 18.7 107% Accessories 6.9 6.8 6.8 6.6 6.6 7.2 5.7 126% 6.8 5.7 120% Books 13.5 15.7 14.1 14.7 15.7 16.8 15.1 111% 15.1 14.9 101% Extended Warranties 62.3 62.5 63.3 62.8 Tickets 15.3 17.5 12.5 8.3 16.2 12.6INCOME STATEMENT AR $ 000s 2004 Monthly Results 2004 Annual Results Jan Feb Mar Apr May June Year-to-Date Year-End Projections Actual Budget Var. Actual Budget Var. Forecast Budget Var. Revenues 7,775 8,302 10,276 10,731 11,971 13,202 11,820 112% 62,257 57,256 109% 150,978 140,976 107% CDs & Cassettes 3,500 3,423 3,673 3,709 3,628 3,763 4,019 94% 21,696 22,261 97% 51,353 57,143 90% Videos (DVD & VHS) 719 782 950 1,127 1,239 1,419 1,207 118% 6,236 4,838 129% 16,299 14,052 116% Electronics 1,412 1,780 2,510 2,715 3,728 4,190 3,429 122% 16,334 13,083 125% 40,897 32,078 127% Hardware 295 355 937 848 910 1,238 771 161% 4,584 3,877 118% 10,513 8,570 123% Software 439 433 472 514 557 607 484 125% 3,022 2,447 124% 7,160 6,373 112% Accessories 869 871 394 1,036 1,097 1,206 1,166 103% 6,075 6,661 91% 14, 109 13,985 101% Books 542 615 468 531 604 701 743 94% 3,461 4,089 85% 8,620 8,774 98% Extended Warranties 25 46 59 130 848 Tickets 42 271 227 162 18 719 1, 179 COGS 6,110 6,590 8,257 8,632 9,772 10,816 9,508 114% 50,177 45,624 110% 121,618 112,053 109% CDs & Cassettes 2,588 2,567 2,733 2,780 2,728 2,869 2,950 97% 16,266 16,523 98% 38,557 42,125 92% Videos (DVD & VHS) 616 627 753 900 1,046 1, 198 1,010 119% 5,141 4,063 127% 13,553 11,727 116% Electronics 1,249 1,574 2,207 2,379 3,286 3,695 3,047 121% 14,389 11,596 124% 35,834 28,429 126% Hardware 257 309 814 733 790 1,079 671 161% 3,982 3,362 118% 9,129 7,441 123% Software 367 358 392 428 464 505 398 127% 2,515 2,015 125% 5,934 5,246 113% Accessories 610 628 711 744 785 846 855 99% 4,324 4,880 89% 10,009 10,247 98% Books 423 486 375 423 479 563 579 97% 2,749 3,185 86% 6,830 6,837 100% Extended Warranties 18 33 42 93 610 Tickets 42 271 227 161 18 718 1,163
