Copy of PracticeExcelExam1

Copy of PracticeExcelExam1 - Month Store # State...

Info iconThis preview shows pages 1–6. 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 1563 1823 1 Los Angeles CA May 5 2543 2040 2 San Francisco CA May 3 2462 2305 3 Long Beach CA May 1 2877 2756 4 Seattle WA May 2 1835 2456 5 Tacoma WA May 6 1943 2043 6 Portland OR May 4 1573 1854 7 Oakland CA May 8 4893 4985 8 Anchorage AK June 4 1248 2103 June 6 2187 2350 June 5 2375 2135 June 2 1975 2078 Instances of California June 8 5167 5250 June 3 2375 2455 Total number of units i June 7 1852 2258 June 1 2681 2800 July 8 4953 4682 July 2 2045 2157 July 7 1458 1895 July 3 2278 1804 July 4 1678 1234 July 5 2675 2750 July 6 2244 2370 July 1 3078 3178 August 5 2756 2843 August 8 5486 5263 August 7 1687 1660 August 3 2489 2743 August 6 1875 1800 August 1 2975 2463 August 4 1709 1550 a in Seattle Loan Amount $100,000 Current Monthly Income $3,500 Term in Months 360 30% of Current Monthly Income $1,050 Interest Rate 6.50% Payment ($632) Assuming whole products only Mice Keyboard Joystick totals unit profit $8.00 $11.00 $9.00 $28,000.00 available labor per unit 0.2 0.3 0.24 740 <= 13000 machine time per unit 0.04 0.06 0.04 135 <= 3000 units made 1000 1000 1000 <= <= <= 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? 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...
View Full Document

This document was uploaded on 02/11/2011.

Page1 / 41

Copy of PracticeExcelExam1 - Month Store # State...

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

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