A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.)

Respuesta :

Cost budgeting can be defined as a tool to estimate the costs or necessary efforts for projects, work packages or activities in project management

Calculation of missing data in 1st Quarter

Collections from customers = Total cash available - Cash balance beginning

= $71 - $6

= $65

Total disbursements = Total Cash available + Deficiency in cash

= $71 + $2

= $73

Selling and administrative expenses = Total disbursements - Purchase of inventory - Equipment Purchase - Dividends

= $73 - $35 - $8 - $2

= $28

Borrowings = $5 + Deficiency in cash

= $5 + $2

= $7

Calculation of missing data in 2nd Quarter

Deficiency in cash = Borrowings - Minimum cash balance

= $15 - $

= $10

Total Cash available = Total Disbursements - Deficiency in cash

= $85 - $10

= $75

Collections from customers = Total cash available - Cash balance beginning

= $75 - $5

= $70

Calculation of missing data in 3rd Quarter

Total Disbursement = Total Cash Available - Excess Cash

= $101 - $11

= $90

Purchase of inventory = Total disbursements  - Selling and administrative expenses - Equipment Purchase - Dividends

= $90 - $30 - $10 - $2

= $48

Repayments = Excess Cash - Minimum Cash

= $11 - $5

= $6

Calculation of missing data in 4th Quarter

Collection from customer = Total Collection - Collection of 1st, 2nd and 3rd Quarter

= $323 - $65 - $70 - $96

= $92

Selling and administrative expense = Total Selling and admin. expense - Selling and admin. expense of 1st, 2nd and 3rd Quarter

= $113 - $28 - $30 - $30

= $25

Equipment Purchase = Total Equipment Purchase - Equipment Purchase of 1st, 2nd and 3rd quarter

= $36 - $8 - $8 - $10

= $10

This is how we can explain the cost balance for four quarters.

To know more about Cash Balance from the given link

https://brainly.com/question/24940564

#SPJ4