Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 8, Problem 21E
To determine
Concept introduction:
The
Requirement 1
The cash receipt and cash payment for June July and August.
To determine
Concept introduction:
The cash receipt budget is prepared by the company to estimate the budgeted amount of cash sales and cash to be received from the customers during a particular period. The cash payment budget estimates the amount of payment to be made in cash during a particular period.
Requirement 2
The balance of various items.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The accountant for Jean’s Dress Shop prepared the following cash budget. Jean’s desires to maintain a cash cushion of $10,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month.
Required
Complete the cash budget by filling in the missing amounts.
Determine the amount of net cash flows from operating activities Jean’s will report on the third quarter pro forma statement of cash flows.
Determine the amount of net cash flows from financing activities Jean’s will report on the third quarter pro forma statement of cash flows.a.
Cash Budget
July
August
September
Section 1: Cash receipts
Beginning cash balance
$25,000
Add cash receipts
90,000
100,000
120,300
Total cash available
115,000
Section 2: Cash payments
For inventory purchases
82,750
70,115
87,076
For S&A expenses
27,250
30,280
30,716
For interest…
The accountant for Jean’s Dress Shop prepared the following cash budget. Jean’s desires to maintain a cash cushion of $10,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month.
Required
Complete the cash budget by filling in the missing amounts.
Determine the amount of net cash flows from operating activities Jean’s will report on the third quarter pro forma statement of cash flows.
Determine the amount of net cash flows from financing activities Jean’s will report on the third quarter pro forma statement of cash flows.
The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash cushion of $10,000 at the
end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1
percent per month.
Required
a. Complete the cash budget by filling in the missing amounts.
b. Determine the amount of net cash flows from operating activities Jean's will report on the third quarter pro forma statement of cash
flows.
c. Determine the amount of net cash flows from financing activities Jean's will report on the third quarter pro forma statement of cash
flows.
Complete this question by entering your answers in the tabs below.
Req A
Req B and C
Complete the cash budget by filling in the missing amounts. (Any shortages or repayments should be indicated with a minus
sign. Round your answers to the nearest whole dollar amount.)
Cash Budget
Section 1: Cash receipts
Beginning cash balance
Add cash receipts
Total cash…
Chapter 8 Solutions
Managerial Accounting
Ch. 8 - Briefly describe why budgetary planning is...Ch. 8 - What role do budgets play in the planning and...Ch. 8 - Prob. 3QCh. 8 - Prob. 4QCh. 8 - Prob. 5QCh. 8 - Prob. 6QCh. 8 - What are the advantages and disadvantages of...Ch. 8 - What is budgetary slack and why might it be...Ch. 8 - Briefly explain how each of the following helps to...Ch. 8 - What is the master budget, and what are its...
Ch. 8 - Explain why the sales budget is the starting point...Ch. 8 - Prob. 12QCh. 8 - What are tile components of tile operating...Ch. 8 - Prob. 14QCh. 8 - Prob. 15QCh. 8 - Prob. 16QCh. 8 - Prob. 17QCh. 8 - Prob. 18QCh. 8 - How does the budgeting process differ for a...Ch. 8 - Prob. 20QCh. 8 - Prob. 1MCCh. 8 - Prob. 2MCCh. 8 - Prob. 3MCCh. 8 - Prob. 4MCCh. 8 - Prob. 5MCCh. 8 - Prob. 6MCCh. 8 - Which of the following budgets is affected by the...Ch. 8 - Prob. 8MCCh. 8 - Prob. 9MCCh. 8 - Prob. 10MCCh. 8 - Describing Advantages of Budgetary Planning...Ch. 8 - Classifying Components of Master Budget Classify...Ch. 8 - Prob. 4MECh. 8 - Prob. 5MECh. 8 - Prob. 6MECh. 8 - Prob. 7MECh. 8 - Preparing Selling and Administrative Expense...Ch. 8 - Prob. 9MECh. 8 - Prob. 10MECh. 8 - Prob. 11MECh. 8 - Prob. 1ECh. 8 - Using Terms to Complete Sentences about Budgets...Ch. 8 - Prob. 3ECh. 8 - Prob. 4ECh. 8 - Prob. 5ECh. 8 - Prob. 6ECh. 8 - Prob. 7ECh. 8 - Prob. 8ECh. 8 - Prob. 9ECh. 8 - Prob. 10ECh. 8 - Prob. 11ECh. 8 - Preparing Production, Raw Materials Purchases...Ch. 8 - Prob. 13ECh. 8 - Prob. 14ECh. 8 - Prob. 15ECh. 8 - Prob. 16ECh. 8 - Prob. 17ECh. 8 - Prob. 18ECh. 8 - Prob. 19ECh. 8 - Prob. 20ECh. 8 - Prob. 21ECh. 8 - Prob. 1.1GAPCh. 8 - Prob. 1.2GAPCh. 8 - Prob. 1.3GAPCh. 8 - Prob. 1.4GAPCh. 8 - Prob. 1.5GAPCh. 8 - Prob. 1.6GAPCh. 8 - Prob. 1.7GAPCh. 8 - Prob. 2GAPCh. 8 - Prob. 3.1GAPCh. 8 - Prob. 3.2GAPCh. 8 - Prob. 3.3GAPCh. 8 - Prob. 4.1GAPCh. 8 - Prob. 4.2GAPCh. 8 - Preparing Operating Budget Components Wesley Power...Ch. 8 - Prob. 4.4GAPCh. 8 - Prob. 5.1GAPCh. 8 - Prob. 5.2GAPCh. 8 - Preparing Operating Budget Components Refer to the...Ch. 8 - Prob. 6.1GAPCh. 8 - Prob. 6.2GAPCh. 8 - Prob. 6.3GAPCh. 8 - Prob. 6.4GAPCh. 8 - Prob. 6.5GAPCh. 8 - Prob. 1.1GBPCh. 8 - Prob. 1.2GBPCh. 8 - Prob. 1.3GBPCh. 8 - Prob. 1.4GBPCh. 8 - Prob. 1.5GBPCh. 8 - Prob. 1.6GBPCh. 8 - Prob. 1.7GBPCh. 8 - Prob. 2GBPCh. 8 - Prob. 3.1GBPCh. 8 - Prob. 3.2GBPCh. 8 - Prob. 3.3GBPCh. 8 - Prob. 4.1GBPCh. 8 - Prob. 4.2GBPCh. 8 - Prob. 4.3GBPCh. 8 - Prob. 4.4GBPCh. 8 - Prob. 5.1GBPCh. 8 - Prob. 5.2GBPCh. 8 - Prob. 5.3GBPCh. 8 - Prob. 6.1GBPCh. 8 - Prob. 6.2GBPCh. 8 - Prob. 6.3GBPCh. 8 - Prob. 6.4GBPCh. 8 - Prob. 6.5GBP
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
- Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forwardCalculating Gross Income with Gratiuities When creating a budget the server needs to figure out their average weekly income. Before tips, the server get paid $4.15/ hour. Tips are calculated based off the food sales and the gratiuity percentage customers choose to pay (this typically averages out to anywhere between 17 - 20%). They pulled their sales, gratituity percentage, and their hourly income for the past 3 weeks. Summarize the weeks income by using the terms gratiuity, sales, hourly income, and average. Explain how you would use this information to create a budget. Also note any trends in the income and how to potentially increase the servers income in the future.Week 1:Hours worked: 14 (Saturday, Sunday & Thursday evening)Food Sales: $3,950Gratiuity percent: 18.5%Week 2:Hours worked: 32 (Monday-Thursday day shift)Food Sales: $2,895Gratiuity percent: 18.9%Week 3:Hours worked: 28 (Wednesday-Saturday evenings)Food Sales: $4,505Gratiuity percent: 19.1%arrow_forward
- Bernes Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During October, the kennel budgeted for 2,700 tenant-days, but its actual level of activity was 2,720 tenant-days. The kennel has provided the following data concerning the formulas to be used in its budgeting: Fixed element per month Variable element per tenant-day Revenue $ 0 $ 30.80 Wages and salaries $ 3,300 $ 6.10 Food and supplies 600 10.10 Facility expenses 8,800 3.60 Administrative expenses 7,600 0.10 Total expenses $ 20,300 $ 19.90 The activity variance for net operating income in October would be closest to: Multiple Choice A. $2,328 F B. $218 U C. $218 F D. $2,328 Uarrow_forwardThe accountant for Munoz’s Dress Shop prepared the following cash budget. Munoz’s desires to maintain a cash cushion of $24,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating activities Munoz’s will report on the third quarter pro forma statement of cash flows. Determine the amount of net cash flows from financing activities Munoz’s will report on the third quarter pro forma statement of cash flows.arrow_forwardGrohs Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During December, the kennel budgeted for 2,500 tenant-days, but its actual level of activity was 2,530 tenant-days. The kennel has provided the following data concerning the formulas to be used in its budgeting: Fixed Element per Month Variable element per tenant-day Revenue $ 0 $33.00 Wages and salaries $ 3,800 $ 7.90 Food and supplies 1,000 11.60 Facility expenses 8,600 2.20 Administrative expenses 6,200 0.20 Total expenses $19,600 $21.90 The net operating income in the planning budget for December would be closest to: Multiple Choice A. $8,150 B. $11,914 C. $8,483 D. $11,633arrow_forward
- Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts $ 521,000 Cash payments $ 467,800 January February March 410,500 458,000 357,300 531,000 Kayak requires a minimum cash balance of $50,000 at each month-end. The company can borrow money at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) KAYAK COMPANY Cash Budget January February March Beginning cash balance $ 50,000 Total cash available…arrow_forwardPersonal Finance Budget - Application • You are a worker in one muti-international company. There are three sources of income (salary, bonus, and other), followed by a list of expenses (rent, food, groceries, restaurants, entertainment, childcare costs, vacations, etc.). And the difference between the two is the person's monthly surplus or deficit. • As a worker, your monthly salary is Php6,000. bonuses are given every April and October in the amount of Php5,000, and Other income earned for the month of January for Php1000. • Your monthly expenses include the following: o Rent - Php1,700 o Food and Groceries - Php800 o Restaurants Expenses - Php1,200 o Entertainment - Php400 o Childcare - Php1,000 o Clothing - Php500, for March, June, September, December o Vacation - Php2,000, scheduled for the months of February and August o Other Expenses - Php1,000 for the months of February, May to December, Php700 for March, and Php2,000 for the month of April. • With the given data, prepare your…arrow_forwardGandrud Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During June, the kennel budgeted for 2,660 tenant-days, but its actual level of activity was 2,640 tenant-days. The kennel has provided the following data concerning the formulas to be used in its budgeting: Fixed element per month Variable element per tenant-day Revenue − $ 38.30 Wages and salaries $ 3,455 $ 7.60 Food and supplies 1,650 14.60 Facility expenses 11,800 2.90 Administrative expenses 10,250 0.60 Total expenses $ 27,155 $ 25.70 The food and supplies in the flexible budget for June would be closest to: $39,867 $40,443 $40,486 $40,194arrow_forward
- Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts $ 518,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Beginning cash balance Total cash available Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. 402,000 476,000 Total cash payments Preliminary cash balance Loan activity Ending cash balance Cash payments $…arrow_forwardKayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 524,000 $ 465,300 February 412,500 353,800 March 475,000 526,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March.arrow_forwardKayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts 523,000 $ Beginning cash balance Total cash available Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, Interest per month, paid at each month-end. The Interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. 408,500 476,000 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Total cash payments Preliminary cash balance Loan activity Ending cash balance Cash payments $ 469,800…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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