Prepare a budgeted profit statement for the year

Assignment Help Accounting Basics
Reference no: EM131207600

 

TASK 1 - Planning for profit and cost control

Objective - To enable the learner to prepare the budgeted profit statement and undertake cost-volume-profit analysis for decision making

Anhad Sdn. Bhd. manufactures car alarms, and its trading results for the year ended 31 October 2013 are as follows:

 

$'000

$'000

Sales (800,000 alarms)

 

7,200

Costs:

 

 

Materials: direct, variable

1,600

 

Labour:  direct, variable

960

 

Labour:  indirect, fixed

280

 

Other production overheads: variable

400

 

Other production overheads: fixed

640

 

Selling overheads: variable

480

 

Selling overheads: fixed

360

 

Distribution overheads: variable

280

 

Distribution overheads: fixed

120

 

Administration overheads: fixed

        600       

 

 

 

     (5,720)    

Net profit for the year

 

1,480

Anhad is planning next year's activity and its forecasts for the year ended 31 October 2014 are as follows:

1. A reduction in selling price per car alarm to $8 per alarm is expected to increase sales volume by 50%.

2. Materials costs per unit will remain unchanged, but 5% quantity discount will be obtained.

3. Hourly direct wage rates will increase by 10%, but labour efficiency will be unchanged.

4. Variable selling overheads will increase in total in line with the increase in sales revenue.

5. Variable production and distribution overheads will increase in line with the 50% increase in sales volume.

6. All fixed costs will increase by 25%.

You are required to do the following:

a) Prepare a budgeted profit statement for the year to 31 October 2014 showing total  sales and marginal costs for the year and also contribution and net profit per unit.

b) Calculate the break-even point for the two years and explain why the break-even point has changed.  Comment on the margin of safety in both years.

c) Calculate the sales volume required (using the new selling price) to achieve the same profit in 2014 and in 2013.

d) A director comments that 'with these figures, all we have to do to work out our budgeted profit is to multiply the net profit per unit by the units we want to sell". Why is this statement incorrect?

TASK 2 - Investment appraisal

Objective - To enable the learner to evaluate and make choices between different projects in which to invest

Satnam Berhad is considering diversifying their business activities and they are currently reviewing two proposals. Proposal A is to launch their own television station whilst Proposal B is a joint venture with Kaboor Limited to launch a satellite that would enable the African region to receive advertisements for both company's products.

The available data is follows:

Proposal A - TV Station

Initial set-up costs: $250 million

Annual running costs: $100 million

Estimated life of project: 5 years

Value of assets released at the end of the project: $40 million

Increased sales as a result of advertising products: $60 million in the first year, growing cumulatively by 50% each year for the following four years.

Project B - Satellite

Initial set-up costs: $700 million

Annual running costs: $50 million

Value of assets released at the end of the project: $10 million (Note: all the above to be shared 50/50 with Kaboor Limited)

Estimated life of the project is 6 years.

Increased sales for Satnam Berhad as a result of advertising their products in the African continent: $80 million in the first year, growing cumulatively by 20% each year for the following five years.

Funding for both projects would be at a cost of capital of 6%.

Relevant discount factors at 6% p.a. are:

Year Cumulative
1 0.943 0.943
2 0.89 1.833
3 0.84 2.673
4 0.792 3.465
5 0.747 4.212
6 0.705 4.917

Required:

a) Using the net present value method of investment appraisal, critically evaluate the two proposals and make your recommendation to Satnam Berhad.

b) What other considerations should Satnam Berhad take into account in deciding which Project to pursue?

TASK 3 - Short term decision making

Objectives - To enable the learner to identify the relevant and irrelevant costs and benefits associated with each feasible alternative with the greatest overall net benefit to aid decision making.

Swagat Manufacturing Sdn. Bhd. needed to determine if it would be cheaper to make 10,000 units of a component in-house or to purchase them from an outside supplier for $4.75 each. Cost information on internal production includes the following:

 

Total Cost $

Unit Cost $

Direct materials

10,000

1.00

Direct labour

20,000

2.00

Variable overheads

8,000

0.80

Fixed overheads 44,000 4.40
Total 82,000 8.20

Fixed overhead will continue whether the component is produced internally or externally. No additional costs of purchasing will be incurred beyond the purchase price.

Required:

a) List the relevant cost of internal production and external purchase.

b) Which alternative is more cost effective and by how much?

c) Now assume that the fixed overhead includes $10,000 of cost that can be avoided if the component is purchased externally. Which alternative is more cost effective and by how much?

Reference no: EM131207600

Questions Cloud

What are your recommendations on choice of country : What is the new cost of goods sold percent of sales for each of the countries?
Find total impedance zt and power factor of the network : For the network of given figure: -  Find the total impedance ZT. -  Calculate the voltage V2 and the current IL. - Find the power factor of the network.
Does one personality always predict one behavior : This module addressed research methodologies used to better understand the construct of personality. Which of these methods produces the most valid information in the real world of personality research? Why?
Create a business impact analysis on sangrafix a video game : Create a business impact analysis on SanGrafix a video game design company. The BIA should include a descriptive list of the organization's key business areas.
Prepare a budgeted profit statement for the year : Prepare a budgeted profit statement for the year to 31 October 2014 showing total  sales and marginal costs for the year and also contribution and net profit per unit
Identify five scholarly source on your intended dissertation : A brief summary of the primary research questions, purpose, limitations, and results of each article. A comparison of the articles that identifies gaps and tensions between the conclusions made by each study.
Find the current and the voltage vc : For the network of given figure: - Find the current I. -  Find the voltage VC. -  Find the average power delivered to the network.
Summerize the role of public key infrastructure : Summerize the role of Public Key Infrastructure (PKI). Discuss the use of a Certificate Authority (CA). Include the use of a CA and also include why the backing up of these keys is so important.
Subject-information technology : Describe reasons for using each of the two software deployment methods ("Published" vs. "Assigned"), as well as some of the "Advanced" deployment options. Describe a case when deploying software via the Assigned method presents a problem.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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