math

posted by .

"ThermoStar has been producing residential thermostats for over 50 years. Looking over the past 20 quarters (5 years) of the different product lines, the general manager has been trying to get a handle on sales, costs, and production, and has asked for your help. Your response to the general manager will be in three parts: An Excel spreadsheet that details your analysis, a 3 slide PowerPoint presentation that shows some key graphs, and a two to three page report on the situation that addresses the company’s operations, cites your analysis, and provides recommendations. You need to use the data to describe the business, plus give your personal recommendations on what the business seems to be doing right, what needs to change, and/or what the manager might need to be concerned about. Write your report with the intention that the general manager will view your complete product as your deliverable, that is, your report should use your Excel and PowerPoint analysis as “attachments” that provide evidence to your narrative. Answer the following five questions using Excel and refer to your datasheet. Make sure your answers include all the data required and are easily accessible for the professor to locate and grade.

1. Calculate the descriptive statistics (summary statistics) for total sales (in K units). Show the Descriptive Statistics as your output on the Excel sheet.

2. Using the unit data by product line, compile a breakdown of sales by product line.
What percentage of the total sales is for each product line?
Also, currently the sales total equals 528,000 units.
If the sales total was changed to 100,000 total units, how many units will Alpha, Beta, and Gamma have?

3. ThermoStar tests thermostats so they are calibrated with a mean of 70 degrees, with an associated standard deviation of 2 degrees. Given this mean and standard deviation what percentage of thermostats will test below the inspector’s cutoff value and thus need to be recalibrated? (See the data sheet for the cutoff and assume that the test results are normally distributed.)

4. A sample of 40 employees shows the mean time spent in training per year to be 40 hours, with the associated standard deviation as noted in the datasheet. Construct a 95 percent confidence interval around the mean presenting both the upper and lower limits

5. We want to predict total costs, and we know the number of units produced. Do a simple linear regression to predict the total costs. What is your dependent variable? What is your independent variable? Write the regression equation showing the relationship between the independent and dependent variables. Also, use the R2 and t-statistic to tell me if this model is suitable for business decision making? If so, why? If not, why not? (Hint: copy and paste special, transpose the data into columns, then run the regression tool.)
"

  • math -

    Tonya took out a loan to help pay for her house. She borrowed $70,000 for 15 years at a yearly simple interest rate of 5%. How much interest will she end up paying the bank?

  • math -

    Simple Interest(I) = PRT

    Principal(P)- $70,000
    Rate of Interest(R)- 5%= 5/100= 0.05
    Time(T)- 15 years

    I=P*R*T
    I= 70000*0.05*15
    I= $52500

    She will pay interest of $52500

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Marketing Management

    Describe a product that entered the market over the past two to three years and succeeded. Why did it succeed?
  2. Microeconomics

    Two years ago a large corp. gegan construction on a new site. At that time, mgrs thought that production from that plant would generate over $25 million in sales. However, a more conservative and realistic estimate suggests that the …
  3. Statistics

    The assignment is in three parts: 1. An analytic section that you will submit as an Excel spread sheet 2. A PowerPoint presentation of 3 to 5 slides. 3. A narrative section that you will submit as a two to three page Word document …
  4. Business Analytics statistics

    I don't under stand ho to get the answer to this excel question can anyone help?
  5. Statistics

    Can any one help me with this? ThermoStar has been producing residential thermostats for over 50 years. Looking over the past 20 quarters (5 years) of the different product lines, the general manager has been trying to get a handle
  6. math B30

    must be answered with a series/sequences formula over the past 10 years, the number of CD's sold by a mail order music company has increased an average of 12% per year. If the company sold 1.5 million CD's ten years ago, the total …
  7. English

    Please check for any errors. Let me know if i need to place commas anywhere or delete. Attached are the Widget Sales figures for the past six months. My principle concern is the lack of effectiveness of the sales manager in the Southwest …
  8. Accounting

    I am having difficulties with the accounting problem below Roland Andersson is the manager of the Ekland Division of Ystad Industries. He is one of several managers being considered for position of CEO, as the current CEO is retiring …
  9. Math

    In a suburb of Houston, housing costs have been increasing at 5.2% per a year compounded annually for the past 8 years. A house with a current value of $26,000 would have been worth how much 8 years ago?
  10. Business Math

    In a suburb of Houston, housing costs have been increasing at 5.2% per a year compounded annually for the past 8 years. A house with a current value of $26,000 would have been worth how much 8 years ago?

More Similar Questions