Question

In: Accounting

Problem 24-2A Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As...

Problem 24-2A

Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Variable costs Rate per Direct Labor Hour Annual Fixed Costs Indirect labor $0.43 Supervision $45,120 Indirect materials 0.52 Depreciation 18,000 Factory utilities 0.33 Insurance 17,640 Factory repairs 0.21 Rent 27,720 The master overhead budget was prepared on the expectation that 480,800 direct labor hours will be worked during the year. In June, 46,500 direct labor hours were worked. At that level of activity, actual costs were as shown below. Variable—per direct labor hour: indirect labor $0.47, indirect materials $0.50, factory utilities $0.37, and factory repairs $0.25. Fixed: same as budgeted.

(a) Prepare a monthly manufacturing overhead flexible budget for the year ending December 31, 2017, assuming production levels range from 38,700 to 53,400 direct labor hours. Use increments of 4,900 direct labor hours. (List variable costs before fixed costs.)

b.) State the formula for computing the total budgeted costs for the Ironing Department. (Round variable cost per unit to 2 decimal places, e.g. 1.55.) The formula is = $____ + total variable costs of $____ per direct labor hour.

Solutions

Expert Solution

Given Data
Variable Cost Cost P/H Fixed Cost Fixed
Indirect Labour 0.43 Supervision $ 45,120.00
Indirect Material 0.52 Depreciation $ 18,000.00
Factory Utilities 0.33 Insurance $ 17,640.00
Factory Repairs 0.21 Factory Rent $ 27,720.00
Monthly manufacturing overhead flexible budget for the year ending Dec 31,17
Activity Level(Hours)
Description 38700 43600 48500 53400
Variable Cost
Indirect Labor@$.43 per hour $    16,641.00 $    18,748.00 $    20,855.00 $    22,962.00
Indirect Material@$.52 per hour $    20,124.00 $    22,672.00 $    25,220.00 $    27,768.00
Factory Utilities@$.33 per hour $    12,771.00 $    14,388.00 $    16,005.00 $    17,622.00
Factory Repairs@$.21 per hour $      8,127.00 $      9,156.00 $    10,185.00 $    11,214.00
Total Variable Cost(A) $    57,663.00 $    64,964.00 $    72,265.00 $    79,566.00
Fixed Cost
Supervision $    45,120.00 $    45,120.00 $    45,120.00 $    45,120.00
Depreciation $    18,000.00 $    18,000.00 $    18,000.00 $    18,000.00
Insurance $    17,640.00 $    17,640.00 $    17,640.00 $    17,640.00
Factory Rent $    27,720.00 $    27,720.00 $    27,720.00 $    27,720.00
Total Fixed Cost(B) $ 108,480.00 $ 108,480.00 $ 108,480.00 $ 108,480.00
Total Cost(A+B) $ 166,143.00 $ 173,444.00 $ 180,745.00 $ 188,046.00

Total budgeted cost= (Fixed Cost + Total Variable cost per direct labor hour)

for June=$108,480 + $1.59 per labor hour.

  for December =$108,480 + $1.49 per labor hour.


Related Solutions

Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result,...
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Variable costs Rate per Direct Labor Hour Annual Fixed Costs Indirect labor $0.40 Supervision $48,000 Indirect materials 0.50 Depreciation 18,000 Factory utilities 0.30 Insurance 12,000 Factory repairs...
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result,...
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Rate per Direct Variable Costs Labor Hour Annual Fixed Costs Indirect labor $0.40 Supervision $48,000 Indirect materials 0.50 Depreciation 18,000 Factory utilities 0.30 Insurance 12,000 Factory repairs...
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result,...
Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Variable costs Rate per Direct Labor Hour Annual Fixed Costs Indirect labor $0.42 Supervision $44,160 Indirect materials 0.53 Depreciation 18,960 Factory utilities 0.31 Insurance 16,560 Factory repairs...
Australia incomes have historically grown over the past 100 years?
Australia incomes have historically grown over the past 100 years?
2. Sales of air conditioners have grown consistently over the years and the follow represents sales:...
2. Sales of air conditioners have grown consistently over the years and the follow represents sales: Year           Sales 1                  520 2                  550 3 600 4                  610 5                  680 6                  710 7 810 8 820 9 900 b. Using smoothing constants of .6 and .9, develop forecasts for the sales of air conditioners. c. What effect did the smoothing constant have on the forecast for air conditioners. Which smoothing constant gives the most accurate forecast? d. Forecast year 7 using linear...
Misusing the percent of sales method​) The Caraway Seed Company has grown rapidly over the last...
Misusing the percent of sales method​) The Caraway Seed Company has grown rapidly over the last decade and is trying to forecast the​ firm's inventory requirements for the next 5 years. Historical sales and inventories for the last 10 years are found in the popup​ window, YEAR SALES INVENTORIES 2005 ​$5,250,000 ​$1,590,924 2006 6,200,000 1,724,221 2007 6,940,000 1,899,573 2008 5,650,000 1,530,054 2009 6,255,000 1,772,059 2010 7,100,000 1,919,042 2011 7,350,000 2,010,025 2012 8,010,000 2,006,023 2013 8,775,000 2,292,119 2014 10,390,000 2,537,486 2015...
The Howland Carpet Company has grown rapidly during the past 5 years. Recently, its commercial bank...
The Howland Carpet Company has grown rapidly during the past 5 years. Recently, its commercial bank urged the company to consider increasing its permanent financing. Its bank loan under a line of credit has risen to $200,000, carrying a 8% interest rate. Howland has been 30 to 60 days late in paying trade creditors. Discussions with an investment banker have resulted in the decision to raise $400,000 at this time. Investment bankers have assured the firm that the following alternatives...
The Howland Carpet Company has grown rapidly during the past 5 years. Recently, its commercial bank...
The Howland Carpet Company has grown rapidly during the past 5 years. Recently, its commercial bank urged the company to consider increasing its permanent financing. Its bank loan under a line of credit has risen to $250,000, carrying an 8% interest rate. Howland has been 30 to 60 days late in paying trade creditors. Discussions with an investment banker have resulted in the decision to raise $500,000 at this time. Investment bankers have assured the firm that the following alternatives...
Why have international financial markets grown so rapidly in the past decade? Is this rate of...
Why have international financial markets grown so rapidly in the past decade? Is this rate of growth likely to continue? What changes do you see in the international financial markets in the coming decade? Consider the influences of both developed and emerging countries. Do you think all firms, in all economic environments should operate under the same set of accounting principles? Elaborate. Support your answer with facts/reasoning.
The sales of Cool-Man air conditioners have grown steadily during the past six years as shown...
The sales of Cool-Man air conditioners have grown steadily during the past six years as shown on the table below. Year Sales 1 450 2 495 3 518 4 563 5 584 6 592 (a) Provide a forecast by using a 3-year weighted moving average technique with weights 4, 2, and 1 (4 = most recent). (b) Forecast sales using a 2-year moving average technique. (c ) What is the MSE from the 2-year moving average? Show work please
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT