Share
Explore BrainMass

Microsoft Spreadsheet -Marketing Help on Computer Prediction

Rules for Marketing.
Use the Marketing area to enter a Price, Promotional Budget, Sales Budget, and Sales Forecast for each product. Accounts Receivable (A/R) and Accounts Payable (A/P) finance decisions are also entered in the Marketing area.

Although the marketing area provides a Computer Prediction, this is a rough estimate so you must determine the true forecast and enter it in the Your Sales Forecast cell (see the Forecasting section). Also, you must ensure that product prices are within the range found in the Market Segment Analyses of The CapstoneĀ® Courier.

Remember, price ranges drop $0.50 per year, so the ranges for the upcoming year will be $0.50 less than those published in the Courier. When decisions are entered, the Marketing area computes Gross Revenues, Cost of Goods, and Contribution Margin.

Marketing decisions for a new product cannot be made until the product is available for sale.

Rules for Finance
Finance Your Finance Department is primarily concerned with five issues:

Acquiring the capital needed for company activities. Capital can be acquired through:
Current Debt
Stock Issues
Bond Issues (Long Term Debt)
Profits
Establishing a dividend policy that maximizes the return to shareholders.
Setting accounts payable and accounts receivable policies (which are entered on the Marketing spreadsheet).
Driving the financial structure of the firm, its relationship between debt and equity.
Selecting and monitoring performance measures that support your strategy.

Also: Change the areas in green (spreadsheet). This is a simulation exercise that I'm working on. I just need recommendations on what to change.

Attachments

Solution Preview

Rules for Marketing.
Use the Marketing area to enter a Price, Promotional Budget, Sales Budget, and Sales Forecast for each product. Accounts Receivable (A/R) and Accounts Payable (A/P) finance decisions are also entered in the Marketing area.

Although the marketing area provides a Computer Prediction, this is a rough estimate so you must determine the true forecast and enter it in the Your Sales Forecast cell ...

Solution Summary

Marketing Help on Computer Prediction. Step-by-Step instructions on Microsoft spreadsheet help i.e. color, format, and so on.

$2.19