Help finding plus collections from accounts receivable
The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $48,000.
Required
Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent and 4 percent. The results at a growth rate of 1 percent are shown as an example.
| Sales Budget | |||
| January | February | March | |
|---|---|---|---|
| Cash sales | $ 210,000 | $ 10,100 | $ 10,201 |
| Sales on account | 50,000 | 50,500 | 51,005 |
| Total budgeted sales | $ 60,000 | $ 60,600 | $ 61,206 |
| Schedule of Cash Receipts | |||
| January | February | March | |
|---|---|---|---|
| Current cash sales | $ 10,000 | $ 10,100 | $ 10,201 |
| Plus collections from accounts receivable | 48,000 | 50,000 | 50,500 |
| Total budgeted collections | $ 58,000 | $ 60,100 | $ 60,701 |
Use the following forms, assuming a growth rate of 2 percent and 4 percent:
Homework Answers
Request Answer!
We need at least 9 more requests to produce the answer.
1 / 10 have requested this problem solution
The more requests, the faster the answer.
The management team of Stuart Modems, Inc. (SMI) wants to investigate the effect of several different...
The management team of Stuart Modems, Inc. (SMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $160,000. Credit sales for January are expected to be $800,000. SMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $768,000 Required Calculate the amount of sales and cash receipts for the months...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $200,000 February 290,000 March 400,000 All sales are on account. 55% of sales are expected to be collected in the month of the sale, 41% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash...
Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a...
Prepare a schedule of budgeted cash collections from sales for
May, June, and July. Include a three-month summary of estimated
cash collections.
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: • 60 percent in the month of...
E22-26 (similar to) Question Help o Marlin Company projects the following sales for the first three...
E22-26 (similar to) Question Help o Marlin Company projects the following sales for the first three months of the year: $12,600 in January: $10,100 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...
60 percent of sales for credit and collections occur after thirty days. A $5000 CD matures...
60 percent of sales for credit and collections occur after thirty days. A $5000 CD matures in March. Monthly fixed disbursements are $10,000. Variable disbursements are 35 percent of sales and are based on next month's sales. A tax payment of $9,500 is due in January. The ending cash in December is $15,000. Sales in December were $60,000. April sales are $30,000 January February March Sales $50,000 $45,000 $35,000 Cash Sales Collections Other Receipts Total Cash Receipts Variable Disbursements Fixed...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows January February Sales $363,600 $404,000 Direct materials purchases 121,200 126.250 Direct labor 90,900 101.000 Manufacturing overhead 70,700 75,750 Selling and administrative expenses 79.790 85,850 All sales are on account, Collections are expected to be 50% in the month of sale, 30 % in the first month following the sale, and 20% in the second month following the sale, Sixty percent (60%) of direct materials...
Part 2: Avery Company projects the following sales for the first three months of the year:...
Part 2:
Avery Company projects the following sales for the first three months of the year: $15,800 in January; $10,100 in February; and $10,400 in March. The company expects 60% 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. 1. Prepare a schedule of...
Laura Falk, Bramble & Hill Fabricators' accounts receivable manager, has just received the company's sales budget...
Laura Falk, Bramble & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February $254.800 $496.860 March Quarter $445.900 $1,197,560 Budgeted revenue The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 70% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 4% of sales are uncollectible. The company expects to...
Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on...
Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $28,000. Total payments in January 20x1 are budgeted at $225,000. • A schedule of cash collections for January and February of 20x1 revealed the following...
expected collections from customers
6. Marmul Packaging Company prepares monthly cash budgets.Relevant data from operating budgets for 2020 are:January (S) February(S)700,000 800,000170,000250,000120.000150,000160,000SalesDirect laborManufacturing overhead150.000Selling and administrative exp.Other data:a) Payment for Purchase of Direct Material for January is$174,000 and Feb. $178,000.(b) Credit sales: December 2019, $560,000.c) Other receipts: January - Collection of interest receivable$8,000;February-Proceeds from saleof securities $30,000.(d) Other disbursements: February - payment of $70,000for landAll sales are on account. Collections are expected to be 60%in the month of sale, 30% in the first month...
The management team of Stuart Modems, Inc. (SMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $160,000. Credit sales for January are expected to be $800,000. SMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $768,000 Required Calculate the amount of sales and cash receipts for the months...
Prepare a schedule of budgeted cash collections from sales for
May, June, and July. Include a three-month summary of estimated
cash collections.
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: • 60 percent in the month of...
E22-26 (similar to) Question Help o Marlin Company projects the following sales for the first three months of the year: $12,600 in January: $10,100 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...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows January February Sales $363,600 $404,000 Direct materials purchases 121,200 126.250 Direct labor 90,900 101.000 Manufacturing overhead 70,700 75,750 Selling and administrative expenses 79.790 85,850 All sales are on account, Collections are expected to be 50% in the month of sale, 30 % in the first month following the sale, and 20% in the second month following the sale, Sixty percent (60%) of direct materials...
Part 2:
Avery Company projects the following sales for the first three months of the year: $15,800 in January; $10,100 in February; and $10,400 in March. The company expects 60% 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. 1. Prepare a schedule of...
Laura Falk, Bramble & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February $254.800 $496.860 March Quarter $445.900 $1,197,560 Budgeted revenue The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 70% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 4% of sales are uncollectible. The company expects to...
Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $28,000. Total payments in January 20x1 are budgeted at $225,000. • A schedule of cash collections for January and February of 20x1 revealed the following...
Most questions answered within 3 hours.
-
What is the Br∅nsted-Lowry base reactant in the following
chemical reactio:
C5H5N(aq) + H2O(l) ⇌ C5H5NH+(aq)+OH-(aq)?...
asked 46 seconds ago -
A comparison between the Cp and Cpk for a
process would find which of the following...
asked 6 minutes ago -
7. Your grandfather left an inheritance for you of $50,000.
However you can only drawdown on...
asked 31 minutes ago -
An assumption of Theory X is that: Question 2 options: people
can exercise self-direction and self-control...
asked 30 minutes ago -
What is Polanyi's critique of Smith and economic liberalism?
asked 34 minutes ago -
Calculate the pH and the equilibrium concentrations of
H2C6H5O7-, HC6H5O72- and C6H5O73- in a 0.1840 M...
asked 42 minutes ago -
How many moles of copper II ion, Cu2+, are present in 200 mL of
a .250...
asked 46 minutes ago -
Use the properties of Boolean Algebra to reduce the following
Boolean expression to the simplest form...
asked 47 minutes ago -
This picture is a visual representation of helium. Write the
chemical formula for helium.
asked 49 minutes ago -
1. Sample Mean:
mens- 27.91
women - 31.57
2. Standard Deviation
men- 0.664
women- 1.167
Sample...
asked 59 minutes ago -
Needs Help with Java Programming language!
Lights Camera
Action Purpose: To learn the basics of linked...
asked 57 minutes ago -
Please answer my questions:
True or False and Explain
5)In a perfectly competitive market, if price...
asked 1 hour ago