Budgeting

3015760_wk4_1 x

See attached word doc. the company I would like to continue using is Walmart or Target.

Pringly Division

A meeting of senior managers at the Pringly Division has been called to discuss the pricing strategy for a new product. Part of the discussion will focus on estimating sales for the new product. Over the past years, a number of new products have failed to meet their sales targets. It appears that the company’s profit for the year will be lower than budget and the main reason for this is the disappointing sales of new products.

This time a range of possible sales targets – rather than only one goal – will be established and evaluated.

The first strategy is to set a selling price of $170 with annual fixed costs at $20,000,000. A number of managers are in favor of this strategy, as they believe it is important to reduce costs.

The second strategy is to increase spending on advertising and promotions and set a selling price of $200. With the higher selling price the annual fixed costs would increase to $25,000,000. The marketing department is adamant that increased emphasis on advertising and promotions is essential.

The table below shows three probable levels of customer demands. The likelihood of reaching a certain level is indicaated by the estimated probability. Note that it is not necessary to create a complex model based on probabilities. However, the probability distribution provides some guidance for the managers. Don’t forget that the company has certain minimum expectations of a new product.

Estimated demand (units)

Estimated probability (units) *

150,000

0.25

180,000

0.5

200,000

0.25

* Estimated proabilities are given to assist in making a final recommendation. These probabilities don’t have to be incorporated into a model, just considered in the final recommendation.

Additional information:

· The estimate of variable cost per unit is $35.

· The probability of the new product achieving break-even is very important. A profit greater than $4,000,000 is expected.

Required:

· Compute break-even at each level.

· Is the company likely to achieve its desired target profit of $4,000,000 or more? Support your discussion with financial analysis.

· Compute the margin of safety and explain the meaning of the number derived.

· Should the company go ahead with the new product?

· Would this type of analysis be useful to a large company with a wide range of products?

· ROI (return on investment) and residual income are two other methods that can be helpful for this type of decisions. Could they be applied in this situation? Support your answer with financial analysis.

HINT: Don’t forget to use the variable costing approach for your analysis

Pringly Division

A meeting of senior managers at the Pringly

Division has been called to discuss the pricing s
trategy for a new product. Part of the discussion will focus on estimating sales for the new p
roduct. Over the past years, a number of new products have failed to meet their sales targe
ts. It appears that t
he company’s profit for the year will be lower than budget and the main
reason for this is the disappointing sales of new products.

This time a range of possible sales targets
–

rather than only one goal
–

will be established a
nd evaluated.

The first stra
tegy is to set a selling price of $170 with annual fixed costs at $20,000,000. A
number of managers are in favor of this strategy, as they believe it is important to reduce c
osts.

The second strategy is to increase spending on advertising and promotions a
nd set a selling
price of $200. With the higher selling price the annual fixed costs would increase to $25,000
,000. The marketing department is adamant that increased emphasis on advertising and pro
motions is essential.

The table below shows three probable

levels of customer demands. The likelihood of reachin
g a certain level is indicaated by the estimated probability. Note that it is not necessary to c
reate a complex model based on probabilities. However, the probability distribution provides
some guidance

for the managers. Don’t forget that the company has certain minimum expe
ctations of a new product.

Estimated demand
(units)

Estimated probability
(units) *

150,000

0.25

180,000

0.5

200,000

0.25

* Estimated proabilities

are given to assist in making a final recommendation. These probabi
lities don’t have to be incorporated into a model, just considered in the final recommendatio
n.

Additional information:

·

The estimate of variable cost per unit is $35.

·

The probability of t
he new product achieving break
–
even is very important. A
profit greater than $4,000,000 is expected.

Required:

·

Compute break
–
even at each level.

·

Is the company likely to achieve its desired target profit of $4,000,000 or mor
e? Support your discussion
with financial analysis.

·

Compute the margin of safety and explain the meaning of the number derived
.

·

Should the company go ahead with the new product?

Pringly Division
A meeting of senior managers at the Pringly Division has been called to discuss the pricing s
trategy for a new product. Part of the discussion will focus on estimating sales for the new p
roduct. Over the past years, a number of new products have failed to meet their sales targe
ts. It appears that the company’s profit for the year will be lower than budget and the main
reason for this is the disappointing sales of new products.
This time a range of possible sales targets – rather than only one goal – will be established a
nd evaluated.
The first strategy is to set a selling price of $170 with annual fixed costs at $20,000,000. A
number of managers are in favor of this strategy, as they believe it is important to reduce c
osts.
The second strategy is to increase spending on advertising and promotions and set a selling
price of $200. With the higher selling price the annual fixed costs would increase to $25,000
,000. The marketing department is adamant that increased emphasis on advertising and pro
motions is essential.
The table below shows three probable levels of customer demands. The likelihood of reachin
g a certain level is indicaated by the estimated probability. Note that it is not necessary to c
reate a complex model based on probabilities. However, the probability distribution provides
some guidance for the managers. Don’t forget that the company has certain minimum expe
ctations of a new product.
Estimated demand
(units)
Estimated probability
(units) *
150,000 0.25
180,000 0.5
200,000 0.25
* Estimated proabilities are given to assist in making a final recommendation. These probabi
lities don’t have to be incorporated into a model, just considered in the final recommendatio
n.
Additional information:
 The estimate of variable cost per unit is $35.
 The probability of the new product achieving break-even is very important. A
