Manufacturing Sales Budgets: Martin & Sons
Not what you're looking for?
Can you help me get started with this assignment?
Martin & Sons, a small door manufacturer, sold 4,600 white six-panel doors for $130 each and 2,400 unfinished six-panel doors for $100 each. Mr. Martin feels that because home-owners are doing more themselves and the economy is down, that they may see an increase of 15% in sales of unfinished six-panel doors in 2012 and a corresponding 10% increase in sales of white six-panel doors. He wonders if he lowered the price of the white six-panel doors to $120 each, that he may only see an 8% decline in sales of white six-panel doors and the corresponding increase in unfinished six-panel doors.
1. Prepare a 2012 sales budget assuming that Martin & Sons holds prices at the current level and sales quantity remains at the 2011 level.
2. Prepare a 2012 sales budget assuming that Martin & Sons holds prices at the current level and the decrease in white six-panel doors is realized as is the increase in unfinished six-panel doors.
3. Prepare a 2012 sales budget assuming that Martin & Sons lowers the price of six-panel doors to $120 each and the decline in sales is as anticipated.
4. Should Martin & Sons lower the price of the white six-panel doors to $120 each?
5. Suppose the cost to produce the white six-panel door is $80 and the unfinished six-panel door is $45, at what volume level of each of the doors does the company make the most amount of profit? Show your work!
6. Theorize the following:
a. What changes could the company make if they wanted to maintain a cash balance of $650,000, rather than $350,000?
b. What is the company's cost of borrowing was 6%, rather than 12%? What recommendations would you make to them?
c. What is the company experienced 10% of bad debt per year? What would be the impact on their ending cash?
*** Please complete in Excel***
Purchase this Solution
Solution Summary
Your tutorial computes sales budgets in Excel (**>> see attached <<**) along with commentary about whether sales price reductions help the sales forecast and profit forecast. Click in cells to see computations and formulas.
Solution Preview
Your sales budgets are completed in Excel (** see attached **) along with commentary about whether sales price reductions help the sales forecast and profit forecast.
6. Theorize the following:
a. What changes could the company make if they wanted to maintain a cash balance of $650,000, rather than $350,000?
We don't know much ...
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
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.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Learning Lean
This quiz will help you understand the basic concepts of Lean.