Explore BrainMass

Explore BrainMass

    Microsoft Spreadsheet -Marketing Help on Computer Prediction

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:28 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/microsoft-spreadsheet-marketing-help-on-computer-prediction-233264

    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

    ADVERTISEMENT