Share
Explore BrainMass

Comprehensive Master budget analysis

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?
---

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