Estimate possible sales quantities and the program

Assignment Help Marketing Management

Reference no: EM131921960

Question: Break-Even/Profit Analysis This problem lets you see the dynamics of break-even analysis. The starring values (costs, revenues, etc.) for this problem arc from the break-even analysis example in Setting in the Business World." of the 11th edition of Basic Marketing The first column computes a break-even point. You can change ants and prices to figure new break-even points (in units and dollars). The second column goes further. There you can specify target profit level, and the unit and dollar sales needed to achieve your target profit level will be computed. You can also estimate possible sales quantities and the program will compute costs, tales, and profits. Use this spreadsheet to answer the following questions.

a. Vary the selling price between $1.00 and $1.40. Prepare a table showing how the break-even point (in units and dollats) changes at the different price levels

b. If you hope to earn a target profit of $25,000, how many units would you have to sell? What would total cost be? Total sales dollars! (Note: Use the right-hand ("profit analysis") column in the spreadsheet.)

c. Using the "profit analysis" column (column 2), allow your estimate of the sales quantity to vary between 70,000 and 90,000. Prepare a table that shows, for each quantity level, what happens to total cost, average cost per unit, and profit. Explain why average cost changes as it does over the different quantity values.

Reference no: EM131921960

Questions Cloud

Determine new price per can based on present pricing method : Moor Company is having a profitable year. Its only product sells to wholesalers for 80 cents a can. Its managers feel that a 60 percent gross margin should be.

Random distribution function to add to simulation : One component is customers per hour, which the franchiser estimates at 25. Which is the best random distribution function to add to your simulation?

Define the divergence and control reversal speeds : Given a flexible wing. Define the divergence and control reversal speeds. Are these related to each other? Equations are not necessary, but may be used

How does a prestige pricing policy fit into a marketing mix : How does a prestige pricing policy fit into a marketing mix? Would exclusive distribution be necessary? Cite a local example of odd-even pricing and evaluate.

Estimate possible sales quantities and the program : Break-Even/Profit Analysis This problem lets you see the dynamics of break-even analysis. The starring values (costs, revenues, etc.) for this problem arc.

Simulate five days of operation of the proposed systems : Develop a spreadsheet simulation to compare the performance of the proposed automated process with the performance of the manual existing process

Create narratives based on the excel area chartto discuss : Create narratives based on the Excel Area Chartto discuss the interpret the historical trend in increase/decrease of population per continent.

What is the takt time of the process : A process makes two products, A and B, and operates 5 days per week, 8 hours per day. demand for the two prducts for the next week is as follows.

Identify the strategy decisions marketing manager must make : Identify the strategy decisions a marketing man-ager must make in the Price area. Illustrate your answer for a local retailer.

User Account

All Pages