Ask Managerial Accounting Expert

Question

On the third day in your role as accountant the general manager has asked you to review the results of 2012 and 2013 to try and determine if there is a relationship between the number of meals prepared per month and the administration costs which she believes to be too high. Data regarding the number of conferences per month, number of meals prepared for that month and the administration costs for the months of 2012 and 2013 are as follows:

891_Draw a scatter diagram of Boutique Catering.png

Required:

a) Draw a scatter diagram of Boutique Catering's Number of meals prepared and administrative costs for the year.

b) The relevant range has been identified as between 200 and 800 meals prepared. Mark the range on the scatter graph. Do you think this is an appropriate range? Why?

c) The high-low method in another way of estimating the cost behaviour of Boutique Catering. Using administration costs and number of meals prepared within the relevant range create an equation to express the results.

d) A third method that can help understand the cost behaviour relationship is by using regression analysis. Construct an excel spreadsheet and use regression analysis to estimate the;

a. Number of meals and administration cost. What is the administration costs' equation when 600 meals are prepared?

b. Number of meals, administration costs and number of conferences. What is the administration cost when 600 meals are prepared?

e) From the methods used which method would you feel most confident to report the findings to the General Manager? In your answer make particular reference to the advantages and disadvantages of each method and in addition discuss the cost-benefit of each method.

Managerial Accounting, Accounting

  • Category:- Managerial Accounting
  • Reference No.:- M9462128

Have any Question?


Related Questions in Managerial Accounting

Instructions for preparation of assignment1 you are to

Instructions for Preparation of Assignment: 1. You are to choose one management accounting topic from the list below for this assignment, and register your chosen topic with your lecturer in class or via email before com ...

Management accounting assessment - research amp analysis

Management Accounting Assessment - Research & Analysis Teamwork Assessment Description - Learning Outcome - Analyse the issues or problems (in a given scenario) using management accounting techniques and tools, and formu ...

Management accounting with a strategic perspective

MANAGEMENT ACCOUNTING with a STRATEGIC PERSPECTIVE Assignment - This Assignment is designed to give students an opportunity to: 1. Integrate traditional, contemporary and advanced theoretical and technical management acc ...

Corporate accounting assignment -assessment task - select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

You need to prepare a paper about lacroix companycompany

You need to prepare a paper about Lacroix company Company: Lacroix Home Work: History & background Page: 1 and half

Managerial accounting assignment -background you are

Managerial Accounting Assignment - Background: You are recently employed as a graduate consultant in a management consultancy firm and are assigned to a team. One of your firm's clients is currently evaluating its budget ...

Managerial accounting assignment -background you have been

Managerial Accounting Assignment - Background: You have been hired by the Board of Directors of your chosen company (ASX Listed) to explain how ABC model can improve the management accounting information available to its ...

Assume you have been hired as a consultant to prepare a

Assume you have been hired as a consultant to prepare a balanced scorecard that will be presented to top management. You will choose a company to research and will provide a professional report that will include the foll ...

Accounting for decision makersproject - appendix

Accounting for Decision Makers PROJECT - APPENDIX A Requirements: 1. Choose a publicly traded company that you currently own/invest in or one that you would like to own / invest in 2. Research the company through the com ...

Task descriptionyou have gained a position as vacation

Task Description You have gained a position as vacation student at the accounting firm T&K Solutions. In your capacity of vacation student you have been asked by the two partners of T&K Solutions to assist them with two ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As