Excel Modified Break-even Pricing Tool-Rev 8---6-11-2013.xls

Excel Modified Break-even Pricing Tool-Rev...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 of 8 EXCEL PRICING TOOL Demand Curve Selected Price Values Price Units Total Revenue Variable Cost Fixed Cost Total Cost Profit $19.50 4500 $87,750 $31,500 $70,000 $101,500 -$13,750 $27,000 $45,000 $58,500 $76,500 $19.00 5000 $95,000 $35,000 $70,000 $105,000 -$10,000 $30,000 $50,000 $65,000 $85,000 $18.50 5500 $101,750 $38,500 $70,000 $108,500 -$6,750 $33,000 $55,000 $71,500 $93,500 $18.00 6000 $108,000 $42,000 $70,000 $112,000 -$4,000 $36,000 $60,000 $78,000 $102,000 $17.50 6500 $113,750 $45,500 $70,000 $115,500 -$1,750 $39,000 $65,000 $84,500 $110,500 $17.00 7000 $119,000 $49,000 $70,000 $119,000 $0 $42,000 $70,000 $91,000 $119,000 $16.50 7500 $123,750 $52,500 $70,000 $122,500 $1,250 $45,000 $75,000 $97,500 $127,500 $16.00 8000 $128,000 $56,000 $70,000 $126,000 $2,000 $48,000 $80,000 $104,000 $136,000 $15.50 8500 $131,750 $59,500 $70,000 $129,500 $2,250 $51,000 $85,000 $110,500 $144,500 $15.00 9000 $135,000 $63,000 $70,000 $133,000 $2,000 $54,000 $90,000 $117,000 $153,000 $14.50 9500 $137,750 $66,500 $70,000 $136,500 $1,250 $57,000 $95,000 $123,500 $161,500 $14.00 10000 $140,000 $70,000 $70,000 $140,000 $0 $60,000 $100,000 $130,000 $170,000 $13.50 10500 $141,750 $73,500 $70,000 $143,500 -$1,750 $63,000 $105,000 $136,500 $178,500 $13.00 11000 $143,000 $77,000 $70,000 $147,000 -$4,000 $66,000 $110,000 $143,000 $187,000 $12.50 11500 $143,750 $80,500 $70,000 $150,500 -$6,750 $69,000 $115,000 $149,500 $195,500 $12.00 12000 $144,000 $84,000 $70,000 $154,000 -$10,000 $72,000 $120,000 $156,000 $204,000 $11.50 12500 $143,750 $87,500 $70,000 $157,500 -$13,750 $75,000 $125,000 $162,500 $212,500 $11.00 13000 $143,000 $91,000 $70,000 $161,000 -$18,000 $78,000 $130,000 $169,000 $221,000 $10.50 13500 $141,750 $94,500 $70,000 $164,500 -$22,750 $81,000 $135,000 $175,500 $229,500 $10.00 14000 $140,000 $98,000 $70,000 $168,000 -$28,000 $84,000 $140,000 $182,000 $238,000 $9.50 14500 $137,750 $101,500 $70,000 $171,500 -$33,750 $87,000 $145,000 $188,500 $246,500 $9.00 15000 $135,000 $105,000 $70,000 $175,000 -$40,000 $90,000 $150,000 $195,000 $255,000 $8.50 15500 $131,750 $108,500 $70,000 $178,500 -$46,750 $93,000 $155,000 $201,500 $263,500 $8.00 16000 $128,000 $112,000 $70,000 $182,000 -$54,000 $96,000 $160,000 $208,000 $272,000 $7.50 16500 $123,750 $115,500 $70,000 $185,500 -$61,750 $99,000 $165,000 $214,500 $280,500 Given Data: Quantity: Price per Unit: Price Increment: Q1:P1 => 14000
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern