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

Q2: See solution attached for the question below it is the spreadsheet
Using the data in the Excel file Credit Card Spending, develop a multiple linear regression model for estimating the average credit card expenditure as a function of both the income and family size.
A) Predict the average expense of a family that has two members and an income of $188,000 per annum, and
B) Another that has three members and an income of $39,000 income per annum.

Describe in words what it is occuring?
I.e. describe method and use add-in excel to solve the problem. You may append the screen shots of menu utilizing the Add-In. Name the add-ins

The following is a set of data from a sample of n = 11 items: X 8 6 9 4 7 11 13 5 10 16 19 Y 22 15 25 10 19 31 37 13 27 45 54 a. Calculate the covariance. b. Calculate the coefficient of correlation. c. Describe the relation between the two variables X and Y.

The vibrations of a bi-atomic molecule AB can be approximated as a harmonic oscillator with the potential energy of type V (x) = (kx^2)/2, x representing the spatial deviation of the relative position between those 2 molecules towards equilibrium. Calculate the vibrational energy of the H2 molecule knowing that k = 510N/m and the mass of a hydrogen atom is m0 = 1.66 ∗ 10−27 kg

Perform a goodness-of-fits test to determine if a uniform distribution between 0 and 10 is a good fit to the 150 data observations summarized in the table below. Use α=0.05.

Assume that you are working at a manufacturing company and trying to decide between the following two projects:

Q1. If the cost of capital is 8%, use the incremental IRR rule to make the decision.

Q2. If the cost of capital is the same as the Q1, determine the NPV of each project.

A business that is known for selling good quality and affordable consumer electronics conducted a market research and came to the conclusion that there is a market for high-quality high-priced premium electronic consumer products. The prospective consumers in this new market are characterized as being tech savvy and affluent; and are aged between 27-35 years old. Based on the information given, create a detailed marketing strategy using the 4Ps.

marketing

What factors contribute to high maternal mortalities rates in Nigeria than any other country?

How do we check if the independent variables are statistically significant and contribute to the multiple regression models?

Describe how antibacterial soaps are among several factors that contribute to the rise of antibiotic-resistance bacteria.