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

What is inventory control, What is Inventory Control? Inventory Contr...

What is Inventory Control? Inventory Control: Scope and importance of Inventory Control: It is the scientific method of determining how much stock is maintained so as to

Diversity management, Diversity management may be understood as the systema...

Diversity management may be understood as the systematic and planned commitment by organisations to recruit, retain, reward, and promote a heterogeneous mix of employees (Thomas, 1

Types of different barriers to successful communication, What are the types...

What are the types of different barriers to successful communication? Various barriers to successful communication are as illustrated here: a. More levels within the organis

Proposal arguments, the strategies that are used to strengthen a proposal a...

the strategies that are used to strengthen a proposal argument and examples of each.

Write the importance of edi, Question 1 What are the difficulties and or i...

Question 1 What are the difficulties and or issues of e-Commerce? Explain Question 2 What is Firewall? Explain how it works as a packet filters Question 3 What are the methods

Explain the different wireless technologies, Question 1 Explain any five a...

Question 1 Explain any five architectural components of CRM solution Question 2 Explain the different wireless technologies Question 3 Explain the meaning of Elect

Global expansion of heineken, Heineken NV is one of the world's largest bee...

Heineken NV is one of the world's largest beer producer, selling more beer outside the United States than its closest competitors, Anheuser-Busch and SABMiller. In 2002, only 14% o

Write a report to mr fenworth to communicate your findings, QUESTION 1 ...

QUESTION 1 Although all teams are groups, not all groups are teams. Discuss this statement with reference to any organisation of your choice QUESTION 2 Mr Fenworth,

What is the suitable procedure of job evaluation, What is the suitable proc...

What is the suitable procedure of job evaluation? Procedure of Job Evaluation: 1. Know the job to be evaluated. 2. Define and analyse the needs of the job. Write-down

Weaknesses of eoq formula, Weaknesses of EOQ Formula 1. Erratic Usa...

Weaknesses of EOQ Formula 1. Erratic Usages : The formula we have used assume that the usage of materials is both predictable and evenly distributed. When this is not t

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