Question

Lodney Tho mos 1/27/2018 Deliver Tneks Real Estate Taxes 2)The following data is given for mixed costs Month Units Produced Total Mixed Cost 10000 10500 9500 16650 18580 17100 a) Compute the variable and fixed cost elements using the high-low method. Mixed Costs sheet attached. b)Estimate the total mixed cost if the company produces 9200 units 3) You are provided with the following for the month of February 2018 Units sold Price per unit Total variable costs Fixed Costs 2000 400 250000 150000 a) Given this data, prepare an income statement for the month Model blank sheet attached. b) What is the break even in units? c) If the targeted net income is 600000, what is the required sales in units 4) Identify the following costs as relevant, opportunity,sunk or none of these. Option A (make) Option B (Buy 1000 500 40000 25000 35000 1000 500 Taxes Building Lease Manufacturing Equip. Purchase Materials Labor Purchase of Terminals In House Equipment Available for a Special Order
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution 1:

Identification of cost as variable, fixed and mixed
Cost description Nature of cost
Deliver Trucks Variable
Depreciation Fixed
Direct Labor Variable
Building Rent Fixed
Manufacturing machine maintenance Mixed
Sales Commission Variable
Real estate taxes Variable
Raw Materials Variable

Solution 2 a:

Highest level of activity = 10500 units, mixed cost = $18,580

Lowest level of activity = 8800 units, mixed cost = $16,200

Variable cost = (Cost at high level - cost at low level) / (Highest activity level - Lowest actvity level)

= ($18,580 - $16,200) / (10500 - 8800) = $1.40 per unit

Fixed cost = $18580 - (10500*$1.40) = $3,880

Mixed cost equation = $3,880 + $1.40X, where x is number of unit produced

Solution 2 b:

Estimated mixed cost at 9200 units = $3,880 + 9200*$1.40 = $16,760

Solution 3:

Income statement
Particulars Per unit Amount
Sales $400.00 $800,000.00
Variable cost $125.00 $250,000.00
Contribution $275.00 $550,000.00
Fixed cost $150,000.00
Net operating income $400,000.00

Breakeven units = Fixed cost / contribution per unit = $150,000 / $275 = 545 units

Target net income = $600,000

Target contribution = $600,000 + $150,000 = $750,000

Nos of units to be sold = $750,000 / $275 = 2727 units

Add a comment
Know the answer?
Add Answer to:
Lodney Tho mos 1/27/2018 Deliver Tneks Real Estate Taxes 2)The following data is given for mixed...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six m...

    Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six months 2019: Units sales per quarter and the selling price per unit are estimated as follows:                                                   Unit sales                      Price per unit January                                   2,500                                 $450 February                                 2,800                                 $450 March                                     2,750                                 $480 April                                       2,750                                 $480 May                                        2,800                                 $500          June                                        2,800                                 $500 July                                         3,000                                 $500 August                                    3,000                                 $500 Sales on November...

  • PLA so VC DL Cmn 501000 Depr. 15.000 FC 1. The following financial statement amounts related...

    PLA so VC DL Cmn 501000 Depr. 15.000 FC 1. The following financial statement amounts related to producing 2,000 units: Direct materials $30,000 Sales 100.000 - Depreciation expense 15,000 DM 30,000 Sales revenue 100,000 20.000 Direct labor (Variable cost) 20,000 Rent expense 15,000 TL Rent. 15,000 a. How much is contribution margin per unit? NI 20,000 0.0001 2000 - 25 b. What is the company's contribution margin ratio? 50% c. What is the company's break-even in units? . Fix cost...

  • On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances:...

    On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances:   Accounts Debit Credit   Cash $ 26,400   Accounts Receivable 48,800   Allowance for Uncollectible Accounts $ 5,500   Inventory 21,300   Land 59,000   Equipment 21,500   Accumulated Depreciation 2,800   Accounts Payable 29,800   Notes Payable (6%, due April 1, 2019) 63,000   Common Stock 48,000   Retained Earnings 27,900        Totals $ 177,000 $ 177,000 During January 2018, the following transactions occur: January 2 Sold gift cards totaling $10,600. The cards are redeemable for...

  • On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances: Accounts...

    On January 1, 2018, the general ledger of ACME Fireworks includes the following account balances: Accounts Debit Credit Cash $ 28,000 Accounts Receivable 48,000 Inventory 20,900 Land 75,000 Equipment 19,500 Allowance for Uncollectible Accounts 5,100 Accumulated Depreciation 2,400 Accounts Payable 29,400 Notes Payable (6%, due April 1, 2019) 59,000 Warranty Liability 26,000 Common Stock 44,000 Retained Earnings 25,500 Totals $ 191,400 $ 191,400 During January 2018, the following transactions occur: January 2 Sold gift cards totaling $9,800. The cards are...

  • On 1/1/2018, Sam's Sporting Goods has the following account balances 62,000 23,000 2,100 35,200 100,000 Cash Accounts R...

    On 1/1/2018, Sam's Sporting Goods has the following account balances 62,000 23,000 2,100 35,200 100,000 Cash Accounts Receivable Allowance for Doubtful Accts Inventory Consists of #3520 urtits @ $10 cost per unit Building A/D Building Accounts Payable Notes Payable (Syr, 6%, interest due every 12/31) Common Stock Retained Earnings 25,000 12,200 50,000 110,000 20,900 220,200 220,200 During the month of January 2018, the following transactions occur: Jan 1: Sell Building for $60,000 cash. Jan 1:Purchase warehouse Equipment with cash $20,000....

  • On January 1, 2018, the general ledger of TNT Fireworks includes the following account balances: Credit...

    On January 1, 2018, the general ledger of TNT Fireworks includes the following account balances: Credit Debit $ 59,000 25,600 $ 2,500 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Notes Receivable (5%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 36,600 15,600 158,000 15,100 223,000 54,200 $ 294,800 $ 294,800 During January 2018, the following transactions occur: January 1 Purchase equipment for $19,800. The company estimates a residual value of $1,800 and a six-year...

  • question # 2: (5marks: 1 mark for each closing entry, 2 marks for the secou closing...

    question # 2: (5marks: 1 mark for each closing entry, 2 marks for the secou closing entry) At December 31, the account balances after adjustments for Wabel Company are as follows: Bank Account Credit Debit S 50 000 2250 3000 1 500 27 000 Prepaid Insurance Account Receivable Supplies Equipment Accumulated Dep. - Equipment Account Payable Notes Payable Uneared Revenue Capital Drawings Sales Revenue Interest Expense Dep. Expense Wages Expense Utilities Expenses $ 5500 2000 12500 5500 44 450 1000...

  • 1. Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are colle...

    1. Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement. a. Income Statement Data for 20XX: • Units produced and sold = 420 • Sales ($80 per unit selling price) = $33600...

  • The highlighted sections are the ones i need figured out MGMT 640 GROUP PROJECT to your...

    The highlighted sections are the ones i need figured out MGMT 640 GROUP PROJECT to your team has been hired to provide financial analysis for a start-up company, Bobble in Style, n produces customized bobble heads. The bobble heads are made out of less rigid materials and are more true to life more true to life than those of competitors. The company inventors, Mr. and Mrs. Lee, are going to pitch trieir idea to Shark Tank in a few months,...

  • Can someone help with #1, 2, 5, 6? OEDD DEODMUHDEVIVOR Exercises/Problems 1. Stockholders' Equity. The owners...

    Can someone help with #1, 2, 5, 6? OEDD DEODMUHDEVIVOR Exercises/Problems 1. Stockholders' Equity. The owners of a new venture have decided to organize as a corporation. The ini. tial equity investment is valued at $100,000, reflecting contributions of the entrepreneur and her family and friends. One hundred thousand shares of stock were initially issued. A. What dollar amount would initially be recorded in the common stock account? B. If a par value on the common stock were set at...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT