ZuoTi.Pro
Question

Management of Pand Corporation requested a cash budget for the coming quarter, January through March 2020. The budget is to be prepared form the following data: November December January February March Sales on $60.000 $70.000 $50.000 $60.000 $70.000 acco

Management of Pand Corporation requested a cash budget for the coming quarter, January through March 2020. 

The budget is to be prepared form the following data: November December January February March Sales on $60.000 $70.000 $50.000 $60.000 $70.000

 account Payroll $20.000 $22.000 $21.000 $22.000 $23.000 

Purchases on $15.000 $20.000 $15.000 $25.000 $20.000 

account Depreciation $5.000 $5.000 $5,000 $5,000 $5,000 Misc.cash $5.000 $6.000 $6.000 $7.000 $6.000 

operating exp Debt retirement $0 $26.000 $0 SO $26.000 

Collections of accounts receivable amount to 25% in the month of sale, 60% in the first month after sales, 10% in the second month after sales and 5% written off as uncollectible. Purchases are paid off at the race of 20% in the month of purchase and 80% in the first month following purchase. Cash on hand at January 1, is $6.000.

0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Management of Pand Corporation requested a cash budget for the coming quarter, January through March 2020. The budget is to be prepared form the following data: November December January February March Sales on $60.000 $70.000 $50.000 $60.000 $70.000 acco
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Q 3. Prepare the cash budget of the company from January to June based on the...

    Q 3. Prepare the cash budget of the company from January to June based on the following (15) information.(Rs.in lakh) Production Overheads 6.000 Month January February March April May June Sales 72.000 97,000 86,000 88,600 102,500 108,700 Material Purchases 25,000 31,000 25,500 30.600 37,000 38,800 Salaries & wages 10,000 12.100 10.600 25.000 22.000 23.000 6,300 6,000 6,500 8,000 8,200 Office & Sedligads 5,500 6.700 7.500 8.900 11,000 11,500 The opening cash balance for the year may be taken as Rs.72,500...

  • Please make a cash budget for the months of January, February and March 1999 based on the data for

    HASF PVT.LTDBUDGETED INCOME STATEMENTFOR 1st QUARTER 1999Description JANUARY FEBRUARY MARCHSales 285,000 323,000 221,000Purchases 129,000 168,000 95,000Wages 35,000 37,000 30,000Supplies 26,000 23,000 21,500Utilities 6,500 8,700 7,200Rent 15,000 12,800 13,600Insurance 12,000 12,000 12,000Advertising 24,500 28,500 18,000Depreciation 20,000 20,000 20,000Net Profit 17,000 13,000 3,700Required:a. Please make a cash budget for the months of January, February and March 1999 based onthe data for: (5 Marks)View Receivable Trend:• 30% of Sales are collected in the month of sale• 30% of Sales are collected after the...

  • Please make a cash budget for the months of January, February and March 1999 based on the data for

    HASF PVT.LTDBUDGETED INCOME STATEMENTFOR 1st QUARTER 1999DescriptionJANUARYFEBRUARYMARCHSales285,000323,000221,000Purchases129,000168,00095,000Wages35,00037,00030,000Supplies26,00023,00021,500Utilities6,5008,7007,200Rent15,00012,80013,600Insurance12,00012,00012,000Advertising24,50028,50018,000Depreciation20,00020,00020,000Net Profit17,00013,0003,700Required:Please make a cash budget for the months of January, February and March 1999 based on the data for: (5 Marks)View Receivable Trend:30% of Sales are collected in the month of sale30% of Sales are collected after the month of sale40% of Sales are collected two months after the sale is madeView Payable Trend:10% of Purchases are paid for in the month of purchase35% of Purchases are paid after the month of purchase55%...

  • Allan Corporation has a sales budget for March of $440,000. About 10% are cash sales and...

    Allan Corporation has a sales budget for March of $440,000. About 10% are cash sales and the remainder is sold on account. The company expects that 60% of credit sales will be collected in the month of the sale, 25% in the next month and 10% in the following month. Materials purchased on account are expected to be $250,000. Allan pays 35% in the month of the purchase, 50% in the month following the purchase and the remaining 15% in...

  • provided Nove Budgeted 2020 Sales: Water bottles February 7,000 produce a cash budger for March January 8.000 8...

    provided Nove Budgeted 2020 Sales: Water bottles February 7,000 produce a cash budger for March January 8.000 8,000 April 10,000 Additional information for your budget preparation is as follows: a) Because of increased competition the average sales price per water bottle in 2020 is expected to drop to b) Wonderful Water bottles has a policy that each month's ending inventory of finished goods (water bottles) $15.00 per bottle should be 20% of the following month's sales in units. Ending inventory...

  • 4. Cash Budget (20 points) The following information pertains to Monroe Company: Month December January February...

    4. Cash Budget (20 points) The following information pertains to Monroe Company: Month December January February March Sales $130,000 $68,000 $87,000 $106,000 Purchases $65,000 $35,000 $46,000 $48,000 • Cash is collected from customers in the following manner: o Month of sale 30% o Month following the sale 65% o Written off as uncollectible 5% 45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 20% of...

  • 4. Cash Budget (20 points) The following information pertains to Monroe Company: Month December January February...

    4. Cash Budget (20 points) The following information pertains to Monroe Company: Month December January February March Sales Purchases $130,000 $65,000 $68,000 $35,000 $87,000 $46,000 $106,000 $48,000 Cash is collected from customers in the following manner: Month of sale 30% Month following the sale 65% Written off as uncollectible 5% .45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 20% of sales. Other operating costs...

  • To prepare a master budget for January, February, and March of 2018, management gathers the following...

    To prepare a master budget for January, February, and March of 2018, management gathers the following information. a. Blue Group’s single product is purchased for $30 per unit and resold for $57 per unit. The expected inventory level of 4,500 units on December 31, 2017, is more than management’s desired level for 2018, which is 20% of the next month’s expected sales (in units). Expected sales are: January, 8,250 units; February, 9,750 units; March, 12,025 units; and April, 10,500 units....

  • 1) Prepare a schedule of cash collections for ianuary February and March, and for the quarter...

    1) Prepare a schedule of cash collections for ianuary February and March, and for the quarter in totall. Use the following format: Quarter 27500 16000 25070 February March 24000 29700 Credit Sales 64400 Total cash collection 71000 33600 100 (2) Prepare a production budget, using the following format January February March 9900 Plus: Der ending investory 210 275 2425 Total needed 10100 11675 12325 Less: Beginning inventory 2000 Units to produce 9850 *Hunt: Units sales Sales in dollars/Seng price per...

  • CASH BUDGET WITH EXPLANATION Budget Information. December 2017 - March 2018 our bank account Assignment 5...

    CASH BUDGET WITH EXPLANATION Budget Information. December 2017 - March 2018 our bank account Assignment 5 Part A THE CASH BUDGET WITH EXPLANATION Millennium Corporation Cash Budget Information - December 2017 - March 2018 Budget Items Total Sales Credit Sales December 1.200.000 1.080.000 January Jar 1.500.000 1.350.000 February 1300000 1,300,000 1.170,000 March 1,400,000 1,260,000 300.000 30.000 15.000 310,000 30,000 16,000 Wages & Salaries Rentals Other Expenses Taxes Paid Dividends Equipment Purchase Cash Balance 325,000 30.000 17.000 150,000 50.000 declared 90,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT