3 If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i e , for Disks, Inc ) The constraints are as follows The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type But, the company can only make a maximum of 5000 Supreme disks to sell Mr Smith also wants none of the individual disk types to make a loss a What is the amount spent on advertising for each disk type b What is the number of units produced to cover demand for High Flyer disks c What is the net income for Tournament disks d What is number of units sold based on advertising for Supreme disks e What Excel feature did you use to answer these questions Income Statement Revenue Units Sold Based on Word of Mouth Units Sold Based on Advertising Total Units Sold Price per Unit Total Regular 2100 205 2305 $12 00 $27,664 60 High Flyer 2050 205 2255 $20 00 $45 107 67 Tournament 1750 205 1955 $24 00 $46,929 21 Supreme 1000 205 1205 $32 00 $38,572 28 Total 6900 822 7722 $22 00 $158,273 76 Variable Expenses Units Produced To Cover Demand Cost per Unit Total Regular $2,535 92 $5 00 $12,679 61 High Flyer $2,480 92 $10 00 $24,809 22 Tournament $2,150 92 $16 00 $34,414 75 Supreme $1,325 92 $20 00 $26,518 44 Total $8,493 69 $12 75 $98,422 02 Fixed Expenses Insurance and maintenance Other Overhead Advertising Total Regular High Flyer $3,000 00 $5,000 00 $6,000 00 $8,500 00 $1,000 00 $1,000 00 $10,000 00 $14,500 00 Tournament Supreme $6,000 00 $10,000 00 $12,000 00 $18,000 00 $1,000 00 $1,000 00 $19,000 00 $29,000 00 Total $24,000 00 $44,500 00 $4,000 00 $72,500 00 Income Summary Total Revenue Total Expenses Net Income Regular High Flyer $27,664 60 $45,107 67 $22,679 61 $39 309 22 $4,984,99 $5,798 45 Tournament Supreme Total $46,929 21 $38,572 28 5158,273 76 $53,414 75 $55,518 44 $170,922 02 ($6,485 54) ($ 16,946 16) ($12,648 26) 3 If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i e , for Disks, Inc ) The constraints are as follows The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type But, the company can only make a maximum of 5000 Supreme disks to sell Mr Smith also wants none of the individual disk types to make a loss a What is the amount spent on advertising for each disk type b What is the number of units produced to cover demand for High Flyer disks c What is the net income for Tournament disks d What is number of units sold based on advertising for Supreme disks e What Excel feature did you use to answer these questions Income Statement Revenue Units Sold Based on Word of Mouth Units Sold Based on Advertising Total Units Sold Price per Unit Total Regular 2100 205 2305 $12 00 $27,664 60 High Flyer 2050 205 2255 $20 00 $45 107 67 Tournament 1750 205 1955 $24 00 $46,929 21 Supreme 1000 205 1205 $32 00 $38,572 28 Total 6900 822 7722 $22 00 $158,273 76 Variable Expenses Units Produced To Cover Demand Cost per Unit Total Regular $2,535 92 $5 00 $12,679 61 High Flyer $2,480 92 $10 00 $24,809 22 Tournament $2,150 92 $16 00 $34,414 75 Supreme $1,325 92 $20 00 $26,518 44 Total $8,493 69 $12 75 $98,422 02 Fixed Expenses Insurance and maintenance Other Overhead Advertising Total Regular High Flyer $3,000 00 $5,000 00 $6,000 00 $8,500 00 $1,000 00 $1,000 00 $10,000 00 $14,500 00 Tournament Supreme $6,000 00 $10,000 00 $12,000 00 $18,000 00 $1,000 00 $1,000 00 $19,000 00 $29,000 00 Total $24,000 00 $44,500 00 $4,000 00 $72,500 00 Income Summary Total Revenue Total Expenses Net Income Regular High Flyer $27,664 60 $45,107 67 $22,679 61 $39 309 22 $4,984,99 $5,798 45 Tournament Supreme Total $46,929 21 $38,572 28 5158,273 76 $53,414 75 $55,518 44 $170,922 02 ($6,485 54) ($ 16,946 16) ($12,648 26)

Question

3  If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo  Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i e , for Disks, Inc )  The constraints are as follows  The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type  But, the company can only make a maximum of 5000 Supreme disks to sell  Mr  Smith also wants none of the individual disk types to make a loss  a  What is the amount spent on advertising for each disk type  b  What is the number of units produced to cover demand for High Flyer disks  c  What is the net income for Tournament disks  d  What is number of units sold based on advertising for Supreme disks  e  What Excel feature did you use to answer these questions  Income Statement Revenue Units Sold Based on Word of Mouth Units Sold Based on Advertising Total Units Sold Price per Unit Total Regular 2100 205 2305 $12 00 $27,664 60 High Flyer 2050 205 2255 $20 00 $45 107 67 Tournament 1750 205 1955 $24 00 $46,929 21 Supreme 1000 205 1205 $32 00 $38,572 28 Total 6900 822 7722 $22 00 $158,273 76 Variable Expenses Units Produced To Cover Demand Cost per Unit Total Regular $2,535 92 $5 00 $12,679 61 High Flyer $2,480 92 $10 00 $24,809 22 Tournament $2,150 92 $16 00 $34,414 75 Supreme $1,325 92 $20 00 $26,518 44 Total $8,493 69 $12 75 $98,422 02 Fixed Expenses Insurance and maintenance Other Overhead Advertising Total Regular High Flyer $3,000 00 $5,000 00 $6,000 00 $8,500 00 $1,000 00 $1,000 00 $10,000 00 $14,500 00 Tournament Supreme $6,000 00 $10,000 00 $12,000 00 $18,000 00 $1,000 00 $1,000 00 $19,000 00 $29,000 00 Total $24,000 00 $44,500 00 $4,000 00 $72,500 00 Income Summary Total Revenue Total Expenses Net Income Regular High Flyer $27,664 60 $45,107 67 $22,679 61 $39 309 22 $4,984,99 $5,798 45 Tournament Supreme Total $46,929 21 $38,572 28 5158,273 76 $53,414 75 $55,518 44 $170,922 02 ($6,485 54) ($ 16,946 16) ($12,648 26) 3  If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo  Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i e , for Disks, Inc )  The constraints are as follows  The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type  But, the company can only make a maximum of 5000 Supreme disks to sell  Mr  Smith also wants none of the individual disk types to make a loss  a  What is the amount spent on advertising for each disk type  b  What is the number of units produced to cover demand for High Flyer disks  c  What is the net income for Tournament disks  d  What is number of units sold based on advertising for Supreme disks  e  What Excel feature did you use to answer these questions  Income Statement Revenue Units Sold Based on Word of Mouth Units Sold Based on Advertising Total Units Sold Price per Unit Total Regular 2100 205 2305 $12 00 $27,664 60 High Flyer 2050 205 2255 $20 00 $45 107 67 Tournament 1750 205 1955 $24 00 $46,929 21 Supreme 1000 205 1205 $32 00 $38,572 28 Total 6900 822 7722 $22 00 $158,273 76 Variable Expenses Units Produced To Cover Demand Cost per Unit Total Regular $2,535 92 $5 00 $12,679 61 High Flyer $2,480 92 $10 00 $24,809 22 Tournament $2,150 92 $16 00 $34,414 75 Supreme $1,325 92 $20 00 $26,518 44 Total $8,493 69 $12 75 $98,422 02 Fixed Expenses Insurance and maintenance Other Overhead Advertising Total Regular High Flyer $3,000 00 $5,000 00 $6,000 00 $8,500 00 $1,000 00 $1,000 00 $10,000 00 $14,500 00 Tournament Supreme $6,000 00 $10,000 00 $12,000 00 $18,000 00 $1,000 00 $1,000 00 $19,000 00 $29,000 00 Total $24,000 00 $44,500 00 $4,000 00 $72,500 00 Income Summary Total Revenue Total Expenses Net Income Regular High Flyer $27,664 60 $45,107 67 $22,679 61 $39 309 22 $4,984,99 $5,798 45 Tournament Supreme Total $46,929 21 $38,572 28 5158,273 76 $53,414 75 $55,518 44 $170,922 02 ($6,485 54) ($ 16,946 16) ($12,648 26)

Accepted Answer

The Answer is in the image, click to view ...

Question

3. If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo. Under

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

After The Quality Audit Closing The Loop On The Audit Process

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question