Explore BrainMass

Explore BrainMass

    Accounting Problem- Charlie's Furniture Store

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

    (See attached file for full problem description)

    Charlie's Furniture Store has been in business for several years. The firm's owners have described the store as a
    "high-price, high-service" operation that provides lots of assistance to its customers. Margin has averaged a relatively
    high 32% per year for several years, but turnover has been a relatively low 0.4 based on average total assets of
    $800,000. A discount furniture store is about to open in the area served by Charlie's, and management is considering
    lowering prices in order to compete effectively.

    Please proceed to the "Analysis" worksheet and complete the basic problem requirements. Complete the problem
    requirements by entering appropriate amounts or formulas in shaded worksheet cells:

    a. Calculate current sales and ROI for Charlie's Furniture Store.
    b. Assuming that the new strategy would reduce margin to 20%, and assuming that average total assets would stay
    the same, calculate the sales that would be required to have the same ROI as that currently earned.

    Suppose that you presented the results of your analysis in parts (a) and (b) of this problem to Charlie, and he replied,
    "What are you telling me?!? If I reduce my prices as planned, then I have to practically double my sales volume in order to
    earn the same return? Given the results of your analysis, how would you react to Charlie?
    Suppose now that Charlie's says, "You know, I'm not convinced that lowering prices is my only option in terms of staying
    competitive. What if I were to increase my marketing efforts? I'm thinking about kicking off a new advertising campaign
    after conducting more extensive market research to better identify who my target customer groups are." In general, explain
    to Charlie what the likely impact of a successful strategy of this nature would be on margin, turnover, and ROI.

    © BrainMass Inc. brainmass.com June 3, 2020, 6:26 pm ad1c9bdddf
    https://brainmass.com/business/financial-ratios/accounting-problem-charlie-s-furniture-store-60096

    Attachments

    Solution Preview

    Please see the attached file.

    In doing such kind of problem, the data to be entered in the yello cells is already provided. The formula to be entered in te gray cells is also given below. You need to look at the formula given and put it in the gray cells. It shows that ROI ...

    Solution Summary

    The solution has the Charlie's Furniture Store problem relating to calculation of margin, turnover and ROI

    $2.19

    ADVERTISEMENT