Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 11E
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.
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
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 at least $5,000 to start each quarter.
Required:
Fill in the missing amounts in the above table.
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.
ces
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at
least $10,000 to start each quarter.
Required:
Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by
a minus sign.)
Cash balance, beginning
Add collections from customers
Total cash available
Less disbursements.
Purchase of inventory
Selling and administrative expenses
Equipment purchases
Dividends
Total disbursements
Excess (deficiency) of cash available over disbursements
Financing:
Borrowings
Repayments (including interest) *
Total financing
Cash balance, ending
*Interest will total $1,000 for the year.
$
1
9
71
80
50
13
2
(5)
Quarter (000 omitted)
2
3
60
45
9
2
116
16
111
30
25
2
12
4
34
2
(30)
(000 omitted)
Year
389
119
57
Chapter 8 Solutions
Introduction To Managerial Accounting
Ch. 8 - What is a budget? What is budgetary control?Ch. 8 - Prob. 2QCh. 8 - What is meant by the term responsibility...Ch. 8 - What is a master budget? Briefly describe its...Ch. 8 - Why is the sales forecast the starting point in...Ch. 8 - “As a practical matter, planning and control mean...Ch. 8 - Prob. 7QCh. 8 - What is a self-imposed budget? What are the major...Ch. 8 - How can budgeting assist a company in planning its...Ch. 8 - Prob. 10Q
Ch. 8 - The Excel worksheet form that appears below is to...Ch. 8 - The Excel worksheet form that appears below is to...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Prob. 2F15Ch. 8 - Prob. 3F15Ch. 8 - Prob. 4F15Ch. 8 - Morganton Company makes one product and it...Ch. 8 - Prob. 6F15Ch. 8 - Prob. 7F15Ch. 8 - Prob. 8F15Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Prob. 11F15Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Morganton Company makes one product and ¡t...Ch. 8 - Schedule of Expected Cash Collections LOB-2 Silver...Ch. 8 - Down Under Products, Ltd., of Australia has...Ch. 8 - Direct Materials Budget LOB-4 Three grams of musk...Ch. 8 - Direct Labor Budget LOB-5 The production manager...Ch. 8 - Manufacturing Overhead Budget L.08—6 The direct...Ch. 8 - Weller Company’s budgeted unit sales for the...Ch. 8 - Cash Budget LOB—8 Garden Depot is a retailer that...Ch. 8 - Gig Harbor is the wholesale distributor of a small...Ch. 8 - The management of Mecca copy, a photocopying...Ch. 8 - Production and Direct Materials Budgets LO8—,...Ch. 8 - Cash Budget Analysis LOB—8 A cash budget, by...Ch. 8 - Prob. 12ECh. 8 - Schedules of Expected Cash Collections and...Ch. 8 - Sales and Production Budgets L08—2, L08—3 The...Ch. 8 - Direct Labor and Manufacturing Overhead Budgets...Ch. 8 - Direct Materials and Direct Labor Budgets LOB—4,...Ch. 8 - Cash Flows; Budgeted Income Statement and Balance...Ch. 8 - Cash Flows; Budgeted Income Statement and Balance...Ch. 8 - Cash Budget: Income Statement: Balance Sheet...Ch. 8 - Cash Budget; Income Statement: Balance Sheet;...Ch. 8 - Schedules of Expected Cash Collections and...Ch. 8 - Evaluating a Company’s Budget Procedures LOB—1...Ch. 8 - Prob. 23PCh. 8 - Cash Budget with Supporting Schedules L08-2,...Ch. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Completing a Master Budget LOB—2, LO8—4, LO8—7,...Ch. 8 - Prob. 30PCh. 8 - Completing a Master Budget LOB-2, LOB-4, LOB-7,...
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
- 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.arrow_forwardQUESTION 1 Which of the following statements is false about cash budgets? O Cash receipts are calculated by adding up all the cash inflows in a given month O When calculating the cash budget the firm must consider many aspects such as, cash receipts, cash expenses, minimum desired cash balance, and previous loans. O Cash receipts include sales, investment income and interest expenses. All of the above are true QUESTION 2 Based on the data below calculate the company's combined cost? Annual requirements = 7500 units Ordering cost = BD 12 Holding cost BD 0.5 O125 300 45000 150 0000arrow_forwardOlson Company Olson Company prepared a cash budget by quarters for the upcoming year. Missing data amounts are indicated with question marks or lower case letters; these lower case letters will be referred to in the questions that follow. Olson requires a minimum balance of $10,000 to start a quarter. All data are in thousands. Olson Corporation Cash Budget QTR 1 QTR 2 QTR 3 QTR 4 Cash balance, beginning $16 $e $13 $10 Add collections from customers a 70 67 80 Total cash available ? ? 80 90 Less disbursements: Purchase of inventory 31 c 40 35 Operating expenses 25 22 ? 15 Equipment purchases 10 14 19 0 Dividends 0 6 0 5 Total disbursements 66 ? f 55 Excess (deficiency) of cash available over disbursements 7 17 (2) 35 Financing: Borrowings: b -- 12 -- Repayments (including interest) -- d -- (12) Total financing ? ? 12 (12) Cash balance, ending $10 $? $10 $23 A) Refer to Olson Company. The collections from customers during the…arrow_forward
- Exercises 1: Questions for discussion 1. Describe the items reflected in the sales budget. 2. List the items included in the production budget 3. Identify the items that comprise the operating budget Exercises 2: Word Problems Roel Trading Company presents the actual sales for the first three months of year 2019 in its own products as follows: Product B P 540,000 P 567,000 P 595,350 Product A Total Sales Janaury February March P 880,000 P 941,000 P 1,006,750 The business expects that the trends for the past three months will P 340,000 P 374,000 P 411400 continue in April and May 2019. Required: Determined the projected sales for April and May 2019 for the two products. Round the amounts to thousand pesos.arrow_forwardA cash budget, by quarters, is given below for a retail company. (000 omitted) company requires a minimum cash balance of at least Br 5,000to start each quarter. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Cash balance, beginning 6 ? ? ? ? Add collections from customers ? ? 96 ? 323 Total cash available 71 ? ? ? ? Less disbursement: Purchase inventory 35 45 ? 35 ? Operating expense ? 30 30 ? 113 Equipment purchase 8 8 10 ? 36 Dividends 2 2 2 2 ? Total disbursement ? 85 ? ? ? Excess (deficiency) of each cash (2) ? 11 ? ? Financing: Borrowing ? 15 - - ? Repayments (including interest) - - ? (17) ? Total financing ? ? ? ? ? Cash balance, ending ? ? ? ? ?arrow_forwardA cash budget, by quarters, is given below for a retail company (000 omitted). The companyrequires a minimum cash balance of at least $5,000 to start each quarter. [table] Required: Fill in the missing amounts in the above table.arrow_forward
- Problem 6 Tomtom store seeks your assistance to develop cash and other budget information for May, June, and July 2009. On April 30, 2009, the company had cash balance of Php5,500. The budget is based on the following assumptions: A. Sales 1. Each month's sales are billed on the last day of the month 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month where discount period is allowed, 9% are collected by the end of the end second month, and 6% prove uncollectible. B. Purchases 1. 54% of all purchases of materials and selling, general and administrative expenses are paid at the month purchased and the remainder in the following month. 2. Each month's unit of ending inventory is equal to 130% of the month's units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and…arrow_forwardCash Budget; Income Statement; Balance Sheet; Changing Assumptions Refer to the data for Minden Company in Problem 8-19. The company is considering making the following changes to the assumptions underlying its master budget: 1. Sales are budgeted for $220,000 for May. 2. Each month’s credit sales are collected 60% in the month of sale and 40% in the month following the sale. 3. The company pays for 50% of its merchandise purchases in the month of the purchase and the remaining 50% in the month following the purchase. All other information from Problem 8-19 that is not mentioned above remains the same. Required: Using the new assumptions described above, complete the following requirements; 1. Calculate the expected cash collections for May. 2. Calculate the expected cash disbursements tor merchandise purchases for May. 3. Prepare a cash budget for May. 4. Using Schedule 9 as your guide, prepare a budgeted income statement for May. 5. Prepare a budgeted balance sheet as of May 31.arrow_forwardQuestion 3 a) Why do successful companies tend to use the bottom-up approach to establish a master budget? b) Green Tea's data show the following information for the financial year, beginning July 2020: July Aug. Sept. Oct. Nov. Estimated sales (units) 25,000 25,000 27,000 27,500 28,000 Sales price per unit $31 $31 $31 $31 $31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next month's requirements. Direct material requires 2.5 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month's needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of materials. Required: i) Prepare a production budget for the first quarter of the…arrow_forward
- Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month November Sales (P) 80,000 70,000 Actual (20X3) December Forecast (20X4) January February March 80,000 100,000 80,000 100,000 90,000 April May The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses iş 5% of turnover – time lag of payment half month. c. Commission on credit sales at 5% is payable on the third month. d. Rent and other expenses amounting to P3,000 paid every month. e. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. g. There will be an opening cash balance of P25,000. Required: a. Prepare a…arrow_forwardQuestion 1 The following data is available from the various functional budgets prepared at Nur Ika Enterprise for the year 2022: January RM '000 February RM '000 March RM '000 April RM 000 Cash sales 128 84 72 90 Credit sales 640 1,140 880 760 800 Purchases for resale Salaries and wages Overhead expenses 560 520 320 266 280 238 248 160 150 160 140 Other information is available as follows: (1) 5% of all sales on credit are expected to become bad debts. Receipts from credit customers are due in the following sales. All goods are bought on credit from suppliers who allow 2.5% cash discount for payment in the month following purchase. (ii) (iii) Salaries and wages are paid in the month they are earned. (iv) Payments for overhead expenses are made in the month the expenses are incurred. The above overhead budget includes RM28,000 per month for depreciation. Purchase two new vans, costing RM21,000 each, are to be paid in April. (v) (vi) Rental for new office amounting RM175,000 is to be…arrow_forwardAssume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $40,000 and $61,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What amount of cash collections from credit sales would the company include in its cash budget for the second month? Multiple Choice $42,700 $18,300 О $46,300 C $30,300arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
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