CallSolverWithMacro

CallSolverWithMacro - OnCallingSolverFromaMacro Solver is a...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
On Calling Solver From a Macro can't be called from an Excel macro without some setup work in advance. The worksheets in this workbook are: Solver Demo - Exposition See Solver work under macro control. Solver's Solution An archive workbook with Solver's solution to the problem recorded. Call Solver from VBA A description of how to set up Solver as an "available reference" to VBA. Solver is a wonderful tool but one that
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
a43dcb0c09c96499597ac8f49de1e42a87de2310.xls Page 2 Product Price: $40.00 Product Cost: $25.00 Q1 Q2 Q3 Q4 Total Seasonality 0.9 1.1 0.8 1.2 Units Sold 3,592 4,390 3,192 4,789 15,962 Sales Revenue $143,662 $175,587 $127,700 $191,549 $638,498 Cost of Sales 89,789 109,742 79,812 119,718 399,061 Gross Margin 53,873 65,845 47,887 71,831 239,437 Salesforce 8,000 8,000 9,000 9,000 34,000 Advertising 10,000 10,000 10,000 10,000 40,000 Overhead 21,549 26,338 19,155 28,732 95,775 Total Costs 39,549 44,338 38,155 47,732 169,775 Product Profit $14,324 $21,507 $9,732 $24,099 $69,662
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 4

CallSolverWithMacro - OnCallingSolverFromaMacro Solver is a...

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

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