{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CallSolverWithMacro

CallSolverWithMacro - Solver is a wonderful tool but one...

This preview shows pages 1–4. Sign up to view the full content.

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

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

View Full Document
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 Profit Margin 10% 12% 8% 13% 11% To return to the original worksheet: The changing cells values were 10,000 each quarter. Excel Solver Demo:  Forecast for 4 quarters Target Cell Constraints Changing Cells Solve for maximum Product Profit in Q1 Return model to original values.
a43dcb0c09c96499597ac8f49de1e42a87de2310.xls

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

CallSolverWithMacro - Solver is a wonderful tool but one...

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

View Full Document
Ask a homework question - tutors are online