Draw a scatter diagram of the administrative cost

Reference no: EM131198349

Problem - CWT Lawyers Pty Ltd started to operate in 2015 in Melbourne. CWT advises clients on legal issues relating to commercial contracts, ASIC compliance, Trade Practices and Corporations Act requirements, business structuring, mergers and acquisitions of business. CWT experienced the first year's widely fluctuating client number in each month. Peter, the accountant of CWT, lists the client number and administrative cost in 2015 shown below.

Month	Client Number	Administrative Cost
January	140	$1,490
February	50	702
March	40	600
April	100	1,000
May	130	1,900
June	95	920
July	110	1,020
August	30	410
September	70	950
October	120	1,220
November	60	830
December	30	750

Peter has estimated that CWT's relevant range of monthly activity in the future will be 50 to 120 clients.

Required-

A. Draw a scatter diagram of the administrative cost and client number from January to December as shown above.

B. Visually fit a semi-variable cost line to the plotted data in part A above. What are the fixed and variable costs? Express the cost behavior in formula form Y = a + bX correct to two decimal places.

C. Identify the number of client number and administrative costs, for each month within the relevant range.

D. Use the high-low method to estimate the behavior of CWT's administrative costs based on the client load within the relevant range. Express the cost behavior in formula form Y = a + bX correct to two decimal places.

E. Construct an Excel spreadsheet and use Excel commands to perform a least-square regression and estimate the administrative cost behavior within the relevant range. Express the cost behavior in formula form Y= a + bX correct to two decimal places. Compute and interpret the R² value for the expression in NOT more than 50 words.

F. Predict the administrative costs for a month when there are 80 clients. Use the cost equations, high low method in Part D and least-square regression in Part E to make the predication. Which prediction would you prefer to use? Why? Justify your answer of NOT more than 100 words.

G. How confident should Peter be about the three cost models (the scatter diagram and a visual fit semi-variable cost line, high-low method and least-square regression within a relevant range)? Explain your answer of NOT more than 150 words.

Reference no: EM131198349

Questions Cloud

Explain why this problem qualifies as a social problem : Discuss the individual and social implications of this problem. Your discussion of implications should be supported by accurate research data. Summarize what social science experts have to say about this social problem. Are their conclusions method..

Developments in health information technology : Identify three ways that developments in health information technology will cause important changes in the U.S. healthcare system. First, how do we know that we spend too much as a nation on healthcare? Second, explain 3 reasons why these costs need ..

How you can explain each piece of information to parents : Choose the information to include. Think about how you can best explain each piece of information to parents and family members. Also, decide how to organize your information.

It auditing and security risk management unit : To assist PVSS, your contract has been expanded to also create a risk assessment. In addition, PVSS management has asked for information on the vulnerabilities, threats, and exploits.

Draw a scatter diagram of the administrative cost : Peter has estimated that CWT's relevant range of monthly activity in the future will be 50 to 120 clients. Draw a scatter diagram of the administrative cost and client number from January to December as shown above

What is the current share price : Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years because the firm needs to plow back its earnings to fuel growth. The company will pay a $12 per share dividend 10 years from today ..

How important is it for enterprise to keep up with version : Seeking to stretch their budgets in a tough economic environment, IT managers are subjecting every technology purchase to rigorous scrutiny and looking for every opportunity to reduce total cost of ownership (TCO).

Prominent consumer products firm-original capital structure : Desert Rose, Inc., a prominent consumer products firm, is debating whether to convert its all-equity capital structure to one that is 30 percent debt. Currently, there are 13,000 shares outstanding, and the price per share is $43. EBIT is expected to..

It auditing and security risk management : At this point, you have a pretty clear understanding that although PVSS has a desire to do things in sound and secure fashion, it is not able to consolidate efforts and focus its attention in appropriate places.

User Account

All Pages