Fundamentals Of Cost Accounting (6th Edition)
6th Edition
ISBN: 9781259969478
Author: WILLIAM LANEN, Shannon Anderson, Michael Maher
Publisher: McGraw Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 13, Problem 37E
Estimate Cash Receipts
Scare-2-B-U (S2BU) specializes in costumes for all occasions. The average price of each of its costumes is $240. For each occasion, S2BU receives a 20 percent deposit two months before the occasion, 50 percent the month before, and the remainder on the day the costume is delivered. Based on information at hand, managers at S2BU expect to make costumes for the following number of occasions during the coming months:
Required
- a. What are the expected revenues for S2BU for each month, April through September? Revenues are recorded in the month of the occasion.
- b. What are the expected cash receipts for each month, April through July?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Scare-2-B-U (S2BU) specializes in costumes
for all occasions. The average price of each
of its costumes is $340. For each occasion,
S2BU receives a 10 percent deposit two
months before the occasion, 50 percent the
month before, and the remainder on the
day the costume is delivered. Based on
information at hand, managers at S2BU
expect to make costumes for the following
number of occasions during the coming
months.
April
45
May
30
June
20
July
35
August
45
September
105
Required:
a. What are the expected revenues for
S2BU for each month, April through
September? Revenues are recorded in the
month of the occasion.
b. What are the expected cash receipts for
each month, April through July?
Problem 1. Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash
disbursement estimates for the period February to June of the current year.
Cash
disbursements
Month
Sales
February
$500
$400
March
600
300
April
400
600
May
200
500
June
200
200
McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the
sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending
balance in its cash account of $25. Balances above this amount would be invested in short-term government securities
(marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable).
The beginning cash balance at April 1 is $115.
a. Prepare cash budgets for April, May, and June.
b.
How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this
3-month period?
c. A pro forma balance…
Treasure Service anticipates the following sales revenue over a five-month period:
Its collection history indicates that credit sales are collected as follows:
E (Click the icon to view the sales data.)
A (Click the icon to view the collections data.)
The company's sales are 20% cash and 80% credit.
How much cash will be collected in Janua
More Info
25% in the month of the sale
50% in the month after the sale
Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do
20% two months after the sale
Treasure Service
5% are never collected
Cash Collections Budget
For the Months of January through March
January
Data Table
Print
Done
Cash sales
Collection of credit sales:
25% Month of sale
November
December
January
February
March
50% Month after
Sales revenue.......
16,100
$
10,000
$ 15,200
$
12,000
$
14,200
20% Two months after
Total cash collections
Print
Done
Chapter 13 Solutions
Fundamentals Of Cost Accounting (6th Edition)
Ch. 13 - Prob. 1RQCh. 13 - Prob. 2RQCh. 13 - Prob. 3RQCh. 13 - What role does the master budget play in the...Ch. 13 - What problems might arise if a firm relies solely...Ch. 13 - What is the coordinating role of budgeting?Ch. 13 - Prob. 7RQCh. 13 - Write out the inventory equation that is used to...Ch. 13 - What makes creating budgets for marketing and...Ch. 13 - Prob. 10RQ
Ch. 13 - Preparing a budget is a waste of time. The...Ch. 13 - In the Business Application feature, Using the...Ch. 13 - Prob. 13CADQCh. 13 - Would the budgeting plans for a company that uses...Ch. 13 - Government agencies are limited in spending by...Ch. 13 - What is the difference between the planning and...Ch. 13 - When might the master budget start with a forecast...Ch. 13 - In some organizations (firms, universities,...Ch. 13 - Our cash budget shows a surplus for the quarter,...Ch. 13 - Your boss asks for your estimate on the costs of a...Ch. 13 - The chapter identified four techniques used for...Ch. 13 - Role of Budgets and Plans
Cosmic Corporation is a...Ch. 13 - Human Element in Budgeting
Roller Partners is a...Ch. 13 - Estimate Sales Revenues Stubs-R-Us is a local...Ch. 13 - Estimate Sales Revenues Friendly Financial has 160...Ch. 13 - Estimate Sales Revenues Larson, Inc., manufactures...Ch. 13 - Estimate Production Levels Offenbach Son has just...Ch. 13 - Estimate Sales Levels Using Production Budgets...Ch. 13 - Estimate Inventory Levels Using Production Budgets...Ch. 13 - Estimate Production Levels: Capacity Constraints...Ch. 13 - Prob. 31ECh. 13 - Estimate Purchases and Cash Disbursements Midland...Ch. 13 - Estimate Purchases and Cash Disbursements Lakeside...Ch. 13 - Estimate Cash Disbursements Cascade, Ltd., a...Ch. 13 - Estimate Cash Collections Minot Corporation is...Ch. 13 - Estimate Cash Collections Ewing Company is...Ch. 13 - Estimate Cash Receipts Scare-2-B-U (S2BU)...Ch. 13 - Estimate Cash Receipts Varmit-B-Gone is a pest...Ch. 13 - Prepare Budgeted Financial Statements
Refer to the...Ch. 13 - Prepare Budgeted Financial Statements Cycle-1 is a...Ch. 13 - Prepare Budgeted Financial Statements Carreras Caf...Ch. 13 - Budgeting in a Service Organization Executive...Ch. 13 - Prob. 43ECh. 13 - Prob. 44ECh. 13 - Prob. 45ECh. 13 - Prob. 46ECh. 13 - Sensitivity Analysis Sanjanas Sweet Shoppe...Ch. 13 - Sensitivity Analysis Classic Limo, Inc., provides...Ch. 13 - Prob. 49ECh. 13 - Prob. 50ECh. 13 - Prepare Budgeted Financial Statements The...Ch. 13 - Prob. 52PCh. 13 - Prepare Budgeted Financial Statements Gulf States...Ch. 13 - Prob. 54PCh. 13 - Prob. 55PCh. 13 - Prepare a Production Budget Haggstrom, Inc.,...Ch. 13 - Sales Expense Budget SPU, Ltd., has just received...Ch. 13 - Budgeted Purchases and Cash Flows Mast Corporation...Ch. 13 - Prepare Budgeted Financial Statements HomeSuites...Ch. 13 - Prob. 60PCh. 13 - Comprehensive Budget Plan Brighton, Inc.,...Ch. 13 - Comprehensive Budget Plan Panther Corporation...Ch. 13 - Budgeted Financial Statements in a Retail...Ch. 13 - Cash Budgets and Sensitivity Analysis in a Retail...Ch. 13 - Prob. 66IC
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
- Current Attempt in Progress The management of Riverbed Industries estimates that credit sales for August, September, October, and November will be $575,000, $700,000, $875,000, and $490,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November. (Do not leave any field blank. Enter O for the amounts.) October November Collections from Customers August Sales September Sales October Sales November Sales 2$ $. Total budgeted collections eTextbook and Media Attempts: 0 of 3 used Submit Answer. Savetor La hp %24 %24arrow_forwardJane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?…arrow_forwardPacific Place has developed the following sales forecast for the following months. Month Sales May $500,000 June $650,000 July $380,000 August $300,000 The collection policy for customers is: 40 percent in the month of sale 60 percent in the following month after sale How much is the expected total cash collections from customers in June? Multiple Choice $610,000 $260,000 $590,000 $560,000 $300,000arrow_forward
- f) The Cathy Specialist Corporation approached you to compile a cash disbursement schedule for the month of March, April and May. Use the following information. Sales: January-RMS20,000; February-RM540,000; March-RM550,000; April=RM600,000; May-RM660,000; June-RM670,000. Purchases: Purchases are calculated as 70% of the following month's sales, 50% of purchase are made in cash, 30% of purchases are settled one month after purchase, and the remaining 20% of purchase are settled two months after purchase. c) d) e) g) h) the firm's expected cash receipts for a) b) Rent: The firm pays rent of RM9,500 per month. Wages & salaries: the fixed wage and salary costs are RM7,500 per month plus a variable cost of 6.5% of the current month's sales. Taxes: the tax bill to be paid in May amount to RM57,500. Fixed asset outlay: new equipment will be acquired during March at a cost of RM85,000. Interest payment: an amount of RM32,000 for interest is due in March. Cash Dividend: Dividends of RM15,000…arrow_forwardCrane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $11 Crane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000 How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $ I Iarrow_forwardGarnett Co. expects to purchase $180,000 of materials in July and $210,000 of materials in August. Three-fourths of all purchases are paid for in the month of purchase, and the other one-fourth are paid for in the month following the month of purchase. How much will August's cash disbursements for materials purchases be? Group of answer choices $210,000 $157,500 $202,500 $135,000arrow_forward
- Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.arrow_forwardDear Bartleby, Could you please assist with the following schedule of cash payments, thank you. e. Prepare a schedule of cash payments for materials, by month and in total, for the second quarter of 2019. Soprano Co. is in the process of preparing the second quarter budget for 2019, and the following data have been assembled: The company sells a single product at a selling price of $40 per unit. The estimated sales volume for the next six months is as follows: March 6,000 units June 8,000 units April 7,000 units July 9,000 units May 10,000 units August 6,000 units All sales are on account. The company's collection experience has been that 40% of a month's sales are collected in the month of sale, 55% are collected in the month following the sale, and 5% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allowance for uncollectible accounts) will be $132,000 on March 31, 2019.…arrow_forwardMusselman Kennels had sales for the months of January through April of $150, $100, $120, and $200, respectively. The firm receives cash payments of 10 percent in the month of sale, 60 percent one month later, and the remaining 30 percent two months after the sale. What will be the cash inflows for April? Multiple Choice $122 $200 $117 $142 $156arrow_forward
- 1.A financial analyst for Carroll Company has prepared the following sales and cash disbursement estimates for the period February-June of the current year. Cash disbursements Month Sales February $500 $400 March 600 300 April May 400 600 200 500 June 200 200 Manager noted that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending balance in its cash account of $25. Balances above this amount would be invested in short- term government securities (marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable). The beginning cash balance at April 1 is $115. a. Prepare a cash budget for April, May, and June. b. How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this 3-month period?arrow_forwardThe management of Kirkut Enterprises prepared the following forecasted total sales schedule for the five months ending December 2021 August September October November December R310 000 R330 000 R325 000 R340 000 R410 000 Additional information: Cash sales comprise 40% of total sales. These customers are entitles to a 4% discount. Credit sales are collected as follows: 40% in the month of sale - these customers get a 2% discount 55% in the month after the sale 5% is written off as bad debts Cash receipts for cash sales made for the period August to December will total: O A. R686 000 O B. R1 715 000 O C. R658 560 D. R1 646 400arrow_forward6. Smith Company was organized on August 1 of the current year. Projected sales for the next three months are: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash and 50% for sales on account. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections from cash and accounts receivable for the three months.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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