Question: set up and solve using excel solver , show work Setup and Solve the following problem using Excel and Solver: 9. Music CD Sales In

Setup and Solve the following problem using Excel and Solver: 9. Music CD Sales In the year 2022, industry revenues from sales of recorded music amounted to $3.6 billion for rock music, $1.8 billion for rap music, and $0.4 billion for classical music. You would like the selection of music in your music store to reflect, in part, this national trend, so you have decided to stock at least twice as many rock music CDs as rap CDs. Your store has an estimated capacity of 20,000 CDs, and, as a classical music devotee, you would like to stock at least 5,000 classical CDs. Rock music CDs sell for $12 on average, rap CDs for $15, and classical CDs for $12. How many of each type of CD should you stock to get the maximum retail value? X1= Number of Rock Music CDs to Stock in Store = A (Format xxxxx No Commas) X2=NumberofRAPCDstoStockinStore= (Format xxxx No Commas) X3=NumberofClassicalMusicCDstoStockinStore= A (Format xxxx No Commas) A (Format xxxxx No Commas) X2= Number of RAP CDs to Stock in Store = (Format xxxx No Commas) X3= Number of Classical Music CDs to Stock in Store = A) (Format xxxx No Commas) Maximum Retail Value = A (Format xxxxxx No commas) Setup and Solve the following problem using Excel and Solver: 9. Music CD Sales In the year 2022, industry revenues from sales of recorded music amounted to $3.6 billion for rock music, $1.8 billion for rap music, and $0.4 billion for classical music. You would like the selection of music in your music store to reflect, in part, this national trend, so you have decided to stock at least twice as many rock music CDs as rap CDs. Your store has an estimated capacity of 20,000 CDs, and, as a classical music devotee, you would like to stock at least 5,000 classical CDs. Rock music CDs sell for $12 on average, rap CDs for $15, and classical CDs for $12. How many of each type of CD should you stock to get the maximum retail value? X1= Number of Rock Music CDs to Stock in Store = A (Format xxxxx No Commas) X2=NumberofRAPCDstoStockinStore= (Format xxxx No Commas) X3=NumberofClassicalMusicCDstoStockinStore= A (Format xxxx No Commas) A (Format xxxxx No Commas) X2= Number of RAP CDs to Stock in Store = (Format xxxx No Commas) X3= Number of Classical Music CDs to Stock in Store = A) (Format xxxx No Commas) Maximum Retail Value = A (Format xxxxxx No commas)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
