Purchase Solution

Pro-forma income statements under two ideas

Not what you're looking for?

Ask Custom Question

BYP5-6
Zoe and Tom opened of MallMart three years ago. For the first 2yrs business was good but the following condensed income statement results for 2007 were disappointing.

MallMart Department Store
Income Statement
For the Year Ended December 31, 2007

Net sales $700,000
Cost of goods sold 560,000
Gross profit 140,000

Operating expenses
Selling expenses $100,000
Administrative expenses 15,000
115,000

Net Income $25,000

Zoe believes the problem lies in the relatively low gross profit rate of 20%. Tom believes the problem is that operating expenses are too high. Zoe thinks the gross profit rate can be improved by making two changes:

(1) Increase average selling prices by 15%, this increase is expected to lower sales volumes so that total sales dollars will increase only 5%.
(2) Buy merchandise in larger quantities and take all purchase discounts; these changes are expected to increase the gross profit rate by 4%. Zoe does not anticipate that these changes will have any effect on operating expenses.

Tom thinks expenses can be cut by making these two changes:

(1) cut 2007 sales salaries of $60,000 in half and gives sales personnel a commission of 2% of net sales.
(2) Reduce store delivers to one day per week rather than twice a week; this change will reduce 2007 delivery expenses of $30,000 by 40%.

Tom feels that these changes will not have any effect on net sales.
Zoe and Tom come to you for help in deciding the best way to improve net income.

1. Prepare a condensed income statement for 2008 assuming (1) Zoe's changes are implemented and (2) Tom's ideas are adopted
2. What is your recommendation to Zoe and Tom?
3. Prepare a condensed income statement for 2008 assuming both sets of proposed changes are made.

Purchase this Solution

Solution Summary

This provides the steps to prepare pro-forma income statements under two ideas

Solution Preview

Current Condensed Income statement

MallMart Department Store
Income Statement
For the Year Ended December 31, 2007
Current GP margin
Net sales $700,000
Cost of goods sold 560,000
Gross profit 140,000 20.00%

Operating expenses
Selling expenses $100,000
Administrative expenses 15,000
115,000

Net Income $25,000

Income Statement as per Zoe's recommendations

MallMart Department Store
Income Statement
For the Year Ended December 31, 2007
Current GP margin
Net sales $764,750 ...

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Motivation

This tests some key elements of major motivation theories.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.