Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

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.

Short Answer

Expert verified

The budgeted cost of goods sold is $380,000 and $310,000 for January and February respectively.

Step by step solution

01

Meaning of cost of goods sold budget

A budget that estimates the cost of goods sold of projected sales is known as the cost of goods sold budget.

02

Preparation of cost of goods sold budget for January and February

Particulars

January

February

Beginning inventory, 200 units

$50,000

Tablets produced and sold in 2021 @ $200 each (1,650 and 1,550 units is January and February)

$330,000

$310,000

Total Budgeted Cost of Goods Sold

$380,000

$310,000

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

Preparing an operating budget—direct materials, direct labor, and manufacturing overhead budgets

Grady, Inc. manufactures model airplane kits and projects production at 650, 500, 450, and 600 kits for the next four quarters. Direct materials are 4 ounces of plastic per kit and the plastic costs \(1 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 850 ounces, and the company desires to end each quarter with 10% of the materials needed for the next quarter’s production. Grady desires a balance of 200 ounces in Raw Materials Inventory at the end of the fourth quarter. Each kit requires 0.10 hours of direct labor at an average cost of \)10 per hour. Manufacturing overhead is allocated using direct labor hours as the allocation base. Variable overhead is \(0.20 per kit, and fixed overhead is \)165 per quarter. Prepare Grady’s direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number.

Using sensitivity analysis in budgeting

Refer to the Victors schedule of cash receipts from customers that you prepared in Short Exercise S22-15. Now assume that Victors’s sales are collected as follows:

40% in the month of the sale

20% in the month after the sale

39% two months after the sale

1% never collected

Prepare a revised schedule of cash receipts for January and February

In a manufacturing company, what are the three types of budgets included in the master budget? Describe each type.

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—sales budget; inventory, purchases and COGS budget; and S&A expense budget Ballard Office Supply’s March 31, 2018, balance sheet follows:

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

a. Sales in April are expected to be \(160,000. Ballard 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. Ballard maintains inventory of \)7,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 \(3,000. Sales commissions equal 5% of sales for that month.

d. Other monthly expenses are as follows: • Rent: \)3,400 • Depreciation: \(800 • Insurance: \)300 • Income tax: $1,500

Requirements

1. Prepare Ballard’s sales budget for April and May 2018. Round all calculations to the nearest dollar.

2. Prepare Ballard’s inventory, purchases, and cost of goods sold budget for April and May.

3. Prepare Ballard’s selling and administrative expense budget for April and May.

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