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.

Short Answer

Expert verified

Answer

The given overhead allocation rate is $ 5 / DLHr.

The calculations are shown below.

Step by step solution

01

Preparation of direct materials budget


Quarter 1

Quarter 2

Quarter 3

Quarter 4

Budgeted kits to be produced

650

500

450

600

Direct material (ounce)per kit

X 4

X 4

X 4

X 4

Direct material needed for production

2,600

2,000

1,800

2,400

Plus: Desired direct materials in ending inventory (Ounce)

200

180

240

200

Total direct materials needed

2,800

2,180

2,040

2,600

Less: Direct materials in beginning inventory (Ounce)

(850)

(200)

(180)

(240)

Budgeted purchases of direct materials

1,950

1,980

1,860

2,360

Direct materials cost per Ounce

X $1

X $1

X $1

X $1

Budgeted cost of direct materials purchases

$1,950

$1,980

$1,860

$2,360

02

Preparation of direct labor budget


Quarter 1

Quarter 2

Quarter 3

Quarter 4

Budgeted kits to be produced

650

500

450

600

Direct labor hours per kit

X 0.10

X 0.10

X 0.10

X 0.10

Direct labor hours needed for production

65

50

45

60

Direct labor cost per hour

X $10

X $10

X $10

X $10

Budgeted direct labor cost

$650

$500

$450

$600

03

Preparation of manufacturing overhead budget


Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Budgeted kits to be produced

650

500

450

600

2,200

VOH* cost per kit

X $0.20

X $0.20

X $0.20

X $0.20

X $0.20

Budgeted VOH

$130

$100

$90

$120

$440

Budgeted FOH

$165

$165

$165

$165

$660

Budgeted manufacturing overhead costs

$295

$265

$255

$285

$1,100

Direct labor hours

65

50

45

60

220

Predetermined overhead allocation rate ($1,100/220)





$5/DLHr

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

Using sensitivity analysis in budgeting Riverbed Sporting Goods Store has the following sales budget:

Suppose June sales are expected to be \(81,000 rather than \)65,000. Revise Riverbed’s sales budget.

Preparing an operating budget—sales budget

Yarbrough Company manufactures T-shirts printed with tourist destination logos. The following table shows sales prices and projected sales volume for the summer months:

Projected Sales in Units T-Shirt Sizes Sales Price June July August Youth $ 7 575 500 525 Adult—regular 17 625 900 825 Adult—oversized 18 400 500 475 Prepare a sales budget for Yarbrough Company for the three months.

Camp Company is a sporting goods store. The company sells a tent that sleeps six people. The store expects to sell 250 tents in 2018 and 280 tents in 2019. At the beginning of 2018, Camp Company has 25 tents in Merchandise Inventory and desires to have 5% of the next year’s sales available at the end of the year. How many tents will Camp Company need to purchase in 2018?

Preparing the financial budget—cash budget

Use the original schedule of cash receipts completed in Exercise E22-26, Requirement 1, and the schedule of cash payments completed in Exercise E22-27 to complete a cash budget for Marcel Company for January, February, and March.

Additional information: Marcel’s beginning cash balance is \(5,000, and Marcel desires to maintain a minimum ending cash balance of \)5,000. Marcel borrows cash as needed at the beginning of each month in increments of \(1,000 and repays the amounts borrowed in increments of \)1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.

Using sensitivity analysis in budgeting

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

60% in the month of the sale

20% in the month after the sale

18% two months after the sale

2% never collected

Prepare a revised schedule of cash receipts for January and February.

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