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

How is voluntary withdrawal cause of labour turnover, How is voluntary with...

How is voluntary withdrawal cause of labour turnover? Voluntary withdrawals or by the worker because of: • dislike for the current job; • good job obtainable elsewhere;

Where is the supervisor taking care about the organization, What are the po...

What are the points where supervisor has to take care about the organization? A supervisor generally has to take care of the given: • Training and selecting of employees

Safety organization, Safety Organization  A safety organization consis...

Safety Organization  A safety organization consists of a systematic procedure by means  of which  interest is  co rated and  maintained and all safety activities  are co relat

Explain about the term quality in management, Explain about the term Qualit...

Explain about the term Quality in Management. Quality: Quality is described as fitness of purpose. It is a relative term and is usually explained along with reference to

What do you mean by managerial motivation, What do you mean by Managerial M...

What do you mean by Managerial Motivation? Managerial Motivation: This motivation is the means or inducements that impel or inspire a person to intensify his willingness

Activities in an organization - organizational structure, Organizational st...

Organizational structure defines the activities and the goals and the achievement level which defined by the organizations. Four organizational structures define the: 1. Func

Explain about the management information system, Explain about the Manageme...

Explain about the Management Information System. Management Information System: It is defined as like a formal method of making obtainable to management the precise and t

Distinguish between leadership and management, Question 1: (a) Define "...

Question 1: (a) Define "Leadership". (b) B. Distinguish between leadership and management. (c) Describe Fiedler's Contingency Theory of Leadership. Discuss the Trait & Be

Analyze the weaknesses of the eia system, "In the past two decades Mauritiu...

"In the past two decades Mauritius has experienced an unprecedented boom in the tourism industry. Tourism activities are mostly concentrated on the coastal zone and over 90% of th

Practices of management.., HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGL...

HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGLY FOR GROUP OBJECTIVES IN YOUR ORGANISATION (TARGET BASED INDUSTRY ) APPLY YOUR INTERPERSONAL INFLUENCE THROUGH COMMUNICATION PROCES

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