Hi/Low and Regression Forecasts with template
Not what you're looking for?
Please answer the attached questions, in a word document, using the attached excel template.
Hi/Low and Regression Models:
a. Complete the analysis (see Excel template)
b.
1) Anne asked specifically about the revenue and volume levels necessary to produce an operating income of $55,000 which you identified as: __________________ and _____________ (.50) each
High/Low
a) Breakeven $______________(.75)
b) Breakeven Units___________(.25)
Regression
a) Breakeven $______________(.75)
b) Breakeven Units____________(.25)
Purchase this Solution
Solution Summary
Your tutorial shows you the high low and the regression method for analyzing the variable portion and the fixed portion of total costs. See the new tabs in Excel, one for regression and one for high-low. I added a graph to illustrate why these methods give you different answers for the cost behaviors. The table of profits at the various levels are completed for you (click in cells to see computations). I added a table to compute the units and dollars needed to achieve the target profit of $55,000 for both methods.
Solution Preview
Your tutorial shows you the high low and the regression method for analyzing the variable portion and the fixed portion of total ...
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
Introduction to Finance
This quiz test introductory finance topics.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.