Question

In: Accounting

Contents » X Company has the following data from 2016 and 2017: 2016    2017    Total costs...

Contents »

X Company has the following data from 2016 and 2017:

2016    2017   
Total costs $260,600 $411,850
Units produced 32,000 57,000


Expected production in 2018 is 43,800 units. Using the high-low method with the 2016 and 2017 data to determine the parameters of the cost function, what are estimated total costs in 2018?

Solutions

Expert Solution

Note - 1

Identification of variable cost per unit

Particulars

2016

2017

Change from 2016 to 2017

Total Cost

$           2,60,600

$      4,11,850

$       1,51,250

Unit Produced

           32000

       57000

          25000

Identification of variable cost per unit =

Change in total cost

=

151250

=

$ 6.05

Per unit

Change in total unit produced

25000

Note - 2

Identification fixed cost

Amount

Total Cost of 2017

$     4,11,850.00

(a)

Less: Variable cost (57000*6.05)

$     3,44,850.00

(b)

Fixed Cost (a-b)

$        67,000.00

Answer

Estimated total cost for 2018

Total expected unit produced in 2018

                  43,800

Unit

Variable Cost (43800*6.05)

$     2,64,990.00

refer note - 1

Add:

Fixed Cost

$        67,000.00

refer note - 2

Total Cost for 2018

$     3,31,990.00


Related Solutions

dex company manufactures a single product assume the following data for 2016: Fixed costs in total:...
dex company manufactures a single product assume the following data for 2016: Fixed costs in total: Selling and administrative 54,000 Production 72,000 Variable costs per unit: Selling and administrative 3 Production 9 there were no units in inventory on january 1. during the year, 18,000 units were produced and 15,000 were sold. the selling price of dex company is 25 per unit. how much company’s net income for 2016 under the direct coating method?
The balance sheet data of Pronghorn Company at the end of 2017 and 2016 follow. 2017...
The balance sheet data of Pronghorn Company at the end of 2017 and 2016 follow. 2017 2016 Cash $29,000 $35,400 Accounts receivable (net) 55,400 44,500 Inventory 64,300 44,600 Prepaid expenses 15,200 25,000 Equipment 90,800 74,800 Accumulated depreciation—equipment (18,100 ) (8,800 ) Land 79,900 39,600 $316,500 $255,100 Accounts payable $63,600 $49,000 Accrued expenses 15,000 18,000 Notes payable—bank, long-term –0– 22,800 Bonds payable 30,200 –0– Common stock, $10 par 200,400 160,100 Retained earnings 7,300 5,200 $316,500 $255,100 Land was acquired for $40,300...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 follow. 2017...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 follow. 2017 2016 Cash $29,000 $34,900 Accounts receivable (net) 55,200 44,900 Inventory 64,900 44,600 Prepaid expenses 15,100 24,900 Equipment 90,100 75,600 Accumulated depreciation—equipment (18,200 ) (7,200 ) Land 80,600 39,800 $316,700 $257,500 Accounts payable $67,200 $53,300 Accrued expenses 14,800 17,900 Notes payable—bank, long-term –0– 23,000 Bonds payable 29,700 –0– Common stock, $10 par 198,700 157,900 Retained earnings 6,300 5,400 $316,700 $257,500 Land was acquired for $40,800...
Exercise 2-11 Suppose the following data were taken from the 2017 and 2016 financial statements of...
Exercise 2-11 Suppose the following data were taken from the 2017 and 2016 financial statements of American Eagle Outfitters. (All numbers, including share data, are in thousands.) 2017 2016 Current assets $ 988,800 $963,900 Total assets 1,940,000 1,866,000 Current liabilities 412,000 357,000 Total liabilities 566,480 544,872 Net income 165,600 347,200 Net cash provided by operating activities 283,000 490,800 Capital expenditures 250,000 284,800 Dividends paid on common stock 78,000 109,300 Weighted-average shares outstanding 207,000 217,000 (a) Calculate the current ratio for...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 are shown...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 are shown below. 2017 2016 Cash $29,800 $35,300 Accounts receivable (net) 54,500 44,900 Inventory 65,000 44,900 Prepaid expenses 15,200 24,700 Equipment 90,000 74,700 Accumulated depreciation—equipment (18,000 ) (8,100 ) Land 70,500 40,000 $307,000 $256,400 Accounts payable $64,900 $51,700 Accrued expenses 15,000 17,800 Notes payable—bank, long-term –0– 22,800 Bonds payable 30,000 –0– Common stock, $10 par 188,000 157,500 Retained earnings 9,100 6,600 $307,000 $256,400 Land was acquired...
Given the following data for 2017: Administrative costs                                 &n
Given the following data for 2017: Administrative costs                                                   $35,000 Current liabilities                                                          18,000 Building depreciation (80% for plant)                       25,000 Indirect materials and supplies                                       4,000 Sales commission expenses                                         12,000 Accounts receivable                                                     15,000 Direct materials inventory, Jan 1, 2017                        15,000 Direct labor                                                                 32,000 Direct materials inventory, Dec 31, 2017                    16,000 Finished goods inventory, Jan 1, 2017                           8,000 Finished goods inventory, Dec 31, 2017                        7,000 Materials purchases                                                    20,000 Work in process inventory, Dec 31, 2017                    10,000 Supervisory and...
A company has the following historic pattern of total manufacturing costs versus total number of products...
A company has the following historic pattern of total manufacturing costs versus total number of products produced: MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000 $400,000 May 14,000 $434,000 June 9,000 $360,000 July 20,000 $550,000 August 21,000 $525,000 September 24,000 $605,000 October 23,000 $589,000 November 28,000 $702,000 December 18,000 $496,000 1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS)...
Predict the number of people arrested for drug possession in 2016 and 2017 from the data...
Predict the number of people arrested for drug possession in 2016 and 2017 from the data Year # of People Arrested 2006 1,519,760 2007 1,361,658 2008 1,321,824 2009 1,387,915 2010 1,179,728 2011 1,143,931 2012 1,237,708 2013 1,203,323 2014 982,169 2015 801,560 2016 2017 2018
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017...
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017 2016 Cash .................................... $   87,375 $   63,750 Available-for-sale securities (not cash equivalents) ......................... 17,250 105,000 Accounts receivable ..................... 90,000 86,250 Merchandise inventory ................... 187,500 163,500 Prepaid insurance ....................... 1,125 1,500 Land, buildings, and equipment ......... 1,378,875 1,087,500 Accumulated depreciation ................ (558,750) (498,750) Total ................................. $1,203,375 $1,008,750 Accounts payable ........................ $ 153,375 $ 236,250 Salaries payable ........................ 18,750 26,250 Notes payable--bank (current) ........... 37,500 150,000...
The economy of Euphoria has the following economic data. Year 2016 2017 2018 Nominal Gross Domestic...
The economy of Euphoria has the following economic data. Year 2016 2017 2018 Nominal Gross Domestic Product ($ billions) 1,625 1,675 1,697.50 Real Gross Domestic Product ($ billions) 2015 = 1,568.5 1,625 1,649.75 1,702.50 GDP deflator 100 101.53 99.71 % change in real Consumption spending 3 1.75 2.8 % change in real Investment spending 2 -10 5 Net exports ($ billions) -3,000 -6,000 -12,000 Unemployment rate (%) 5.3 5.8 5.2 Natural rate of unemployment 4.8 4.8 4.8 Index of production...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT