31. Budgets for Cash Collections from Sales and Cash Payments for Purchases. Car Products, Inc., produces car covers. The dollar amount of the company's quarterly sales and direct materials purchases are projected to be as follows (this information is derived from the previous exercises): 1st 2nd 3rd 4th Sales $ 3,510,000 $ 5,850,000 $ 7,020,000 $ 4,680,000 Direct materials purchases 434,928 $ 649,584 $ 696,336 $ 543,408 Assume all sales are made on credit. The company expects to collect 80 percent of sales in the quarter of sale and 20 percent the quarter following the sale. Accounts receivable at the end of last year totaled $600,000, all of which will be collected in the first quarter of the coming year. Assume all direct materials purchases are on credit. The company expects to pay 90 percent of purchases in the quarter of purchase and 10 percent the following quarter. Accounts payable at the end of last year totaled $45,000, all of which will be paid in the first quarter of this coming year. Required: a. Prepare a budget for cash collections from sales for Car Products, Inc. Use a format similar to the top section of Figure 9.5. b. Prepare a budget for cash payments for purchases of materials for Car Products, Inc. Use a format similar to the middle section of Figure 9.5. Round to the nearest dollar.

31. Budgets for Cash Collections from Sales and Cash Payments for Purchases. Car Products, Inc., produces car covers. The dollar amount of the company's quarterly sales and direct materials purchases are projected to be as follows (this information is derived from the previous exercises): 1st 2nd 3rd 4th Sales $ 3,510,000 $ 5,850,000 $ 7,020,000 $ 4,680,000 Direct materials purchases 434,928 $ 649,584 $ 696,336 $ 543,408 Assume all sales are made on credit. The company expects to collect 80 percent of sales in the quarter of sale and 20 percent the quarter following the sale. Accounts receivable at the end of last year totaled $600,000, all of which will be collected in the first quarter of the coming year. Assume all direct materials purchases are on credit. The company expects to pay 90 percent of purchases in the quarter of purchase and 10 percent the following quarter. Accounts payable at the end of last year totaled $45,000, all of which will be paid in the first quarter of this coming year. Required: a. Prepare a budget for cash collections from sales for Car Products, Inc. Use a format similar to the top section of Figure 9.5. b. Prepare a budget for cash payments for purchases of materials for Car Products, Inc. Use a format similar to the middle section of Figure 9.5. Round to the nearest dollar.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 13EA: What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the...

See similar textbooks

Similar questions

What is the amount of budgeted cash payments if purchases are budgeted for $190,500 and the beginning and ending balances of accounts payable are $21,000 and $25,000, respectively?
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: September October November Sales $135,000 $162,000 $225,000 Manufacturing costs 57,000 70,000 81,000 Selling and administrative 47,000 49,000 86,000 expenses Capital expenditures 54,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 $10,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…
Calculate cash? Calculate Accounts Payable? Please show formulas and calculations in spreasheet
ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…
Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
(a) For the current year, Encor Ltd. had net sales of $450,000 and paid $260,000 for the cost of goods sold. They had average receivables of $130,000, average payables of $57,000, and an average inventory of $90,000. Calculate the Operating cycle and Cash cycle for Encor Ltd. Interpret the results. (b) Prepare a Cash Budget based on the info below for the year 2020 for the months of January, February, March, and April. - Encor Ltd., anticipates sales of $18,000 in January 2020, with anticipated growth of 10% per month; - Credit sales are paid 50% the same month and 50% the following month (credit sales for December 2019 was $14,000) - Credit purchases are paid 35% of sales; paid in the month they are incurred - Wages and expenses are 30% of sales every month; paid in the month they are incurred - In February, the company pays $27,000 cash for new equipment - The beginning cash balance is $13,000
A cash budget, by quarters, is given below for a retail company. (000 omitted) company requires a minimum cash balance of at least Br 5,000to start each quarter. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Cash balance, beginning 6 ? ? ? ? Add collections from customers ? ? 96 ? 323 Total cash available 71 ? ? ? ? Less disbursement: Purchase inventory 35 45 ? 35 ? Operating expense ? 30 30 ? 113 Equipment purchase 8 8 10 ? 36 Dividends 2 2 2 2 ? Total disbursement ? 85 ? ? ? Excess (deficiency) of each cash (2) ? 11 ? ? Financing: Borrowing ? 15 - - ? Repayments (including interest) - - ? (17) ? Total financing ? ? ? ? ? Cash balance, ending ? ? ? ? ?
Your data collection has yielded the following: (i) Extracts from the sales and purchases budgets are as follows: Month November 2023 - March 2024 Cash Sales Sales on Account Purchases November $151,000 $480,000 $375,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $508,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $521,000 An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 2/30, n90:45% in the month of sale30% in the first month following the sale.25% in the second month following the sale. (iii) Expected purchases include cash purchases of $28,000 in January and $21, 000 in March.All other purchases are on account. Accounts payable are settled as follows, in accordancewith the credit terms 4/30, n60:75% in the month in which the inventory is purchased.25% in the following month (iv) The management of Toyota &…
Estimate manufacturing costs and operating expenses Purchases (material) budget Personnel budget Overhead budget Selling and administrative budget
the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
I ne Tollowing information is available from various budgets for the current period: Account Cash Accounts Receivable Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense - Equipment (expense incurred during the period) Budget Cash budget Amount $20,000 Schedule of cash receipts from customers 38,000 Inventory, purchases, and cost of goods sold budget 47,000 Selling and administrative expense budget 2,000 Capital expenditures budget 31,000 Selling and administrative expense budget 1,000 The following balances are available from the balance sheet at the end of the previous year: Prepaid Insurance Equipment Accumulated Depreciation Equipment $6,000 22,000 1,000 What would be the amount of total assets on the budgeted balance sheet?
QUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…