Question

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 monReq 1A Req 1B Req ЗА Req 3B Req 4 What is the variable utility cost per hour of operation? Variable cost per hourReq 1A Req 1B Req ЗА Req 3B Req 4 Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regresWhat is the variable utility cost per hour of operation? (Do not round intermediate calculations. Round the intercept to theDuring July, the store will be open 300 hours. Predict the stores total utility cost for July using each of the cost-estimat

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Gator Beach
High Low method
Variable cost= (Highest activity cost- Lowest activity cost)/ (Highest activity units- Lowest activity units)
Answer 1 Month Hours of operation Utility costs
Highest activity March                        800.00                  3,900.00
Lowest activity June                        300.00                  1,900.00
Change                        500.00                  2,000.00
Amount $
Variable cost per hour                       4.00
Fixed cost: Highest activity cost- (Highest units * Variable cost per unit)
Fixed cost: 3900-(800*4)
Fixed cost                  700.00
Answer 1 a
Y= 700+ 4.x
Answer 1 b
Variable cost per hour = $ 4.
Answer 4 Amount $
Hours in July                  300.00
Variable cost per hour                       4.00
Variable cost               1,200.00
Fixed cost                  700.00
Total cost               1,900.00
Answer 3 a
Regression method
The equation of a line is y=mx+b
X= Hours
y=total cost
m= (N Σ(xy) − Σx Σy)/ (N Σ(x2) − (Σx)2)
Month Hours (x) Costs (y) x2 xy
January                  450.00                     2,520.00              202,500.00    1,134,000.00
February                  600.00                     3,100.00              360,000.00    1,860,000.00
March                  800.00                     3,900.00              640,000.00    3,120,000.00
April                  400.00                     2,400.00              160,000.00       960,000.00
May                  350.00                     2,050.00              122,500.00       717,500.00
June                  300.00                     1,900.00                90,000.00       570,000.00
Total               2,900.00                  15,870.00          1,575,000.00 8,361,500.00
N= number of months= 6.
m= (N Σ(xy) − Σx Σy)
(N Σ(x2) − (Σx)2)
m= 6*8361500- 2900*15870
6*1575000- 2900^2
m= 50169000- 46023000
9450000-8410000
m=       4,146,000.00
      1,040,000.00
m=                       3.99
b= (Σy − m Σx)/N
b= 15870- 3.99*2900
                      6.00
b= 15870- 11571
                      6.00
b=               4,299.00
                      6.00
b=                  717.00
So fixed cost per month is $ 717.
Answer 3 b
Variable cost per hour is $ 3.99.
Answer 4 Amount $
Hours in July                  300.00
Variable cost per hour                       3.99
Variable cost               1,197.00
Fixed cost                  717.00
Total cost               1,914.00
Final Answer 4 Amount $
High Low method               1,900.00
Regression method               1,914.00
Add a comment
Know the answer?
Add Answer to:
Hi please answer asap Thank you ! Gator Beach Marts, a chain of convenience grocery stores...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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.    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...

  • 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...

  • Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach...

    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...

    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...

  • please answer these questions! thank you! Problem 10A-8 Applying Overhead; Overhead Variances (LO10-3, LO10-4) Lane Company...

    please answer these questions! thank you! Problem 10A-8 Applying Overhead; Overhead Variances (LO10-3, LO10-4) Lane Company manufactures a single product that requires a great deal of hand labor. Overhead cost is applied on the basis of standard direct labor-hours. The budgeted variable manufacturing overhead is $5.60 per direct labor-hour and the budgeted fixed manufacturing overhead is $2.880,000 per year. The standard quantity of materials is 4 pounds per unit and the standard cost is $12,00 per pound. The standard direct...

  • I AM LOST THIS CHAPTER PLEASE HELP ASAP Lane Company manufactures a single product and applies...

    I AM LOST THIS CHAPTER PLEASE HELP ASAP Lane Company manufactures a single product and applies overhead cost to that product using standard direct labor-hours. The budgeted variable manufacturing overhead is $4.20 per direct labor-hour and the budgeted fixed manufacturing overhead is $1,599,000 per year. The standard quantity of materials is 4 pounds per unit and the standard cost is $8.50 per pound. The standard direct labor-hours per unit is 1.5 hours and the standard labor rate is $13.10 per...

  • Required information [The following information applies to the questions displayed below.] The controller of Chittenango Chain...

    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...

  • Please answer asap thank you WMEJ is an independent television station run by a major state...

    Please answer asap thank you WMEJ is an independent television station run by a major state university. The station's broadcast hours vary during the year depending on whether the university is in session. The station's production-crew and supervisory costs are as follows for July and September Cost Behavior Variable Cost Amount Broadcast Hours during Month $5,060 Cost Item Production crew July September Supervisory employees July September 7,705 440 670 Fixed 5,600 440 670 5,600 Required: 1. Compute the cost per...

  • please answer soon High Desert Potteryworks makes a variety of pottery products that it sells to...

    please answer soon High Desert Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which departmental predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Molding Department is based on machine-hours, and the rate in the Painting Department is based on direct labor hours. At the beginning of the year, the company provided the following estimates: Direct Labor-hours Department Molding...

  • please answer the required 1-4, thank you. Check my work Lane Company manufactures a single product and applies...

    please answer the required 1-4, thank you. Check my work Lane Company manufactures a single product and applies overhead cost to that product using standard direct labor-hours. The budgeted variable manufacturing overhead is $4.60 per direct labor-hour and the budgeted fixed manufacturing overhead is $1,935,000 per year. The standard quantity of materials is 4 pounds per unit and the standard cost is $9.50 per pound. The standard direct labor-hours per unit is 1.5 hours and the standard labor rate is...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT