Financial & Managerial Accounting
14th Edition
ISBN: 9781337119207
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 21, Problem 9DQ
A. Discuss the purpose of the
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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What revenue sources allow this budget to be balanced in each year? What revenue source will have the greatest impact on the budget? What assumptions
have been made with respect to revenue sources? What two expenditures will have the greatest impact upon the budget?
LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of December 31, 2018
is as follows:
Assets
Liabilities
Cash
$5,000
Accounts Payable
$9500
Accounts Recievable
28,000
Inventories
Direct Materials
8,100
Finished Goods (500
Units)
16,870
Stockholders Equity
Equipment - gross
45,000
Accumulated depreciation
15.000
Common Stock
$15,000
Net Equipment
30,000
Retained Earnings
63,470
Total Assets
$87,970
Total Liabilities and
$87,960
Equity
LB sells one product for $45/unit. The Company forecasts that it will sell 2,000; 1,500; 1,600; and 1,700 units
in January, February, March and April, respectively.
• Sales to customers are all on credit. 40% of the cash for these sales is collected in the month of the sale and
the remaining 60% is collected in the following month.
LB wants finished goods inventory equal to 25% of the next month's sales on hand at the end of each
month.
LB wants direct materials equal to 75% of the current month's production…
Chapter 8: Applying Excel: Exercise (Part 2 of 2)
Requirement 2:
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling
price from $8 to $7. The marketing manager would like to use the following projections in the budget:
Year 2 Quarter
Year 3 Quarter
Data
1
2
3
1
2
Budgeted unit sales
Selling price per unit
45,000
$7
70,000
120,000
60,000
80,000
95,000
A.
B
D
E
G
1 Chapter 8: Applying Excel
2
Data
Year 3 Quarter
4
1
2
3
4
1
2
5 Budgeted unit sales
45,000
70,000
120,000
60,000
80,000
95,000
6.
7 · Selling price per unit
- Accounts receivable, beginning balance
9 · Sales collected in the quarter sales are made
Sales collected in the quarter after sales are made
$
7 per unit
8
$
65,000
75%
10
25%
11 · Desired ending finished goods inventory is
12 · Finished goods inventory, beginning
13 · Raw materials required to produce one unit
30% of the budgeted unit sales of the next quarter
12,000 units
5 pounds
14 ·…
Chapter 21 Solutions
Financial & Managerial Accounting
Ch. 21 - Prob. 1DQCh. 21 - Briefly describe the type of human behavior...Ch. 21 - What behavioral problems are associated with...Ch. 21 - What behavioral problems are associated with...Ch. 21 - Under what circumstances would a static budget be...Ch. 21 - How do computerized budgeting systems aid firms in...Ch. 21 - Why should the production requirements Set forth...Ch. 21 - Prob. 8DQCh. 21 - A. Discuss the purpose of the cash budget. B. If...Ch. 21 - Give an example of how the capital expenditures...
Ch. 21 - Flexible budgeting At the beginning of the period,...Ch. 21 - Production budget Pasadena Candle Inc. projected...Ch. 21 - Direct materials purchases budget Pasadena Candle...Ch. 21 - Direct labor cost budget Pasadena Candle Inc....Ch. 21 - Cost of goods sold budget Prepare a cost of goods...Ch. 21 - Prob. 21.6BECh. 21 - Personal budget At the beginning of the school...Ch. 21 - Flexible budget for selling and administrative...Ch. 21 - Static budget versus flexible budget The...Ch. 21 - Flexible budget for Assembly Department Steelcase...Ch. 21 - Production budget Weightless Inc. produces a Bath...Ch. 21 - Sales and production budgets Sonic Inc....Ch. 21 - Prob. 21.7EXCh. 21 - Prob. 21.8EXCh. 21 - Prob. 21.9EXCh. 21 - Prob. 21.10EXCh. 21 - Direct materials purchases budget Anticipated...Ch. 21 - Direct labor cost budget Ace Racket Company...Ch. 21 - Production and direct labor cost budgets Levi...Ch. 21 - Factory overhead cost budget Sweet Tooth Candy...Ch. 21 - Cost of goods sold budget Delaware Chemical...Ch. 21 - Cost of goods sold budget The controller of...Ch. 21 - Prob. 21.17EXCh. 21 - Schedule of cash collections of accounts...Ch. 21 - Schedule of cash payments for a service company...Ch. 21 - Prob. 21.20EXCh. 21 - Capital expenditures budget On January 1, 20Y6,...Ch. 21 - Forecast sates volume and sales budget For 20Y8,...Ch. 21 - Sales, production, direct materials purchases, and...Ch. 21 - Budgeted income statement and supporting budgets...Ch. 21 - Cash budget The controller of Bridgeport...Ch. 21 - Budgeted income statement and balance sheet As a...Ch. 21 - Forecast sales volume and sales budget Sentinel...Ch. 21 - Sales, production, direct materials purchases, and...Ch. 21 - Budgeted income statement and supporting budgets...Ch. 21 - Cash budget The controller of Mercury Shoes Inc....Ch. 21 - Budgeted income statement and balance sheet As a...Ch. 21 - Nursing staff budget Mercy Hospital staffs its...Ch. 21 - Parking lot staff budget Adventure Park is a large...Ch. 21 - Prob. 3ADMCh. 21 - Prob. 21.1TIFCh. 21 - Communication The city of .Milton has an annual...
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. Prepare Cash Budget for the period of 6 months from July to December 2020. B. Explain the advantages and disadvantages of cash budgeting.arrow_forwardA cash flow budget can be used to A. estimate when and how much money will need to be borrowed during the year B. estimate when and how much debt can be repaid during the year C. estimate when excess cash may be available so plans can be made to invest it D. all of the abovearrow_forwardThe amount of prepaid expense reflected in the disbursement section of the cash budget is the same amount that is found on the monthly operating statement. True Falsearrow_forward
- March Madness" refers to which of the following: O a. Financial year end O b. A period when financial statements by government departments are due A period when the budget is due d. The last month of the Financial year and all funds must be utilizedarrow_forward(a) The business needs to have a sense of its future cashflows and therefore requires thepreparation of the following: ▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months October to December. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months October to December. ▪ A cash budget, with a total column, for the quarter ending December 31, 2021, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.arrow_forward(a) The business needs to have a sense of its future cashflows and therefore requires thepreparation of the following:▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months October to December. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account)for each of the months October to December.▪ A cash budget, with a total column, for the quarter ending December 31, 2021, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.arrow_forward
- Why should an organization revise its budget for the fourth quarter?arrow_forwardHahaarrow_forwardWhich of the following would appear on both the budgeted income statement and on the schedule of expected cash disbursements for operating expenses? (A) Depreciation expense (B) Rent expense (C) Sales commission expense (D) Both B and Carrow_forward
- Using the same above information, what would it look like to complete the following? Schedule of cash payments for direct materials.Cash budget.Budgeted income statement for entire second quarter (not monthly).arrow_forward38. The cash budget reflects Group of answer choices all the items that appear on a budgeted balance sheet. expected cash receipts and cash disbursements from all sources. all revenues and all expenses for a period. all the items that appear on a budgeted income statement.arrow_forwarda) The business needs to have a sense of its future cashflows and therefore requires the preparation of the following:▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months October to December. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account)for each of the months October to December. ▪ A cash budget, with a total column, for the quarter ending December 31, 2021, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting (Text Only)
Accounting
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
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