Prepare a cash budget for october

Assignment Help Accounting Basics
Reference no: EM131298633

About TMA:

The TMA covers the management accounting concepts and practices in the businesses. It is marked out of 100 and is worth 20% of the overall assessment component. It is intended to assess students' understanding of some of the learning points within chapters 16, 20, 22 and 24. This TMA requires you to apply the course concepts. The TMA is intended to:

- Assess students' understanding of key learning points within chapters 16, 20, 22 and 24.
- Increase the students' knowledge about the reality of the cost and management accounting as a profession.
- Develop students' communication skills, such as essay writing, analysis and presentation of material.
- Develop the ability to understand and interact with the nature of the managerial accounting tools in reality.

The TMA:

The TMA requires you to:
1- Review various study chapters of 'Financial & Managerial Accounting' Book and apply some of the concepts within it.
2- Conduct a simple information search using the internet.
3- Present your findings in not more than 1,200 words (800 words for Part A and 400 words for Part B). The word count excludes headings, references, title page, and diagrams.
4- You should use a Microsoft Office Word and Times New Roman Font of 12 points.
5- You should read and follow the instructions below carefully. Each part of the process will carry marks for the assignment.

Part A

Managerial Accounting for Pearson Company

Pearson Company is one of the leading automobile manufacturing companies in Middle East region. The company has been known for providing best quality products and highest standards of service level for the possible selling price. Pearon's products have been most liked by customers who are in different age groups say 18 - 55 years. The Company has been trying its best to sustain its competitive edge through its products and pricing structure.

This company has three major divisions and each division has a top accountant called the controller, and the management accounting that is done in these divisions comes under the leadership of the controller. On the other hand, the controller usually reports to the vice president of finance for the division who, in turn, reports to the division's president and/or overall chief financial officer (CFO). All of these individuals are responsible for the flow of good accounting information that supports the planning, control, and evaluation work that takes place within the organization.

The need for Management Accountant

The company's top executives always felt that they need a management accountant in particular in order to fetch good accounting reports and data for making good decisions and to have good planning about the activities to be implemented.

Divisions of Pearson Company

The Pearson Company has three divisions operating. They are termed as Merchandise, Manufacturing and Service divisions. The sales and cost details of these three divisions for the month September 2016 are as given below:

Information

Service Division

Merchandising Division

Manufacturing Division

Sales (no of services/ units)

380 services

190 units

495 units

Selling price

$ 20 per service done

$ 80 per unit

$ 40 per unit

Expenses

 

 

 

Salaries Expense

$ 1,900

 

 

Rent Expense

$   500

 

 

Utilities Expense

$   200

 

 

Selling & Administrative Expense

----

$ 3,200

$ 3,200

Inventory Details

 

 

 

Beginning Inventory

 

$ 4,000

$ 4,000

Purchases & Freight

 

$ 7,600

 

Cost of goods manufactured

 

 

$ 15,200

Ending Inventory

 

$4,400

$ 6,600

Products of Pearson's Subsidiary Company (Elsevier Company)

Elsevier Company is a subsidiary of Pearson Company. Elsevier manufactures two products namely A and B. The cost details of products A and B are given as under:

Information

A

B

Sales price per unit

$ 60

$ 180

Variable Cost per unit

$ 30

$ 60

Elsevier expects to sell two products of A for every four products of B. The total fixed costs of Elsevier amount to $ 270,000

Cost structure of Company X and Company Y (Two associates of Pearson)

The cost structure of Company X and Y (associates of Pearson Company) are given below:

Information

Company X

Company Y

Sales price per unit

$ 125

$125

Variable Cost per unit

$ 25

$ 75

Sales Units

2500

2500

Fixed Costs

$ 30,000

$ 5,000

The CEO of Pearson wants to know more about cost and leverage details of both Companies X and Y respectively

Required

(1) Pearson Company is in need of a Management Accountant. The CEO of Pearson has read widely that management accounting systems provide information, both financial and non-financial to managers and employees inside an organization.

In the above context, explain management accounting and explain how management accounting helps organizations in planning, decision making and controlling functions

(2) Prepare Income statement respectively for three divisions of Pearson Company.

(note: service and merchandising companies differences need to be considered)

(3) For Elsevier Company, (given above), calculate the following:

(a) Break Even point and show the proof that at BEP level of sales, company achieves zero profit.

(b) Estimate the sales (units) & (in money value) required to earn a target profit of $ 270,000

(4) For Companies X and Y (Associates of Pearson), calculate the operating leverage and comment on the results.

PART B

Budgeting for Atkinson Processing Company

Atkinson Processing Group needs a cash budget for October. The cash balance at the beginning of October is $9,000. The actual sales for August and September and expected sales for October are:

Information

August ($)

September ($)

October ($)

Cash Sales

13,000

10,500

14,800

Sales on Account

