Blue Sunset Band is planning to record a new album.A major decision to be made is if the band can record the album on their own, or if they should hire a studio to record it with.The fixed cost for recording at the studio is $100,000, plus the manufacturing cost per CD, which is at $5.If they record the album in-house, the cost per CD is $10.They plan to produce 3000 copies of the album regardless of the place of recording.If the band wished to break even with the cost, how can they achieve this by using the Goal Seek feature in Excel?

Question

Quizplus · Accepted Answer

The Answer of Blue Sunset Band is planning to record a new album.A major decision to be made is if the band can record the album on their own, or if they should hire a studio to record it with.The fixed cost for recording at the studio is $100,000, plus the manufacturing cost per CD, which is at $5.If they record the album in-house, the cost per CD is $10.They plan to produce 3000 copies of the album regardless of the place of recording.If the band wished to break even with the cost, how can they achieve this by using the Goal Seek feature in Excel?

Blue Sunset Band Is Planning to Record a New Album