Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Someone help me with this question, prefarbely using excel solver. I am not sure what the question is asking Case: Delhi Foods Manisha Patel recently

image text in transcribed

image text in transcribed

Someone help me with this question, prefarbely using excel solver. I am not sure what the question is asking

Case: Delhi Foods Manisha Patel recently completed her first week of work as a summer intern at Delhi Foods. Earlier this morning, Manisha's boss, the director of marketing, asked her to come up with a recommendation on the level of marketing expenses (advertising and promotion expenditures) for a line of frozen Indian dinners as it enters its seventh year in the marketplace. Exhibit 8.1 which Manisha received from her boss, contains an accounting summary of essential product costs and revenues in the first 6 y imentation with marketing policies. For year 7, the table shows projections for the coming year ears, during which there has been some trial-and-error exper EXHIBIT 8.1 Summary of Product Costs and Revenues ear Demand (cartons) 3,200 3,400 3,500 3,600 3,800 4,400 4,700 Revenue S(000) 62,000 63,000 66,000 75,000 86,000 98,000 105,000 Production Materials Other variables Fixed Marketing Advertising 27,000 29,000 30,000 35,000 39.000 33,000 35,000 1,700 2.2002,800 3.5002,400 10,800 ,600 500 4,700 4,900 5,000 5,300 5,600 5,900 10,300 11.700 15,000 16,200 17,800 22,000 24,000 9,000 6,000 4,000 11,000 12,000 13,000 14,000 6,000 6,000 5,000 5,000 5,000 5,000 6,000 Operating margin3,500 3,400 4,300 (700) 4,500 8,600 8,500 based on a continuation of last year's policy. This includes a new high of $38,000 in marketing expense, but Manisha's boss intimated that this might be excessive. Late last week, Manisha read an internal marketing study that had been completed at Delhi Foods. The study concluded that it is possible to represent the influence of marketing expenses on demand by means of the equation D = aM" where D and M represent demand and marketing expenses, respectively, and where a is called the scale factor and b the elasticity of marketing expenses. Manisha knows from courses she has taken that this model belongs to a family of demand equations commonly used in market analysis. To determine values for the parameters a and b that apply to this product, she will have to match this model to the observations as closely as possible. Manisha ponders the information in the table. Costs for the coming year appear to be known; therefore, variable costs have already been estimated. Overhead and fixed production costs do not appear to be variable costs, so they don't enter into a calculation of gross margin. Instead, the gross margin is based on revenue, materials costs, and other variable costs. Using the projected figures for the coming year, Manisha expects that she will be able to compute the gross margin per unit. From there, Manisha believes she can represent profit for the line of dinners by using the gross margin per unit along with an estimate of demand to predict this year's gross margin. Then she can subtract marketing expenses and fixed costs to arrive at a profit figure. She sees that marketing expenses show up in her profit calculation, but they also affect her demand estimate. If she can sort out all the relationships in a spreadsheet model, Manisha believes that she can find the optimal level to spend on marketing

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

3. Provide advice on how to help a plateaued employee.

Answered: 1 week ago