Question

In: Accounting

E5-14 Prepare a cash budget for two months. Rigley Company expects to have a cash balance...

E5-14 Prepare a cash budget for two months.
Rigley Company expects to have a cash balance of $46,000 on January 1, 2017.
These are the relevant monthly budget data for the first two months of 2017.
1. Collection from customers: January $71,000 and February $146,000.
2. Payments to suppliers: January $40,000, February $75,000.
3. Wages: January $30,000 and February $40,000. Wages are paid in the month
they are incurred.
4. Administrative expenses: January $21,000 and February $24,000. These costs
include depreciation of $1,000 per month. All other costs are paid as incurred.
5. Selling expenses: January $15,000 and February $20,000. These costs are exclusive
of depreciation. They are paid as incurred.
6. Sales of short-term investments in January are expected to realize $12,000 in
cash. Rigley has a line of credit at a local bank that enables it to borrow up
to $25,000. The company want to maintain a minimum monthly cash balance
of $20,000.
Instructions
Prepare a cash budget for January and February.
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .
RIGLEY COMPANY
Cash Budget
For the Two Months Ending February 28, 2017
January February
Beginning cash balance Value Value
Add: Cash receipts
Collections from customers Value Value
Sale of short-term investments Value Value
Total receipts ? ?
Total available cash ? ?
Less: Cash disbursements
Payments to suppliers Value Value
Wages Value Value
Administrative expenses Value Value
Selling expenses Value Value
Total disbursements ? ?
Excess (deficiency) of available cash over disbursements ? ?
Financing
Add: Borrowings Value Value
Less: Repayments Value Value
Ending cash balance ? ?
After you have completed E7-14, consider the following additional question
1. Assume that collection from customers and payment to suppliers in January changed to $80,000
and $55,000 respectively. Show the impact of these changes on the Cash Budget.

SOLVE FOR MISSING VALUES AND ANSWER QUESTION 1

Solutions

Expert Solution

Solution

Rigley Company

Cash budget for two months January and February:

Rigley Company

Cash Budget

for the two months - January and February

January

February

Beginning Cash balance

$46,000

$24,000

Add: Cash receipts

collections from customers

$71,000

$146,000

Sale of short term investments

$12,000

0

Total receipts

$83,000

$146,000

Available cash

$129,000

$174,000

Less: Disbursements:

Payment to suppliers

$40,000

$75,000

Wages

$30,000

40,000

Administrative expenses

$20,000

$23,000

selling and administrative expenses

$15,000

$20,000

Total disbursements

$105,000

$158,000

Excess/(deficiency) of available cash over disbursements

$24,000

$16,000

minimum balance

$20,000

$20,000

Financing -

Add: Borrowings

$4,000

Less: Repayments

Ending cash balance

$24,000

$20,000

Note:

  1. Depreciation is a non-cash expense hence the same is deducted from administrative expenses.
  2. The excess of available cash over disbursements in February is $16,000 however the minimum required cash balance is $20,000. Hence the company needs to borrow $4,000 from the bank to maintain the minimum cash balance.

Impact of changes in collections from customers and payment to suppliers in the month of January on Cash budget:

Rigley Company

Cash Budget

for the two months - January and February

January

February

Beginning Cash balance

$46,000

$20,000

Add: Cash receipts

collections from customers

$80,000

$146,000

Sale of short term investments

$12,000

0

Total receipts

$92,000

$146,000

Available cash

$138,000

$166,000

Less: Disbursements:

Payment to suppliers

$55,000

$75,000

Wages

$30,000

40,000

Administrative expenses

$20,000

$23,000

selling and administrative expenses

$15,000

$20,000

Total disbursements

$120,000

$158,000

Excess/(deficiency) of available cash over disbursements

$18,000

$8,000

minimum balance

$20,000

$20,000

Financing -

Add: Borrowings

$2,000

$12,000

Less: Repayments

Ending cash balance

$20,000

$20,000

Note:

  1. Depreciation is a non-cash expense hence the same is deducted from administrative expenses.
  2. The excess of available cash over disbursements in January is $18,000 and in February is $8,000. The minimum required cash balance is $20,000 per month hence the company borrows $2,000 and $12,000 from the bank to maintain the minimum balance of $20,000 in the months of January and February, respectively.

Related Solutions

text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...
text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $290,000 $310,000 $280,000 Cash disbursements 270,000 350,000 290,000 The expected cash balance at January 1, 2016, is $72,000. Brewster wants to maintain a cash balance at the end of each month of at least $70,000. Short-term borrowings at...
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...
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...
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...
E5-8 Prepare bank reconciliation and adjustments. The following information pertains to Lance Company. 1. Cash balance...
E5-8 Prepare bank reconciliation and adjustments. The following information pertains to Lance Company. 1. Cash balance per bank, July 31, $7,328. 2. July bank service charge not recorded by the depositor $38. 3. Cash balance per books, July 31, $7,364. 4. Deposits in transit, July 31, $2,700. 5. $2,016 collected for Lance Company in July by the bank through electronic funds transfer. The collection has not been recorded by Lance Company. 6. Outstanding checks, July 31, $686. Instructions (a) Prepare...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months ending 30 April 2018. The following sales figures are for the months of November 2017 to June 2018. The figures from January 2018 onward are estimated: Actual Sales for 2017 November...............60,000 December................64,000 Sales Forecast for 2018 January.............65,000 February............70,000 March...................72,500 April..................76,250 May.................80,000 June................78,750 50% of the sales are usually paid for in the month in which they occur, while the remaining sales are paid for...
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...
Use the following information to prepare a cash budget for December. The cash balance on December...
Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT