/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q44PGB Preparing a financial budget—b... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Preparing a financial budget—budgeted income statement and balance sheet Ball 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 $ 121,800 Budgeted purchases of merchandise inventory, all on account 60,400 Budgeted cost of goods sold 60,900 Budgeted selling and administrative expenses:

Commissions expense 6,090 Salaries expense 7,000 Rent expense 4,100 Depreciation expense 600 Insurance expense 400 Budgeted cash receipts from customers 125,840 Budgeted cash payments for merchandise inventory 67,775 Budgeted cash payments for salaries and commissions 14,822 Budgeted income tax expense 5,400 Additional information: Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount.

Requirements

  1. Prepare a budgeted income statement for the quarter ended March 31, 2019.
  2. 2. Prepare a budgeted balance sheet as of March 31, 2019.

Short Answer

Expert verified
  1. The net income is $37,310.
  2. The total of balance sheet is $146,235

Step by step solution

01

Preparation of Income statement

Ball Company

Income Statement

For the quarter ended March 31, 2019

March Quarter

Net sales revenue

$121,800

Cost of goods sold

$60,900

Gross profit

$60,900

Selling and administrative expenses

$18,190

Operating income

$42,710

Income tax

$5,400

Net income

$37,310

02

Preparation of Balance sheet

Ball Company

Budgeted Balance Sheet

For the quarter ended March 31, 2019

Assets

Current Assets:

Cash

$56,743

Accounts Receivables

$27,960

Raw material inventory

$12,132

Total current assets

Property, plant, and equipment

Equipment

$60,000

Less: Accumulated depreciation

($10,600)

$49,400

Total Assets

$146,235

Liabilities

Current Liabilities:

Accounts payable

$16,625

Stockholder’s Equity

Common stock, no par

$18,000

Retained earnings

$111,610

Total stockholder’s equity

$129,610

Total liabilities and stockholder’s equity

$146,235

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 91Ó°ÊÓ!

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

Preparing a financial budget—schedule of cash receipts and schedule of cash payments

Agua Cool is a distributor of bottled water. For each of the items, compute the amount of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item.

a. Management expects to sell equipment that cost \(14,000 at a gain of \)7,000. Accumulated depreciation on this equipment is \(5,000.

b. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for \)14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month.

c. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one-half of commissions and other selling expenses in the month incurred, with the balance paid the following month.

Preparing an operating budget—cost of goods sold budget Butler Company expects to sell 1,650 units in January and 1,550 units in February. The company expects to incur the following product costs:

Direct materials cost per unit \( 85

Direct labor cost per unit 60

Manufacturing overhead cost per unit 55

The beginning balance in Finished Goods Inventory is 250 units at \)200 each for a total of $50,000. Butler uses FIFO inventory costing method. Prepare the cost of goods sold budget for Butler for January and February.

Preparing a financial budget—schedule of cash payments

Marcel Company has the following projected costs for manufacturing and selling and administrative expenses:

January February March Direct materials purchases \( 3,100 \) 3,500 $ 4,800 Direct labor costs 3,300 3,500 3,600 Depreciation on plant 550 550 550 Utilities for plant 650 650 650 Property taxes on plant 200 200 200 Depreciation on office 550 550 550 Utilities for office 250 250 250 Property taxes on office 170 170 170 Office salaries 3,500 3,500 3,500

All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1. Prepare a schedule of cash payments for Marcel for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31.

Preparing an operating budget—cost of goods sold budget

Refer to the budgets prepared in Exercise E22-24. Determine the cost per kit to manufacture the model airplane kits. Grady projects sales of 100, 150, 100, and 200 kits for the next four quarters. Prepare a cost of goods sold budget for the year. Grady has no kits in beginning inventory. Round amounts to two decimal places.

How is benchmarking beneficial?

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.