The following is the sales budget for Yellowhead Inc. for the first quarter of 2021:SalesJanuary$200,000February$220,000March$243,000Credit sales are collected as follows: 65% in the month of the sale, 20% in the month after the sale, and 15% in the second month afterthe sale.The accounts receivable balance at the end of the previous quarter was $84,000 ($54,000 of which was uncollected December sales).a. Calculate the sales for November. (Omit "$" sign in your response.)November salesb. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit "$" sign in your response.)December sales$c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations.Round the final answers to 2 decimal places. Omit "$" sign in your response.)JanuaryFebruaryMarchCash collections$$$

The problem asking to find the sales for November and December and the corresponding cash…

Answered: The following is the sales budget for…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

WILDHORSE COMPANY Cash Budget $ S January $ Febru
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business-September, October, and November-are $241,000, $314,000, and $415,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in November from accounts receivable are projected to be: C a. $331,632 Ob. $232,400 O c. $188,440 Od. $276,360
Grit Company was formed on May 1, 2023. During May, 2023, the company reported sales on account of $750,000. During June, 2023, Grit Company reportes sales on account of $800,000. Anticipated collections patterns of accounts receivable indicate 40% will be collected in the month of sale, 10% in the next month, and the remainder in the following month. How much will appear on the cash receipts and disbursements budget prepared for June, 2023? $620,000 O $465,000 O $545,000 O $540,000
Woodpecker Co. has $293,000 in accounts receivable on January 1. Budgeted sales for January are $977,000. Woodpecker Co. expects to sell 20% of its merchandise for cash. Of the remaining 80% of sales on account, 75% are expected to be collected in the month of sale and the remainder the following month. The January cash collections from sales are a. $644,760 Ob. $1,367,600 Oc. $859,680 Od. $1,074,600
The company pays for its purchases within 10 days of purchase, so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $10 per case. At the end of each month, it is desired to have an inventory equal in units to 75% of the following month's sales in units. Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at$80,600, of which $19,000 is fixed expense (which includes a $5,200 annual depreciation charge). this is incurred fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurredRequirementl.
Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION es Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash…
A company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken to meet this requirement at a cost of 1% interest per month (paid at the end of each month). Any preliminary cash balance above $12,400 is used to repay loans at month-end. The cash balance on March 1 is $12,400, and the company has no outstanding loans. Budgeted cash receipts from sales are: March, $26,000; April, $32,400; and May, $41,000. Budgeted cash payments (excluding loan or interest payments) are: March, $30,000; April, $30,200; and May, $32,400. Required: Prepare a cash budget for March, April, and May. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash receipts from sales Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance,…
Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in…
Boris detergents expects to have a cash balance of P46,000 on January 1, 2020. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January P71,000, February P146,000. 2. Payments to suppliers: January P40,000, February P75,000. 3. Wages: January P30,000, February P40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January P21,000, February P24,000. These costs include depreciation of P1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January P15,000, February P20,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize P12,000 in cash. The Company has a line of credit at a local bank that enables it to borrow up to P25,000. The company wants to maintain a minimum monthly cash balance of P20,000. Prepare a cash budget for January and February.
Spartan Industries has budgeted the following information for January Cash Receipts $ 43,400 Beginning Cash Balance $ 16,400 Cash Payments $ 61,400 Desired Ending Cash Balance $ 11,400 If there is not enough cash on hand to meet the desired ending balance, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,700 increments. Interest is paid monthly on the first day of the following month. The interest rate is 1 percent per month. The company had no debt before January 1 The shortage or surplus of cash before considering cash borrowed or interest payments in January would be a: Multiple Choice $1,600 shortage $9,800 shortage.
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 $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 528,000 Kayak requires a minimum cash balance of $30,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 $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available KAYAK COMPANY Cash Budget January $ 30,000…
jagdish

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS