goal seek solver answers

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

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

View Full Document Right Arrow Icon
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
Background image of page 1
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

Ask a homework question - tutors are online