Calculate the operating profit for one month
Course:- Accounting Basics
Reference No.:- EM131009582

Assignment Help
Assignment Help >> Accounting Basics


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:



Selling price per carton: Coffee flavour


Selling price per carton: Chocolate flavour


Selling price per carton: Vanilla flavour


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)




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)




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.


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.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Accounting Basics) Materials
Prepare general journal entries to record the above transactions and the depreciation journal entries required at the end of each reporting period up to June 2014 - Evaluate
Use the information provided in BE12-7. Assume that the fair value of the division is estimated to be $750,000 and the implied goodwill is $350,000. Prepare Waters' journal en
Aneko Company reports the following ($ 000s): net sales of $ 14,800 for 2013 and $ 13,990 for 2012; end of year total assets of $ 19,100 for 2013 and $ 17,900 for 2012. Comput
The company had cash and marketable securities worth $1,235,455, accounts payables worth $4,159,357, inventory of $7,121,599, accounts receivables of $3,488,121, notes payab
On January 1 the Prepaid Insurance account had a balance of $6,000 that represented 6 months' worth of advance payment. It is now the end of March and there have been no adj
1) Prepare an income statement showing the appropriate performance of each product. 2) Adm2341's Top management asked you to provide them with a "decision rule" they could app
As part of its cost accounting routine, Wilcox Company assigns $36,000 in fixed costs to each product each month. Calculate the break-even dollar sales volume for each proje
Is preventing employee fraud easier or more difficult in small companies? Why? Use examples from the news or your own experience to explain and justify your answer.