November December January February March Sales $9,500 $10,000 $11,000 $12,100 $13,310 All sales are for credit, with 80% collected the following month and 20% collected during the second month. Purchases of raw materials equals 60% of sales. Purchases are made in the month of the sale, but suppliers are paid in the month following the purchase. Wages are $1,000 per month, rent is $1,500, taxes are $500, and a $1,000 loan payment is due in February. Monthly interest expense is $200. What are the net cash flows in January, February, and March?
Q: Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. Sales units…
A: Hi student Since there are multiple subparts, we will answer only first three subparts.
Q: Information pertaining to Collection Corporation's sales revenue is presented below: November…
A: The budget is prepared to estimate the requirements for the period. The cash payment schedule is…
Q: Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the…
A: It's part of Budgeting which forms integral part of business.
Q: Assume a merchandising company’s estimated sales for January, February, and March are $106,000,…
A: Cash disbursements for February = (Budgeted purchases for January X 75%) + (Budgeted purchases for…
Q: The management of Sheffield Industries estimates that credit sales for August, September, October,…
A: Cash collection means the amount of money estimated to be collected by the entity from the sales of…
Q: Marcel Company projects the following sales for the first three months of the year: $13,500 in…
A: Cash budget: It implies to a financial estimation that reflects all the inflows and outflows of cash…
Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January,…
A: Cash Budget is an estimation of the cash inflows and cash outflows for the future period for that…
Q: Cash is collected from customers in the following manner: - Month of sale 30% - Month following the…
A: Cash payment to supplier is the amount of cash paid to supplier for the purchase made during the…
Q: Shredder Manufacturing has the following projected unit sales (at $18 per unit) for four months of…
A: Budgeting is a process of estimating future receipts and payments so that appropriate decisions can…
Q: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…
A: In this case of Halifax shoes, it is given that there are a certain fixed proportion of credit…
Q: The following information pertains to Monroe Company: Month Sales Purchases January $62,000 $33,000…
A: Purchases may be made in cash or by credit. The credit purchases have to be paid for in the months…
Q: Assume a merchandising company's estimated sales for January, February, and March are $105,000,…
A:
Q: A company’s sales on account for the coming months are as follows: May $120,000 June $126,000…
A: Expected cash receipts in July- Cash receipts of July received in the same month= $132,300 *70% i.e…
Q: Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in…
A: Working Note Particulars January February March Total Budgeted Sales 11,500…
Q: Lindell Company made direct materials purchases of $50,200 and $62,200 in September and October,…
A: The objective of the question is to calculate the total cash paid for purchases in October by…
Q: Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: es March…
A: The production budget is a part of the master budget that estimates the unit should be produced…
Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,200 in January,…
A: The cash budget refers to the statement prepared by the management estimating future possible cash…
Q: Cnton Company sells air purifiers to customers for $150 per unit. An overseas company supplies the…
A: Hi student Since there are multiple questions, we will answer only first question.
Q: Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the…
A: Cash payments budget is one of the important budget prepared in business, which shows expected cash…
Q: The Constantine Corporation purchases robes for $12 per unit and then sells them for $25 per unit.…
A: Budget means the expected value for future. Budget is prepared for future and actual value is…
Q: Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the…
A: The cash payment schedule is the statement with all the cash payments from the business stating all…
Q: es Shadee Corporation expects to sell 560 sun shades in May and 410 in June. Each shades sells for…
A: CASH BUDGETA cash budget is an estimation of the cash flows of a business over a specific period of…
Q: Eastern Auto Parts Incorporated has 20 percent of its sales paid for in cash and 80 percent on…
A: Cash receipts schedule are those schedule how much cash we collected in a particular months or…
Q: Simpson Glove Company has made the following sales projections for the next six months. All sales…
A: Answer - The Cash Receipts Schedule - A cash receipts schedule/ budget shows the pattern and…
Q: Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January,…
A: A cash budget is an estimation of the cash flows of a business over a specific period of time. This…
Q: Cromwell Company is a distributor that sells products to retail companies. The company sells one…
A: Purchase during a month=sales in that month+closing inventory-opening inventory purchase price per…
Q: At the end of September a company has cash balance of $800, trade receivables of $12000 and trade…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: Shadee Corporation expects to sell 580 sun shades in May and 410 in June. Each shades sells for $15.…
A: In accounting, budgeting refers to the process of creating a financial plan for a specific period,…
Q: Shadee Corporation expects to sell 500 sun shades in May and 440 in June. Each shades sells for $19.…
A: CASH BUDGET A cash budget is an estimation of the cash flows of a business over a specific period of…
Q: A company's data regarding its operations follow: 1. Sales budget November $360,000 December…
A: The net income is transferred from the income statement to the retained earnings.. Dividends are…
Q: OfficeMart Inc. has “cash and carry” customers and credit customers. OfficeMart estimates that 30%…
A: A cash collection schedule means showing a pattern in which a business expects to collect cash from…
Q: How much cash will be collected in January? In February? In March? For the quarter in total?
A: WORKING NOTE November December January Febuary March Sales revenue 16,500…
Q: Simpson Glove Company has made the following sales projections for the next six months. All sales…
A: Cash budgets are prepared the management to estimate the total amount of receipts and collections…
Q: ge Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected…
A: Cash Receipts from Customers is based on budgeted cash receipts that is estimated on specific…
Q: The Constantine Corporation purchases robes for $12 per unit and then sells them for $25 per unit.…
A: Lets understand the basics.Management prepares budget in order estimate future profit from the…
Q: Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the…
A: Given, 70% of March purchases are paid in March 30% of February purchases are paid in March
Q: Suits Inc. expect to sell 8,500 units for $190 each in January, 2,500 suits for $200 each in…
A: Cash receipts refers to a form of evidence of purchased issued by the buyer when paid in cash. It is…
Q: The management of Marigold Industries estimates that credit sales for August, September, October,…
A: The cash collection is done as per the collection schedule. Collection for October include 25% of…
Q: Graham Company projects the following sales for the first three months of the year: $10,600 in…
A: The cash collection schedule is prepared to estimate the amount of cash to be collected from…
Q: Office World Inc. has “cash and carry” customers and credit customers. Office World estimates that…
A: The Schedule of Collections from Sales shows the amount to be collected from the customers during a…
Q: Assume a merchandising company's estimated sales for January, February, and March are $107,000, $…
A: The budget is prepared to estimate the requirements for the period. The purchase budget is prepared…
Q: Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May…
A: “Since you have posted multiple questions with multiple sub parts, we will provide the solution only…
Q: Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are…
A: The objective of the question is to calculate the total cash receipts for Page Company in Month 4.…
Q: Ed’s Waterbeds has made the following sales projections for the next six months. All sales are…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: The Constantine Corporation purchases robes for $12 per unit and then sells them for $25 per unit.…
A: The projected ending inventory for March is calculated as follows:Projected Ending Inventory for…
Unlock instant AI solutions
Tap the button
to generate a solution
Click the button to generate
a solution
- Brooklyn Studio's sales are all made on account. The firm's collection experience has been that 29% of a month's sales are collected in the month the sale is made, 52% are collected in the month following the sale, and 17% are collected in the second month following the sale. The sales forecast for the months of September through December is as follows: September October November December $ 236,000 285,000 307,000 369,000 Required: Calculate the cash collections that would be included in the cash budgets for November and December. November December Cash Collections 4The Lumber Yard has projected the sales below for the next four months. The company collects 37 percent of i sales in the month of sale, 44 percent in the month following the month of sale, 16 percent two months after the month of sale, and never collects 3 percent of its sales. How much will the company collect in April? April January February March Sales $137,900 $144,400 $151,975 $166,000 Multiple Choice O $152,375 $155,530 $119,767 $148,365Lindor Enterprises projects sales for the first three months of the year to be: $10,100 in January, $12,400 in February, and $12,900 in March. Cash receipts are expected to be: $8,450 in January, $11,770 in February, and $12,810 in March.They anticipate the following cash payments: Lindor Enterprises January February March Direct materials purchased $3,500 $4,000 $4,900 Direct labor costs $3,000 $4,100 $3,600 Depreciation on plant $510 $510 $510 Utilities for plant $650 $650 $650 Property taxes on plant $140 $140 $140 Depreciation on office $560 $560 $560 Utilities for office $370 $370 $370 Property taxes on office $170 $170 $170 Office salaries $2,900 $2,900 $2,900 All costs are paid in the month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a…
- Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) . 4,000 $ 720,000 May (actual) 2,000 360,000 June (budgeted) . 6,000 1,080,000 July (budgeted) 5,000 900,000 August (budgeted) . 3,800 684,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 28% in the second month after the sale, and 2% proves to be uncollectible. The product’s purchase price is $110 per unit. 60% of purchases made in a month is paid in that month and the other 40% is paid in the next month. The company has a policy to maintain an ending monthly inventory of 20% of the next month’s unit sales plus a safety stock of 100 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are $1,320,000 and are paid evenly throughout the year in cash. The company’s minimum cash balance at…Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 6,000 4,100 $ 900,000 2,400 5,000 $360,000 $750,000 $ 615,000 Sales units Sales dollars. All sales are on credit. Collections are as follows: 24% is collected in the month of the sale, and the remaining 76% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 22% of the next month's unit sales. The May 31 actual inventory level of 1,320 units is consistent with this policy. Selling and administrative expenses of $114,000 per month are paid in cash. The company's minimum cash balance at month-end is $140,000. Loans are obtained at the end of any month when the preliminary cash balance is below $140,000. Any preliminary cash…Eastern Auto Parts Inc. has 20 percent of its sales paid for in cash and 80 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January February March April $ 82,000 72,000 117,000 62,000 Sales in December of the prior year were $92,000. Prepare a cash receipts schedule for January through April. Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts Eastern Auto Parts Inc. February January $ 80,000 $ March 81,000 $ April 106,000
- Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $74,000 in June, $68,000 in July, and $88,000 in August? Cash collected $fill in the blank 1Dick's Draperies has gross sales $15,000 per month, half of which are on credit (paid with 30 days). Monthly expenses are as follows: wages, $3,000; utilities and rent, $2,000; advertising, $300; and miscellaneous, $500, inventory is purchased every three months and totals $30,000 for each order. Yearly expenses paid for in advance are insurance of $1,000 and a rent deposit of $700. Prepare a six-month cash flow statement for Dick's Draperies. What advice would you give this business based on the cash flow statement?Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
- Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 12,000 June $ 14,000 April 16,000 July 17,000 May 10,000 August 18,000 Sales in January and February were $13, 500 and $13,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a. Prepare a monthly cash receipts schedule for the firm for March through August. Ed's Waterbeds Cash Receipts Schedule January February March April May June July August Sales $ $ $ $ $ $ $ $ Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ $ $ $ $$b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? Amount…Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 80 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter. July August September 545 450 430 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale. 40 percent is collected during the following month, and 8 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August SeptemberWiggles Right forecasted sales of $5,000 in October, $4,000 in November, and $4,000 in December. All sales are on credit. 40% is collected the month of sale, and the remainder the following month. How much is collected from accounts receivable in November? Group of answer choices $6,000 $4,600 $5,400 $4,800