Calculate the operating profit for one month

Assignment Help Accounting Basics
Reference no: EM131009582

Question

Part A - Decision making and relevant information

Ishtar Ltd makes an energy drink sold mainly at gyms. Currently the energy drink is available in 500 ml bottles in three different flavours (Coffee, Chocolate, and Vanilla). The energy drink is sold to gyms in cartons containing 12 bottles of the same flavour. Due to the downturn in the economy and competitors entering the market, sales have dropped significantly. The CEO of Ishtar Ltd is concerned about the decline in the profit of the company. The CEO believes that cutting the cost of manufacturing the energy drink will enable Ishtar Ltd to reduce the selling price and regain some of its market. She asked the management accountant (Julius) to investigate the cost structure of making the energy drink. Julius provides the following information about the current monthly activity level:

Description

$

Selling price per carton: Coffee flavour

36

Selling price per carton: Chocolate flavour

60

Selling price per carton: Vanilla flavour

50

Variable manufacturing costs per carton that vary with number of units produced

    Coffee flavour (for producing 60 000 litres)

    Chocolate flavour (for producing 90 000 litres)

    Vanilla flavour (for producing 45 000 litres)

24

40

34

Variable costs per set up for making different flavour energy drinks (see additional information below)

1 000

Fixed manufacturing costs per month

50 000

Fixed marketing costs per month

25 000

Variable marketing costs per carton sold per flavour:

    Coffee flavour (for producing and selling 60 000 litres)

    Chocolate flavour (for producing and selling 90 000 litres)

    Vanilla flavour (for producing and selling 45 000 litres)

1.20

1.40

1.30

Ishtar Ltd only has one manufacturing plant and can only make one flavour of energy drink at a time. It sets the plant up to make 5 000 litres of one flavour at a time, starting with Coffee flavour, followed by Chocolate flavour and then the Vanilla flavour and then repeat that sequence until the 45 000 litres of Vanilla flavour has been produced. It then starts again with making 5 000 litres of the Coffee flavour, followed by the Chocolate flavour. Once the 60 000 litres of the Coffee flavour energy drink is manufactured, it sets up the plant once to manufacture the remainder of the Chocolate flavour. The company has the capacity to manufacture 195 000 litres of energy drink per month. Currently, it operates at full capacity and makes and sells the following levels per flavour per month:

Coffee flavour

Chocolate flavour

Vanilla flavour

60 000 litres

90 000 litres

45 000 litres

While investigating the cost structure of the energy drink, Julius (who was born in Kenya) contacted a very close friend in Kenya who has a coffee plantation. Julius discovered that coffee beans could be imported from Kenya at a cost much lower than what Ishtar Ltd currently pays. Currently Ishtar Ltd buys the coffee beans from an Australian coffee farmer in the Atherton Tableland in Queensland. Should Ishtar Ltd import the coffee beans from Kenya, the variable manufacturing costs per carton of the coffee flavour energy drink will decrease to $15, the variable marketing costs will be $1.00 per carton and each carton can then be sold for $30. Assume only one set-up will be required to make the 195 000 litres of Coffee flavour energy drink. Furthermore, Julius believes that importing the coffee beans from Kenya will also be the right thing to do ethically, as it is a fair trade transaction, helping a third world country. Julius decided not to tell the CEO about his relationship with the source of the coffee beans from Kenya. Julies is a member of CIMA, and bound to CIMA's Code of Ethics for Professional Management Accountants.

Julius proposes that Ishtar Ltd imports the coffee beans from Kenya, and use the full capacity to make and sell only Coffee flavoured energy drinks.

Required:

1. Calculate the operating profit / (loss) for one month for Ishtar Ltd using variable costing method for the two scenarios: (a) business as usual and (b) import the coffee beans from Kenya. Use the format of figure 8.4 on page 304 of the prescribed textbook to show your calculations. Show the Income Statements for the two scenarios (a) and (b) next to each other in one table.

To receive maximum marks, please show all your workings and calculations. You will receive zero marks if your figures are incorrect and you do not show any calculations as the marker will not be able to give you partial marks.

Tip: calculate the number of cartons that need to be made and sold per month.

2. Discuss the following issues that Ishtar Ltd will have to consider in making the decision whether to accept or reject Julius' proposal to import the coffee beans from Kenya and to use the full capacity to make and sell Coffee flavour energy drinks only:

(a) Relevant and irrelevant costs and revenue (identify which are relevant and which are irrelevant and justify your decision).

(b) Other non-financial issues.

(c) Any ethical issues that Julius, as a member of CIMA and being bound to CIMA's Code of Ethics for Professional Management Accountants, should consider in making this proposal. Tip: Not all fundamental principles may be relevant, only discuss the relevant principles and justify why it is relevant.

Reference no: EM131009582

Questions Cloud

The steps to mining group gold include : The steps to Mining Group Gold include- defining the behavioral parameters of a unique subset of cultures. establishing a zone of proximal development. setting expectations for reasonableness of the ideas presented.
Demand increases-demand decreases-supply decreases : Consider a market for pawn brokers. The television show Pawn Stars creates a lot of positive buzz for the profession. What will happen to the market? Demand increases, demand decreases, supply decreases, no change in either, or supply increases?
What sets the boundaries for trade : What sets the boundaries for trade? Globalization, comparative advantage, absolute advantage, or opportunity cost?
One of the factors that shift the aggregate supply curve : Which would be considered to be one of the factors that shift the aggregate supply curve? A change in: consumer spending. net export spending. government regulation. consumer expectations on investment projects.
Calculate the operating profit for one month : Discuss the following issues that Ishtar Ltd will have to consider in making the decision whether to accept or reject Julius' proposal to import the coffee beans from Kenya
Determine breakeven total volume of sales : Determine breakeven total volume of sales and sales volume for each product.
Innovation capabilities of the organisation : Concisely reports on selected aspects of the innovation capabilities of the organisation - Consider whether any/all of your three identified issues are shaped by the context of your organisation- its size, types of products, types of consumers, na..
Problem based on by implicit differentiation : Find dy/dx by implicit differentiation. Show all steps while completing the problem
Analyse the communication demonstrated in the film : Describe examples of effective and ineffective therapeutic communication in the film - Identify and critique the use of verbal and non-verbal communication in the film

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