CODING IN IT

QUESTION

Brief Assignment Instructions:

 

Fill in all your student details  at the top of the “Observations” worksheet and read the Assignment Detail specification document on DSO closely. Do not alter any data already provided  in this template file.

 

Please insert your answer below each question asked on the “Observations” sheet, (i.e. this worksheet) as shown in the following example, Question – A.

 

Your answers to Questions 1 to 8 should include the following:

– A table of summary data showing your data findings and appropriately calculated  totals in response to the question;

– A chart that ‘best’ illustrates your data findings, some chart type hints are provided. Please include chart titles, axis labels and data labels where appropriate;

– A text box containing a brief explanation of your answer and any further observations or relevant comments you wish to make.

 

IMPORTANT: In this assignment you should, where appropriate, use a specific Excel functions in the Observations worksheet to analyse the underlaying data worksheets and return your calculation values automatically to the Observations worksheet. You are free to add extra columns of data and calculation in the underlaying data worksheets if you wish for supplementary calculations but you are not permitted to change or alter the original data provided.

 

NOTE: The use of TABLES or PIVOT TABLES from the Insert tab menu item Tables  to organise data or derive any solutions is NOT PERMITTED and  will result  in a loss of marks for the specific question.

 

Finally, provide your “Recommendations” as instructed and submit your assignment for marking by the due date.  Please use your Student  ID Number  as the Filename for your  file submission via DSO.

 

Attempt all questions and if you have problems, please see your Tutor for assistance.

SOLUTION

