Purchase Solution

Market budget

Not what you're looking for?

Ask Custom Question

A fictional Products yearly income, Cost of Goods sold can be 250, but as I said it is a fictional product, so all of this is made up, so whatever fits in with the amounts given will satisfy the requirements.

---
Dr. Scholl's board of directors has determine the percentage of the budget that will go towards the marketing budget is $50,000.00 for Dr. Scholl's new product the Comfort Cuddler (orthopedic shoe).
1. Product: the development of the shoe will need itself which would be the Comfort Cuddler, part of the budget will need to go towards development of the shoe.
2. Place: Includes two things, the distribution of the product and the warehousing of the product.
3. Promotion: Promoting the product, advertising, media research to find out what media to advertise with. The target audience: would be the elderly, pregnant women and people with feet and joint problems, research to find out who your target audience is, so you know who your target audience are.
4. Monitor and Control: Using Competitive Intelligence and have a contingency plan.

The above factors or equally important, but promotion needs to go more in-depth to solve many of the complications of advertising and research, because of this the categorization of the budget are as follows.
25% goes to product and monitoring and controlling, 15% is used for placement because Dr. Scholl's is already an established company, they have distribution centers and warehouses for there previous products in existence. 35% is used for promotion and research of target audience, with the main portion of 30% going towards advertisements.
Product 25%
Monitoring and Controlling 25%
Placement (Distribution and Warehousing) 15%
Promotion (Advertising and Research) 35% (with the 30% for advertising alone)

I am completely stumped on how to put this in order, with the above and below information, I need an excel chart done on a yearly forecasting by month with production starting in April (basically a budget) of this companies new product, it has to include, the following information, the Production, Placement (distribution and factory overhead), Promotion (Advertising and Research), Monitoring and Controlling the information would need to inform the board of cost of goods, cost of goods sold, which is consider cash flows (inflows and outflows) Expenses, Revenue, Gross Margin, Net income and total expenses. Dr. Scholl's is allocating $50,000.00 for this venture, with a ten percent increase in sales every quarter.

TOTAL Dr. Scholl's cost $62.77
Dr.Scholl's net profit $4.55
Gross wholesale price $67.32
Retail cost and profit $52.68
Estimated Retail sales price $ 120.00
---

Purchase this Solution

Solution Summary

Excel file contains solution for market budget problem.

Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Motivation

This tests some key elements of major motivation theories.