Explore BrainMass

Explore BrainMass

    Roche Brothers alternatives for expansion of supermarket

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

    See attached file and please show ALL work.

    Roche Brothers is considering two alternatives for a capacity expansion of its supermarket - (1) 3-stage expansion, and (2) 1-stage expansion.

    The first alternative expands the supermarket at the end of year 0 to 60,000 customers, to 70,000 at the end of year 3, and to 80,000 at the end of year 5. Since the first stage expansion provides a big leap for the company to provide services from 30,000 to 60,000 customers, the initial investment would be higher at the end of year 0 than other two investments. The initial investment would be $1,000,000 at the end of year 0, $500,000 at the end of year 3, and $200,000 at the end of year 5. With this alternative, the company must pay $50,000 of monthly operating expenses.

    The second alternative expands the supermarket at the end of year 0 to 75,000. The initial investment would be $1,500,000 at the end of year 0. With this alternative, the company must pay $30,000 of monthly operating expenses.

    The projected demand for the next 7 years is shown below.

    Year Projected Demand
    1 50,000
    2 55,000
    3 60,000
    4 65,000
    5 70,000
    6 75,000
    7 80,000

    The current effective capacity is equivalent to 30,000 customers per year and the pre-tax profit is approximately $3 per month of customer spending. Using information given above, please prepare the following information in details:

    a. Before-tax cash inflows , cash outflows, and cumulative cash flow through year 7 for each alternative
    b. What is the final contribution at the end of year 7 for each alternative?
    c. What is the break-even years and months for each alternative?
    d. According to the question (c), if the annual compound interest rate is 10%, which alternative is better? Why?

    © BrainMass Inc. brainmass.com June 3, 2020, 9:32 pm ad1c9bdddf
    https://brainmass.com/business/business-management/roche-brothers-alternatives-for-expansion-of-supermarket-187775

    Attachments

    Solution Preview

    See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks

    Roche Brothers is considering two alternatives for a capacity expansion of its supermarket - (1) 3-stage expansion, and (2) 1-stage expansion.

    The first alternative expands the supermarket at the end of year 0 to 60,000 customers, to 70,000 at the end of year 3, and to 80,000 at the end of year 5. Since the first stage expansion provides a big leap for the company to provide services from 30,000 to 60,000 customers, the initial investment would be higher at the end of year 0 than other two investments. The initial investment would be $1,000,000 at the end of year 0, $500,000 at the end of year 3, and $200,000 at the end of year 5. With this alternative, the company must pay $50,000 of monthly operating expenses.

    The second alternative expands the supermarket at the end of year 0 to 75,000. The initial investment would be $1,500,000 at the end of year 0. With this alternative, the company must pay $30,000 of monthly operating expenses.

    The projected demand for the next 7 years is shown below.

    Year Projected ...

    Solution Summary

    This problem address and illustrates in step-by-step manner how to take capital investment decisions. The solution is presented in Excel format for easy understanding.

    $2.19

    ADVERTISEMENT