Creating a Budget for a Company
Not what you're looking for?
Scenario: Four Flags is a retail department store. The following cost-volume relationships were used in developing a flexible budget for the company for the current year:
Yearly Fixed Expenses Variable Expenses per Sales Dollar
Cost of merchandise sold 0 $0.600
Selling and promotion of expenses $210,000 0.082
Building occupancy expenses 186,000 0.022
Buying expenses 150,000 0.040
Delivery expenses 111,000 0.010
Credit and collection expenses 72,000 0.002
Administrative expenses 531,000 0.003
Totals $1,260,000 $0.759
Management expected to attain a sales level of $12 million during the current year. At the end of the year, the actual results achieved by the company were as follows:
Net sales $10,500,000
Cost of goods sold 6,180,000
Selling and promotion expenses 1,020,000
Building occupancy expenses 420,000
Buying expenses 594,000
Delivery expenses 183,000
Credit and collection expenses 90,000
Administrative expenses 564,000
A) Prepare a schedule comparing the actual results with the flexible budget amounts developed for the actual sales volume of $10,500,000. Organize your schedule as a partial multiple-step income statement, ending with operating income. Include separate columns for (1) flexible budget amounts, (2) actual amounts and (3) any amount over (under) budget. Use the cost-volume relationships given in the problem to compute the flexible budget amounts.
B) Write a statement evaluating the company's performance in relation to the plan reflected in the flexible budget.
Purchase this Solution
Solution Summary
The expert creates a budget for a company.
Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance
These questions will test you on your knowledge of finance.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Introduction to Finance
This quiz test introductory finance topics.
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