profit greater than $4,000,000 is expected.
Required:
 Compute break-even at each level.
 Is the company likely to achieve its desired target profit of $4,000,000 or mor
e? Support your discussion with financial analysis.
 Compute the margin of safety and explain the meaning of the number derived
.
 Should the company go ahead with the new product?

Budgeting is an important internal activity. Preparing budgets involves forecasting sales and estimating costs. For this SLP, you will prepare a flexible budget for next year for the company of your choice. The budget needs to be realistic and based on corporate and economic trends.

Companies prepare budgets based on absorption and/or variable costing. Due to lack of information, we’re limiting our budgeting to the absorption approach. Don’t forget that the presentation of the information is important.

Set up the flexible budget showing three different growth rates. Use the financial statements and do research on the company of your choice to determine growth trends. Explain your estimates and prepare a flexible budget showing the low, the average, and the high revenues and adjust all other line items in the income statement to reflect the revised revenue assumptions.

· What is the growth rate in sales for the past three years?

· Are revenues and expenses growing at the same rate? What was the experience in the past few years?

· What is the current growth rate in the economy?

· How are the competitiors doing?

· Current interest rates and tax burdens.

Discuss the implications of the information after you have completed the flexible budget.

· How does the flexible budget differ from a static budget?

· Budgets are used for planning and control. Discuss how you can use the information derived for these two purposes?

· Comment on using this information for performance evaluations.

Modular SLP Assignment Expectations

Always include the name of the organization(s), time period covered and source of information. It is important to answer the questions as posed. The document should be written in a clear and concise manner. Don’t forget to include tables as required. Support your discussion or tables with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved. You can turn in the spreadsheet instead of the Word document. The content should be equivalent to the page length suggested for a word processing document.

Budgeting is an important internal activity. Preparing budgets involves forecasting sales and estimating
costs. For this SLP, you will prepare a flexible budget for next year for the company of your choice. The
budget needs to be realistic and based on cor
porate and economic trends.

Companies prepare budgets based on absorption and/or variable costing. Due to lack of information, we’re
limiting our budgeting to the absorption approach. Don’t forget that the presentation of the information is
important.

Set

up the flexible budget showing three different growth rates. Use the financial statements and do
research on the company of your choice to determine growth trends. Explain your estimates and prepare a
flexible budget showing the low, the average, and the
high revenues and adjust all other line items in the
income statement to reflect the revised revenue assumptions.

·

What is the growth rate in sales for the past three years?

·

Are revenues and expenses growing at the same rate? What was the experience in th
e past few
years?

·

What is the current growth rate in the economy?

·

How are the competitiors doing?

·

Current interest rates and tax burdens.

Discuss the implications of the information after you have completed the flexible budget.

·

How does the flexible bu
dget differ from a static budget?

·

Budgets are used for planning and control. Discuss how you can use the information derived
for these two purposes?

·

Comment on using this information for performance evaluations.

Modular SLP Assignment Expectations

Alway
s include the name of the organization(s), time period covered and source of information. It is
important to answer the questions as posed. The document
should be
written in a clear and concise manner.
Don’t forget to include tables as required. Support yo
ur discussion or tables with references in APA format.
You are encouraged to use Excel or other compatible spreadsheet when computations are involved. You can
turn in the spreadsheet instead of the Word document. The content should be equivalent to the pag
e length
suggested for a word processing document.

Budgeting is an important internal activity. Preparing budgets involves forecasting sales and estimating
costs. For this SLP, you will prepare a flexible budget for next year for the company of your choice. The
budget needs to be realistic and based on corporate and economic trends.
Companies prepare budgets based on absorption and/or variable costing. Due to lack of information, we’re
limiting our budgeting to the absorption approach. Don’t forget that the presentation of the information is
important.
Set up the flexible budget showing three different growth rates. Use the financial statements and do
research on the company of your choice to determine growth trends. Explain your estimates and prepare a
flexible budget showing the low, the average, and the high revenues and adjust all other line items in the
income statement to reflect the revised revenue assumptions.
 What is the growth rate in sales for the past three years?
 Are revenues and expenses growing at the same rate? What was the experience in the past few
years?
 What is the current growth rate in the economy?
 How are the competitiors doing?
 Current interest rates and tax burdens.
Discuss the implications of the information after you have completed the flexible budget.
 How does the flexible budget differ from a static budget?
 Budgets are used for planning and control. Discuss how you can use the information derived
for these two purposes?
 Comment on using this information for performance evaluations.
Modular SLP Assignment Expectations
Always include the name of the organization(s), time period covered and source of information. It is
important to answer the questions as posed. The document should be written in a clear and concise manner.
Don’t forget to include tables as required. Support your discussion or tables with references in APA format.
You are encouraged to use Excel or other compatible spreadsheet when computations are involved. You can
turn in the spreadsheet instead of the Word document. The content should be equivalent to the page length
suggested for a word processing document.