Redo the companys income statement at the 5100-unit level

Assignment Help Accounting Basics
Reference no: EM13481508

Problem 1-18A Cost Behavior; High-Low Method; Contribution Format Income Statement [LO3, LO4, LO5]

Frankel Ltd., a British merchandising company, is the exclusive distributor of a product that is gaining rapid market acceptance. The company's revenues and expenses (in British pounds) for the last three months are given below:

 

Frankel Ltd.
Comparative Income Statements
For the Three Months Ended June 30

April   May   June    
   Sales in units 1,700 3,400 5,100  







  Sales revenue £ 299,200 £ 598,400   £ 897,600  
  Cost of goods sold 117,300 234,600 351,900  




  Gross margin 181,900 363,800 545,700  




  Selling and administrative expenses:


        Shipping expense 42,300 64,400 86,500  
        Advertising expense 69,900 69,900 69,900  
        Salaries and commissions 104,900 174,600 244,300  
        Insurance expense 8,700 8,700 8,700  
        Depreciation expense 41,900 41,900 41,900  




  Total selling and administrative expenses 267,700 359,500 451,300  




  Net operating income (loss)

£  (85,800)

£   4,300 £   94,400   








  

(Note: Frankel Ltd.'s income statement has been recast in the functional format common in the United States. The British currency is the pound, denoted by £.)

 

Required:
1.

Identify each of the company's expenses (including cost of goods sold) as either variable, fixed, or mixed.

 

                 
   Expenses Classification
   Cost of goods sold
   Shipping expense
   Advertising expense
   Salaries and commissions
   Insurance expense
   Depreciation expense

 

2.

Using the high-low method, separate each mixed expense into variable and fixed elements. State the cost formula for each mixed expense. (Enter mixed expenses in the order of company expenses provided under question.)

 


Variable Cost Fixed Cost Formula
    £ per unit   £     Y = £ + £   X  
    £ per unit £     Y = £ + £   X  

 

3.

Redo the company's income statement at the 5,100-unit level of activity using the contribution format. (Input all amounts as positive values except losses which should be indicated by a minus sign.)

 

Frankel Ltd.
Income Statement
For the Month Ended June 30
   
£   
  Variable expenses:

         £
        
           



   Contribution margin
  
  Fixed expenses:

        
        
        
        
           



   
£   

Reference no: EM13481508

Questions Cloud

Calculate the total amount of cash that michael would pay : michael just graduated from college and has his first job. his salary is that of an entry-level employee so he has to
An investor buys a one-year 1000 face-value us treasury : an investor buys a one-year 1000 face-value us treasury bill or t-bill for 960. the investor expects to receive 1000
Salad daze maintains an inventory of produce worth 390 its : salad daze maintains an inventory of produce worth 390. its total bill for produce over the course of the year was
Seldin company owns a royalty interest in an oil well what : seldin company owns a royalty interest in an oil well. the contract stipulates that seldin will receive royalty
Redo the companys income statement at the 5100-unit level : problem 1-18a cost behavior high-low method contribution format income statement lo3 lo4 lo5frankel ltd. a british
What i need you to do is to prepare a complete set of : bobbi brown has come to me and asked for my help. sherecently started up a new consulting practice and needs some
Chiks chickens has average accounts receivables of 5433 : chiks chickens has average accounts receivables of 5433. sales for the year were 8900.00. what is its average
Use an excel spreadsheet and the fv pv pmt functions to : use an excel spreadsheet and the fv pv pmt functions to determine the amount of each of the following rthe annual
What would the sustainable growth rate be if davis chilis : consider the following information davis chilis bagwell company return on equity roe 14.10 9.00 plowback ratio 0.34

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