Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The budget committee of Berg Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income statements for May

The budget committee of Berg Office Supply has assembled the following data. As the

business manager, you must prepare the budgeted income statements for May and June 2011.

Sales in April were $50,000. You forecast that monthly sales will increase 2.0% in May and 2.4% in June.

Clipboard maintains inventory of $9,000 plus 25% of the sales revenue budgeted for the following month. Monthly purchases average 50% of sales revenue in that same month. Actual inventory on April 30 is $13,000. Sales budgeted for July are $65,000.

Monthly salaries amount to $3,000. Sales commissions equal 4% of sales for that month. Combine salaries and commissions into a single figure.

Other Monthly expenses are:

Rent Expense $2,600, paid as incurred

Depreciation expense $300

Insurance expense $200, expiration of prepaid amount

Income Tax 20% of operating income

Requirement

1.

Prepare Berg's budgeted income statements for May and June. Show cost of goods sold

computations.

Requirement 1

Before completing the budgeted income statements, calculate the budgeted cost of goods

sold for May and June using the inventory, purchases, and cost of goods sold budget form.

May

June

Beginning inventory

+ Purchases

= Goods available for sale

- Ending inventory

= Cost of goods sold

Now complete the budgeted income statements for May and June.

Berg Office Supply

Budgeted Income Statements

May and June 2011

May

June

Sales revenue

Cost of goods sold

Gross profit

Operating expenses:

Salaries & commission expense

Rent expense

Depreciation expense

Insurance expense

Operating income

Income tax expense

Net income

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_2

Step: 3

blur-text-image_3

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

Beyond Compliance Design Of A Quality System Tools And Templates For Integrating Auditing Perspectives

Authors: Janet Bautista Smith, Robert Alvarez

1st Edition

1951058232, 978-1951058234

More Books

Students also viewed these Accounting questions

Question

Explain the main differences between CPT and SP/A.

Answered: 1 week ago

Question

Design a job advertisement.

Answered: 1 week ago