1_Ceram_A_solution-2_研究生入學(xué)考試_高等教育_教育專區(qū).xls

1 CERAM AForExercise N Budgeted Income StatementPreparedN 1DateNov QuartersQ1Q2Q3Q4Total BudgetBudgetBudgetBudgetBudget Sales Oriental VasesQuantity Price Value Sales BowlsQuantity Price Value Total Sales Value Sales Commissions Distribution Expenses Sales Administration Advertising Total Selling Expenses Manufacturing ExpensesOriental Vases Bowls Total Production Overheads Total Production Costs Personnel Expenses Administrative Expenses Financial Charges Total Administrative Expenses Total Expenses Earnings before Tax ABCDEFG 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 In thousand unitsQ1Q2Q3Q4 PRODUCT ORIENTAL VASE West216264300420 South450550625875 East144176200280 North270330375525 Total1080132015002100 PRODUCT BOWL West18253844 South79105157184 East456090105 North23304552 Total165220330385 Q1Q2Q3Q4 PRODUCT ORIENTAL VASE 790 00790 00790 00790 00 PRODUCT BOWL 1 200 00 1 140 001 140 001 140 00 Comm VC distri VC prod PRODUCT ORIENTAL VASE 10 2 495 PRODUCT BOWL 10 2 725 Q1Q2Q3Q4 FC distri administration60 00060 00060 00060 000 advertising30 00090 00090 00090 000 FC production80 00080 00080 00080 000 Personal expenses100 000 100 000 100 000 100 000 Administrative expenses15 00015 00015 00015 000 Financial expenses12 00012 00012 00012 000 Total 1200 2500 800 1500 6000 125 525 300 150 1100 1 CERAM AForExercise Budgeted Income StatementPreparedN 1Date QuartersQ1Q2Q3Q4 BudgetBudgetBudgetBudget Sales Oriental VasesQuantity1 080 1 320 1 500 2 100 Price790 790 790 790 Value853 200 1 042 800 1 185 000 1 659 000 Sales BowlsQuantity165 220 330 385 Price1 200 1 140 1 140 1 140 Value198 000 250 800 376 200 438 900 Total Sales Value1 051 200 1 293 600 1 561 200 2 097 900 Sales Commissions105 120 129 360 156 120 209 790 Distribution Expenses21 024 25 872 31 224 41 958 Direct variable commercial costs126 144 155 232 187 344 251 748 Sales Administration60 000 60 000 60 000 60 000 Advertising30 000 90 000 90 000 90 000 Total Selling Expenses90 000 150 000 150 000 150 000 Manufacturing ExpensesOriental Vases534 600 653 400 742 500 1 039 500 Bowls119 625 159 500 239 250 279 125 Total654 225 812 900 981 750 1 318 625 Production Overheads80 000 80 000 80 000 80 000 Total Production Costs734 225 892 900 1 061 750 1 398 625 Personnel Expenses100 000 100 000 100 000 100 000 Administrative Expenses15 000 15 000 15 000 15 000 Financial Expenses12 000 12 000 12 000 12 000 Total Administrative Expenses127 000 127 000 127 000 127 000 Total Expenses1 077 369 1 325 132 1 526 094 1 927 373 Earnings before Tax 26 169 31 532 35 106 170 527 ABCDEF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 N Nov Total Budget 6 000 790 4 740 000 1 100 1 140 1 263 900 6 003 900 600 390 120 078 720 468 240 000 300 000 540 000 2 970 000 797 500 3 767 500 320 000 4 087 500 400 000 60 000 48 000 508 000 5 855 968 147 932 G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 1 CERAM AForExercise Budgeted Income StatementPreparedN 1Date QuartersQ1Q2Q3Q4 BudgetBudgetBudgetBudget Sales Oriental VasesQuantity1 080 1 240 1 410 1 974 Price790 790 790 790 Value853 200 979 600 1 113 900 1 559 460 Sales BowlsQuantity165 207 310 362 Price1 200 1 140 1 140 1 140 Value198 000 235 980 353 400 412 680 Total Sales Value1 051 200 1 215 580 1 467 300 1 972 140 Sales Commissions105 120 121 558 146 730 197 214 Distribution Expenses21 024 24 312 29 346 39 443 Direct variable commercial costs126 144 145 870 176 076 236 657 Sales Administration60 000 60 000 60 000 60 000 Advertising30 000 30 000 30 000 30 000 Total Selling Expenses90 000 90 000 90 000 90 000 Manufacturing ExpensesOriental Vases534 600 613 800 697 950 977 130 Bowls119 625 150 075 224 750 262 450 Total654 225 763 875 922 700 1 239 580 Production Overheads80 000 80 000 80 000 80 000 Total Production Costs734 225 843 875 1 002 700 1 319 580 Personnel Expenses100 000 100 000 100 000 100 000 Administrative Expenses15 000 15 000 15 000 15 000 Financial Expenses12 000 12 000 12 000 12 000 Total Administrative Expenses127 000 127 000 127 000 127 000 Total Expenses1 077 369 1 206 745 1 395 776 1 773 237 Earnings before Tax 26 169 8 835 71 524 198 903 ABCDEF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 N Nov Total Budget 5 704 790 4 506 160 1 034 1 140 1 200 060 5 706 220 570 622 114 124 684 746 240 000 120 000 360 000 2 823 480 756 900 3 580 380 320 000 3 900 380 400 000 60 000 48 000 508 000 5 453 126 253 094 G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Advertising at 30 000 MSCV Total sales value5 706 220 00 Variables costs4 265 126 40 MSCV1 441 093 60 25 Fixed costs without advertising 1 068 000 00 Fixed costs with adverstising 120 000 00 Result253 093 60 If the decrease of the advertising is 180 000 the volumes are going to decrease by 6 and the margin on variable costs is going to decrease by 6 that is a reduction in profit of 105 162 What should have been the minimal impact of the advertising Thus finally the profit falls when the company makes more advertising what means that the additional volumes of sales do not generate enough margin on additional variable costs to cover the increase of the advertising budget To arrive at the same level of profit the additional MSCV would have had to be at least 180 000 equivalent to the variation between the two hypotesis Considering the rate of MSCV 25 the sales value would thus have had to progress of 720 000 instead of 297 680 6 003 900 5 706 220 Advertising at 90 000 MSCV Variance 6 003 900 00 297 680 4 487 968 00 222 842 1 515 932 00 25 74 838 1 068 000 00 0 300 000 00 180 000 147 932 00 105 162 If the decrease of the advertising is 180 000 the vol