Explore BrainMass
Share

Explore BrainMass

    Software division sound card template

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com October 9, 2019, 8:02 pm ad1c9bdddf
    https://brainmass.com/business/organizational-economics/software-division-sound-card-template-137424

    Attachments

    Solution Summary

    Computations done for you.

    $2.19