Appendix 3A) Jenson Manufacturing is developing cost formula for future planning and cost control. Utilities...

90.2K

Verified Solution

Question

Accounting

Appendix 3A) Jenson Manufacturing is developing cost formula for future planning and cost control. Utilities is one of the mixed costs associated with production. The cost analyst has suggested that units produced be used as the activity base to determine the fixed and variable costs and the cost formula for utility costs. The controller feels the most appropriate cost base is direct labour hours. Below is information collected over the past 8 months: Month Units Produced Direct Labour Hours Utilities Cost 1 1,100 500 $7,200 2 900 300 6,500 3 1,300 400 7,100 4 1,500 600 7,500 5 1,720 1,000 10,800 6 1,700 900 10,000 7 1,700 800 9,200 8 1,670 1,100 12,000

Required:

Use the least squares regression method to determine the cost formula for utilities cost assuming units produced is the independent variable. Calculate the R-squared. Use the same method to determine the cost formula and R-squared assuming direct labour hours is the independent variable. Use a spreadsheet or calculator to determine the slope and intercept. Do you recommend the company use units produced or direct labour hours as a cost base? Explain.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students