Copy of PracticeExcelExam1Key

Copy of PracticeExcelExam1Key - Month Store # State...

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: Month Store # State UnitsReceived UnitsOrdered Comments Store # City State May 7 CA 1563 1823 Insufficient 1 Los Angeles CA May 5 WA 2543 2040 Excess 2 San Francisco CA May 3 CA 2462 2305 OK 3 Long Beach CA May 1 CA 2877 2756 OK 4 Seattle WA May 2 CA 1835 2456 Insufficient 5 Tacoma WA May 6 OR 1943 2043 OK 6 Portland OR May 4 WA 1573 1854 Insufficient 7 Oakland CA May 8 AK 4893 4985 OK 8 Anchorage AK June 4 WA 1248 2103 Insufficient June 6 OR 2187 2350 OK June 5 WA 2375 2135 Excess June 2 CA 1975 2078 OK 15 Instances of California June 8 AK 5167 5250 OK June 3 CA 2375 2455 OK 6208 Total number of units i June 7 CA 1852 2258 Insufficient June 1 CA 2681 2800 OK July 8 AK 4953 4682 Excess July 2 CA 2045 2157 OK July 7 CA 1458 1895 Insufficient July 3 CA 2278 1804 Excess July 4 WA 1678 1234 Excess July 5 WA 2675 2750 OK July 6 OR 2244 2370 OK July 1 CA 3078 3178 OK August 5 WA 2756 2843 OK August 8 AK 5486 5263 Excess August 7 CA 1687 1660 OK August 3 CA 2489 2743 Insufficient August 6 OR 1875 1800 OK August 1 CA 2975 2463 Excess August 4 WA 1709 1550 OK a in Seattle Loan Amount $166,121 Current Monthly Income $3,500 Term in Months 360 30% of Current Monthly Income $1,050 Interest Rate 6.50% Payment ($1,050) Set cell: B4 To value:-1050 By changing cell: B1 Assuming whole products only Mice Keyboard Joystick totals unit profit $8.00 $11.00 $9.00 $488,863.00 labor per unit 0.2 0.3 0.24 12999.9 <= machine time per unit 0.04 0.06 0.04 2389.32 <= units made 15000 24533 11000 <= <= <= demand 15000 25000 11000 A computer manufacturing plant produces mice, keyboards, and video game joysticks. Each month, a total of 13,000 labor hours and 3,000 hours of machine time are available. How can the manufacturer maximize its monthly profit contribution from the plant? available 13000 3000 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...
View Full Document

Page1 / 50

Copy of PracticeExcelExam1Key - Month Store # State...

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