Purchase Solution

Panera Bread Company: Flexible budget Three levels

Not what you're looking for?

Ask Custom Question

You will prepare a flexible budget for next year for the company of your choice (A bakery is my choice). The budget needs to be realistic and based on corporate and economic trends.

Set up the flexible budget at three levels for the income statement. Companies prepare budgets based on absorption and/or variable costing. Due to lack of information, we're limiting our budgeting to the absorption approach. You still need to estimate cost behavior based on trends.

Information to consider in determining the three levels.

What is the growth rate in sales for the past three 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.
What did you learn ; and
How can you use this information as a manger?

Modular SLP Expectations

Always include the name or the organization(s), time period covered and source of information. It is important to answer the questions as posed. The discussion should be two to four pages and written in a clear and concise manner. Support your discussion with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved.

Purchase this Solution

Solution Summary

Your tutorial is 714 words plus a flexible budget for Panera Bread Company in Excel (see attached, click in cells to see computations) for three levels of sales. The flexible budget is based on 2011 actual Panera results.

Solution Preview

PANERA BREAD COMPANY

I have created a flexible budget for PANERA BREAD COMPANY (attached in Excel) which shows three levels of flexible budget. That is, there are three levels of expected activity and the expenses and revenues are adjusted to conform to expectations given those levels of activity.
What is the growth rate in sales for the past three years?

Review of Panera's 2011 financial statement (annual report from www.panerabread.com) shows that sales were up by 20% in the most recent year. They have been the beneficiary of two large macro trends : desire for better nutritional choices and down-grading from expensive restaurants. By being high quality food and modest cost, they have stolen market share. I expect that this will probably continue as healthy trends continue and the economy grows too slow for diners to upgrade back to ritzy culinary options. So, I have assumed "low"? as 5% increase, middle as the current growth of 20% and high of 30% growth.

What is the current growth rate in the economy?

The current growth rate in the economy is closer to 2% and Panera is clearly exceeding the overall economy by orders of magnitude. The reason is that they are benefitting like McDonalds from people having to downgrade from ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Organizational Leadership Quiz

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

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.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking