The Angla Ruston University operates a Laundromat, solely for the purpose of providing laundering services to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Angla Ruston University operates a Laundromat, solely for the purpose of providing laundering services to students in residence. You have been hired as accounting students to analyze the cost of the laundering services and develop a cost function which describes the behaviour of the laundering costs. The university administration has assembled the data for a twelve-month period pertaining to the monthly total costs of providing the service and the corresponding number of students who used the laundering facilities each month. You were recently taught how to use the Excel graphing tool and a member of the team successfully generated the scattergram given below from the data set provided. 300,000 250,000 200,000 Total Laundering Costs 150,000 100,000 50,000 ANGLA RUSTON UNIVERSITY SCATTER DIAGRAM + A Line of Best Fit 500 1,000 1,500 2,000 2,500 3,000 # of Students Laundering The other team members are now tasked to use the graph to provide the administrators with a detailed response to the following questions: a) What is another name for the "line of best fit" in Excel? What is the purpose of this line? (2 marks) b) Using the "line of best fit", determine Angla Ruston University's fixed cost per month and the variable cost per student. (Use 0 & 2,500 students.) c) Based on the scatter gram, what is the equation of the total mixed cost function? (4 marks) (2 marks) d) In August of the upcoming academic year, the university expects the number of students using the The Angla Ruston University operates a Laundromat, solely for the purpose of providing laundering services to students in residence. You have been hired as accounting students to analyze the cost of the laundering services and develop a cost function which describes the behaviour of the laundering costs. The university administration has assembled the data for a twelve-month period pertaining to the monthly total costs of providing the service and the corresponding number of students who used the laundering facilities each month. You were recently taught how to use the Excel graphing tool and a member of the team successfully generated the scattergram given below from the data set provided. 300,000 250,000 200,000 Total Laundering Costs 150,000 100,000 50,000 ANGLA RUSTON UNIVERSITY SCATTER DIAGRAM + A Line of Best Fit 500 1,000 1,500 2,000 2,500 3,000 # of Students Laundering The other team members are now tasked to use the graph to provide the administrators with a detailed response to the following questions: a) What is another name for the "line of best fit" in Excel? What is the purpose of this line? (2 marks) b) Using the "line of best fit", determine Angla Ruston University's fixed cost per month and the variable cost per student. (Use 0 & 2,500 students.) c) Based on the scatter gram, what is the equation of the total mixed cost function? (4 marks) (2 marks) d) In August of the upcoming academic year, the university expects the number of students using the
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0071339476
Volume 1, 6th Edition
Authors: Beechy Thomas, Conrod Joan, Farrell Elizabeth, McLeod Dick I
Posted Date:
Students also viewed these accounting questions
-
Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
For the circuit in Fig. 8.115, use PSpice to obtain v(t) for 0 6 2 H 24 V 3 04Fv
-
Do Exercise 4.21 (1), using FIFO and four decimal places for unit costs. Explain any difference between the cost of work completed and transferred out and cost of closing work in progress in the...
-
Financial figures of the business of C. Wilson for the last 2 years are shown below. c. wilson Comparative Statements of Financial Position as at 30 June 2017 2018 ASSETS Cash at bank Accounts...
-
Two residents of California filed a lawsuit against Hertz Corporation on behalf of a group of people arguing that the companys labor practices were illegal. The corporation was labeling workers as...
-
Gronseth Drywall Systems, Inc., is in discussions with its investment bankers regarding the issuance of new bonds. The investment banker has informed the firm that different maturities will carry...
-
5. A compact car has a maximum acceleration of 4.5 m/s when it only carries the driver. The driver and the car combined, have a total mass of 1250 kg. What is the maximum acceleration after picking...
-
Imagine a situation in which a star that has initially a radius of Ro = 8 108m collapses to become a red dwarf with approximately the same radius as the earth, R = 6.38 x 10 m. (a) If it was...
-
we will be looking for:- four major types of planned change: human process interventions, techno-structural interventions, human resource management interventions, and strategic change interventions?...
-
Organizational Behavior Scholarly Journals only. Find an article that focuses on organizational behavior topics such as leadership, or decision making in your chosen field ( human resources. For...
-
Why would a leader demonstrating emotional intelligence be especially motivating to followers? How is self-monitoring related to emotional intelligence? How are these concepts (self-monitoring and...
-
Identify the components of an information system using the five-component framework and provide a brief summary of each. Explain Porter's five forces model. Management information systems...
-
Analyze how Filtronic used Arena to eliminate its time-consuming struggles with its internally developed product development tool that made tracking, maintaining, and releasing products slow and...
-
A torque of 36.5 N m is applied to an initially motionless wheel which rotates around a fixed axis. This torque is the result of a directed force combined with a friction force. As a result of the...
-
Pearson Education, a publisher of college textbooks, would like to know if students prefer traditional textbooks or digital textbooks. A random sample of students was asked their preference and the...
-
Buildit Corp. was contracted to construct a building for $ 1,600,000. the contract provided for progress payments. Buildits accounting year ends 31 December. Work began under the contract on 1 March...
-
For each of the following circumstances, give the letter item(s) indicating the accounting principle involved. Some letters may be used more than once, and some may not be used at all. A. Continuity...
-
When must a company record the present value of the costs of future asset retirement? How is the present value calculated?
-
Identify the sources and discuss the consequences of bank runs, bank panics, and financial crises.
-
Explain why and how the government intervenes in the financial system, and the problems the government safety net creates.
-
Deflation is the rate of decline in the aggregate price level. Why might unexpected deflation be of particular concern to someone managing a bank?
Study smarter with the SolutionInn App