{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

goal seek solver answers

# goal seek solver answers - totals unit profit \$ 8.00 \$...

This preview shows page 1. Sign up to view the full content.

Nicole Rabe Isys 201 Section 5 Goal Seek 1. 12.26% 2. 39.23%, so on the fourth day Solver 1. Our profit went from \$394.80 to \$487.59, but it cost \$500, which equals a net loss of \$407.21, so no, we would lose \$ 2. Units Made Demand Made Product Tech A Tech B Tech C Tech D 80 78 1 30 48 0 0 50 34.28571 2 0 0 0 34.28 571 50 50 3 20 0 30 0 Tech A makes 30 P1, 20 P3 Tech B makes 48 P1 Tech C makes 30 P3 Tech D makes 34 P2 which equals a total of 78 P1, 34 P2, and 50 P3 with a profit of \$1,208 for the month. 3. Mice Keyboard Joystick
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: totals unit profit \$ 8.00 \$ 11.00 \$ 9.00 \$488,866.6 7 avail able labor per unit 0.2 0.3 0.24 13000 <= 1300 machine time per unit 0.04 0.055 0.04 2389.33333 3 <= 3000 units made 15000 24533.33 11000 <= <= <= demand 15000 25000 11000 If 15000 mice, 24533 keyboards, and 11000 joysticks are made then it would maximize profits that month to about \$488,867 using all 13000 labor hours and about 2389 machine hours....
View Full Document

{[ snackBarMessage ]}