Explore BrainMass

Explore BrainMass

    Comprehensive Master budget analysis

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

    Budget analysis, look at westport excel and help answer questions on westport word

    (See attached files for full problem description)

    ---
    Discussion Questions for Westport Budget

    1. Memo from Tom Westport: In real life do you think the boss would send you such a informative memo including so many of the details handed to you or would you have to play detective as well as do some guessing?

    2. Annual Budget: What do you think of their goal of reducing direct labor hours per table from 1.56 to 1.40 this year?

    3. Annual Budget: Why is the price on the annual budget $53.50 but it's $54 and $56 on the sales budget?

    4. Annual Budget: If Mr. Westport wanted $100,000 in profit instead of $70,000, what are a few ways he could get it?

    5. Sales Budget: Why isn't all $27000 in sales from the first quarter collected in the first quarter?

    6. Production Budget: Why didn't Sally simply match production to sales. For instance, why isn't production 500 in Q1, 3000 in Q2, 5000 in Q3 and 1500 in Q4?

    7. Direct Materials-Legs: What does "Supplier terms are 30 days" mean?

    8. Mfg Overhead Budget: Where was the POR of $0.73 calculated? How did Sally come up with it?

    9. Cash Budget: Why isn't depreciation expense a cash disbursement?

    10. Cash Budget: Why did the owner kick-in $75,000 in Q2 and take it back in Q4?
    ---

    © BrainMass Inc. brainmass.com June 3, 2020, 6:09 pm ad1c9bdddf
    https://brainmass.com/business/cash-budgeting/comprehensive-master-budget-analysis-49554

    Attachments

    Solution Preview

    1. Memo from Tom Westport: In real life do you think the boss would send you such a informative memo including so many of the details handed to you or would you have to play detective as well as do some guessing?

    2. Annual Budget: What do you think of their goal of reducing direct labor hours per ...

    Solution Summary

    This shows comprehensive master budget analysis through excel file

    $2.19

    ADVERTISEMENT