Answered

Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

Danner Company expects to have a cash balance of $52,965 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $100,045, February $176,550. Payments for direct materials: January $58,850, February $88,275. Direct labor: January $35,310, February $52,965. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,717, February $29,425. These costs include depreciation of $1,765 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,655, February $23,540. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $14,124 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $29,425. The company wants to maintain a minimum monthly cash balance of $23,540.
Prepare a cash budget for January and February.

Sagot :

anthougo

Answer:

Danner Company

Cash Budget for January and February

                                                       January       February

Beginning balance                        $52,965       $32,367

Collections from customers          100,045       176,550

Sales of marketable securities         14,124

Cash available                               $167,134    $208,917

Payments:

Direct materials                             $58,850     $88,275

Direct labor                                       35,310       52,965

Manufacturing overhead                22,952       27,660

Selling & administrative expenses  17,655       23,540

Total payments                            $134,767    $192,440

Cash balance                                $32,367      $16,477

Required minimum balance          23,540       23,540

Excess (Needed) Financing          $8,827       ($7,063)

Explanation:

a) Data and Calculations:

Expected January 1, 2017 Cash Balance = $52,965

                                                      January       February

Collections from customers        $100,045     $176,550

Sales of marketable securities         14,124

Payments:

Direct materials                             $58,850      $88,275

Direct labor                                       35,310        52,965

Manufacturing overhead                22,952        27,660

Selling & administrative expenses  17,655        23,540

Line of credit limit = $29,425

Required minimum cash balance = $23,540

We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Get the answers you need at Westonci.ca. Stay informed with our latest expert advice.