Aaron Corporation is projecting a cash balance of $31,076 in its December 31, 2013, balance sheet. Aaron's schedule of expected collections from customers for the first quarter of 2014 shows total collections of $180,326. The schedule of expected payments for direct materials for the first quarter of 2014 shows total payments of $40,898.
Other information gathered for the first quarter of 2014 is sale of equipment $3,218, direct labor $69,511, manufacturing overhead $35,470, selling and administrative expenses $44,510 and purchase of securities $12,047. Aaron wants to maintain a balance of at least $24,942 cash at the end of each quarter.
Prepare a cash budget for the first quarter.
Cash Budget | |
Particulars | Quarter 1 |
Beginning cash balance | 31,076 |
Cash receipts | |
Cash collections from credit sales | 1,80,326 |
Sale of Equipment | 3,218 |
Total cash available(A) | 2,14,620 |
Cash disbursements | |
Direct Material | 40,898 |
Direct Labor | 69,511 |
Manufacturing Overhead | 35,470 |
Selling and administrative expenses | 44,510 |
Purchase of Secuirity | 12,047 |
Total Cash Payable(B) | 2,02,436 |
Cash balance(A-B) | 12,184 |
Minimum balance | 24,942 |
Loan Raised | 12,758 |
Deitz Corporation is projecting a cash balance of $37,500 in its December 31, 2019, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2020 shows total collections of $231,250. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $53,750. Other information gathered for the first quarter of 2020 is sale of equipment $3,750; direct labor $87,500, manufacturing overhead $43,750, selling and administrative expenses $56,250; and purchase of...
Deitz Corporation is projecting a cash balance of $35,400 in its December 31, 2019, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2020 shows total collections of $218,300. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $50,740. Other information gathered for the first quarter of 2020 is sale of equipment $3,540; direct labor $82,600, manufacturing overhead $41,300, selling and administrative expenses $53,100; and purchase...
Concord Corporation is projecting a cash balance of $30,360 in its December 31, 2016, balance sheet. Concord’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $187,220. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,516. Other information gathered for the first quarter of 2017 is sale of equipment $3,036; direct labor $70,840, manufacturing overhead $35,420, selling and administrative expenses $45,540; and purchase...
Exercise 23-15 Deitz Corporation is projecting a cash balance of $ 33,150 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $ 204,425 . The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $ 47,515 . Other information gathered for the first quarter of 2017 is sale of equipment $ 3,315; direct labor $ 77,350, manufacturing...
Oriole Corporation is projecting a cash balance of $34.800 in its December 31, 2019, balance sheet. Oriole's schedule of expected collections from customer for the first quarter of 2020 shows total collections of $214,600. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $49,880. Other information gathered for the first quarter of 2020 is sale of equipment $3,480, direct labor $81,200, manufacturing overhead $40,600, selling and administrative expenses $52.200; and purchase...
Exercise 13-15 Blue Corporation is projecting a cash balance of $38,460 in its December 31, 2016, balance sheet. Blue's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $237,170. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $55,126. Other information gathered for the first quarter of 2017 is sale of equipment $3,846; direct labor $89,740, manufacturing overhead $44,870, selling and administrative expenses $57,690;...
Deitz Corporation is projecting a cash balance of $ 37,830 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections frarn customers for the first quarter of 2017 shows total callections af $233,285. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $ 54,223. Other information gathered for the first quarter of 2017 is sale of equipment s 3,783 ; direct labor $ aa, 270, manufacturing overhead $ 44,135,...
haney company has provided the following budget information for the first quarter of 2018: Haney Company has provided the following budget information for the first quarter of 2018 (Click the loon to view the budget information.) Additional data related to the first quarter of 2018 for Haney Company (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Haney Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018...
Exercise 21-15 Deitz Corporation is projecting a cash balance of $36,960 in its December 31, 2016, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $227,920. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $52,976. Other information gathered for the first quarter of 2017 is sale of equipment $3,696; direct labor $86,240, manufacturing overhead $43,120, selling and administrative expenses $55,440;...
Danner Company expects to have a cash balance of $58,050 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $109,650, February $193,500. Payments for direct materials: January $64,500, February $96,750. Direct labor: January $38,700, February $58,050. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,090, February $32,250. These costs include depreciation of $1,935 per month. All other overhead costs are paid as incurred....