Planning and control systems , Business Management

Assignment Help:

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.

 


Related Discussions:- Planning and control systems

Decision making and leadership, Question 1 Herring (1994: introduction)...

Question 1 Herring (1994: introduction) claims that "men and women have recognizably different styles in posting to the Internet". Discuss. Question 2 (a) Often women

Global economic crises, Global Economic Crises                     Th...

Global Economic Crises                     The current economic crisis has affected many countries in Europe as well as many countries in the world over. Micro credit institu

Efficient communication-ocr’s examination blunders, efficient communication...

efficient communication (unlike the OCR's examination blunders) is fundamental to an organisation such as the OCR exam board because it helps to: Keeps schools (the custome

Monthly maintenance programme, Daily maintenance for every facility is n...

Daily maintenance for every facility is not advisable as it would be quite expensive and time consuming. Hence according to the requirements and importance of the machi

E-strategy, Estimate the Contribution of an E-Strategy to the Achievement o...

Estimate the Contribution of an E-Strategy to the Achievement of an Organisation''s Objectives

Define the term training, QUESTION 1 (a) Define the term training (b...

QUESTION 1 (a) Define the term training (b) Clearly explain the benefits that an organisation derives from training QUESTION 2 (a) Explain the term reward management

How do you and your organization define system, Problem 1. How do you a...

Problem 1. How do you and your organization define system? Mention the systems that require engineering. Defining system Mentioning the systems that require engineerin

5-year strategic planning, Guide lines for this 5-year strategic planning. ...

Guide lines for this 5-year strategic planning. Develop a five-year strategic plan with cost estimates and a time line. It should be 5-7 double-spaced, typed (12 point) pages plus

Research on environmental attitudes, Research on environmental attitudes in...

Research on environmental attitudes in the context of nature-based tourism and ecotourism in particular have emerged as an interesting topic among tourism researchers in recent yea

Describe email usage at work, Describe Email usage at work a) Electron...

Describe Email usage at work a) Electronic mail (email) refers to the process of using telephone and computers lines as a mailing system for both external (internet) and inter

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd