Login Registrieren

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

Chapter 22: Q56CT (page 1261)

Using Excel for to prepare an operating budeget (manufacturing company)
Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren.
Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information is presented on the Excel template.
Requirements
1. Prepare a Sales Budget.
2. Prepare a Production Budget.
3. Prepare a Direct Materials Budget.
4. Prepare a Direct Labor Budget.
5. Prepare a Manufacturing Overhead Budget.
6. Prepare a Cost of Goods Sold Budget
7. Prepare a Selling and Administrative Expense Budget.

Short Answer

Expert verified

The total projected manufacturing cost per unit is $32.69.

Step by step solution

01

Preparation of sales budget

02

Preparation of production budget

03

Preparation of direct materials budget

04

Preparation of direct labor budget

05

Preparation of manufacturing overhead budget

06

Preparation of cost of goods sold budget

07

Preparation of Selling and Administrative Expense Budget

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

Preparing a financial budget—cash budget

Wilson Company has \(11,000 in cash on hand on January 1 and has collected the following budget data:

January February Sales \) 1,400,000 \( 710,000 Cash receipts from customers 851,420 871,800 Cash payments for merchandise inventory 561,100 532,310

Assume Wilson has cash payments for selling and administrative expenses including salaries of \)55,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $8,500. Prepare a cash budget for January and February. Will Wilson need to borrow cash by the end of February?

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

Puckett Company has provided the following budget information for the first quarter of 2018:

Total sales \( 216,000

Budgeted purchases of direct materials 40,600

Budgeted direct labor cost 36,800 Budgeted manufacturing overhead costs:

Variable manufacturing overhead 1,025

Depreciation 1,000

Insurance and property taxes 6,650

Budgeted selling and administrative expenses:

Salaries expense 14,000

Rent expense 2,500

Insurance expense 2,000

Depreciation expense 350

Supplies expense 4,320

Additional data related to the first quarter of 2018 for Puckett Company:

a. Capital expenditures include \)41,000 for new manufacturing equipment to be purchased and paid in the first quarter.

b. Cash receipts are 75% of sales in the quarter of the sale and 25% in the quarter following the sale.

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

d. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.

e. Income tax expense for the first quarter is projected at \(49,000 and is paid in the quarter incurred.

f. Puckett Company expects to have adequate cash funds and does not anticipate borrowing in the first quarter.

g. The December 31, 2017, balance in Cash is \)25,000, in Accounts Receivable is \(21,600, and in Accounts Payable is \)16,500.

Requirements

1. Prepare Puckett Company’s schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018.

2. Prepare Puckett Company’s cash budget for the first quarter of 2018.

Preparing the financial budget—budgeted balance sheet

Barker, Inc. has the following balance sheet at December 31, 2018:

Barker projects the following transactions for 2019:

Sales on account, \(20,000

Cash receipts from customers from sales on account, \)17,600

Purchase of raw materials on account, \(7,000

Payments on account, \)3,500

Total cost of completed products, \(16,600, which includes the following:

Raw materials used, \)7,100

Direct labor costs incurred and paid, \(3,900

Manufacturing overhead costs incurred and paid, \)4,800

Depreciation on manufacturing equipment, \(800

Cost of goods sold, \)14,800

Selling and administrative costs incurred and paid, \(500

Purchase of equipment, paid in 2019, \)2,000

Prepare a budgeted balance sheet for Barker, Inc. for December 31, 2019. (Hint: It may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.)

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

Baxter Company’s budget committee provides the following information: December 31, 2017, account balances:

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 60% in the month of purchase and 40% in the month following the purchase.

3. Prepare the schedule of cash payments for selling and administrative expenses for January and February 2018. Assume 40% of the accrual for Salaries and Commissions Payable is for commissions and 60% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 30% in the month incurred and 70% 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 2018. Assume no financing took place.

: Completing a comprehensive budgeting problem—merchandising company

Belton Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for the month of April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows:

As Belton Printing’s controller, you have assembled the following additional information:

a. April dividends of \(7,000 were declared and paid.

b. April capital expenditures of \)17,000 budgeted for cash purchase of equipment.

c. April depreciation expense, \(800.

d. Cost of goods sold, 55% of sales.

e. Desired ending inventory for April is \)24,800.

f. April selling and administrative expenses includes salaries of \(29,000, 20% of which will be paid in cash and the remainder paid next month.

g. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April.

h. April budgeted sales, \)86,000, 80% collected in April and 20% in May.

i. April cash payments of March 31 liabilities incurred for March purchases of inventory, \(8,300.

j. April purchases of inventory, \)22,900 for cash and $37,200 on account. Half the credit purchases will be paid in April and half in May

Requirements

1. Prepare the sales budget for April.

2. Prepare the inventory, purchases, and cost of goods sold budget for April.

3. Prepare the selling and administrative expense budget for April.

4. Prepare the schedule of cash receipts from customers for April.

5. Prepare the schedule of cash payments for selling and administrative expenses for April.

6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance.

7. Prepare the budgeted income statement for April.

8. Prepare the budgeted balance sheet at April 30, 2018.

See all solutions

Recommended explanations on Business Studies Textbooks

Managers

Read Explanation

Human Resources

Read Explanation

Corporate Finance

Read Explanation

Operational Management

Read Explanation

Organizational Behavior

Read Explanation

Business Case Studies

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