Preparing a financial budget—budgeted income statement and balance sheet

Ballentine Company has the following post-closing trial balance on December 31, 2018:

The company’s accounting department has gathered the following budgeting information for the first quarter of 2019:

Budgeted total sales, all on account $ 305,500 Budgeted direct materials to be purchased and used 40,000 Budgeted direct labor cost 12,500 Budgeted manufacturing overhead costs: Variable manufacturing overhead 2,600 Depreciation 800 Insurance and property taxes 1,100 Budgeted cost of goods sold 71,300 Budgeted selling and administrative expenses: Salaries expense7,000 Rent expense 3,500 Insurance expense 2,000 Depreciation expense 350 Supplies expense 3,055 Budgeted cash receipts from customers 263,500 Budgeted income tax expense 44,000 Budgeted purchase and payment for capital expenditures

(additional equipment) 34,000

Additional information:

a. Direct materials purchases are paid 50% in the quarter purchased and 50% in the next quarter.

b. Direct labor, ma following budgeted income statement manufacturing overhead, selling and administrative costs, and income tax expense are paid in the quarter incurred.

c. Accounts payable at December 31, 2018 are paid in the first quarter of 2019. Requirements

1. Prepare Ballentine Company’s budgeted income statement for the first quarter of 2019.

2. Prepare Ballentine Company’s budgeted balance sheet as of March 31, 2019.

Short Answer

Expert verified
  1. The net income is $174,295.

2. The total of balance sheet is $349,945

Step by step solution

01

Preparation of Income statement

Ballentine Company

Income Statement

For the first quarter, 2019

First Quarter

Net sales revenue

$305,500

Cost of goods sold

$71,300

Gross profit

$234,200

Selling and administrative expenses

$15,905

Operating income

$218,295

Income tax

$44,000

Net income

$174,295

02

Preparation of Balance sheet

Ballentine Company

Budgeted Balance Sheet

As of March, 2019

Assets

Current Assets:

Cash

$184,945

Accounts Receivables

$59,900

Inventory

$11,600

Total current assets

$216,295

Property, plant, and equipment

Equipment

$154,000

Less: Accumulated depreciation

($20,350)

$133,650

Total Assets

$349,945

Liabilities

Current Liabilities:

Accounts payable

$37,300

Stockholder’s Equity

Common stock, no par

$85,000

Retained earnings

$267,795

Total stockholder’s equity

$352,795

Total liabilities and stockholder’s equity

$390,095

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Budgeting types Consider the following budgets and budget types.

Cash Cost of Goods Sold

Flexible Master

Operational Sales

Static Strategic

Which budget or budget type should be used to meet the following needs?

a. Upper management is planning for the next five years.

b. A store manager wants to plan for different levels of sales.

c. The accountant wants to determine if the company will have sufficient funds to pay expenses.

d. The CEO wants to make companywide plans for the next year.

Preparing an operating budget—production budget Bailey Company expects to sell 1,500 units of finished product in January and 1,750 units in February. The company has 180 units on hand on January 1 and desires to have an ending inventory equal to 80% of the next month’s sales. March sales are expected to be 1,820 units. Prepare Bailey’s production budget for January and February.

Question:Brooks Company expects to sell 8,500 units for \(175 each for a total of \)1,487,500 in January and 2,500 units for \(200 each for a total of \)500,000 in February. The company expects cost of goods sold to average 70% of sales revenue, and the company expects to sell 4,700 units in March for \(280 each. Brooks’s target ending inventory is \)20,000 plus 50% of the next month’s cost of goods sold. Prepare Brooks’s inventory, purchases, and cost of goods sold budget for January and February

How does the master budget for a merchandising company differ from a manufacturing company?

Using sensitivity analysis Caputo Company prepared the following budgeted income statement for the first quarter of 2018:

Caputo Company is considering two options. Option 1 is to increase advertising by \(1,100 per month. Option 2 is to use better-quality materials in the manufacturing process. The better materials will increase the cost of goods sold to 55% but will provide a better product at the same sales price. The marketing manager projects either option will result in sales increases of 25% per month rather than 20%.

Requirements

1. Prepare budgeted income statements for both options, assuming both options begin in January and January sales remain \)10,000. Round all calculations to the nearest dollar.

2. Which option should Caputo choose? Explain your reasoning.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free