Explore BrainMass
Share

Explore BrainMass

    Consumer Mathematics - Quantitative Reasoning

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    HardWood, Inc., produces and sells the finest quality pool tables in all of Madison County, Iowa. The company expects the following sales and expense in 2009 for its tables:
    Sales (1,000 tables @ $500 per table) $ 500,000
    Variable expenses 200,000
    Fixed expenses 60,000
    A. What is the contribution margin (CM)?
    B. How many tables must be sold in order for Hardwood, Inc., to break even?
    C. What dollar amount of sales of tables is necessary to break even?

    D. Using the slope-intercept formula: Y = mx +b, where Y= Calculated cost, m = variable expense per unit, x = number of tables (units) sold, and b = y-intercept (which is the fixed expense of $60,000), graph the break-even point using MS Excel (show only sales line and expenses line. The break-even point where the total expenses line crosses the sales line ).

    I have complete parts A,B,C, but need help with part D

    © BrainMass Inc. brainmass.com October 9, 2019, 11:32 pm ad1c9bdddf
    https://brainmass.com/math/consumer-mathematics/consumer-mathematics-quantitative-reasoning-259553

    Solution Preview

    HardWood, Inc., produces and sells the finest quality pool tables in all of Madison County, Iowa.  The company expects the following sales and expense in 2009 for its tables:
    Sales (1,000 tables @ $500 per table) $ 500,000
    Variable expenses    200,000
    Fixed ...

    Solution Summary

    A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

    $2.19