Chapter6Solution

Chapter6Solution - Excel Templates Chapter 6 Student Name...

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

Excel Templates Chapter 6 Student Name: <Type your name here> Class: <Type your class here>

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

View Full Document
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
<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

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

View Full Document
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
<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

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

View Full Document
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
<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

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

View Full Document
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
<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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/19/2010 for the course ACCOUNTING 341 taught by Professor Ken during the Spring '10 term at University of Guelph - Humber.

Page1 / 28

Chapter6Solution - Excel Templates Chapter 6 Student Name...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online