PracticeExcelExam2

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

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

View Full Document Right Arrow Icon
State Tax Rate ID 5.50% MN 6.50% UT 6.25% Location Sale Amount Tax Rate Sales Tax Total Price ID $112.25 $- $112.25 UT $235.25 $- $235.25 MN $27.25 $- $27.25 MN $59.58 $- $59.58 UT $65.12 $- $65.12 ID $75.21 $- $75.21
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 Bob Tim
Background image of page 2
Feet to Intersection Action 100 150 140 200 90 110
Background image of page 3

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

View Full DocumentRight Arrow Icon
Principle $500,000.00 Interest 6.50% Term 360 Payment ($3,160.34)
Background image of page 4
Candy Bars Twix Milky Way Snickers Nut Roll # Produced 50 50 50 50 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 0 Caramel 1 1 1 1 Peanuts 0 0 1 1 Chocolate Used 150 2500 <----- Available Caramel Used 200 2500 <----- Available Peanuts Used 100 2000 <----- Available Profit $72.00
Background image of page 5

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

View Full DocumentRight Arrow Icon
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 Salt Lake City Sarah Normal 24
Background image of page 6
06-Sep-08 Provo Jeff Normal 2 06-Sep-08 Provo Matt Normal 28 06-Sep-08 Provo Matt Normal 28 06-Sep-08 Orem David Normal 13 06-Sep-08 Orem Jenny Normal 25 07-Sep-08 Salt Lake City Ray Normal 17 07-Sep-08 Provo Matt Normal 26 07-Sep-08 Orem
Background image of page 7

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

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

Page1 / 42

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

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

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