Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 22: 4SE (page 1229)

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.

Short Answer

Expert verified

The budgeted units to be produced for January and February is 2,720 and 1,806 respectively.

Step by step solution

01

Meaning of sales budget

A budget that is prepared to estimate the sales revenue figure is known as a sales budget.

02

Preparation of sales budget for January and February

Particulars

January

February

Budgeted units to be sold

1,500

1,750

Plus: Desired tablets in ending inventory

1,400

1,456

Total units needed

2,900

3,206

Less: Units in beginning inventory

(180)

(1,400)

Total units to be produced

2,720

1,806

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.

Start your free trial

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

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: a. 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. b. 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. c. Monthly salaries amount to \(7,000. Sales commissions equal 5% of sales for that month. d. 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.

Preparing a financial budget—budgeted balance sheet

Use the following June actual ending balances and July 31, 2018, budgeted amounts for Omas to prepare a budgeted balance sheet for July 31, 2018.

a. June 30 Merchandise Inventory balance, \(17,770

b. July purchase of Merchandise Inventory, \)4,400, paid in cash

c. July payments of Accounts Payable, \(8,400

d. June 30 Accounts Payable balance, \)10,700

e. June 30 Furniture and Fixtures balance, \(34,100; Accumulated Depreciation balance, \)29,880

f. June 30 total stockholders’ equity balance, \(28,020

g. July Depreciation Expense, \)500

h. Cost of Goods Sold, 60% of sales

i. Other July expenses, including income tax, \(2,000, paid in cash

j. June 30 Cash balance, \)11,600

k. July budgeted sales, all on account, \(12,600

l. June 30 Accounts Receivable balance, \)5,130

m. July cash receipts from collections on account, $14,700

(Hint: It may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.)

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

Beasley Company’s budget committee provides the following information:

December 31, 2017, account balances:

Cash \( 32,000 Accounts Receivable 19,000 Merchandise Inventory 16,000 Accounts Payable 15,000 Salaries and Commissions Payable 2,900 Budgeted amounts for 2018:

January February Sales, all on account \) 84,000 $ 84,400 Purchases, all on account 41,000 41,600 Commissions Expense 4,200 4,220 Salaries Expense 5,000 5,000 Rent Expense 2,200 2,200 Depreciation Expense 500 500 Insurance Expense 200 200 Income Tax Expense 1,900 1,900

Requirements

1. Prepare the schedule of cash receipts from customers for January and February 2018. Assume cash receipts are 80% in the month of the sale and 20% in the month following the sale.

2. Prepare the schedule of cash payments for purchases for January and February 2018. Assume purchases are paid 70% in the month of purchase and 30% in the month following the purchase.

3. Prepare the schedule of cash payments for selling and administrative expense for January and February 2018. Assume 25% of the accrual for Salaries and Commissions Payable is for commissions and 75% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 70% in the month incurred and 30% in the following month. Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount.

4. Prepare the cash budget for January and February. Assume no financing took place.

Understanding the components of the master budgetThe following are some of the components included in the master budget of amerchandising company.

a. Budgeted balance sheet

b. Sales budget

c. Capital expenditures budget

d. Budgeted income statement

e. Cash budget

f. Inventory, purchases, and cost of goods sold budget

g. Selling and administrative expense budget

List the items of the master budget in order of preparation.

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.
See all solutions

Recommended explanations on Business Studies Textbooks

Strategic Analysis

Read Explanation

Organizational Behavior

Read Explanation

Introduction to Business

Read Explanation

Business Case Studies

Read Explanation

Business Operations

Read Explanation

Financial Performance

Read Explanation
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