Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Rationale:

You have finally completed your accounting degree and secured a job with a catering business called Boutique Catering and have been asked to report to management on the issues identified in the problems below. This business has experienced significant growth over a short period of time and desperately requires someone to help manage the rapid growth of the business. Boutique Catering’s core business is providing meals for 3 conference rooms which are owned by the company. The business operates from Tuesday to Friday. The general manager who is also the owner wants you to review the business with ‘fresh eyes’ to see where it can improve and also seek some guidance about business opportunities that might be available

As such you are required to complete all parts of the problems showing all workings and providing a clear explanation of the process and output. Where appropriate use a well constructed spreadsheet, compatible with Excel, to answer the problems. The spreadsheet must be submitted with your written report. Your spreadsheet will have a separate worksheet for each problem. For each problem there will be a data entry section followed by a model or results section. Where appropriate, formula should be utilised.

Your response is to be in a report format and it is compulsory for you to lodge both the report (word file) and your calculations (spreadsheet excel compatible).

problem 1

In order to assist the manager you are compiling a resource which will define the various management accounting terms used in the process of strategic analysis. Provide an explanation of the following terms, with exs specifically relating to Boutique Catering, to include in a resource file which incorporates a reason why each concept is relevant or not relevant to decision-making:

Satisficing model
Simulation
Opportunity Cost
Sunk cost
Break-even point

problem 2

It’s your second day with Boutique Catering and the general manager has received a report summarising client complaints which she would like you to investigate. There is a consistent theme of clients being unhappy with the service time when receiving their meals. The general manager would like you to establish if additional staff should be employed to improve the service time. Meals are served in a general area and often the clients will stand around talking before placing an order. The following pattern records customer arrivals and the time it takes for the clients to receive their meals.

Time between arrivals (minutes)      Frequency
1                                                     0.08
2                                                     0.25
3                                                     0.20
4                                                     0.12
5                                                     0.35

Service time (minutes)               Relative Frequency
1                                                     0.10
2                                                     0.25
3                                                     0.25
4                                                     0.40

a) Using the random number function in excel simulate the arrival of 25 customers

b) find out the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?

c) Do you think that enough simulations have been completed to report an outcome to the general manager, describe your answer?

problem 3

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:

1187_Results of previous year.jpg

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.

problem 4

The forecast for the financial year 2013/2014 shows there will be a significant increase in the number of conferences that Boutique Catering will need to prepare meals for. The general manager is concerned that she will need to double the staff numbers to allow for such an increase. She has mentioned that because of the learning curve phenomenon it will be too difficult to accurately budget for the expected increase.

Required:

a) describe to the General Manager what the learning curve is? In your explanation make reference to the two variant methods. Include in your response the conditions under which a learning curve could be used to assist in forecasting for future operations. (10 marks)

problem 5

Boutique Catering is considering expanding business structure by preparing frozen meals that will be home-delivered. The meals will then only require to be heated up by the customer. As a point of difference the meals will be cooked according to the CSIRO total wellbeing recipe book. The meals Boutique Catering will offer are ‘everyday’, ‘vegetarian’ and ‘speciality’ meals (for people who have allergies). To prepare and cook the meals Boutique Catering is looking at purchasing Frozen Delights which already has the capital equipment to prepare the three types of meals. Frozen Delights provides supermarkets with frozen meals and has spare capacity to supply Boutique Catering with the frozen meals as well as maintain its current customer base. In the table below is an estimation of the cost and hours required to prepare, cook and freeze the meals and hours available to supply Boutique Catering with the meals.

                                   Cost per meal      Preparation (hours)   Cooking (hours)  Freezing (hours)
HOURS REQUIRED
Everyday meals             $8.00                                   4                        8                           3
Vegetarian meals         $9.00                                   10                        3                           2
Speciality meals           $12.00                                   8                       8                            2
HOURS AVALIABLE                                                  800                  1200                       1000

Required

a) Using solver derive optimal solutions for how many meals should be prepared to maximise profit.

b) State optimum meal mix and the resulting profit

c) Describe to the General Manager what transfer pricing is and what are two methods which could be used to set price between divisions?

problem 6

Decision making process is a series of steps or stages that we work through to make the choice from the array of alternatives. Making decisions is significant role that management accountants need to undertake in their position. Describe the utility curve with reference to three perceptions of risk. Which of these best describes your attitude toward risk? In your role as a management accountant describe how your choice might affect your decision-making process and behaviour.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92721
  • Price:- $70

Priced at Now at $70, Verified Solution

Have any Question? 


Related Questions in Accounting Basics

Discussionpart 1 please respond the following question no

Discussion Part 1 please respond the following question no less then 350 words (original work, no plagiarism, 1 reference "criminal fraud versus civil fraud and taxation of u.s. businesses operating abroad" please respon ...

Answer the following questionduring 2012 nasa co produced a

Answer the following question. During 2012, NASA Co. produced a new line of computers that carry a three-year warranty against manufacturer's defects. Based on industry experience, NASA Co. estimated warranty costs at 1% ...

I on 1115 big co acquired 70 of little co for 350000 euros

I) On 1/1/15 Big Co. acquired 70% of Little Co. for 350,000 Euros (€). The fair value of the non-controlling interest on that date was €150,000. Little's book value on that date was €500,000, and all assets and liabiliti ...

Problem 1emma and laine form the equal el partnership emma

PROBLEM #1 Emma and Laine form the equal EL Partnership. Emma contributes cash of $100,000. Laine contributes property with an adjusted basis of $40,000 and a fair market value of $100,000. A. How much gain. If any, must ...

Review the provisions of the sarbanes-oxley act of 2002 to

Review the provisions of the Sarbanes-Oxley Act of 2002 to address the accounting scandals in the late 1990s and early 2000s (Enron, WorldCom, etc.). Identify the provisions that you believe made the most significant imp ...

Accounting questions1 if cash is 2345 in 20x2 and 3671 in

Accounting Questions 1. If Cash is $2,345 in 20X2 and $3,671 in 20X1, what is the percentage of increase or (decrease) from 20X1 to 20X2? A. 56.55%******* B. (56.55%) C. 36.12% D. (36.12%) 2. Gross profit by department a ...

Accountingbulluse the internet to research an annual report

Accounting • Use the Internet to research an annual report of a retail company. • Then, imagine you are an investor or creditor; suggest the ratios that you believe would provide an investor or creditor with the most imp ...

Discussion liabilities please respond to the followingfor

Discussion: "Liabilities" Please respond to the following: For this week's eActivity, research one publicly traded company in which you are interested using the Internet and/or Strayer databases. Locate the company Websi ...

Question 1 owners of business firms are the only people who

Question 1 Owners of business firms are the only people who need accounting information. Question 2  Requiring employees to take vacations is a weakness in the system of internal controls because it does not promote oper ...

Assignmentas my town is very small and i was unable to find

Assignment As my town is very small and I was unable to find the CAFR, but I was able to find reports for my nearest city (and the one I work in), Concord, NH, for the fiscal year ending June 30, 2015. One thing that I f ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro