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:
Education
  • MBA, Indian Institute of Finance
  • Bsc, Madras University
Recent Feedback
  • "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
  • "thank you!"
  • "Thank you again Jayant. You are super fast. "
  • "Thank you Jayant. You are appreciated. "
  • "Again, thank you Jayant. You are wonderful. "
Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

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.

Introduction to Finance

This quiz test introductory finance topics.