Accounting assignment

Anonymous
timer Asked: Nov 13th, 2017
account_balance_wallet $40

Question Description

Includes:

- budgeting

- profitability calculating

- etc..

Answer to all questions clear and carefully. Proceed step by step.

Unformatted Attachment Preview

Carey, Knowles & Towers-Clark: Accounting - A Smart Approach, 3rd edition Management Accounting: Case Study Company Coco Company Coco is a luxury chocolate manufacturer, which has recently been performing well. The board of directors is considering how it should expand the business and is looking at a number of options. First, the directors need to produce a budget for the coming year and ensure that the business can maintain its profitability. The marketing and production directors have given you, the management accountant, details of estimated product sales volumes and proposed sales prices, as well as expected raw material and factory costs. They plan to produce 20 chocolate bars in every direct labour hour. The sales director is confident that he could increase sales prices with a small decrease in sales volume. The marketing director would like to expand the product range by buying in fruit and nut chocolate bars from a supplier but has asked you to estimate what it would cost the company to make them instead. The managing director has ambitious plans to buy a moulding machine to save labour and packaging labour costs. Table MA.1 Dark Milk White Raw material costs Volume chocolate bars 80,000 140,000 60,000 Selling price per bar £ 2.00 1.80 2.00 Cocoa grams per bar 170 130 0 £4 per kg Sugar grams per bar 30 40 70 £2 per kg Table MA.2 Indirect costs* £k Rent 18.2 Utilities 13.8 Factory administration 12.7 Marketing and sales 47.4 Administrative salaries 38.5 *Factory indirect costs are currently allocated on a blanket rate. Packaging is estimated at £200 per 1,000 bars. Direct labour costs are expected to be £10 per hour. © Mary Carey, Cathy Knowles, Jane Towers-Clark 2017. All rights reserved. Milk millilitres per bar 0 30 130 £1 per litre Carey, Knowles & Towers-Clark: Accounting - A Smart Approach, 3rd edition REQUIRED: a) Prepare a budget based on the information in Table MA.1 including total sales revenue, raw material and packaging purchases, and direct labour costs. Estimate the net profit, using the assumptions for indirect costs in Table MA.2 . How could a management accountant assure himself that these estimated numbers are realistic? b) Calculate a product profitability for each type of chocolate bar (dark, milk, and white) assuming that manufacturing costs are allocated on a blanket rate. Advise the board of directors on their product strategy. c) Assess the proposal of the sales director to improve company profitability by increasing sales prices and reducing sales volume, as in Table MA.3 . What other factors might affect pricing decisions? d) Using the information in Table MA.4, advise the marketing director on whether it would be more beneficial to make fruit and nut bars rather than buy them in from another company for £1.70 per bar. What other considerations need to be taken into account? e) The managing director has given you some estimates on which to base your calculations for the new moulding machine. If the business invests £300,000 in equipment, he forecasts that they could save 50% of direct labour costs and 25% of packaging costs; but utility costs would increase by 5%. By calculating the net present value over the next five years using a discount rate of 7%, advise the board whether it should invest in this project. You should also outline the limitations and non-financial factors that need to be considered. Table MA.3 Sales director’s volume and price assumptions Increase price Dark chocolate bars 10% Milk chocolate bars 5% White chocolate bars No change Table MA.4 Fruit and nut: raw material costs Per bar Quantity Cocoa, sugar, and milk Assume 50% of milk bar Fruit 50g per bar Nut 50g per bar Direct labour, packaging, Cost per bar: use same and factory overhead assumptions as other chocolate bars Decrease volume 10% 5% No change Cost £4 per kg £8 per kg © Mary Carey, Cathy Knowles, Jane Towers-Clark 2017. All rights reserved. ...
Purchase answer to see full attachment

Tutor Answer

Doctor_Ralph
School: Purdue University

Attached.

Running head: COMPANY COCO MANAGEMENT ACCOUNTING CASE STUDY

Management Accounting Case Study: Company Coco
Names:
Institution:

1

COMPANY COCO MANAGEMENT ACCOUNTING CASE STUDY

2

Management Accounting Case Study: Company Coco
Company Coco’s budget
Direct costs and revenues
Volume
chocolate
bars

Sell
ing
pric
e
per
bar
£

Cocoa Total
grams Cocoa
per bar in Kg

Sugar
grams
per
bar

Tot
al
Sug
ar
in
Kg

Milk
Total
millilitre milk in
s per bar litres

Revenues

Dark

80,000

2

170

0.47

30

2.6
7

0

0

£160,000

Milk

140,000

1.8

130

1.08

40

3.5

30

4.67

£252,000

White

60,000

2

0

0

70

0.8
6

130

0.46

£120,000

5.13

£532,000

Raw material
costs
Total

£4 per
kg
280000

Indirect costs
Indirect
costs*

£k

Rent

£18,200

Utilities

£13,800

Factory
£12,700
administration
Marketing
and sales

£47,400

Administrativ
e salaries

£38,500

Packaging
estimates

£56,000

£2
per
kg
1.55

£1 per
litre
7.0
2

COMPANY COCO MANAGEMENT ACCOUNTING CASE STUDY
Direct labor
costs

£140,000

Raw materials

163,600

Total costs

£490,200

Estimated
revenues

£532,000

Net income

£41,800

Ensuring that the estimates are realistic
It is common for management accounts to develop budgets that fail to conform to their
expectations. According to the Harvard Business Review Staff (2015), this is often as a result
of errors arising from being too ambitious or underestimating possibilities. A realistic budget
should be neither too ambitious nor should it estimate the possibilities. There are a number of
ways that the management accountant should follow so as to ensure that the budget is
realistic. They should begin with setting organizational goals. However, these should be based
on the organizations’ capabilities as well as an achievable target that the organization focuses.
In fact, these should include clearly defined parameters such as the estimated period of time
and the expected proportion of change. At the same time, the Harvard Business Review Staff
(2015) recommends that the set shifts, for example, a 5% increase in profit after raising the
prices of item...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors