Complete the following cases studies from chapter 5 &6 of Business Mathâ€
Case Study 5-2,pp 184-185 Case Study 6-2,pp 216-217
Use Microsoft Excel template for your answers.
NOTE: Show all work and calculations. (The use of Microsoft Excel Software is required.)
5-2 Artistâ€™s Performance Royalties
Performance rights organizations track and pay royalties to song writers, publishers, and musicians for
use of their works. Royalties are paid to an artist based on a complicated credit system using a formula
with weights assigned for a variety of factors, including the following:
â€¢ Use: weight based on the type of song or performance (theme, underscore, or promotional).
â€¢ Licensee: weight based on the stationâ€™s licensing fee, which is determined by the size of the
licenseeâ€™s markets and number of stations carrying its broadcast signal.
â€¢ Time-of-Day: weight assigned according to whether the performances are broadcast during peak
viewing or listening times.
â€¢ Follow-the-Dollar: factor based on the medium from which the money came (radio play, live
performance, TV performance, and so on).
â€¢ General Licensing Allocation: based on fees collected from bars, hotels, and other nonbroadcast
These amounts are multiplied together, and then a radio feature premium is added, if applicable, to
arrive at a total number of credits for the particular artist, or his or her credit total for a particular
reporting period. Royalties are usually split among the writer, the publisher, and possibly a performer if
the writer does not perform his or her own work. The proportion that each party receives is called the share value. All of the money collected
for the reporting period divided by the total number of credits for all performers is called the credit value. An artist who wants to figure out
what money he or she will receive for a period has to multiply the three factors; credit total, share value, and credit value.
1. Ziam wants to know how much his royalty will be for a song he has written. How will it be calculated? Write the steps or the formulas
that will be used to calculate his royalty payment.
2. Ziam has written a popular song entitled â€œGoing There,â€ which has been recorded by a well-known performer. He recently received a
royalty check for $7,000. If Ziam gets a 0.5 share of the royalties and the credit value is $3.50, what was the credit total that his song
earned? Write out the problem in the form of an equation and solve it.
3. Ziam quickly published another song, â€œTake Me There,â€ that is played even more often than â€œGoing There.â€ If his first song earns 4,000
credits and his second song earns 6,000 credits, what will the royalty payment be from the two songs if the credit value remains at $3.50?C
A4. Ziam is considering an offer to perform his own songs on a CD to be titled â€œWaiting There.â€ In the past he has written, but not performed,
his music. If Ziamâ€™s royalty is 0.12 of the suggested retail price of $15.00, but 0.25 of the retail price is deducted for packaging before
Ziamâ€™s royalty is calculated, how much will he receive for sale of the CD? Write your answer in the form of an equation and solve it.SE
6-2 Customer Relationship Management
Minh Phan is going over the numbers one more time. He is about to make the most important sales
presentation of his young career, and wants everything to be right. His prospective client, Media
Systems, Inc., is one of the countryâ€™s leading media and communications organizations. Media Systemsâ€™
primary challenge is how to effectively manage its diverse customer base. The company has
70,000 publication subscribers, 58,000 advertisers, 30,000 telephone services customers, and
18,000 ISP (Internet service provider) customers. The company had little information about who its
customers truly were, which products they were using, and how satisfied they were with the service
they received. Thatâ€™s where Minh and his company, Customer Solution Technologies, LLC, came
in. Through the use of customer relationship management software, Minh believed Media Systems
would be able to substantially improve its ability to cross-sell and up-sell multiple media and communications
services to customers, while substantially reducing customer complaints.
1. What percentage of the total does each of the four customer groups represent? Round to the
nearest hundredth of a percent.
2. Minhâ€™s data shows that on average, only 4.6% of customers were purchasing complementary services available within Media Systems.
By using his companyâ€™s services, Minh was projecting that these percentages would triple across all user groups within one year. How
many customers would that equate to in total for each group? What would be the difference compared to current levels?
3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers,
423; telephone service customers, 4,411; and ISP customers 823. What percentage of customers (round to two decimal places)
complained within the last year in each category? If the CRM software were able to reduce complaints by 50% each year over the next
two years, how many complaints would there be by category at the end of that time period? What would the number of complaints at the
end of two years represent on a percentage basis
Attached is the case study and the template