Question

In: Accounting

Exercise 9-14 (Video) Danner Company expects to have a cash balance of $48,600 on January 1,...

Exercise 9-14 (Video)

Danner Company expects to have a cash balance of $48,600 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows.

Collections from customers: January $91,800, February $162,000.
Payments for direct materials: January $54,000, February $81,000.
Direct labor: January $32,400, February $48,600. Wages are paid in the month they are incurred.
Manufacturing overhead: January $22,680, February $27,000. These costs include depreciation of $1,620 per month. All other overhead costs are paid as incurred.
Selling and administrative expenses: January $16,200, February $21,600. These costs are exclusive of depreciation. They are paid as incurred.


Sales of marketable securities in January are expected to realize $12,960 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $27,000. The company wants to maintain a minimum monthly cash balance of $21,600.

Prepare a cash budget for January and February.

Solutions

Expert Solution

Jan Feb
Opening Cash $          48,600 $          29,700
Add - Collections $          91,800 $        162,000
Sales of marketable securities $          12,960
Total Cash $        153,360 $        191,700
Less - Payments
Payments for direct materials $          54,000 $          81,000
Direct labor $          32,400 $          48,600
Manufacturing overhead $          21,060 $          25,380
Selling and administrative expenses $          16,200 $          21,600
Total Payments $        123,660 $        176,580
Net Cash $          29,700 $          15,120
Financing $                    -   $            6,480
Closing Cash $          29,700 $          21,600

Related Solutions

Exercise 9-14 (Video) Danner Company expects to have a cash balance of $45,000 on January 1,...
Exercise 9-14 (Video) Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other overhead costs are...
Exercise 7-14 Sheridan Company expects to have a cash balance of $57,950 on January 1, 2017....
Exercise 7-14 Sheridan Company expects to have a cash balance of $57,950 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1.Collections from customers: January $82,950, February $157,950. 2.Payments to suppliers: January $51,950, February $86,950. 3.Wages: January $31,790, February $41,790. Wages are paid in the month they are incurred. 4.Administrative expenses: January $22,790, February $25,790. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5.Selling...
Sandhill Company expects to have a cash balance of $69,000 on January 1, 2020. These are...
Sandhill Company expects to have a cash balance of $69,000 on January 1, 2020. These are the relevant monthly budget data for the first two months of 2020. 1. Collections from customers: January $106,500, February $219,000. 2. Payments to suppliers: January $60,000, February $112,500. 3. Wages: January $45,000, February $60,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $31,500, February $36,000. These costs include depreciation of $1,500 per month. All other costs are paid as...
Cullumber Company expects to have a cash balance of $32,200 on January 1, 2022. These are...
Cullumber Company expects to have a cash balance of $32,200 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $49,700, February $102,200. 2. Payments to suppliers: January $28,000, February $52,500. 3. Wages: January $21,000, February $28,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $14,700, February $16,800. These costs include depreciation of $700 per month. All other costs are paid as...
Blossom Company expects to have a cash balance of $23,000 on January 1, 2022. These are...
Blossom Company expects to have a cash balance of $23,000 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $35,500, February $73,000. 2. Payments to suppliers: January $20,000, February $37,500. 3. Wages: January $15,000, February $20,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $10,500, February $12,000. These costs include depreciation of $500 per month. All other costs are paid as...
Carla Vista Company expects to have a cash balance of $64,400 on January 1, 2022. These...
Carla Vista Company expects to have a cash balance of $64,400 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $99,400, February $204,400. 2. Payments to suppliers: January $56,000, February $105,000. 3. Wages: January $42,000, February $56,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $29,400, February $33,600. These costs include depreciation of $1,400 per month. All other costs are paid...
Martin Company expects to have a cash balance of $135,000 on January 1, 2017. Relevant monthly...
Martin Company expects to have a cash balance of $135,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows: Collections from customers: January $246,500, February $435,000. Payments for direct materials: January $155,000, February $240,000 Direct labor: January $90,000, February $135,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $63,000, February $75,000. These costs include depreciation of $5,000 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $45,900 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,900 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $86,700, February $153,000. Payments for direct materials: January $51,000, February $76,500. Direct labor: January $30,600, February $45,900. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,420, February $25,500. These costs include depreciation of $1,530 per month. All other overhead costs are paid as incurred....
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: ● Collections from customers: January $249,800, February $442,100. ● Payments for direct materials: January $156,600, February $246,700 ● Direct labor: January $91,700, February $136,600. Wages are paid in the month they are incurred. ● Manufacturing overhead: January $61,700, February $75,200. These costs include depreciation of $4,900 per month. All other overhead costs...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly...
Martin Company expects to have a cash balance of $135,100 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: ● Collections from customers: January $249,800, February $442,100. ● Payments for direct materials: January $156,600, February $246,700 ● Direct labor: January $91,700, February $136,600. Wages are paid in the month they are incurred. ● Manufacturing overhead: January $61,700, February $75,200. These costs include depreciation of $4,900 per month. All other overhead costs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT