Explore BrainMass
Share

Explore BrainMass

    Break even graph

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

    There are two ways to produce television sets; each has a different cost structure as follows:

    Process A Process B
    Unit Sales price = $120,00 unit sales price = $150,00
    Unit Variable cost = $75,00 unit variable cost = $90,00
    Fixed Cost = $4,500 fixed cost = $5,400

    A) What is the break-even volume ( ex How many telvesion sets must be sold to Breakeven) for process A?

    B) if you sold 95 television sets, what would the profit be if you used process A? Process B?

    C) Which process ( A or B) would you choose to use if you knew with certainty that you would sell 98 television sets? What about if you knew for certainty the you would sell 100 television sets? Explain.

    D) Draw the break even graph for process A and B.

    E) At what quantity will the profits or losses be the same

    Quantity= Fixed Costs/(Unit Selling Price - Unit Variable Cost)

    Profit = (U.S.P.)(Quantity) - [(U.V.C.)(Quantity) +Fixed Costs]

    2) A manufacture is producing three types of pliers - economy, standard and deluxe - with this "unit information"

    Economy Standard Deluxe
    Selling Price $3.00 Selling Price $4.00 Selling Price $5.00
    Metal Required- 3 oz Metal Required 7oz Metal Required 6 oz
    Time Required- 10min Time Required 12 min Time Required 15 min

    There is no limit on the amount of metal he can use - he only has 1,400 ounces of metal. There is also no limit on the minutes of labor he can use- he only has 4,000 minutes of labor. Each ounce of metal costs $0.04 and each minute of labor costs $0.20. The manufacturer wants to make the most money he could make and he defines his "profit" as "total revenue" which is price X quantity, less the 'cost of resources'

    A) Build a "influence chart" ( with mathematical Operators adn Shapes) that shows the influence among these items:

    PROFIT COST OF LABOR USED
    METAL USED UNIT SELLING PRICE
    LABOR USED QUANTITY MADE
    TOTAL REVENUE METAL PER UNIT
    MINUTES PER UNIT COST PER OUNCE
    COST OF RESOURCES USED COST PER MINUTE
    COST OF METAL USED

    B) Indicate it the items are: dependent variables (DV), independent variables ( IND.V), intermediate variables ( INT.V.) or constants (C).

    C) Show in a spreadsheet the manufacturing process.

    D) Use Whats Best or Microsoft Solver for the Problem.

    © BrainMass Inc. brainmass.com October 9, 2019, 6:55 pm ad1c9bdddf
    https://brainmass.com/business/business-management/break-even-graph-102358

    Solution Preview

    Please see attachments for complete details.
    1. Word document contains influence chart, formulas, notes, and algebraic ...

    Solution Summary

    Word document contains influence chart, formulas, notes, and algebraic formulation . Excel file contains detailed computations , graphs , formulas sheet , working notes , manufacturing process (alternative depiction), formulation and solution to linear problem, formulas sheet, and integer optimal solution.

    $2.19