Purchase Solution

TSA trend

Not what you're looking for?

Ask Custom Question

I need help in understanding the question below:

See PDF: Forecasting problems
1. These figures represent the company's short term potential. Use a TSA trend (linear regression) analysis from Excel Chart to produce a graph and forecast for the next two quarters. Show how much variance (R-square) is accounted for and the formula for the forecast.

2. There might be some correlation between columns three and four. Please use Data Analysis to calculate that correlation.

See Excel: Copy of Proforma Profit & Loss-08

1. Please calculate the effect on the company's annual Net Income (before taxes) if it were able to do scenario 1 in the related learning activity.

2. Please calculate the effect on the company's annual Net Income (before taxes) if it were able to do scenario 2 in the related learning activity.

See Excel: Copy of Proforma Profit & Loss-08
1. Using the Pro Forma from the White Again learning activity, what would be the company's net income before tax (NIBT) if the company sold 5% more each month than the numbers in that spreadsheet for the STAC and all SuperWrap products from April-December?

See Excel: Copy of Inventory Management Problems 1-2 08(1)
1. In Problem #1, explain why the carrying costs for STAC with ONE order per year is not 15,000 (5% x 300,000).

Purchase this Solution

Solution Summary

The expert examines TSA trends and short term potentials.

Solution provided by:
  • MBA, Indian Institute of Finance
  • Bsc, Madras University
Recent Feedback
  • "thank you!"
  • "Thank you again Jayant. You are super fast. "
  • "Thank you Jayant. You are appreciated. "
  • "Again, thank you Jayant. You are wonderful. "
  • "Thanks Jayant."
Purchase this Solution

Free BrainMass Quizzes
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.


This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.