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 high-low method to estimate the cost behavior for the store’s utility costs. Express the cost behavior in formula form (Y= a + bX).
1-b. What is the variable utility cost per hour of operation?
3-a. Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the cost behavior for the store's utility cost. Express the cost behavior in formula form.
3-b. What is the variable utility cost per hour of operation?
4. During July, the store will be open 300 hours. Predict the store’s total utility cost for July using each of the cost-estimation methods employed in requirements (1) and (3).
1-a
Variable cost per unit = ($1900-1300)/(700-400) = $2 per hour
Fixed Cost = $1900 - 700 x 2 = $500
Y = $500 + 2 X
1-b
Variable utility cost per hour = $2
3-a
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.97559 | |||||||
R Square | 0.951776 | |||||||
Adjusted R Square | 0.93972 | |||||||
Standard Error | 54.90902 | |||||||
Observations | 6 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 238023.3 | 238023.3 | 78.94638 | 0.000886 | |||
Residual | 4 | 12060 | 3015 | |||||
Total | 5 | 250083.3 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 501 | 123.3054 | 4.063083 | 0.01531 | 158.6494 | 843.3506 | 158.6494 | 843.3506 |
Total Hours of Operation | 2.02 | 0.227345 | 8.885178 | 0.000886 | 1.388789 | 2.651211 | 1.388789 | 2.651211 |
Y = 501 + 2.02 X
3-b
Variable cost per hour = $2.02 per hour
4
(1) Total Cost = $500 + 300 x $2 = $1100
(2) Total Cost = $501 + 300 x $2.02 = $1107
Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store...
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. 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...
Hi please answer asap Thank you ! 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 Hours Month of Operation January 450 February 600 March 800 April 400 May 350 June 300 Total Utility Cost $2,520 3,100 3,900 2,400 2,050...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) 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 Hours of Month Operation January 550 February bruary 600 March 700 April 500 May 450 June 400...
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...
Required information [The following information applies to the questions displayed below.] The controller of Chittenango Chain Company believes that the identification of the variable and fixed components of the firm's costs will enable the firm to make better planning and control decisions. Among the costs the controller is concerned about is the behavior of indirect-materials cost. She believes there is a correlation between machine hours and the amount of indirect materials used. A member of the controller's staff has suggested...
Required information [The following information applies to the questions displayed below.] The controller of Chittenango Chain Company believes that the identification of the variable and fixed components of the firm’s costs will enable the firm to make better planning and control decisions. Among the costs the controller is concerned about is the behavior of indirect-materials cost. She believes there is a correlation between machine hours and the amount of indirect materials used. A member of the controller’s staff has suggested...
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. 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 suggested that a good starting...
The Troy store of Carlson Mart, a chain of small neighborhood convenience stores, has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Carlson Mart has three product categories: soft drinks (35% of cost of goods sold [COGS]), fresh snacks (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the Troy store, the cost drivers and their rates, and the cost-driver amount...
The Elmore store of Gabriel's Corner, a chain of small neighborhood convenience stores, has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Gabriel's Corner has three product categories: soft drinks (35% of cost of goods sold [COGS]), fresh snacks (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the Elmore store, the cost drivers and their rates, and the cost-driver amount...
Finch Computer Services, Inc. has been in business for six months. The following are basic operating data for that period Month July 114 Aug. Sept Oct. Nov. Dec. Service hours Revenue Operating costs 328 $6,270 $7,370 $14,190 $23,540 $17,600 $18,040 $4,260 $5,280 7,170 $11,170 9,150 $10,550 134 258 428 320 Required a. What is the average service revenue per hour in each month and the overall average for the six-month period? b. Use the high-low method to estimate the total...