PracticeExcelExam2

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

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.
  • Spring '09
  • Salt Lake City, Salt Lake City Salt Lake City Provo Provo Provo Provo Orem Orem Salt Lake City Salt Lake City Salt Lake City Salt Lake City Provo Provo Provo Provo Provo Provo Provo Orem Orem Orem Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake C, Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Salt L, Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake Cit, Salt Lake City Provo Orem Salt Lake City Salt Lake City Salt Lake City Provo Provo Provo Provo Provo Orem Orem Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City, Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake

Page1 / 42

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

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