The Writer MUST be very good on Data Analysis, Finacial Managment and MS Excel (Advanced User). Please see below the description which I will attach in word format
Unit 5: Cost Volume Profit Analysis
In this assignment, you will prepare an analysis report using CVP analysis.
This assignment is worth 17.5% of your total grade for the module.
Your task is to perform CVP Analysis.
Use your individual student data provided in the excel file you have downloaded before the start of this week to answer the questions in the case study.
Evolution technologies consider launching a new innovative product, the X5A. The product is a new generation smartwatch that collects vital health data and makes a range of prognoses. There are very positive projections about the future market of wearable devices. You can see these here:
The executive team has produced some estimates about the expected sales, costs, and selling price. These are available in this downloadable Assignment data file.
However, they would like you to conduct a CVP analysis and provide your recommendation about the viability of X5A.
Part A: A CVP analysis, consisting of:
1. The contribution per X5A
2. The break-even point, both in units of X5A and as £ of sales.
3. The margin of safety, both in units of X5A and as % of expected sales.
4. The expected profit for the expected sales (assume no cost of borrowing; tax rate of 20%).
5. The selling price that will generate £350,000 pre-tax profit (assume that all other variables remain the same).
6. The impact on net profit if advertising costs increase by 10% and expected sales in units increase by 15%.
7. The CVP chart, showing:
• Total revenues
• Total costs
• Fixed costs
• Margin of safety line
• Profit and loss areas.
Part B: Using the findings in a (1-7), write a synopsis with your recommendations to the executive team. Your synopsis should include a clear recommendation whether you agree or not with the launch of X5A. In your note you should highlight the limitations of CVP analysis that may impact the validity of your findings and recommendations.
• The word limit is 700 words maximum (exclusive of references).
• Part A should be prepared and submitted as an MS Excel workbook. The workbook should contain formulas and you should avoid hard-coding the data.
• Part B should be completed and submitted in an MS Word document.
• You should provide citations and references to support your calculations and your analysis/recommendations.
• You need to make sure you answer all the questions.
• The word count for this assessment is 700 words plus or minus 10%. The word count excludes footnotes and reference list.
• You should use the NTU Library Harvard Referencing System.
• This assignment uses plagiarism detection software. Remember to reference your work.
Presentation From the specific origin of film visual impacts have been utilized by various picture takers and movie producers to upgrade, to acknowledge and make new significance. The beginning of film took extraordinary favorable position of 'visual enchantment' to make figments and duplicity which have awed incalculable groups of onlookers. Over a century back when photography was rising as a fine art some corrupt business picture takers would catch representation shots utilizing a common introduction yet then when the subject was expelled from the studio a colleague would be situated inside a similar setting, a brisk presentation would be taken in order to leave a swoon picture follow on the film. The clueless client would then be given a positive duplicate of their picture with what seemed, by all accounts, to be a spooky figure in shot. A more inconspicuous variety included the client being set with various props around him or her, the props would be evacuated for the second introduction of the apparition character, so as they wouldn't show up too intentionally twofold uncovered. The apparition character would more often than not be wearing dark apparel as film does not 'see' dark because of the compound procedure in the emulsion of film which recognizes light just, consequently just the phantom would show up in the second picture. What's more, in this started the business of embellishments. This phantom trap was the beginning stage for what is currently known as the matte procedure where unrequired objects are expelled from the introduction by veiling them so they don't enlist on the film. One of the primary employments of this procedure in a moving picture grouping was seen in Alexander Korda's Things To Come (1936) in which the upper dimensions of a cutting edge underground city have been twofold uncovered above film of live performing artists, matte covers anticipated one picture appearing on the other picture. This film gives one of the most punctual instances of embellishments being embraced to decidedly enhance the feel of a film. Obviously since film's initial investigations with visual impacts the business has today formed into an extremely complex, carefully determined and in fact ultra-progressed visual medium. PCs have taken enhancements to a completely new dimension and as PCs proceed to refresh and enhance their spec so too will the film business create around these advances; basically PCs and computerized innovation have empowered movies to be delivered which generally would not have been. Anyway in spite of the frequently significant visual accomplishment of embellishments in specific cases a few people contend that film is currently setting an over dependence on enhancements, they contend that visual impacts in a few movies are counter unbelievably crosswise over as ineffectual and a few times pointless. Some likewise question the execution of the performing artists if all they are doing in a film is running before a green screen yelling at an envisioned 'outsider' grasping an envisioned prop. Others raise concerns with respect to the movies quality and the procedures of assembling a film where quite a bit of it is CGI comprised. So is it extremely the case that films being created now would be better gotten by gatherings of people in the event that they didn't make such a great amount of utilization of visual impacts? Or on the other hand is it that a few studios and chiefs essentially can't change successfully to current film making? What's more, who is to be faulted for this? Man or machine? As visual impacts craftsman Piers Bizony calls attention to: One of the best misguided judgments about present day motion pictures is that visual impacts are created by PCs. Nothing could be further from reality. Human imagination is the most imperative fixing and it generally will be. PCs offer astounding new potential outcomes, yet the basic difficulties of film dreams are indistinguishable today from they were about a century back when the business was youthful . Section 1: The Profound Benefits of Using Visual Effects in Film Advanced impacts have fundamentally affected on standard movies, in reality computerized innovation is presently synonymous with excellent visual impacts. Michael Bailey's science fiction movie Armageddon (1999) gives a genuine case of an executive drawing in with advanced visual impacts which accomplishes a great and immensely fruitful finished result. The calamity film portrays the endeavors to counteract Earth being devastated by a colossal shooting star on an impact course with it. Groups of 'legends' are sent into space trying to explode the shooting star and spare the world. The film is soaked with advanced impacts some of which are the aftereffect of an exceptionally unpredictable process. These PC created successions incorporate the whole circle scenes, the shooting star shots and the film's peak. The developmental procedure by which the visual impacts item is cultivated can be a dazzling procedure in itself; take for instance the space rock in Armageddon which started life as a little portray on a napkin, the picture was then refined and digitized, at that point shading was added to it in Photoshop. After this a physical model of the space rock was built out of froth. Various shots were then taken and encouraged once again into a PC with the goal that different impacts could be included, for example, gasses and rocks. A second and bigger model was then assembled and utilizing a mind boggling innovative process wired the model so a PC could peruse each and every three-dimensional detail of it. The last item we find in the film is a picture which is the aftereffect of different computerized symbolism layers with a considerable lot of the film's scenes containing among fifty and a hundred layers. It is an astonishing accomplishment of current visual guile. On the off chance that the film had been made quite a long while before hand it would have needed to utilize the more regular optical printing cinematographic process. Anyway this would have left green lines noticeable regarding the matters and devalued the general tasteful characteristics of the film, today PCs can expel these lines in this way rendering the composite procedure undetectable to the watcher. Contemporary present day visual impacts induce a film culture dependent on a creation procedure that in established truth is less 'physical'. As scholastics and creators Peter Lehman and William Luhr watch: As a motion picture like Armageddon clarifies, quite a bit of what we currently find in Hollywood movies never existed before the camera and this has had a significant impact upon how we consider motion pictures. The nature of the visual impacts essentially impacts on the acceptability of the film for the watcher and most Hollywood movies endeavor to shroud any indications of the film making strategies utilized with the point of furnishing the observer with a 'genuine' ordeal. Some mark this style of Hollywood film making a 'the imperceptible style' and computerized visual impacts in numerous occasions presently makes this film making approach considerably more feasible, and more less demanding to deliver as expenses are cut. Movies like Cecil B. De Mille's The Ten Commandments (1956) used to be an uncommon occasion in Hollywood on account of the costs engaged with making the unique visual impacts, however now because of present day visual impacts money related hindrances have been evacuated and we currently observe Hollywood expanding their yield of all the more outwardly brave movies. Michael Bailey's follow-up to Armageddon was the colossally fruitful blockbuster Pearl Harbor (2002) which again rehashed the achievement of his past film as respects the utilization of visual impacts and proceeded to create overall film industry offers of just shy of £300,000,000. At the point when Ridley Scott's authentic activity show Gladiator (2000) was discharged there was wide media inclusion concentrating on a large number of the visual impacts the film had utilized . In the film a large number of the scenes happen in the Roman open air theater and we are blessed to receive a lot of shots of a whole amphitheater where crowds of onlookers involve it watching the grotesque occasion occurring underneath. Anyway the scene was in undeniable reality developed from numerous advanced layers and is another case of visual impacts making an important commitment to the film business. It is just through advanced innovation that we can appreciate with such visual smoothness the epic structure of the stadium, the fighters participating in their wild fight and the sneering onlookers across the board shot. James Cameron is a Canadian chief with various titles to his name and is notable for his utilization of front line visual impacts innovation. His first blockbuster raid into the visual impacts field was with his pivotal science fiction The Terminator (1984) in which we witness an executive pushing the limits of enhancements capacities. The film encapsulates a pattern of the time in which Hollywood was trying different things with new methods for visual impacts through the creation of movies which combined the class of sci-fi and loathsomeness including Alien (1979), Blade Runner (1982), Robocop (1987) and Predator (1987), a type of movies which creator Mark Jancovich depicts as movies which: Contain solid female leads; an enthusiasm for the family; worries about logical specialized levelheadedness and the military; executing machines which need cognizant inspiration; and types of body/awfulness . Inside Cameron's Terminator movie we can gather an overwhelming feeling of directorial inventiveness which, for the majority of the movie's noteworthy and fruitful visual impacts, is still in some way or another compelled not by the brain of the chief but rather by the innovation accessible to him. The film was low spending costing around £4m to make however because of its colossal fame produced £30m in film industry deals in America alone. The Terminator reared an establishment and to date four movies have been made albeit just the initial two were under Cameron's bearing. In Terminator 2: Judgment Day (1991) Cameron collaborates with George Lucas' Industrial Light and Magic visual impacts house and three other enhancements houses. Cameron expands on his rendered water appendage he made for The Abyss (1989); he was energized by a portion of the ideas utilized for The Abyss and in Terminator 2 made a Terminator developed of fluid metal – the T– 1000. On screen we witness T-1000, a polym>GET ANSWER