Planning and control systems , Business Management

a) You are required to carry out a suitable time series analysis using the MINITAB project file SALES.MPJ.  The data set pertains to 8 years of monthly sales (£'000s) for a company.

A management accountant in the product division was asked to develop a model that could be used to obtain short-term forecasts of the monthly demand.  Comment upon your results and the methodology used.

b) You are required to carry out a regression analysis using the MINITAB project file FINANCIAL.MPJ.  The database contains financial data on 100 companies.  Use Total Revenues, Total Assets, Return on Equity, Earnings per Share, Average Yield and Dividends per Share to predict the average P/E ratio for a company.

The analysis should include any necessary diagnostic procedures to validate your results.  It should also cover the regression diagnostics to check the validity of the data and the assumptions underlying linear regression.  You are reminded that your analysis should contain adequate statistical analysis with appropriate discussions to convey your understanding of the statistical procedures involved.

Present your findings in the form of a technical report which should be word-processed. The style and presentation of your work is, however, important and should be in-line with what would be presented in a commercial/business environment

Capture electronically, the regression results from MINITAB and to import them into WORD so that they can be edited and presented in a professional manner.

Required:

1. Build a suitable time series model for forecasting the monthly spot prices and carry out a suitable forecast.

2. Build a regression model to predict the monthly returns on Microsoft stock using an appropriate selection of the given variables. 

3. Carry out any necessary diagnostic procedures in order to verify the validity of your chosen models.

3.  Interprete the various relevant MINITAB output from your various analysis.

4.  Write a technical report providing a full interpretation of your findings, a justification of your chosen models with supporting evidence, make any recommendations you think are appropriate and outline any shortcomings of the approach you have used.

 

Posted Date: 2/23/2013 7:35:49 AM | Location : United States







Related Discussions:- Planning and control systems , Assignment Help, Ask Question on Planning and control systems , Get Answer, Expert's Help, Planning and control systems Discussions

Write discussion on Planning and control systems
Your posts are moderated
Related Questions
QUESTION Outsourcing Customer Service- Is it a real solution? Outsourcing any of your business functions can pose risks, or at least give you reason to lose sleep, but above al

What fundamental budgets are essential for manufacturing budget? Manufacturing budget requires the given fundamental budgets or estimates to meet the plans as follows: 1. Pr

Question 1: Discuss the importance of applying the relationship-marketing concept to the marketing activities of Wal-Mart. Question 2: Explain how Wal-mart can monitor

QUESTION 1 "The process of Communication involves the exchange of ideas, feelings and values to build up mutual understanding and good human relations." Give an account of the

Management skills: Q. A few organizations have recently tried to minimize employee use of email when communicating with colleagues. Specifically, these companies have banned t

Section - Introduction An introduction to either   An industry or   A profession or   A particular business or   A iwi/hapu group Give an introduction t

QUESTION (a) After seeing the results obtained from table above, Ah Kong decides to implement an ERP system. List down two advantages and two disadvantages of implementing such

what are the functions of material managemnet

Competitive Environment and Strength of a Company Over the years the growth in Glass industry had slowed down and margins are shrinking in high volume markets. The reason attr

AskEvaluate the ethics of selling gene tests directly to consumers like these companies are doing. What would each of the three theories of a business’s duties to consumers say abo