The Geller Company has projected the following quarterly sales amounts for the coming year Q1 $690 Q2 $720 Q3 $780 04 $930 Sales a. Accounts recelvable at the beginning of the year are $450. The company hos a 45- day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round Intermediate calculatlons and round your answers to the nearest whole number, e.g., 32) Q1 Q2 QS G4 Boginning recelvables Sales 720 780 930 Cash collactions Ending receivables

The Geller Company has projected the following quarterly sales amounts for the coming year Q1 $690 Q2 $720 Q3 $780 04 $930 Sales a. Accounts recelvable at the beginning of the year are $450. The company hos a 45- day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round Intermediate calculatlons and round your answers to the nearest whole number, e.g., 32) Q1 Q2 QS G4 Boginning recelvables Sales 720 780 930 Cash collactions Ending receivables

Name: 2. Fill in all of the blanks The Geller Company has projected the foll
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: 2. Fill in all of the blanks The Geller Company has projected the following quarterly sales amounts for the comingyearQ1$690Q2$720Q3$78094$930Salesa. Accounts recelvable at the beginning of the year are $450. The company has a 45-day collection perio

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
The following four suggestions have been made to improve the company’s cash position. Evaluate the effect on cash flow for each of the four suggestions. After evaluating each suggestion, enter the projected cash balances in the spaces provided. Consider each suggestion separately. Reset cells to their initial values after each new suggestion. Seek agreement with suppliers to extend the credit period to 30 days. This would mean that all current monthly purchases would be paid for in the following month. Raise the unit price from $28 to $30. A price increase will reduce unit sales by 10% each month. Unit purchases will also be reduced by 10%. Put the company’s two salespeople on straight commission. This would reduce fixed marketing and administrative costs to $1,500 per month and raise variable marketing and administrative costs to $7 per unit. Increase the cash discount from 5% to 10%. It is anticipated that this would increase the percentage of customers paying within the discount period to 85%, and those paying the month after the discount period would drop to 8%. Five percent would pay in the following month and 2% would still be uncollectible. What are your recommendations for Sweet Pleasures, Inc.? Consider potential impact on profits as well as cash balances.
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.
Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month The forecast for both cash and credit sales is as follows. Required: 1. What is the forecasted cash inflow for Ragman Company for May? 2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow related to sales made in April? (CMA adapted)