Share
Explore BrainMass

Software division sound card template

Please see attached spreadsheet. I need help completing the sound card template. According to the teacher, all the numbers needed are on the template already but i cant figure out how to calculate the rest of the numbers.

Software division
Quantity (x1,000) TFC(AVC) TVC TC AVC AC MC
0 2791 0 2791
10 2791 1140 3931 114 393.1 114
20 2791 2240 5031 112 251.55 110
30 2791 3310 6101 110.3333333 203.3666667 107
40 2791 4350 7141 108.75 178.525 104
50 2791 5370 8161 107.4 163.22 102
60 2791 6370 9161 106.1666667 152.6833333 100
70 2791 7350 10141 105 144.8714286 98
80 2791 8320 11111 104 138.8875 97
90 2791 9270 12061 103 134.0111111 95
100 2791 10210 13001 102.1 130.01 94
110 2791 11140 13931 101.2727273 126.6454545 93
120 2791 12060 14851 100.5 123.7583333 92
130 2791 12990 15781 99.92307692 121.3923077 93
140 2791 13930 16721 99.5 119.4357143 94
150 2791 14880 17671 99.2 117.8066667 95
160 2791 15840 18631 99 116.44375 96
170 2791 16810 19601 98.88235294 115.3 97
180 2791 17790 20581 98.83333333 114.3388889 98
190 2791 18780 21571 98.84210526 113.5315789 99
200 2791 19790 22581 98.95 112.905 101
210 2791 20830 23621 99.19047619 112.4809524 104
220 2791 21900 24691 99.54545455 112.2318182 107
230 2791 23000 25791 100 112.1347826 110
240 2791 24130 26921 100.5416667 112.1708333 113
250 2791 25290 28081 101.16 112.324 116
260 2791 26480 29271 101.8461538 112.5807692 119
270 2791 27700 30491 102.5925926 112.9296296 122
280 2791 28950 31741 103.3928571 113.3607143 125
290 2791 30220 33011 104.2068966 113.8310345 127
300 2791 31510 34301 105.0333333 114.3366667 129
310 2791 32830 35621 105.9032258 114.9064516 132
320 2791 34180 36971 106.8125 115.534375 135
330 2791 35560 38351 107.7575758 116.2151515 138
340 2791 36980 39771 108.7647059 116.9735294 142
350 2791 38450 41241 109.8571429 117.8314286 147
360 2791 39980 42771 111.0555556 118.8083333 153

Keyboard Division
Economic Income Statement
(after categorization and allocation)
Sound Card Software Keyboard Total
Sales Volume 240 280 45 565
Sales Revenue 19,440 35,280 13,725 68,445
Less: Variable costs -
Direct Labor 1,283 2,895 1,682 5,860
Materials 10,097 17,369 7,694 35,160
Manufacturing Overhead
Electricity
Production Setup
Maintenance & Repair
Indirect Labor
Selling costs
Total variable costs
Variable Margin
Less: Fixed Costs
Manufacturing Overhead
Electricity
Production Setup
Maintenance & Repair
Indirect Labor
Selling costs
Advertising/Promotion
R&D
Marketing Research
Other General and Administrative
Total Fixed costs
Net Income before taxes

Attachments

Solution Summary

Computations done for you.

$2.19