Purchase Solution

Software division sound card template

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

Computations done for you.

Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • break-even quantities and operating leverages

    Describe how expanding the division with the highest operating leverage would affect the company's risk position. 4. For the sound-card division, calculate the profits associated with each production technology at the possible quantities.

  • Break-even points

    We've reviewed the marketing report and are convinced that the company would be well served by expanding the Electric 88 keyboard division instead of the software division.

  • MusicCo Fixed and Variable Cost - Task 1

    A spreadsheet that shows the sound-card division\'s costs and identifies the quantities associated with MusicCo\'s current production plan and each VP\'s recommendation. ?

  • Break even, degree of operating leverage, and average cost

    WOULD YOU RECOMMEND EXPANDING THE KEYBOARD DIVISION OR THE SOFTWARE DIVISION? WHY? I would recommend expanding the Keyboard division because it has higher degree of operating leverage.

  • e-Business failure

    When the customers credit card statement arrives, they must verify its accuracy, enter the data into their accounting software, and then issue an EFT between the bank and the credit card company to complete the transaction.

  • Website Design - Validation, Sound & Video

    The page should have the following fields: Name Address City State Zip Telephone number E-mail address Date of birth Radio buttons for credit card type Credit card number Credit card expiration date month Credit card expiration date year

  • Recommend the production of new sound card

    Recommend the production of new sound card. Adopt the option 2 for the production of sound card. Thanks This posting explains why to recommend the production of new sound card.

  • Payroll Weakness

    Template categories ? Time sheets time-card-software-review.toptenreviews.com/ www.vertex42.com ? ... ?

  • Excel Templates to solve managerial accounting problems

    Insert the journal reference where "JOURN #" appears on the template during posting. Insert the title in the cell where "TITLE" appears on the template.

View More Related Solutions