Purchase Solution

Comprehensive Master budget analysis

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

This shows comprehensive master budget analysis through excel file

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

Purchase this Solution


Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media