Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

How to use Gross Margin before VC to calculate for Sales Mix Variance and Sales Qty Variance? Exhibit 7a (continued) INCOME STATEMENT (cont.) AR $

How to use Gross Margin before VC to calculate for Sales Mix Variance and Sales Qty Variance?

image text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Reasoning for Everyday Life

Authors: Jeff Bennett, Bill Briggs, Mario F. Triola

4th edition

978-0321817624

Students also viewed these Accounting questions