Determine how many hardcover books must be sold to breakeven.

USE EXCEL

r Back Paperback contribution SalesContribution HardcoverHardcover Pape Before Tax Profit Fixed CostRoyality SalesContrbution $100,000 $1,100,000 $200,000$600,000 $1,700,000 $1,100,000 $12,000,000 ($11,400,000) $200,000$2,200,000 $400,000 $1,200,000$3,400,000 $1,100,000 $12,000,000 ($9,700,000) 300,000 $3,300,000 $600,000 $1,800,000 $5,100,000 $1,100,000 $12,000,000 ($8,000,000) 400,000 $4,400,000 $800,000 $2,400,000 $6,800,000 $1,100,000 $12,000,000 ($6,300,000) 500,000 $5,500,000 $1,000,000 $3,000,000 $8,500,000 $1,100,000 $12,000,000 ($4,600,000) 600,000$6,600,000 $1,200,000 $3,600,000 $10,200,000 $1,100,000 $12,000,000 ($2,900,000) $700,000 $7,700,000 $1,400,000 $4,200,000 $11,900,000 $1,100,000 $12,000,000 ($1,200,000) 800,000$8,800,000 $1,600,000 $4,800,000 $13,600,000 $1,100,000 $12,000,000$500,000 900,000$9,900,000 $1,800,000 $5,400,000 $15,300,000 $1,100,000 $12,000,000 $2,200,000 1,000,000 $11,000,000 $2,000,000 $6,000,000 $17,000,000 $1,100,000 $12,000,000 $3,900,000