Motion Music - A Financial Feasibility Analysis - Management Assignment Help

Assignment Task:

1. Motion Music is doing a financial feasibility analysis for a new album. Recordings and production are estimated at $65,000. The printing of CDs is fixed at $5000 for set up plus $3 per CD The artist's royalty is 4% per CD of the publisher's price to music stores. Advertising and promotion costs are budgeted at 59.000 

(a) If the price to music stores is set at $21, how many CDs must be sold to break even? Find the break-even point algebraically and by using an EXCEL graph. Attach the printout or copy your EXCEL graph into your assignment submission. 

EXCEL Instructions: Create a column called Number of CDs and in that column enter values from 0 to 5,000 in increments of 500. Then create two more columns. one for Total Cost and another for Total Revenue. Enter appropriate formulae in EXCEL to obtain the total cost and total revenue corresponding to each value in the Number of CDs column. Highlight the resulting three sets of numbers and go to the Insert tab (or Chart menu) to obtain an appropriate diagram. 

Make sure that your graph has been labelled appropriately (i.e. title, axis labels. legend). Refer to Topic 3 in the EXCEL Supplement for further instructions on entering formulae and graphing in EXCEL. 

(b) The marketing department is forecasting sales of 5.000 CDs at the price of $21. Based on your graph from part (a), will there be a net profit or net loss from the project at this volume of sales? How do you know? Calculate this net profit or loss amount. (Assume no tax costs.) 

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.