b.
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.939637678 | |||||||
R Square | 0.882918965 | |||||||
Adjusted R Square | 0.8775971 | |||||||
Standard Error | 161798.0253 | |||||||
Observations | 24 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 4.34E+12 | 4.34E+12 | 165.904 | 1.01E-11 | |||
Residual | 22 | 5.76E+11 | 2.62E+10 | |||||
Total | 23 | 4.92E+12 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 978728.8682 | 164194.3 | 5.960798 | 5.34E-06 | 638210.8 | 1319247 | 638210.8 | 1319247 |
Labor Hours | 6.75215177 | 0.52422 | 12.88037 | 1.01E-11 | 5.664986 | 7.839318 | 5.664986 | 7.839318 |
Intercept = $978728.87
Cost per labor hour = $6.75
c.
Cost for 450000 hours = 450000 x $6.75 + 978729 = $4016229
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and...
3 54,15 Hartman Company's Lucas plant manufactures thermostatic controls, Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor hours. 2.85 Boints A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member...
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations. Month Labor-Hours Machine-Hours 1 725 1,362 2 720 1,411 3 680 1,526 4 740 1,460 5 790 1,589 6 760 1,583 7 730 1,398 8 725 1,304 9 700 1,462 10 795 1,544...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-9) Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company's stores are listed below for the past six months. Total Utility Total Hours Month of Operation January 550 February 600 March 700 April 500 May 450 400...
P 6A - B High-Low Analysis and Cost Behavior Broccoli Company's total overhead costs vary considerably, from month to month, based on direct labor hours. Month August September October November December Labor Hours 3,000 3,400 2,000 2,800 3,600 Total Overhead $234,000 249,200 196,000 226,400 256,800 Their overhead costs consist of indirect labor, supervisor's salary and maintenance. A breakdown of these costs, for the month of October (their low month of activity), follows. Indirect labor (V) Supervisor's salary (F) Maintenance (M)...
High-Low Analysis and Cost Behavior Broccoli Company's total overhead costs vary considerably, from month to month, based on direct labor hours. P6A - B Month August September October November December Labor Hours 3,000 3,400 2,000 2,800 3,600 Total Overhead $234,000 249,200 196,000 226,400 256,800 Their overhead costs consist of indirect labor, supervisor's salary and maintenance. A breakdown of these costs, for the month of October (their low month of activity), follows. Indirect labor (V) Supervisor's salary (F) Maintenance (M) Total...
Required information [The following information applies to the questions displayed below.] Caiman Distribution Partners is the Brazilian distribution company of a U.S. consumer products firm. Inflation in Brazil has made bidding and budgeting difficult for marketing managers trying to penetrate some of the country's rural regions. The company expects to distribute 450,000 cases of products in Brazil next month. The controller has classified operating costs (excluding costs of the distributed product) as follows. Account Supplies Supervision Truck expense Building leases...
Sawaya Co., Ltd., of Japan is a manufacturing company whose total factory overhead costs fluctuate considerably from year to year according to increases and decreases in the number of direct labor-hours worked in the factory. Total factory overhead costs at high and low levels of activity for recent years are given below: Level of Activ Low 51,000 High 68,000 Direct labor-hours Total factory overhead costs 267,200 $299,500 The factory overhead costs above consist of indirect materials, rent, and maintenance. The...
Sawaya Co., Ltd., of Japan is a manufacturing company whose total factory overhead costs fluctuate considerably from year to year according to increases and decreases in the number of direct labor-hours worked in the factory. Total factory overhead costs at high and low levels of activity for recent years are given below: Level of Activ Low 51,000 High 68,000 Direct labor-hours Total factory overhead costs 267,200 $299,500 The factory overhead costs above consist of indirect materials, rent, and maintenance. The...
Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months. Month Total Hours of Operation Total Utility Cost January 550 $ 1,620 February 600 1,700 March 700 1,900 April 500 1,600 May 450 1,350 June 400 1,300 Required: 1-a. Use the...
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations: Month NOVO AWN Labor-Hours 730 725 680 750 770 755 745 720 715 790 685 700 Machine-Hours 1,352 1,413 1,519 1,444 1,594 1,585 1,386 1,303 1,447 1,543 1,288 1,620 Overhead Costs $ 102,690...