Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Berlin Inc. has just received its sales and expense report for January, which follows. Item Amount Sales commissions $200,000 Sales staff salaries 50,000 Telephone and

Berlin Inc. has just received its sales and expense report for January, which follows.

Item Amount

Sales commissions $200,000

Sales staff salaries 50,000

Telephone and mailing 20,000

Building lease payment 30,000

Heat, light, and water 5,000

Packaging and delivery 30,000

Depreciation 20,000

Marketing consultants 25,000

Sales 600,000

You have been asked to develop budgeted costs for the coming year. Since this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data:

* Sales volume is expected to increase by 10 percent.

* Sales prices are expected to increase by 8 percent.

* Commissions are based on a percentage of selling price.

* Sales staff salaries will increase 8 percent next year regardless of sales volume.

* Building rent is based on a five-year lease that expires in three years.

* Telephone and mailing costs are scheduled to increase by 6 percent even with no change in sales volume. However, these costs are variable with the number of units sold, as are packaging and delivery costs.

* Heat, light, and water are scheduled to increase by 10 percent regardless of sales volume.

* Depreciation includes furniture and fixtures used by the sales staff. No additions or retirements are expected.

* Marketing consultant expenses were for a special advertising campaign that runs from time to time. During the coming year, the costs are expected to average $35,000 per month.

Required:

Prepare Berlins pro-forma operating statement for a typical month in the coming year.

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

IFRS edition volume 2

978-0470613474, 470613475, 978-0470616314

More Books

Students also viewed these Accounting questions

Question

why random selection is an important component of a sampling plan.

Answered: 1 week ago

Question

Relational Contexts in Organizations

Answered: 1 week ago