Cash Receipts Budget and Accounts Receivable Aging ScheduleShalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:Quarter 1$4,750,000Quarter 26,000,000Quarter 32,890,000Quarter 48,530,000In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent arecollected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected.Total sales for the third quarter of the current year are $5,250,000 and for the fourth quarter of the current year are $7,360,000. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from creditsales. If an amount is zero, enter "0".Shalimar CompanyCash Receipts BudgetFor the Coming YearQuarter 1 Quarter 2Quarter 3 Quarter 4Cash salesReceived on account from:Quarter 3, current yearQuarter 4, current yearQuarter 1, next yearQuarter 2, next yearQuarter 3, next yearQuarter 4, next yearTotal cash receipts3. What if the recession led Shalimar's top management to assume that in the next year 10 percent of credit sales would never be collected? Theexpected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received ineach quarter? Construct a revised cash budget using the new assumption.Shalimar Company

The cash collection budget is prepared to record the cash receipts from cash sales, customers during…

Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,750,000 Quarter 2 Quarter 3 Quarter 4 6,000,000 2,890,000 8,530,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,250,000 and for the fourth quarter of the current year are $7,360,000.

Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,750,000 Quarter 2 Quarter 3 Quarter 4 6,000,000 2,890,000 8,530,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,250,000 and for the fourth quarter of the current year are $7,360,000.

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

Finance answer question b)
Preparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $19,200,000. There is a 5% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries Utilities Office space $960,000 365,000 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year.
i need the answer quickly
Cash 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: Line Item Description September October November Sales $102,000 $132,000 $174,000 Manufacturing costs 43,000 57,000 63,000 Selling and administrative expenses 36,000 40,000 66,000 Capital expenditures 42,000 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 $6,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…
Preparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $19,800,000. There is a 4% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses Fixed expenses: Salaries Utilities Office spacе Advertising Total fixed expenses Total selling and administrative expenses
2. Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,080,000 and for the fourth quarter of the current year are $7,220,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank b0590a054f99004_1 $fill in the blank b0590a054f99004_2 4, current year fill in the blank…
XYZ Corp has the following sales budget: $195,550 $185,950 Sales budget They collect 60% of sales in the month of the sale, 20% in the first month after the sale, 15% in the second month after the sale, and 5% goes uncollected. What are the cash collections from sales in March? $206,050 January $205,000 $210,000 February $194,000 March $210,000
Preparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $20,000,000. There is a 3% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses $fill in the blank 1 Fixed expenses: Salaries $fill in the blank 2 Utilities fill in the blank 3 Office space fill in the blank 4 Advertising fill in the blank 5 Total fixed expenses fill in the blank 6 Total selling and administrative expenses $fill in the blank 7
Operating Budget, Comprehensive Analysis (5) The unit selling price of the wiring harness assembly is $110. In February, the company plans to purchase land for future expansion. The land costs $68,000. All sales and purchases are for cash. The cash balance on January 1 equals $62,900. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum. Required: Prepare a monthly operating budget for the first quarter with the following schedules:
2. Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,620,000 Quarter 2 5,610,000 Quarter 3 1,190,000 Quarter 4 7,840,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,640,000 and for the fourth quarter of the current year are $7,320,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 0b62a1fb700f07d_1 $fill in the blank…
Cash 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: Line Item Description September October November Sales $250,000 $300,000 $315,000 Manufacturing costs 150,000 180,000 185,000 Selling and administrative expenses 42,000 48,000 51,000 Capital expenditures 200,000 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…
do not give solution in image