Develop a trendline to identify the relationship between billable hours and overhead costs.

  • The managing director of a consulting group has the following monthly data on total overhead costs and professional labor hours to bill to clients:
OverheadCosts BillableHours
$365,000 3,000
$400,000 4,000
$430,000 5,000
$477,000 6,000
$560,000 7,000
$587,000 8,000
  • a) Develop a trendline to identify the relationship between billable hours and overhead costs.
  • b) Interpret the coefficients of your regression model. Specifically, what does the fixed component of the model mean to the consulting firm?
  • c) If a special job requiring 1,000 billable hours that would contribute a margin of $38,000 before overhead was available, would the job be attractive?
find the cost of your paper

Create a three-column chart in which the first column lists non management skills you have.

The 21st century offers many challenges to every one of us. As more firms go global, as more economies interconnect, and as the Web blasts away boundaries to communication, we….

What is your reaction when faced with stressful or time-pressured situations

When faced with stressful or time-pressured situations: 1. I use effective time-management methods such as keeping track of my time, making to-do lists, and prioritizing tasks. 2. I reaffirm my….

Develop creative and innovative solutions to problems.

When faced with a complex or difficult problem that does not have an easy solution: 1.. I define a problem in multiple ways. I don’t limit myself to just one….