Referring to the two-variable data table shown in the following worksheet:
The row-input cell is
NewLeaf Paper Monthly Revenue Projected customers (per month) Projected average units (per customer) Customers Revenue Expenses Income U $0 $14,000 $14,000 5 $22,500 $29,500 $7,000 10 $45,000 $45,000 $0 15 $67,500 $60,500 $7,000 20 $90,000 $76,000 $14,000 25 $112,500 $91,500 $21,000 30 $135,000 $107,000 $28,000 35 $157,500 $122,500 $35,000 40 $180,000 $138,000 $42,000 45 $202,500 $153,500 $49,000 50 $225,000 $169,000 $56,000
Variable Expenses (per customer) Customer Setup fee (once per customer) Total Variable Expenses per customer Variable Expenses per unit Unit cost (once per unit) Total Variable Expenses
Fixed Expenses Marketing phone, print, postage Training Total Fixed Expenses
BrandBuilder selling price Income 10 12 14 16 225 $11,500 $2,500 $6,500 250 $19,000 ($9,000) $1,000 $11,000 275 $17,500 ($6,500) $4,500 $15,500 300 ($16,000) ($4,000) $8,000 $20,000 325 $14,500) ($1,500) $11,500 $24,500 350 $13,000 $1,000 $15,000 $29,000 375 ($11,500) $3,500 $18,500 $33,500 400 ($10,000) $6,000 $22,000 $38,000
Total Monthly Expenses $76,000 Income $14,000