Question

In: Accounting

Question 3 Mr. Livingstone is concerned about the inventories of bottled coconut water the company has...

Question 3

Mr. Livingstone is concerned about the inventories of bottled coconut water the company has been experiencing because of its limited shelf life. He suspects that it is related to bonus packages that the supervisors receive but is uncertain and does not know how to calculate it. The supervisors of Farm Management and the Processing Unit equally share a 2% bonus based on the income of Saddleback Farms every quarter and the company uses the absorption costing approach to financial statement preparation.  He asks for your assistance.

To prepare answers for him, you collect the results of the Coconut water processing activity for the first quarter below.

Budgeted production 108,000 liter

Amount sold   90,000 liters

Selling price                                                                $20 per liter

Variable costs                                                             $12 per liter

Fixed costs                                                                  $216,000

Required:Prepare the income statement under both absorption costing and variable costing to show to Mr. Livingstone the impact of each method on the bonus that the supervisors of the units would earn.  What recommendation (if any) would you make to Mr. Livingstone?

Solutions

Expert Solution

Absorption costing: Absorption costing is one of the methods which is used to calculate the costs which are related to manufacturing costs. The fixed Overheads are treated as the product costs and are deducted as expenses only the fixed costs related to the units sold, while the remaing fixed costs are added to the value of the Closing Inventory.

Variable Costing: Variable Method is another type of method which treats the Fixed Costs as the period costs and the whole fixed costs are deducted as expenses in the income statement.

Given,

Budgeted Production - 108,000 liters

Units Sold - 90,000 liters

Selling Price - $20 per liter

Variable Costs - $12 per liter

Fixed Costs - $216,000

Calculation of Fixed Cost Per Unit Under Absorption Method:

Fixed Cost Per Unit Under Absorption Method = Total Fixed Costs / Budgeted Production

= $216,000 / 108,000

Fixed Cost Per Unit Under Absorption Method = $2

Income Statement Under Absorption and Variable Costing Methods:

Particulars Absorption Costing Variable Costing
Sales Revenue $1,800,000
(90,000 * $20
$1,800,000
(90,000 * $20
Variable Costs ($1,080,000)
(90,000 * $12)
($1,080,000)
(90,000 * $12)
Contribution Margin (or) Gross Profit $720,000 $720,000
Fixed Costs ($180,000)
(90,000 * $2)
($216,000)
Net Profit $540,000 $504,000

If Mr. Livingstione uses Absorption Costing the bonus for the supervisors will be $540,000 * 2% = $10,800

If Mr. Livingstione uses Variable Costing the bonus for the supervisors will be $504,000 * 2% = $10,080

By using Variable Costing Method Livingston can save the bonus expense of $720 ($10,800 - $10,080)

So it is recommended to Livingston to use Variable Costing Method to Save the amount of $720.


Related Solutions

Mr. Preprah is the chairman of PALOO company and has become concerned about the accumulation of...
Mr. Preprah is the chairman of PALOO company and has become concerned about the accumulation of cash in hand and in the deposit accounts shown in the company's statement of financial position. The company is in the manufacturing sector, supplying engines to the auto markets in the Ghana and Africa. For the last 30 years the company has grown predominantly by acquisition and has not invested significantly in research and development on its own account. The acquisitions have given the...
Mr. Preprah is the chairman of PALOO company and has become concerned about the accumulation of...
Mr. Preprah is the chairman of PALOO company and has become concerned about the accumulation of cash in hand and in the deposit accounts shown in the company's statement of financial position. The company is in the manufacturing sector, supplying engines to the auto markets in the Ghana and Africa. For the last 30 years the company has grown predominantly by acquisition and has not invested significantly in research and development on its own account. The acquisitions have given the...
Halla Corporation produces and sells bottled water. The bottled water produced by the company is sold...
Halla Corporation produces and sells bottled water. The bottled water produced by the company is sold for 500 won per bottle, and the variable cost of producing and selling a bottle of bottled water is 300 won. Meanwhile, the fixed cost incurred in facility investment for the production and sale of the bottled water is 10 million won. Halla Corp. uses 40 million won in debt with an interest rate of 10 percent. Answer the following question. 1. Halla Corporation's...
The Mineral Water Company sells bottled water for offices and homes. The price of the water...
The Mineral Water Company sells bottled water for offices and homes. The price of the water is $20 per 10 gallon bottle and the company currently sells 2000 bottles per day. Following are the company’s income and costs on a daily basis: Sales Revenue $40,000 Variable Cost $16,000 Fixed Cost $20,000 [Note: You can assume that variable costs are constant so that the average of them is also the unit variable cost.] The company is enjoying stable demand with its...
American Products is concerned about managing cash efficiently. On the​ average, inventories have an age of...
American Products is concerned about managing cash efficiently. On the​ average, inventories have an age of 8484 ​days, and accounts receivable are collected in 3939 days. Accounts payable are paid approximately 3333 days after they arise. The firm has annual sales of about ​$3737 million. Cost of goods sold are ​$2020 ​million, and purchases are ​$1616 million. a.  Calculate the​ firm's operating cycle. b.  Calculate the​ firm's cash conversion cycle. c.  Calculate the amount of resources needed to support the​...
American Products is concerned about managing cash efficiently. On average, inventories have an age of 80...
American Products is concerned about managing cash efficiently. On average, inventories have an age of 80 days, and accounts receivables are collected in 40 days. Accounts payable are paid on average 30 days after they arise. The firm has annual credit sales of $30 million, cost of goods sold total $20 million, and purchases are $15 million. 1. What is operating cycle? Calculate the firm's operating cycle and explain what it means. 2. What is cash cycle? Calculate the firm's...
In order to expand its bottled water business, a local company is considering the acquisition of...
In order to expand its bottled water business, a local company is considering the acquisition of additional equipment. It plans to buy the equipment. The total cost of the equipment (as one initial payment at the beginning of the project) is $200,500. During the time span of its use, the equipment is expected to produce net cash inflows of $67,000 each year. The equipment is expected to be used for 4 years, then re-sold in the used-equipment market for $25,000....
Mr. Edward, the owner of several restaurants in New York, is concerned about the wide differences...
Mr. Edward, the owner of several restaurants in New York, is concerned about the wide differences in profit margins of the various restaurants. He would like to try some incentive plans for increasing the efficiency levels of these restaurants that are lagging behind. But before he introduces this, he would like to be sure that the idea would work. He sets up a meeting with all the managers and senior staff of each restaurant and asks you, as a researcher,...
   Question 3 Mr A Mathews, a client of your firm, has provided you with the...
   Question 3 Mr A Mathews, a client of your firm, has provided you with the following bank statement and bank account details in respect of the month ended 31 December 2016. STATEMENT OF ACCOUNT - YOUR BANK LTD Statement date - 31 December 2016. Account No 123456 Date              Particulars           Debit     Credit    Balance 01-Dec-16 Balance forward 61,526 Cr 01-Dec-16 Cheque 1233 5,000 56,526 Cr 01-Dec-16 Lodgement 6,000 62,526 Cr 03-Dec-16 Cheque 1234 6,600 55,926 Cr 05-Dec-16...
The president of a company that manufactures car seats has been concerned about the number and...
The president of a company that manufactures car seats has been concerned about the number and cost of machine breakdowns. The problem is that the machines are old and becoming quite unreliable. However, the cost of replacing them is quite high, and the president is not certain that the cost can be made up in today’s slow economy. To help make a decision about replacement, he gathered data about last month’s costs for repairs in dollars (y) and the ages...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT