Chapter6Solution - Excel Templates Chapter 6 Student Name:...

Info iconThis 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>
Background image of page 1

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

View Full DocumentRight 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
Background 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
Background image of page 3

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

View Full DocumentRight 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
Background 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
Background image of page 5

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

View Full DocumentRight 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
Background 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
Background image of page 7

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

View Full DocumentRight 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
Background 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
Background image of page 9

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

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

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 Right Arrow Icon
Ask a homework question - tutors are online