Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Irwin Company has provided the following budget information for the first quarter of 2018: Total sales $208,000 Budgeted purchases of direct materials 41,000 Budgeted direct

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

Total sales

$208,000

Budgeted purchases of direct materials

41,000

Budgeted direct labor cost

37,300

Budgeted manufacturing overhead costs:

Variable manufacturing overhead

1,000

Depreciation

600

Insurance and property taxes

6,900

Budgeted selling and administrative expenses:

Salaries expense

4,000

Rent expense

3,500

Insurance expense

1,800

Depreciation expense

250

Supplies expense

6,240

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

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

b. Cash receipts are 65% of sales in the quarter of the sale and 35% in the quarter following the sale.

c. Direct materials purchases are paid 60% in the quarter purchased and 40% 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 $42,000 and is paid in the quarter incurred.

f. Irwin 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 $40,000, in Accounts Receivable is $25,400, and in Accounts Payable is $12,500.

Requirements:

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

2. Prepare Irwin Company's cash budget for the first quarter of 2018.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AML Auditing Understanding Foreign Exchange What Every AML KYC Auditor Should Know

Authors: Bob Walsh

1st Edition

1539576248, 978-1539576242

More Books

Students also viewed these Accounting questions

Question

Interact with others without being asked what country you are from?

Answered: 1 week ago

Question

What lessons in OD contracting does this case represent?

Answered: 1 week ago

Question

Does the code suggest how long data is kept and who has access?

Answered: 1 week ago