Purchase Solution

Microsoft Spreadsheet -Marketing Help on Computer Prediction

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.