Product Category Product Code Wholesaler Publisher Year DVD Title Product Product Format $0.00 Genre Viewing Aspect Release Date Member Rating (0 – 5) Run Time (min)  Wholesale Price Recommended Retail Price Sale Discount %  Sale Sub Total Customer Delivery Mode  Sales Postage & Handling Final Sale Price Stock on Hand COB 29/7/2011 Product Profit Margin Total profit
Coming Soon 111663 DVD Direct Co. 20th Century Fox 2011 Water For Elephants Movie DVD & BluRay PG Drama 10/12/2011 0 120  $      11.25  $              44.99 23%  $   34.64 Download  $    3.00  $     37.64 120  $         26.39 3167.076
Coming Soon 111441 All Games & Video Australia Universal Pictures Home Video 2011 Thor Movie DVD & BluRay M Action 3D 10/6/2011 0 110  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 120  $         33.74 4048.8
Coming Soon 111713 Euro Video Entertainment Pty. Ltd. 20th Century Fox 2011 Rio Movie DVD & BluRay G Animation 3D 9/28/2011 0 95  $      11.25  $              44.99 49%  $   22.94 Download  $    3.00  $     25.94 120  $         14.69 1763.388
Coming Soon 111334 Rising Sun Films Madman Entertainment 2011 Snowtown Movie DVD & BluRay MA15+ Drama 9/21/2011 0 119  $      11.25  $              44.99 0%  $   44.99 Download  $    3.00  $     47.99 120  $         36.74 4408.8
Coming Soon 111686 t-Rex Film Distributors Roadshow Home Entertainment 2011 Hoodwinked Too! Movie DVD & BluRay G Animation 3D 9/15/2011 0 87  $      11.25  $              44.99 13%  $   39.14 Download  $    3.00  $     42.14 120  $         30.89 3706.956
Latest Releases 101336 Rising Sun Films Madman Entertainment 2010 Bedevilled Movie DVD PG Drama 9/14/2011 1 112  $        8.75  $              34.99 22%  $   27.29 Download  $    3.00  $     30.29 96  $         21.54 2068.0512
Latest Releases 101774 Specialist Movie Media ICON Film 2010 Insidious Movie DVD & BluRay M Horror 9/14/2011 2 98  $      11.25  $              44.99 12%  $   39.59 Download  $    3.00  $     42.59 80  $         31.34 2507.296
Latest Releases 111227 Euro Video Entertainment Pty. Ltd. Warner Bros. 2011 Drive Angry Movie DVD & BluRay MA15+ Action 3D 9/7/2011 3 93  $      11.25  $              44.99 24%  $   34.19 Post  $    4.00  $     38.19 70  $         26.94 1885.968
Latest Releases 111528 Specialist Movie Media ICON Film 2011 The Lost Bladesman Movie DVD & BluRay MA15+ Action 8/26/2011 2 92  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 69  $         33.74 2328.06
Latest Releases 101700 Euro Video Entertainment Pty. Ltd. Sony Pictures Home Entertainment 2010 Chain Letter Movie DVD MA15+ Horror 8/3/2011 2 84  $      10.00  $              39.99 12%  $   35.19 Courier  $    5.00  $     40.19 111  $         30.19 3351.2232
Latest Releases 101770 Specialist Movie Media Pinnacle Films 2010 The Reef Movie DVD & BluRay M Thriller 7/22/2011 3 88  $      10.70  $              42.80 18%  $   35.10 Download  $    3.00  $     38.10 87  $         27.40 2383.452
Latest Releases 101624 Euro Video Entertainment Pty. Ltd. Sony Pictures Home Entertainment 2010 The Warrior’s Way Movie DVD. MA15+ Action 1080p 7/20/2011 1 99  $      11.25  $              44.99 49%  $   22.94 Free  $        –  $     22.94 18  $         11.69 210.5082
Latest Releases 111784 DVD Direct Co. Universal Pictures Home Video 2011 True Justice: Deadly Crossing Movie DVD R18+ Action 7/7/2011 5 94  $        8.75  $              34.99 0%  $   34.99 Free  $        –  $     34.99 90  $         26.24 2361.6
Latest Releases 111574 Raven Pictures Distribution Buena Vista Home Entertainment 2011 Gnomeo & Juliet Movie DVD & BluRay G Animation 3D 6/29/2011 5 84  $      11.25  $              44.99 24%  $   34.19 Post  $    4.00  $     38.19 9  $         26.94 242.4816
Most Rented 101523 DVD Direct Co. 20th Century Fox 2010 Black Swan Movie DVD & BluRay MA15+ Thriller 6/1/2011 3 108  $      11.25  $              44.99 0%  $   44.99 Download  $    3.00  $     47.99 6  $         36.74 220.44
Most Rented 111646 Raven Pictures Distribution Paramount Pictures 2011 The King’s Speech Movie DVD & BluRay PG Drama 4/30/2011 4 117  $      11.25  $              44.99 22%  $   35.09 Courier  $    5.00  $     40.09 5  $         28.84 144.211
Most Rented 101664 Euro Video Entertainment Pty. Ltd. Warner Bros. 2010 Harry Potter and the Deathly Hallows Part 1 Movie DVD & BluRay M Adventure 4/15/2011 4 145  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 7  $         33.74 236.18
Most Rented 101730 Raven Pictures Distribution Paramount Pictures 2010 Megamind Movie DVD & BluRay G Animation 4/7/2011 4 89  $      11.25  $              44.99 49%  $   22.94 Download  $    3.00  $     25.94 8  $         14.69 117.5592
Most Rented 101270 Euro Video Entertainment Pty. Ltd. Sony Pictures Home Entertainment 2010 Social Network Movie DVD & BluRay M Drama 3/2/2011 4 115  $      11.25  $              44.99 13%  $   39.14 Download  $    3.00  $     42.14 6  $         30.89 185.3478
Most Rented 101403 DVD Direct Co. Universal Pictures Home Video 2010 Despicable Me Movie DVD & BluRay PG Family 3D 1/6/2011 3 95  $      11.25  $              44.99 14%  $   38.69 Download  $    3.00  $     41.69 5  $         30.44 152.207
Most Rented 101574 Raven Pictures Distribution Warner Bros. 2010 Inception Movie DVD & BluRay M Science Fiction 12/8/2010 3 142  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 103  $         33.74 3475.22
Most Rented 101390 Digital DVD & Games Inc. Disney 2010 Prince of Persia – The Sands Of Time Movie DVD & BluRay M Adventure 10/20/2010 3 104  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 8  $         33.74 269.92
Most Rented 901798 t-Rex Film Distributors Roadshow Home Entertainment 2009 Sherlock Holmes Movie DVD & BluRay M Adventure 5/6/2010 4 128  $      11.25  $              44.99 14%  $   38.69 Download  $    3.00  $     41.69 9  $         30.44 273.9726
Most Rented 901422 All Games & Video Australia Roadshow Home Entertainment 2009 The Time Traveller’s Wife Movie DVD & BluRay M Science Fiction 3/18/2010 3 107  $      11.25  $              44.99 0%  $   44.99 Free  $        –  $     44.99 12  $         33.74 404.88
User Rated Favourites 901670 Specialist Movie Media Shock Records 2009 Deep Purple: History, Hits and Highlights ’68-’76 Movie DVD M Music 6/5/2009 1 287  $        6.25  $              24.99 49%  $   12.74 Post  $    4.00  $     16.74 14  $         10.49 146.9286
User Rated Favourites 801243 Specialist Movie Media Shock Records 2008 Diana Krall: Live In Rio Movie DVD & BluRay G Music 5/29/2009 2 135  $        6.25  $              24.99 24%  $   18.99 Post  $    4.00  $     22.99 89  $         16.74 1490.0736
User Rated Favourites 901261 Specialist Movie Media Shock Records 2009 KISSology: The Ultimate Kiss Collection – Volume One 1974-1977 Movie DVD PG Music 5/22/2009 5 195  $        6.25  $              24.99 0%  $   24.99 Download  $    3.00  $     27.99 7  $         21.74 152.18
User Rated Favourites 401484 Rising Sun Films Madman Entertainment 2004 Mind Game Movie DVD R18+ Anime 12/3/2008 3 103  $        2.50  $                9.99 53%  $    4.70 Download  $    3.00  $       7.70 8  $           5.20 41.5624
User Rated Favourites 941664 At Home Entertainment Corp. Warner Home Video 1994 The Shawshank Redemption Movie DVD & BluRay MA15+ Drama 5/11/2005 4 142  $      11.25  $              44.99 53%  $   21.15 Post  $    4.00  $     25.15 78  $         13.90 1083.8334
User Rated Favourites 931547 DVD Direct Co. Universal Pictures Home Video 1993 Schindler’s List Movie DVD M Drama 4/1/2004 5 196  $      10.00  $              39.99 24%  $   30.39 Download  $    3.00  $     33.39 101  $         23.39 2362.6324
User Rated Favourites 791766 All Games & Video Australia Roadshow Home Entertainment 1979 Mad Max Movie DVD R18+ Action 9/6/2002 5 89  $        6.25  $              24.99 23%  $   19.24 Post  $    4.00  $     23.24 98  $         16.99 1665.2454
User Rated Favourites 791391 DVD Direct Co. Universal Pictures Home Video 1979 Apocalypse Now: Redux Movie DVD R18+ Action 8/12/2002 5 760  $        6.25  $              24.99 14%  $   21.49 Post  $    4.00  $     25.49 52  $         19.24 1000.5528
User Rated Favourites 941625 All Games & Video Australia Universal Pictures Home Video 1994 Once Were Warriors/What Becomes of the Broken Hearted Movie DVD M Drama 9/12/2001 5 193  $        8.75  $              34.99 13%  $   30.44 Courier  $    5.00  $     35.44 5  $         26.69 133.4565
User Rated Favourites 871594 At Home Entertainment Corp. Paramount Home Entertainment 1987 The Untouchables Movie DVD M Drama 9/7/2001 5 115  $        6.25  $              24.99 22%  $   19.49 Download  $    3.00  $     22.49 6  $         16.24 97.4532
 $    333.20 120

L044

“The presented piece of writing is a good example how the academic paper should be written. However, the text can’t be used as a part of your own and submitted to your professor – it will be considered as plagiarism.

But you can order it from our service and receive complete high-quality custom paper.  Our service offers Information system essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”

Please  Click on the  below links to Chat Now  or fill the Order Form !
order-now-new                        chat-new (1)