Purchase Solution

# TSA trend

Not what you're looking for?

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).

##### Solution Summary

The expert examines TSA trends and short term potentials.

Solution provided by:
###### Education
• MBA, Indian Institute of Finance
###### 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."

##### 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.

##### SWOT

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