Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Huber Company has provided the following budget information for the first quarter of 2018: (Click the icon to view the budget information.) Additional data related
Huber Company has provided the following budget information for the first quarter of 2018: (Click the icon to view the budget information.) Additional data related to the first quarter of 2018 for Huber Company: (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Huber Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018. Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018. More Info - X Cash Receipts from Customers First Quarter i Data Table 2018 Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2017 211,000 40,900 a. Capital expenditures include $39,000 for new manufacturing equipment to be purchased and paid in the first quarter b. Cash receipts are 85% of sales in the quarter of the sale and 15% in the quarter following the sale. c. Direct materials purchases are paid 70% in the quarter purchased and 30% 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 $43,000 and is paid in the quarter incurred. f. Huber 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 $10,000, in Accounts Receivable is $15,500, and in Accounts Payable is $11,600. 36,600 1st Qtr.Sales Total cash receipts from customers Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing overhead costs: Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses: Salaries expense Rent expense Insurance expense Depreciation expense 1,125 600 6,750 Accounts Receivable balance, March 31, 2018: 1st Qtr.-Sales, collected in 2nd Qtr. Print Done 9,000 5,000 1,800 250 10.550 Requirements - X Supplies expense Print Done 1. Prepare Huber Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018. 2. Prepare Huber Company's cash budget for the first quarter of 2018. Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started