Explore BrainMass

Explore BrainMass

    Allen Frame: Cost Concepts for Higher Production Levels

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

    In 2005 AFC, produced 23,000 and provided 1,000 custom framing services and sold 20,000 frames. Holding the sales and framing service constant, supose the president instructed manufacaturing to produce at levels of 26,000 and 28,000. I have attached the excel spread that I have completed so far.

    Write 2-3 Paragraphs explanation as to why the president would want to do this and how this might create a future problem for AFC.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:56 pm ad1c9bdddf
    https://brainmass.com/business/management-accounting/allen-frame-cost-concepts-for-higher-production-levels-158476

    Attachments

    Solution Preview

    I can write those paragraphs you want, but first a couple of comments about your spreadsheets:

    1. I expected to see a little chart projecting the dollar amount of contribution margin at 3 different sales levels: 23K, 26K and 28K. It seems like it should show sales, cost of sales based on your 11.91 unit price, gross margin, then overhead (a mini forecasted income statement). A president is looking to more profits, of course, but your spreadsheets mostly address the past, not the future.

    2. I don't understand why fixed costs changed on your contribution income statement. There may be a good reason that I can't see. The format of your income statement is ...

    Solution Summary

    The solution includes four comments for additional clarity about the prepared spread sheet. The memo to the President is also included.

    $2.19

    ADVERTISEMENT