40,000

60,000

80,000

Total Sales

53,000

70,500

98,800

Sales on account are collected over a three-month period in the following ratio:
10% in the month of sale,
70% in the month following sale
18% in the second month following sale
2% remaining are uncollectible.
Additional information includes:
(a) Purchases of inventory will total $ 50,000 for October; 20% will be paid for in October. Accounts payable from September's inventory purchases is $ 32,000, all of which will be paid in October.
(b) Selling and administrative expenses are budgeted at $ 26,000 for October; of which $ 8,000 is for depreciation.
(c) Equipment costing $ 36,000 will be purchased for cash during October, and other miscellaneous cash expenses of $ 6,000 will be paid during October.

Required

(1) Prepare a Cash Budget for October. Show all working clearly (20 marks)

(2) One of the divisions of Atkinson Processing Company provides following information pertaining to October 2016:

Information

Amount ($)

Operating Income

2,900,000

Average Total Assets

32,200,000

Net Sales

53,000,000

Required: Compute Profit Margin Ratio, Asset Turnover Ratio and ROI for this division of Atkinson Company

(3) Discuss briefly about some of the advantages and disadvantages of ROI as a measure of divisional performance

Reference no: EM131298633

Questions Cloud

Financial innovations increased : How have financial innovations increased the liquidity of home mortgages since the late 1970s? Has this increase in liquidity tended to increase or decrease the interest rate on home mortgages? Explain why.
Write a query statement to show all data records : Use the customers table inside of the salesordersexample database, and write a query statement to show all data records of the customers table.
Discuss how the actions of the federal reserve : Discuss how the actions of the Federal Reserve, specifically an increase or decrease in money supply, affect the other variables represented in the IS/LM model. Is this model a useful tool in setting U.S. monetary policy? Why or why not? Argue and..
Explain as much as necessary to get the point across : Should a company ever produce a good or service if the managers know it will lose money? Why or why not. Provide examples to support your response. Explain as much as necessary to get the point across.
Prepare a cash budget for october : Compute Profit Margin Ratio, Asset Turnover Ratio and ROI for this division of Atkinson Company - Discuss briefly about some of the advantages and disadvantages of ROI as a measure of divisional performance
Why the drought will lead to a rise in the price of bread : Explain why the drought will lead to a rise in the price of bread.
Antitrust legislation in the us summarize key points : Go to the internet and find a news article (from 2015/2016 only) that discusses antitrust legislation in the U.S, summarize key points, and reference textbook material in support of your summary, and post in the Discussions area.
Show its effect on the price of cereals : It's a case of two extremes: drought in parts of the United States and in Europe have sparked fears of a supply crunch of wheat, while supplies of corn are being threatened by flooding and heavy rain in the Midwest.
Examine alternatives and select best alternative for company : Examine the alternatives and select the best alternative for this company. Include your rationale for selecting this over the others and discuss the implementation process.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Under the perpetual inventory system the cost of

1.a company had sales of 699000 and cost of goods sold of 280000. its gross profit

  The c ontrol environment reflects the companys attitude

the c ontrol environment reflects the companys attitude awareness and actinos of management and the board concerining

  The initial cash outlay and cash flow projections are

the initial cash outlay and cash flow projections are presented below for new equipment that outdoor sports inc. is

  Show critical thinking skills on a job

Critical Thinking and Job Requirements : While communication and critical thinking skills are important, they may not be the only requirements for a future job.

  Unsuccessfully for president of france

When Ségolène Royal was running unsuccessfully for president of France, she proposed that workers who lost their jobs would receive unemployment payments equal to 90 percent of their previous wages during their first year of unemployment.

  Prepare process accounts and profit and loss accounts.

Management expenses during the year were Rs 80,000 and selling expenses were Rs 50,000. These are not allocable to the processes.

  Process to increase company net income

Disney's variable costs are 30% of sales. The company is contemplating an advertising campaign that will cost $22,000. If sales are expected to increase $40,000, by how much will the company's net income increase? and what is the process?

  Income of subsidiary and investment in subsidiary

How do I find income of subsidiary, investment in subsidiary, and retained earnings using equity, initial value, and partial equity method?

  What was the noncontrolling interest share

What was the noncontrolling interest's share of Sparis' net income for 2011?

  Prepare journal entries to record transactions

Purchased raw materials at a cost of $45,000 and general factory supplies at a cost of $13,000 on account (recorded materials and supplies in the materials account)

  Compensating nonprofit board members

Often Board and other committee volunteers for nonprofit organizaations are compensated for expenses during travel and meetings. Some think that this attracts volunteers for the wrong reasons.

  The ceo''s and heather''s treatment of the situation

1.At the beginning of 2011, the Healthy Life Food Company purchased equipment for $42 million to be used in the manufacture of a new line of gourmet frozen foods.

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!

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