User Account

All Pages

Draw a scatter diagram of boutique catering number

Assignment Help Managerial Accounting
Reference no: EM13502492

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:

Year    Month Number of conferences   Total number of meals prepared       Administrative cost

2012    Jan                  20                                            700                              27800

2012    Feb                  22                                            250                             14000

2012    Mar                  10                                            200                              12000

2012    Apr                  20                                            500                              20000

2012    May                24                                            650                              23800

2012    Jun                   28                                          450                               18400

2012    Jul                    16                                            650                             20400

2012    Aug                14                                            150                              8200

2012    Sep                 24                                            350                             18800

2012    Oct                  24                                            600                             22200

2012    Nov                16                                             300                              16600

2012    Dec                 32                                           750                              32200

2013    Jan                  18                                            850                             41500

2013    Feb                 19                                            175                              19000

2013    Mar                 12                                            100                             17800

2013    Apr                 18                                            775                              35500

2013    Jun                  24                                            475                             27400

2013    Jul                   16                                            775                             30400

2013    Aug                14                                            25                               12100

2013    Sep                  23                                           325                             28000

2013    Oct                 21                                           700                             33100

2013    Nov                 16                                            250                              24700

2013    Dec                 26                                            925                              48100

 

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 behavior 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 behavior 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.

 

Reference no: EM13502492

Questions Cloud

What was the work performed by the loosing team as they lost : Imagine a game of tug of war where the winner must move the middle of the rope 1 meter in their direction. What was the work performed by the loosing team as they lost
Explain molar hcl to completely neutralize the acid : How many mL of 0.64 molar NaOH must be added to 39 mL of 0.11 molar HCl to completely neutralize the acid.
Explain how many mls of the 0.010 m solution : If you have 25 mL of a standard 1 mg/mL CaCO3 solution, how many mLs of the 0.010 M solution do you expect to use in the titration
Find the field at the center of the crt : Two solenoids are used to produce a magnetic field across a cathode-ray tube. Find the field at the center of the CRT
Draw a scatter diagram of boutique catering number : 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 whi..
Determine ph of a solution after 0.10 mol of hcl : Find the pH of a solution after 0.10 mol of HCl is added to 1.0 L of a buffer solution that contains 1.40 M NH3 and 0.90 M NH4+.
What is pink jeep total ariable cost for each tour : List the various costs pink jeep would incur to offer each tour. Indicate whether each cost identified is variable, fixed or mixed based on the number of tours offered and what is pink jeep total ariable cost for each tour? Does this cost differ fo..
How long should the person stay inside the vehicle : When lightning strikes a vehicle with a person inside, how long should the person stay inside the vehicle
Calculate the total simulated hours : Calculate the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Journal entry to record the allocation

Manufacturing overhead for the month was overapplied by $5,000. The company allocates any underapplied or overapplied overhead among work in process.

  Indicators of measurement and performance

The Concept of a balance scorecard is the topic. While there is not necessarily one best way to view a balance scorecard, clearly the good indicators of measurement and performance go beyond financial perspectives.

  Determining the traditional costing-activity based costing

K's Cornerspot, a popular university eatery in a competitive market, has seating & staff capacity to serve about 600 lunch customers every day. For the past 2 months, demand has fallen from its previous near-capacity level. Concerned about his dec..

  Ramifications of price discrimination

Thomas Selling, an expert on nuclear strategy and arms control, examined in his book The Strategy of Conflict (Cambridge, MA: Harvard University Press, 1960), " The power to constrain the adversary depends on the power to bind oneself." Describe t..

  Coffee makers incorporated cmitwo divisions of a cmi are

coffee makers incorporated cmi.two divisions of a cmi are involved in a dispute.nbsp division a purchases part 101 and

  Product liability-regulatory agencies

Pick a product you are familiar with or interested in. What product liability issues arise for that product? What measures can management take to prevent these product liability problems from arising? How can they minimize legal risk involving the..

  Standard cost and actual cost

Phoenix Manufacturers makes blank computer disks. It takes one-eighth of a pound of direct materials and one minute of direct labor at standard per disk. Direct materials cost $2.60 per pound at standard, and the standard direct labor rate is $6.0..

  What are the equivalent units for conversion costs

What are the equivalent units for conversion costs for the month in the first processing department?

  An electric utility issued 3000 shares of common stock all

an electric utility issued 3000 shares of common stock all of the same class 2800 shares are outstanding and 200 are

  What was the cost of the raw materials used in production

What is the total amount of the costs listed above that are not direct costs of the Brentwood Store?

  Production cost variances

When determining end of period production cost variances, which of the following product costs components will require flexing?

  Nbspmaxwell company manufactures and sells a single

nbspmaxwell company manufactures and sells a single product.the following costs were incurred during the companys first

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd