Question

In: Accounting

Abbott Lamp Corporation manufactures Mountain Dew Lamps.   Abbott Lamp Corporation has the following historical cost behavior...

Abbott Lamp Corporation manufactures Mountain Dew Lamps.   Abbott Lamp Corporation has the following historical cost behavior data:

Year

Total Direct Labor Hours

Total

Utilities

Total Indirct

Labor

Total Indirct

Materials

Total Mixed OH costs

2014

100

$125

$400

$175

$700

2015

150

$175

$550

$225

$950

2016

200

$225

$700

$275

$1,200

2017

350

$375

$1,150

$425

$1,950

Other 2018 estimated information is as follows:

Rent on production facility                 $100

Factory supervisor salary                    $100

Depreciation on factory equipment    $200

Rent on corporate headquarters          $300

Corporate HQ salaries                         $1,000

Total                                                    $1,700

Abbott Lamp also estimates the following with regard to direct materials and direct labor:

Direct Materials:

1 mountain can/mountain dew lamp @ $2/mountain dew can;

.25 pieces of paper/mountain dew lamp @$4/piece of paper;

Direct Labor

.2 dlh/mountain dew lamp @ $10/dlh

Abbott Lamp Corporation manufactures Mountain Dew Lamps.   Abbott Lamp Corporation has the following historical cost behavior data:

Year

Total Direct Labor Hours

Total

Utilities

Total Indirct

Labor

Total Indirct

Materials

Total Mixed OH costs

2014

100

$125

$400

$175

$700

2015

150

$175

$550

$225

$950

2016

200

$225

$700

$275

$1,200

2017

350

$375

$1,150

$425

$1,950

Other 2018 estimated information is as follows:

Rent on production facility                 $100

Factory supervisor salary                    $100

Depreciation on factory equipment    $200

Rent on corporate headquarters          $300

Corporate HQ salaries                         $1,000

Total                                                    $1,700

Abbott Lamp also estimates the following with regard to direct materials and direct labor:

Direct Materials:

1 mountain can/mountain dew lamp @ $2/mountain dew can;

.25 pieces of paper/mountain dew lamp @$4/piece of paper;

Direct Labor

.2 dlh/mountain dew lamp @ $10/dlh

1. A. Estimate the VARIABLE predetermined overhead rate using the high-low method. Using the high-low method, what does the y-intercept ‘mean’ in this case?

B. Using your answer from 1 above (using BOTH the VPDOH and the y-intercept), compute the breakeven point in terms of total # of mountain dew lamps that need to be sold to break even. Assume that the price per Mountain Dew Lamp is $20/mountain dew lamp and that capacity is NOT an issue.

C. Calculate the # of mountain dew lamps that must be sold in order to achieve a goal operating income of $10,000 (and still use your answer from part 1 above);

Solutions

Expert Solution

A. Variable predetermined overhead rate: $5 per direct labor hour

Working:

Total Direct Labor Hours Total Mixed OH Costs
High activity level 350 $            1,950
Low activity level 100 $                700
Change 250 $            1,250

Variable cost per unit = $1250/250 = $5

Fixed cost (at high level) = $1950 - (350 x $5) = $1950 - $1750 = $200

Fixed cost (at low level) = $700 - (100 x $5) = $700 - $500 = $200

Fixed overhead 200
Rent on production facility 100
Factory supervisor salary 100
Depreciation on factory equipment 200
Rent on corporate headquarters 300
Corporate HQ salaries 1000
Total fixed costs $ 1900

y-intercept: $1900

The y-intercept means the total fixed costs.

B. Break-even point (units) = Fixed costs/Contribution per unit

Sales price per unit 20
Variable costs:
Direct materials
1 mountain can 2
0.25 pieces of paper (0.25 x $4) 1
Direct labor (0.2 x $10) 2
Variable overhead (0.2 x $5) 1
Total variable costs 6
Contribution margin per unit $ 14

Break-even point = $1900/$14 = 135.71 = 136 lamps

C. Number of lamps to be sold = (Fixed costs + Desired profit)/Contribution margin per unit = ($1900 + $10000)/$14 = $11900/$14 = 850 lamps


Related Solutions

Abbott Lamp Corporation manufactures Mountain Dew Lamps.   Abbott Lamp Corporation has the following historical cost behavior...
Abbott Lamp Corporation manufactures Mountain Dew Lamps.   Abbott Lamp Corporation has the following historical cost behavior data: Year Total Direct Labor Hours Total Utilities Total Indirct Labor Total Indirct Materials Total Mixed OH costs 2014 100 $125 $400 $175 $700 2015 150 $175 $550 $225 $950 2016 200 $225 $700 $275 $1,200 2017 350 $375 $1,150 $425 $1,950 Other 2018 estimated information is as follows: Rent on production facility                 $100 Factory supervisor salary                    $100 Depreciation on factory equipment    $200 Rent...
The Schuyler Corporation manufactures lamps. It has set up the following standards per finished unit for...
The Schuyler Corporation manufactures lamps. It has set up the following standards per finished unit for direct materials and direct manufacturing​ labor: Direct materials: 10 lb. at $4.60 per lb. $46.00 Direct manufacturing labor: 0.5 hour at $30 per hour 15.00 The number of finished units budgeted for January 2017 was 9,650​; 9,600 units were actually produced. Actual results in January 20172017 were as​ follows: Direct materials: 94,500 lb. used Direct manufacturing labor: 4,600 hours $144,900 Assume that there was...
Exercise 11.3 The Lumins Lamp Company, a producer of old-style oil lamps, estimated the following demand...
Exercise 11.3 The Lumins Lamp Company, a producer of old-style oil lamps, estimated the following demand function for its product: Q=120,000−10,000PQ=120,000−10,000P where Q is the quantity demanded per year and P is the price per lamp. The firm’s fixed costs are $12,000 and variable costs are $1.50 per lamp. What is the total revenue (TR) function in terms of Q? Q−Q210,000Q−Q210,000 120,000Q−Q210,000120,000Q−Q210,000 120,000Q−10,000×Q2120,000Q−10,000×Q2 12Q−Q210,00012Q−Q210,000 What is the marginal revenue (MR) function? 1−Q5,0001−Q5,000 120,000−Q5,000120,000−Q5,000 12−Q5,00012−Q5,000 120,000−20,000Q120,000−20,000Q What is the total cost...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017 2018 Current assets Current liabilities Cash $ 10,450 $ 10,000 Accounts payable $ 70,750 $ 63,000 Accounts receivable 27,800 28,750 Notes payable 49,500 48,000 Inventory 63,200 63,100 Total $ 120,250 $ 111,000 Total $ 101,450 $ 101,850 Long-term debt $ 64,900 $ 62,700 Owners' equity Common stock and paid-in...
Just Dew It Corporation reports the following balance sheet information for 2008 and 2009. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2008 and 2009. JUST DEW IT CORPORATION 2008 and 2009 Balance Sheets Assets Liabilities and Owners' Equity 2008 2009 2008 2009 Current assets Current liabilities Cash $ 10,250 $ 10,750 Accounts payable $ 72,250 $ 58,000 Accounts receivable 28,850 28,800 Notes payable 46,500 45,500 Inventory 64,600 64,900 Total $ 118,750 $ 103,500 Total $ 103,700 $ 104,450 Long-term debt $ 57,900 $ 64,300 Owners' equity Common stock and paid-in...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015   Current assets   Current liabilities       Cash $ 11,025 $ 11,970       Accounts payable $ 43,750 $ 47,250       Accounts receivable 22,225 26,670       Notes payable 24,325 24,780       Inventory 44,625 51,450         Total $ 77,875 $ 90,090         Total $ 68,075 $ 72,030   Long-term debt $ 35,000 $ 21,000   Owners’ equity       Common stock and paid-in...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 12,000 $ 17,775       Accounts payable $ 46,875 $ 55,575       Accounts receivable 12,750 16,425       Notes payable 19,125 24,750       Inventory 50,250 56,925         Total $ 75,000 $ 91,125         Total $ 66,000 $ 80,325   Long-term debt $ 30,000 $ 27,000   Owners’ equity       Common stock and paid-in...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017 2018   Current assets   Current liabilities     Cash $   10,150        $ 10,350        Accounts payable $ 74,500     $ 61,250           Accounts receivable 27,100      27,250        Notes payable 48,500     49,250           Inventory 62,900      63,500          Total $ 123,000     $ 110,500            Total $ 100,150      $...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017 2018   Current assets   Current liabilities     Cash $   10,250        $ 10,750        Accounts payable $ 72,250     $ 58,000           Accounts receivable 28,850      28,800        Notes payable 46,500     45,500           Inventory 64,600      64,900          Total $ 118,750     $ 103,500            Total $ 103,700      $...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW...
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 4,350 $ 9,800       Accounts payable $ 48,000 $ 49,800       Accounts receivable 11,550 14,200       Notes payable 10,350 18,600       Inventory 58,350 75,800         Total $ 74,250 $ 99,800         Total $ 58,350 $ 68,400   Long-term debt $ 42,000 $ 34,000   Owners’ equity       Common stock and paid-in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT