excel Speadshhet

profiledunlap05
bis155_practical_exam_spreadsheet-2.xlsx
Home>Human Resource Management homework help>excel Speadshhet

Documentation

BIS-155 Final Exam Practical Problems
Music on Demand (V3)
Name:
Date:

Quest 1 & 2

Music on Demand-Sales by Product
Product Unit Price Quantity Total Sales
Vinal Albums 14.99 75
Cassetts 3.99 30
Digital 1.99 256
Single Songs 2.99 98
Headsets 15.89 16
Turn tabes 105.75 8
Speakers 50.99 20
Wiring 10.99 15
Outdoor Speakers 55.65 15
Cleaning kit for Vynal 5.99 25
Clearning kit ofr Cassetts 6.89 35
Headset parts 10.5 24
Electrical cords 7.25 15
MP3 Players 21.76 200
Sales Assessment
0 Poor
500 Good
1000 Outstanding!

Quest 3-Lists & Sorting

Quest 4-Financials

Part 1 - Income Statement Payment Function and Analysis (Part F & G)
Annual Revenue: Down Payment Present Value Interest/Period Loan Amount # Periods Payment
Sales: 10000 160000
Vinal Albums 20000 160000
Cassetts
Digital
Single Songs 1-way Analysis on MP3 Player
Headsets Unit Sales 200
Turn tabes Unit Price $ 21.76 Effect of Varying Unit Sales on Total Sales, Total Cost, and Net Income
Speakers Unit Cost $ 17.25 Initial Values 10 12 14 16 18
Wiring Total Sales: $ 4,352.00 Total Sales $ 4,352.00
Outdoor Speakers Total Cost: $ 3,450.00 Total Cost $ 3,450.00
Cleaning kit for Vynal Net Income: $ 902.00 Net Income $ 902.00
Clearning kit ofr Cassetts
Headset parts
Electrical cords
MP3 Players
Total Revenue
Annual Expenses:
Variable Expenses
Postage 200
Handling 200
Sub Total Variable Expenses
Fixed Expenses
Insurance 100
Maintenance 150
Administrative and Markeing 300
Taxes 2450
SubTotal Fixed Expenses
Total Expenses
Summary:
Total Revenue
Total Expenses
Net Income

Quest 5-Organizing Data

DC Branch

DC Branch Sales
Month Vinal Albums Cassetts Digital Single Songs Headsets Turn tables Speakers Wiring Outdoor Speakers Cleaning kit for Vynal Clearning kit ofr Cassetts Headset parts Electrical cords MP3 Players
January 246 547 649 1050 570 607 594 204 109 743 659 598 335 349
February 343 598 355 246 547 649 1050 570 607 594 109 289 659 400
547 649 1050 570 607 594 204 109 743 289 400 335 349 547
462 349 547 649 1050 570 607 594 204 109 289 400 598 335
590 335 340 547 649 1050 570 607 594 204 743 659 400 598
112 698 207 350 876 547 649 1050 570 607 204 743 289 659
267 987 547 649 1050 570 607 594 204 109 289 400 598 335
324 1040 459 650 547 649 1050 570 607 594 109 289 659 400
523 545 356 234 157 547 649 1050 570 607 204 743 289 659
145 222 1050 570 607 594 204 109 743 289 400 335 349 254
635 356 765 1050 570 607 594 204 109 743 659 598 335 349
598 111 343 349 649 1050 570 607 594 204 743 659 400 598

Houston Branch

Houston Branch Sales
Month Vinyl Albums Cassettes Digital Single Songs Headsets Turn tables Speakers Wiring Outdoor Speakers Cleaning kit for Vinyl Cleaning kit for Cassettes Headset parts Electrical cords MP3 Players
January 565 547 649 1050 570 607 594 204 109 743 659 598 335 349
February 578 598 355 246 547 649 1050 570 607 594 109 289 659 400
269 649 1050 570 607 594 204 109 743 289 400 335 349 547
462 349 547 649 242 570 607 594 204 109 289 400 598 335
656 335 340 547 649 1050 570 607 594 204 743 659 400 598
350 698 207 350 876 547 649 1050 570 607 204 743 289 665
987 987 547 649 126 570 607 553 204 212 998 235 365 335
353 223 459 650 547 649 145 267 607 226 109 129 659 400
686 545 356 234 157 547 649 987 570 774 647 289 267 834
113 222 1050 570 607 594 204 109 743 289 400 335 267 254
567 356 765 1050 570 607 594 204 109 743 659 598 335 349
489 111 343 349 649 1050 570 607 594 204 743 659 400 598

LA Branch

LA Branch Sales
Month Vinal Albums Cassetts Digital Single Songs Headsets Turn tables Speakers Wiring Outdoor Speakers Cleaning kit for Vynal Clearning kit ofr Cassetts Headset parts Electrical cords MP3 Players
January 246 547 649 1050 570 607 594 204 109 743 659 598 335 349
February 343 598 355 246 547 649 1050 570 607 594 109 289 659 400
547 649 1050 570 607 594 204 109 743 289 400 335 349 547
462 349 547 649 1050 570 607 594 204 109 289 400 598 335
590 335 340 547 649 1050 570 607 594 204 743 659 500 598
112 698 207 350 876 547 649 1050 570 607 204 743 289 659
267 987 547 649 25 570 607 594 204 109 289 600 598 335
324 657 459 650 547 649 167 570 607 594 336 289 659 350
523 545 356 234 157 547 649 257 570 265 204 788 289 659
145 222 226 570 607 594 204 109 743 289 400 335 349 254
635 356 765 573 570 607 594 204 109 743 659 598 335 349
598 111 343 349 649 1050 570 607 594 204 743 659 400 598

Quest 6-Report & Summarize

Place memo and Text here.