MANAGERIAL ACCOUNTING
17th Edition
ISBN: 9781264151455
Author: Garrison
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 11E
EXERCISE 8-11
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.
Quarter
| 1 | 2 | 3 | 4 | Year | |
| Cash balance, beginning | $ 6 | $ ? | $ ? | $ ? | $ ? |
| Add collections from customers | ? | ? |
96 |
? |
323 |
| — | — | ||||
| Total cash available | 71 | ? |
? |
? |
? |
| Less disbursements: | |||||
| Purchase of inventory | 35 | 45 | ? | 35 | ? |
| Selling and administrative expenses | 7 | 30 | 30 | ? | 113 |
| Equipment purchases | 8 | 8 | 10 | ? | 36 |
| Dividends | 2 | 2 | 2 | 2 | ? |
| — | — | — | |||
| Total disbursements | ? | 85 |
? |
? |
? |
| Excess (deficiency) of cash available | |||||
| over disbursements | (2) | ? |
11 |
? |
? |
| Financing: | |||||
| Borrowings | ? | 15 | - | — | ? |
| Repayments (including Interest)* | ____-_ | - | (?) | (17) | (?) |
| Total financing | ? | ? | ? | _? | ? |
| Cash balance, ending | ... $ ? | $ ? |
$ ? |
$ ? |
$ ? |
'Interest will total $ 1,000 (or the year.
Required:
Fill in the missing amounts in the above table.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Exercise 7 (Cash Budget Analysis)
A cash budget, by quarters, is given below for a retail company. (000 omitted).
The company requires a minimum cash balance of P5,000 to start each quarter.
Quarter
1
2
3
4
Year
Cashbalance,beginning..
P9
P ?
P ?
P?
P?
Add collectionsfromcustomers....
?
?
125
?
391
Totalcash available...
85
?
?
Less disbursements:
Purchaseofinventory.
40
58
?
32
Operatingexpenses.
42
54
?
180
Equipmentpurchases..
10
8
8
36
Dividends...
2
2
2
2
?
Totaldisbursement..
110
?
?
?
Excess (deficiency) of cash available
Ordisbursements....
(3)
30
?
?
Financing:
Borrowings..
?
20
Repayments (including interest)*..
(?)
(7)
(?)
Total financing...
?
?
(?)
(?)
Cash balance, ending....
P ?
P ?
P ?
P ?
P?
*Interest will total P4, 000 for the year.
Required:
Fill in the missing amounts in the table above.
Exercise 7 (Cash Budget Analysis)
A cash budget, by quarters, is given below for a retail company. (000 omitted).
The company requires a minimum cash balance of P5,000 to start each quarter.
Quarter
1 2 3 4 Year
Cash balance, beginning..................... P9 P? P? P? P?
Add collections from customers….. ? ? 125 ? 391
Total cash available………………. 85 ? ? ? ?
Less disbursements:
Purchase of inventory….................. 40 58 ? 32 ?
Operating expenses…………... ? 42 54 ? 180
Equipment purchases…................ 10 8 8 ? 36
Dividends…………………….. 2 2 2 2 ?
Total disbursement………………..…
Problem 5
Prepare a cash budget by month for the month quarter ending September 30, 2009,
from the following data obtained from the Peninsula Co. Support your solution with
schedules of estimated receipts & payments.
August
P 16,000
150,000
120,000
18,000
2,000
July
P 12,000
110.000
90,000
Operating Expenses 15,000
September
P 18,000
120,000
110,000
16,000
Cash sales
Credit sales
Purchases
Interest expense
Credit are collected 50% in the month of sales. 40% in the month following, 8% in the
second month following and 2% uncollectible. Credit sales for May and June are
expected to be P100,000 and P90,000 respectively. Purchases of merchandise, all
on account are paid 60% in the month of purchase and 40% in the month fallowing.
Purchase for June are estimated at 80,000 are paid in the month incurred. Cash
balance on June 30, 2009 is P27,000.
Chapter 8 Solutions
MANAGERIAL ACCOUNTING
Ch. 8 - Prob. 1QCh. 8 - Prob. 2QCh. 8 - Prob. 3QCh. 8 - 8-4 What is a master budget? Briefly describe its...Ch. 8 - 8—5 Why is the sales forecast the starting point...Ch. 8 - Prob. 6QCh. 8 - 8-7 Why is it a good idea to create a ‘"Budgeting...Ch. 8 - 8-8 What is a self-imposed budget? What are the...Ch. 8 - Prob. 9QCh. 8 - Prob. 10Q
Ch. 8 -
The Excel worksheet form that appears below is to...Ch. 8 - Prob. 2AECh. 8 - Prob. 1F15Ch. 8 - Prob. 2F15Ch. 8 - Prob. 3F15Ch. 8 - Prob. 4F15Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Prob. 11F15Ch. 8 - Prob. 12F15Ch. 8 - Prob. 13F15Ch. 8 - Prob. 14F15Ch. 8 - Prob. 15F15Ch. 8 - EXERCISE 8-1 Schedule of Expected Cash Collections...Ch. 8 - Prob. 2ECh. 8 - EXERCISE 8-3 Direct Materials Budget LOW Three...Ch. 8 - Prob. 4ECh. 8 -
EXERCISE 8-5 Manufacturing Overhead Budget...Ch. 8 -
...Ch. 8 -
The company's beginning cash balance for the...Ch. 8 - EXERCISE 8-8 Budgeted Income Statement LO8-9 Gig...Ch. 8 - EXERCISE 8-9 Budgeted Balance Sheet LO8-10 The...Ch. 8 -
EXERCISE 8-10 Production and Direct Materials...Ch. 8 - EXERCISE 8-11 Cash Budget Analysis LOB-8 A cash...Ch. 8 - Prob. 12ECh. 8 - Prob. 13ECh. 8 -
EXERCISE 8-14 Sales and Production Budgets LO8-2,...Ch. 8 - Prob. 15ECh. 8 - Prob. 16ECh. 8 - Prob. 17ECh. 8 - Prob. 18ECh. 8 - PROBLEM 8-19 Cash Budget: Income Statement:...Ch. 8 -
PROBLEM 8-20 Cash Budget; Income Statement;...Ch. 8 - Prob. 21PCh. 8 -
PROBLEM 8-22 Evaluating a Company’s Budget...Ch. 8 - PROBLEM 8—23 schedule or Expected cash...Ch. 8 - PROBLEM 8-24 Cash Budget with Supporting Schedules...Ch. 8 - PROBLEM B-25 Cash Budget with Supporting...Ch. 8 - PROBLEM 8-26 Behavioral Aspects of Budgeting:...Ch. 8 - (
$
55,000
$ 55, 000
...Ch. 8 -
PROBLEM 8-28 Cash Budget with Supporting...Ch. 8 - PROBLEM 8-29 Completing a Master Budget LO8-2,...Ch. 8 - PROBLEM 8-30 Integration of the Sales, Production,...Ch. 8 - Prob. 31PCh. 8 -
CASE 8-32 Evaluatinga Company’s Budget Procedures...Ch. 8 - CASE 8-33 Master Budget with Supporting Schedules...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?arrow_forwardQUESTION 4: CASH BUDGET JL is preparing its cash budget for the next three quarters of the 2019 financial year. The following data have been extracted from the operating budgets: Quarter 1 Quarter 2 Quarter 3 R R R Sales revenue 500 000 450 000 480 000 Direct material purchases 138 000 151 200 115 600 Additional information: a) JL sells 20% of its goods for cash. It is estimated that 70% of all credit sales is received within the quarter in which the sales are made; and 30% of all credit sales is received in the following quarter. It is estimated that trade receivables will be R125 000 at the start of Quarter 1. No credit loss is anticipated. b) All direct material purchases are made on credit. It is estimated that 50% of all direct material purchases are paid in the quarter of purchase; the remaining 50% is paid in the quarter following the quarter of purchase. It is estimated that the amount owning for direct material purchases will be R60 000 at the beginning of Quarter 1. c) JL…arrow_forward-/1 Question 11 View Policies Current Attempt in Progress A company's past experience indicates that 60% of its credit sales are collected in the month of sale, 30% in the next month, and 5% in the second month after the sale; the remainder is never collected. Budgeted credit sales were: ort $310000 January 166000 February 490000 March The cash inflow in the month of March is expected to be O $294000. O $359300 O $240300. O $343800. hp ho l t 44 12 Su prt sc delete home enc & 7 backspace lock T Y P home K enter 4 M N Iarrow_forward
- Question Content Area Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,280,000 Quarter 3 5,700,000 Quarter 4 8,420,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,280,000 and for the fourth quarter of the current year are $7,620,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 43aa7d03501507c_1 $fill…arrow_forwardExercise 1 (Schedule of expected Cash Collection) Peak sales for Mideast Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below: July August September Total Budgeted sales ................ P600,000 P900,000 P500,000 P2,000.000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P430,000 and June sales totaled P540,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. Assume that the company will prepare a budgeted statement of financial position as of September 30. Compute the accounts receivable as of that date.arrow_forwardQuestion Content Area Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,680,000 Quarter 2 5,690,000 Quarter 3 6,780,000 Quarter 4 8,040,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,050,000 and for the fourth quarter of the current year are $6,950,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year,…arrow_forward
- Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid and • Accounts payable for raw materials, beginning balance $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit $2 per hour $60,000 •Variable MOH rate…arrow_forward2. Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,620,000 Quarter 2 5,610,000 Quarter 3 1,190,000 Quarter 4 7,840,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,640,000 and for the fourth quarter of the current year are $7,320,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 0b62a1fb700f07d_1 $fill in the blank…arrow_forwardFAS: Problems for Budgeting Part 3 Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,120,000 Quarter 3 6,660,000 Quarter 4 8,600,000 In Shalimar's experience, 10 percent of sales are paid cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,700,000 and for the fourth quarter of the current year are $7,210,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year 4, current year 1, next year 2, next year 3, next year 4, next year Construct a…arrow_forward
- Question 10 View Policies Current Attempt in Progress The following credit sales are budgeted by Waterway Industries: t $174000 January 250000 February 390000 March 280000 April The company's past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month of April is O $336920. O $294000. O $280800. O $274000. hp holl 12 44 ins prt sc delete home & 6 7 backspace lock P C H K L ntarrow_forwardQuestion 2 A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: June RM Cash sales Credit sales Total sales 10,200 26,100 36,300 July RM 14,700 33,900 48,600 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest…arrow_forwardQuestion-4 REQUIRED Use the information provided by Empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget. INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024. 2. Budgeted sales figures for 2024 are as follows: 3. 4. 5. 6. 7. Cash sales Credit sales 9. January R320 000 R370 000 Total purchases February R370 000 R390 000 March R310 000 R320 000 Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: • 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January February R410 000 R460 000 April R250 000 R300 000 March R400 000 April R380 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY