HW1_11A_sol

HW1_11A_sol - Production Quantity Sales Price per Gallon...

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

View Full Document Right Arrow Icon
Rich Feldman Production Process Revenue 749.18 80  59,934  Material Per Product Purchased Unit cost Budget ChemA 4.0  2,996.704  3.12  9,350  ChemB 8  5,993.407  1.27  7,612  ChemC 2  1,498.352  2.05  3,072  Labor 1  749.176  40  29,967  Total Cost  50,000  Profit $9,934 Use Goal Seek to force Cell E10 (the "set cell") to equal 50000 by changing Cell B4
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Production Quantity Sales Price per Gallon Production Quantity: 749.2 Chem A: 2996.7 Chem B: 5993.4 Chem C: 1498.4 Profit: $9934 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20...
View Full Document

Ask a homework question - tutors are online