Question

In: Accounting

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 are collected two months after the sale is made

Manal Payable Trend:
10% of Purchases are paid for in the month of purchase, 35% of Purchases are paid after the month of purchase, and 55% of Purchases are paid two months after the purchase is made

Additional Information:

Rent and Insurance expense were prepaid at the end of 2020
All other expenses are paid for in the month they were incurred

November Sales = 195,000 November Purchases = 100,000
December Sales = 250,000 December Purchases = 165,000

Please see attached Budgeted Income Statement for 1st Quarter 2020

Required:
Calculate to show Jan-Mar 2020 cash collection from sale, cash payment of purchases and total expenses each month separately on the basis of above given data.

Solutions

Expert Solution


Related Solutions

Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000...
Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production in units 19,600 20,600 19,300   One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 25% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Garrison 16e Rechecks 2017-10-03 Multiple Choice 20,925 pounds 20,575 pounds 20,275 pounds 18,325 pounds , Depasquale Corporation is...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in units 18,500 19,500 17,400 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 19,970 pounds 18,630 pounds 18,870 pounds 20,130 pounds
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000...
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000 respectively. Cash sales are normally 25% of total sales. Of the credit sales, 40% are collected in the same month as the sale, and 60% are collected during the first month after the sale. Compute the amount of cash received from sales during the month of February.
The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in...
The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in units 18,200 19,200 17,100 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 18,630 pounds 19,830 pounds 19,670 pounds 18,570 pounds
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...
The following credit sales are budgeted by Sheridan Electronics: January $123600 February 120000 March 135600 April...
The following credit sales are budgeted by Sheridan Electronics: January $123600 February 120000 March 135600 April 141000 May 141300 The company's past experience indicates that 50% of the accounts receivable are collected in the month of sale, 30% in the month following the sale, and 19% in the second month following the sale. 1 percent are uncollectible. How much does the company anticipate as cash receipts for March? $134244 $127284 $136947 $123564
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT