BURTON OFFICE SUPPLY Balance Sheet March 31, 2018 Assets Current Assets: Cash $ 32,000 Accounts Receivable 12,000 Merchandise Inventory 40,000 Prepaid Insurance 1,600 Total Current Assets $ 85,600 Property, Plant, and Equipment Equipment and Fixtures 40,000 Less: Accumulated Depreciation (12,000) 28,000 Total Assets $ 113,600 Liabilities Current Liabilities: Accounts Payable $ 16,000 Salaries and Commissions Payable 2,700 Total Liabilities $ 18,700 Stockholders' Equity Common Stock, no par 25,000 Retained Earnings 69,900 Total Stackholders' Equity 94,900 Total Liabilities and Stockholders' Equity $ 113,600

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Preparing an operating budget—sales budget; inventory, Purchases and COGS budget; and S&A expense budget

Burton Office Supply’s March 31, 2018, balance Sheet follows :

The budget committee of Burton Office Supply has assembled the following data:

  • Sales in April are expected to be $200,000. Burton Forecasts that monthly sales will increase 2% over April sales in May. June’s sales will increase by 4% over April sales. July sales will increase 20% over April sales.
  • Burton maintains inventory of $15,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of goods sold equal 50% of sales revenue.
  • Monthly salaries amount to $7,000. Sales commissions equal 5% of sales for that month.

Other monthly expenses are as follows:

• Rent: $2,000

Depreciation: $200

• Insurance: $100

• Income tax: $2,200

Requirements

  1. Prepare Burton’s sales budget for April and May 2018. Round all calculations to the nearest dollar.
  2. Prepare Burton’s inventory, purchases, and cost of goods sold budget for April and May.
  3. Prepare Burton’s selling and administrative expense budget for April and May.
  •  
  •  
BURTON OFFICE SUPPLY
Balance Sheet
March 31, 2018
Assets
Current Assets:
Cash
$ 32,000
Accounts Receivable
12,000
Merchandise Inventory
40,000
Prepaid Insurance
1,600
Total Current Assets
$ 85,600
Property, Plant, and Equipment
Equipment and Fixtures
40,000
Less: Accumulated Depreciation
(12,000)
28,000
Total Assets
$ 113,600
Liabilities
Current Liabilities:
Accounts Payable
$ 16,000
Salaries and Commissions Payable
2,700
Total Liabilities
$ 18,700
Stockholders' Equity
Common Stock, no par
25,000
Retained Earnings
69,900
Total Stackholders' Equity
94,900
Total Liabilities and Stockholders' Equity
$ 113,600
Transcribed Image Text:BURTON OFFICE SUPPLY Balance Sheet March 31, 2018 Assets Current Assets: Cash $ 32,000 Accounts Receivable 12,000 Merchandise Inventory 40,000 Prepaid Insurance 1,600 Total Current Assets $ 85,600 Property, Plant, and Equipment Equipment and Fixtures 40,000 Less: Accumulated Depreciation (12,000) 28,000 Total Assets $ 113,600 Liabilities Current Liabilities: Accounts Payable $ 16,000 Salaries and Commissions Payable 2,700 Total Liabilities $ 18,700 Stockholders' Equity Common Stock, no par 25,000 Retained Earnings 69,900 Total Stackholders' Equity 94,900 Total Liabilities and Stockholders' Equity $ 113,600
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education