Prepare a budgeted profit statement for the year

Assignment Help Accounting Basics
Reference no: EM131748175

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

1.833

3

0.840

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: EM131748175

Questions Cloud

Define your random variables : a) Define your random variables, and use them to express the farmer s net income. b) Find the mean.
Why etl process is important for data warehousing efforts : Write a 1-2 page APA formatted paper with citations and references that analyzes why the ETL process is important for data warehousing efforts.
Journalize the transactions that took place : Journalize the transactions that took place in 2015 in the General Journal
Coffee and doughnuts : At a certain coffee shop, all the customers buy a cup of coffee; some also buy a doughnut. The shop owner believes that the number of cups
Prepare a budgeted profit statement for the year : Prepare a budgeted profit statement for year to 31 October 2014 showing total sales and marginal costs for year and also contribution and net profit per unit
Develop an optimum facility location model : Conduct a sensitivity analysis to consider reshoring part or all of MEF's flat packed product line.Be sure to consider the impact on MEF other product families.
What is total stockholders equity : Issued22,000 shares of common stock. The stock has a par value of$3.00 per share and was issued at$16.00 per share.
Define your variables clearly and state any assumptions : What's the probability that the total weight in that second box exceeds 60.5 pounds? Define your variables clearly and state any assumptions.
Tannin level in apples is affected by the fertilizer regimen : Public Health and Nutrition Tannin is a general term for certain nonvolatile phenolic substances in many fruits that provide an astringent sensation.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Post july transactions to the general journal

Post July transactions to the general journal and general ledger 'T' accounts. Prepare an unadjusted trial balance

  Cost of goods manufactured equals 44000 for 2008 finished

1.cost of goods manufactured in a manufacturing company is analogous to a.ending inventory in a merchandising company.

  What is the economic order quantity

Use "NORMSINV" function in Excel to find the accurate z value. Based on the z value found, what is the safety stock level for this item

  Carla transfers land with a fmv of 100000 basis of 20000

carla transfers land with a fmv of 100000 basis of 20000 to a corporation in exchange for 50 of the corporations stock.

  Quick ratio formula

The appendix containing a list and calculations of the ratios. A list of the calculations shown with formulas and the resulting answer.

  Haskins and jones attorneys-at-law maintain its books on a

haskins and jones attorneys-at-law maintain its books on a cash basis. during 2013 the company collected 590000 in fees

  During january the companys employees earned wages of 76250

on january 1 2010 the ledger of glennon company contained these liability accounts.accounts payable 49020sales taxes

  What should be the book value of the land

Give the journal entry to record all expenditures. Assume that all transactions were for cash and they occurred at the start of the year. Compute straight- line depreciation on the building at the end of one year, assuming an estimated 12- year usefu..

  Problem regarding the piece-rate system

Is it likely that workers under a piece-rate system will end up choosing to produce less than the minimum output required under the hourly wage system? Briefly explain.

  How the two income statement formats would look side by side

Using the following company data, show how the two income statement formats would look side by side

  Record any necessary journal entries

Teal Company sells televisions at an average price of $856 and Record any necessary journal entries in 2017

  State marginal tax rate

Right after you sent the memo to your boss, you were given the news that your client has just moved to California and now is subject to a state marginal tax rate of 9.55%. Write a brief e-mail to your boss that explains:

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