PracticeExcelExam2KEY

PracticeExcelExam2KEY - State Tax Rate ID 5.50% MN 6.50% UT...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: State Tax Rate ID 5.50% MN 6.50% UT 6.25% Location Sale Amount Tax Rate Sales Tax Total Price ID $112.25 5.50% $6.17 $118.42 UT $235.25 6.25% $14.70 $249.95 MN $27.25 6.50% $1.77 $29.02 MN $59.58 6.50% $3.87 $63.45 UT $65.12 6.25% $4.07 $69.19 ID $75.21 5.50% $4.14 $79.35 Item Amount Salesperson Shoes $30.00 Jane Pajamas $30.00 Bob Toy $15.00 Tim Toy $50.00 Tim Snack $1.00 Jane Battery $2.00 Bob Toy $50.00 Jane Shoes $25.00 Jane Shoes $30.00 Tim Bicycle $100.00 Bob Pajamas $20.00 Tim Shoes $30.00 Jane Toy $5.00 Tim Battery $3.00 Jane Toy $1.00 Bob Shoes $15.00 Tim Salesperson # Trans Total Sales Jane 6 $139.00 Bob 4 $133.00 Tim 6 $135.00 Feet to Intersection Action 100 Speed Up 150 Stop 140 Speed Up 200 Stop 90 Keep Driving 110 Speed Up Principle $221,495.15 Interest 6.50% Term 360 Payment ($1,400.00) Set Cell D5 To Value $(1,400.00) By Changing D1 Candy Bars Twix Milky Way Snickers Nut Roll # Produced 700 900 700 200 Demand 700 900 1000 200 Price/Bar $0.60 $0.60 $0.60 $0.60 Cost/Bar $0.23 $0.17 $0.31 $0.25 Profit/Bar $0.37 $0.43 $0.29 $0.35 Chocolate 1 1 1 Caramel 1 1 1 1 Peanuts 1 1 Chocolate Used 2300 2500 <----- Available Caramel Used 2500 2500 <----- Available Peanuts Used 900 2000 <----- Available Profit $919.00 Date Location Sales Rep Sales Approach Customer ID 01-Sep-08 Salt Lake City Lynn Normal 17 01-Sep-08 Salt Lake City Lynn Normal 17 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Matt Normal 1 01-Sep-08 Orem Jenny Normal 2 01-Sep-08 Orem Sean Normal 3 02-Sep-08 Salt Lake City Sarah Normal 4 02-Sep-08 Salt Lake City Lynn Normal 5 02-Sep-08 Salt Lake City Lynn Normal 5 02-Sep-08 Salt Lake City Ray Normal 12 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Orem David Normal 8 02-Sep-08 Orem Jenny Normal 9 02-Sep-08 Orem Jenny Normal 9 02-Sep-08 Orem Sean Normal 10 03-Sep-08 Salt Lake City Sarah Normal 12 03-Sep-08 Salt Lake City Sarah Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Orem Jenny Normal 11 03-Sep-08 Orem Sean Normal 12 04-Sep-08 Salt Lake City Lynn Normal 17 04-Sep-08 Salt Lake City Lynn Normal 17 04-Sep-08 Salt Lake City Ray Normal 13 04-Sep-08 Provo Jeff Normal 14 04-Sep-08 Provo Jeff Normal 14 04-Sep-08 Provo Matt Normal 15 04-Sep-08 Provo Matt Normal 15 04-Sep-08 Provo Phil Normal 16 04-Sep-08 Orem David Normal 18 04-Sep-08 Orem Jenny Normal 18 04-Sep-08 Orem Sean Normal 3 05-Sep-08 Salt Lake City Sarah Normal 28 05-Sep-08 Salt Lake City Ray Normal 19 05-Sep-08 Provo Jeff Normal 20 05-Sep-08 Provo Phil Normal 21 05-Sep-08 Provo Phil Normal 21 05-Sep-08 Orem David Normal 22 05-Sep-08 Orem Sean Normal 23 06-Sep-08 Salt Lake City Sarah Normal 24 06-Sep-08...
View Full Document

This document was uploaded on 02/11/2011.

Page1 / 47

PracticeExcelExam2KEY - State Tax Rate ID 5.50% MN 6.50% UT...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online