{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter6Solution - Excel Templates Chapter 6 Student Name...

Info icon This preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Templates Chapter 6 Student Name: <Type your name here> Class: <Type your class here>
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Exercise 6-05 Given Data: EZ RENTAL CAR Month January 2,310 $10,113 February 2,453 $12,691 March 2,641 $10,905 April 2,874 $12,949 May 3,540 $15,334 June 4,861 $21,455 July 5,432 $21,270 August 5,268 $19,930 September 4,628 $21,860 October 3,720 $18,383 November 2,106 $9,830 December 2,495 $11,081 Rental Returns Car Wash Costs
Image of page 2
<Type your name here> <Type your class here> Excel Templates Chapter 6 Exercise 6-05 Month (X) (Y) January 2,310 $10,113 February 2,453 12,691 March 2,641 10,905 April 2,874 12,949 May 3,540 15,334 June 4,861 21,455 July 5,432 21,270 August 5,268 19,930 September 4,628 21,860 October 3,720 18,383 November 2,106 9,830 December 2,495 11,081 (use Excel formulae; do not round your calculations) Intercept (fixed cost) = $2,296 Slope (variable cost per unit) = $3.74 Rental Returns Car Wash Costs
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Exercise 6-08 Given Data: ZERBEL COMPANY Month January 4 $2,200 February 7 $3,100 March 5 $2,600 April 2 $1,500 May 3 $2,200 June 6 $3,000 July 8 $3,600 Units Shipped Total Shipping Expense
Image of page 4
<Type your name here> <Type your class here> Excel Templates Chapter 6 Exercise 6-08 Part 1 Month (X) (Y) January 4 $2,200 February 7 3,100 March 5 2,600 April 2 1,500 May 3 2,200 June 6 3,000 July 8 3,600 Cost formula: (use Excel formulae; do not round your calculations) Shipping expense = $1,010.71 + $317.86 Units Shipped Part 2 Scattergraph method $300.00 $1,100.00 High-low method $350.00 $800.00 Least-squares regression method $317.86 $1,010.71 Units Shipped Total Shipping Expense Variable Cost per Unit Fixed Cost per Month
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Exercise 6-13 Given Data: VARIC COMPANY Week 1 8 $270 2 5 $200 3 10 $310 4 4 $190 5 6 $240 6 9 $290 Part 3 Production 7 units Units Produced Total Glazing Cost
Image of page 6
<Type your name here> <Type your class here> Excel Templates Chapter 6 Exercise 6-13 Part 1 Week (X) (Y) 1 8 $270 2 5 200 3 10 310 4 4 190 5 6 240 6 9 290 (use Excel formulae; do not round your calculations) Intercept (fixed cost) = $107.50 Slope (variable cost per unit) = $20.36 Part 2 Cost formula: Total glazing cost = $107.50 + $20.36 Units Glazed Part 3 Glazing cost for 7 units = $250.00 Units Produced Total Glazing Cost
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Problem 6-14 Given Data: HIGHLAND PARK Total Cost 5 $13,000 2 $7,000 4 $10,500 6 $14,000 3 $10,000 Part 3 Total leagues 7 Number of Leagues
Image of page 8
<Type your name here> <Type your class here> Excel Templates Chapter 6 Problem 6-14 Part 1 Total Cost (X) (Y) 5 $13,000 2 7,000 4 10,500 6 14,000 3 10,000 (use Excel formulae; do not round your calculations) Intercept (fixed cost per year) = $4,100.00 Slope (variable cost per league = $1,700.00 Part 2 Cost formula: Total program cost = $4,100.00 + $1,700.00 Leagues Part 3 Cost for 7 leagues = $16,000.00 Can you see any problem with using the cost formula from (2) above to derive this total cost figure? Part 4 Number of Leagues The problem with using the cost formula from (2) to estimate total cost in this particular case is that an activity level of 7 leagues may be outside the relevant range—the range of activity within which the fixed cost is approximately $4,100 per year and the variable cost is approximately $1,700 per league. These approximations appear to be reasonably accurate within the range of 2 to 6 leagues, but they may be invalid outside this range.
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern