Managerial Accounting
15th Edition
ISBN: 9781337912020
Author: Carl Warren, Ph.d. Cma William B. Tayler
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 9DQ
a.
To determine
Discuss the purpose of the
b.
To determine
Describe the excess cash to be used when the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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 8 Solutions
Managerial Accounting
Ch. 8 - Prob. 1DQCh. 8 - Briefly describe the type of human behavior...Ch. 8 - What behavioral problems are associated with...Ch. 8 - What behavioral problems are associated with...Ch. 8 - Under what circumstances would a static budget be...Ch. 8 - Prob. 6DQCh. 8 - Prob. 7DQCh. 8 - Why should the timing of direct materials...Ch. 8 - Prob. 9DQCh. 8 - Give an example of how the capital expenditures...
Ch. 8 - At the beginning of the period, the Fabricating...Ch. 8 - Pasadena Candle Inc. projected sales of 800,000...Ch. 8 - Pasadena Candle Inc. budgeted production of...Ch. 8 - Pasadena Candle Inc. budgeted production of...Ch. 8 - Prob. 5BECh. 8 - Cash budget Pasadena Candle Inc. pays 40% of its...Ch. 8 - At the beginning of the school year, Craig Kovar...Ch. 8 - Digital Solutions Inc. uses flexible budgets that...Ch. 8 - Static budget versus flexible budget The...Ch. 8 - Prob. 4ECh. 8 - Production budget Healthy Measures Inc. produces a...Ch. 8 - Sales and production budgets Sonic Inc....Ch. 8 - Professional foes earned budget for a service...Ch. 8 - Prob. 8ECh. 8 - Prob. 9ECh. 8 - Prob. 10ECh. 8 - Prob. 11ECh. 8 - Direct labor cost budget Ace Racket Company...Ch. 8 - Prob. 13ECh. 8 - Factory overhead cost budget Sweet Tooth Candy...Ch. 8 - Cost of goods sold budget Delaware Chemical...Ch. 8 - Prob. 16ECh. 8 - Prob. 17ECh. 8 - Prob. 18ECh. 8 - Schedule of cash payments for service company...Ch. 8 - Prob. 20ECh. 8 - Capital expenditures budget On January 1, 20Y6,...Ch. 8 - Prob. 1PACh. 8 - Sales, production, direct materials purchases, and...Ch. 8 - Budgeted income statement and supporting budgets...Ch. 8 - Budgeted income statement and supporting budgets...Ch. 8 - Cash budget The controller of Bridgeport...Ch. 8 - Budgeted income statement and balance sheet As a...Ch. 8 - Prob. 1PBCh. 8 - Sales, production, direct materials purchases, and...Ch. 8 - Budgeted income statement and supporting budgets...Ch. 8 - Prob. 4PBCh. 8 - Cash budget The controller of Mercury Shoes Inc....Ch. 8 - Budgeted income statement and balance sheet As a...Ch. 8 - Analyze Johnson Stores staffing budget for...Ch. 8 - Prob. 2MADCh. 8 - Prob. 3MADCh. 8 - Prob. 4MADCh. 8 - Ethics in Action The director of marketing for...Ch. 8 - Prob. 3TIFCh. 8 - Evaluating the budgeting system in a service...Ch. 8 - Static budget for a service company A hank manager...Ch. 8 - Objectives of the master budget Dominos Pizza LLC...Ch. 8 - When compared to static budgets, flexible budgets:...Ch. 8 - Prob. 2CMACh. 8 - Ming Company has budgeted sales at 6,300 units for...Ch. 8 - Krouse Company produces two products, forged...
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_forwardIf the company wants to find out the likely balance of cash in hand at the end of July, August and September 2021. Which of the following helps the company to fulfill their objective? a. Purchase budget b. Cash budget c Sales budget d. Materials budgetarrow_forwardA. Prepare Cash Budget for the period of 6 months from July to December 2020. B. Explain the advantages and disadvantages of cash budgeting.arrow_forward
- A 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_forwardMarch 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_forwardWhy should an organization revise its budget for the fourth quarter?arrow_forward
- Hahaarrow_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_forwardUsing 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningAccountingAccountingISBN: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 PubFinancial 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