Question

In: Accounting

Flatiron Corp has the following budgeted sales in each quarter of the year 2020: Expected Sales...

Flatiron Corp has the following budgeted sales in each quarter of the year 2020:

Expected Sales

Q1 $ 300,000

Q2 $ 320,000

Q3 $ 340,000

Q4 $ 360,000

Cash collection information are as follows:

1. Of all sales, 80% are on credit.

2. For the credit sales made in the year 2020; 60% of credit sales are collected in the quarter in which the sale is made; 30% are collected in the following quarter; and 10% are collected in the second quarter after sale.

3. Accounts Receivable is estimated to be $60,000 on December 31,2019. The company expects to collect all outstanding receivable in the first quarter of 2020.

What is the total cash collection for the first quarter of 2020?

Expert Solution

Given Information,

Q1 Expencted Sales is $ 3,00,000

Sales pattern is as follows:

80% on credit, other way 20% on cash.

For Credit Sales Collection:

60% Collected in Same Quarter in which sale is made

30% Collected in following Quarter

10% are collected in the second quarter after sale

The company expects to collect all outstanding receivable i.e $ 60,000 in the first quarter of 2020

Expected Total Sale Quarter 1	Cash Sale	Cash Sale	Credit Sale	Credit Sale
$ 3,00,000	20%	$ 60,000	80%	$ 2,40,000

Total Cash Collection for the First Quarter of 2020 is as follows:

Particular	Amount
Cash Sales (20% of Q1 Sales)	$ 60,000
60% of Q1 Credit Sale ( $ 2,40,000*60%)	$ 1,44,000
Outstanding accounts receivable	$ 60,000
Total Cash Collection for the Q1	$ 2,64,000

Thus, Total Cash Collection for the First Quarter of 2020 is $ 2,64,000

ekkarill92 answered 2 years ago

AH Corp has the following budgeted unit sales for the second half of the 2020: Month...

AH Corp has the following budgeted unit sales for the second half of the 2020: Month Unit Sales July 90,000 August 120,000 September 210,000 October 150,000 November 180,000 December 120,000 It is expected to have 30,000 units of finished goods in inventory at the beginning of budget period and the plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced....

Coliseum Company has budgeted the following unit sales: Quarter Units Qtr. 1, 2020 60,000 Qtr. 2,...

Coliseum Company has budgeted the following unit sales: Quarter Units Qtr. 1, 2020 60,000 Qtr. 2, 2020 50,000 Qtr. 3, 2020 40,000 Qtr. 4, 2020 80,000 The finished goods inventory on hand on December 31, 2019 was 6,000 units. 90% of the next quarter’s sales will come from production during that quarter, and the remainder of next quarter’s sales will come from this quarter’s ending inventory. Required: Prepare a production budget for the first two quarters of 2020. Include totals...

The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4 Sales...

The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4 Sales 10,000 12,000 14,000 16,000The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,200 pounds. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's...

A) Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019...

A) Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000 3rd Quarter 2019 4,000 Beginning finished goods for the first quarter was 1,400 units. The company's policy is to maintain an inventory of finished goods as 20% of the next quarter sales. The production budget for the SECOND quarter is __________. (no dollar signs, decimals or commas) HINT: you must calculate the first quarter in order to calculate the 2nd quarter. B)JTS Corp...

Starfish Industries’ sales budget for the first quarter of the upcoming year shows budgeted sales of...

Starfish Industries’ sales budget for the first quarter of the upcoming year shows budgeted sales of $325,000, $350,000, and $310,000 in January, February, and March, respectively. All sales are made on credit. The cash receipts budget for March shows total cash receipts equal to $306,840. Starfish grants a discount to customers who pay within 10 days of the invoice. Starfish collects 60% of sales within the discount period, 20% in the month of sale but outside the discount period, 20%...

Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000...

Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000 3rd Quarter 2019 4,000 Beginning finished goods for the first quarter was 1,400 units. The company's policy is to maintain an inventory of finished goods as 20% of the next quarter sales. The production budget for the SECOND quarter is __________. (no dollar signs, decimals or commas) HINT: you must calculate the first quarter in order to calculate the 2nd quarter.

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales...

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 Selling price per unit $7 per unit 1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...

Manal Pvt.Ltd. budgeted income statement for 1st quarter 2020 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000...

Manal Pvt.Ltd. budgeted income statement for 1st quarter 2020 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000 221,000 Purchases 129,000 168,000 95,000 Wages 35,000 37,000 30,000 Supplies 26,000 23,000 21,500 Utilities 6,500 8,700 7,200 Rent 15,000 12,800 13,600 Insurance 12,000 12,000 12,000 Advertising 24,500 28,500 18,000 Depreciation 20,000 20,000 20,000 Net Profit 17,000 13,000 3,700 Manal Receivable Trend: 30% of Sales are collected in the month of sale, 30% of Sales are collected after the month of sale. 40% of Sales...

1.Budgeted units to be sold for each quarter: 1000, 1200, 1500 and 2000 for the year...

1.Budgeted units to be sold for each quarter: 1000, 1200, 1500 and 2000 for the year 2018 and 2019. Assume that company policy requires 20% of the next quarter’s sales in ending inventory and that beginning inventory of t-shirts for the first quarter of the year was 180. The unit selling price of t-shirt is $10. 2. Budgeted units to be produced for each quarter: 1060, 1260, 1600, and 1800. Plain t- shirts cost $3 each, and ink costs $0.20...

For the second quarter of the following year Cloaks Company has projected sales and production in...

For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...