Prepare schedule of projected monthly cash receipts

Assignment Help Managerial Accounting
Reference no: EM132785643

Question 1 - Cash Receipts Budget - Colecta Company wants to determine the expected monthly cash receipts during the last quarter of the current year. The cash receipts are expected to come mainly from cash sales and collection of accounts receivable.

Based on the company's experience, total sales consist of 30% cash, the balance is on account. Collection of accounts receivable follows this pattern.

50% in the month of sale

30% in the month following the month of sale

18% in the second month following the month of sale

2% uncollectible

Actual and projected sales were given as follows:

July 350,000

August 420,000

September 380,000

October 530,000

November 610,000

December 750,000

In October, the company expects to finalize its negotiations for the sale of its piece of land at three times its book value of 250,000.

Before ethe end of the current month, it was learned that a customer, deemed by the company's management to have died already because of about a year's absence, is still alive. The customer owes Colecta company an amount of 50,000 which has already been written off from the accounts.

Required - Prepare schedule of projected monthly cash receipts for the last quarter of the current year.

Question 2 - The following information was available from Kadune Corporation's books:

2020

Purchases

Sales

January

42,000

72,000

February

48,000

66,000

March

36,000

60,000

April

54,000

78,000

Collections from customers are normally 70% in the month of sale, 20% in the month following the sale, and 9% in the second month following the sale. The balance is expected to be uncollectible. Kadune takes full advantage of the 2% discount allowed on purchases paid for by the tenth of the following month. Purchases for May are budgeted at 60,000, while sales for May are forecasted at 66,000. Cash disbursements for expenses are expected to be 14,400 for the month of May. Kadune's cash balance at May 1 was 22,000.

Required - Prepare the following schedules:

1. Expected cash collections during May.

2. Expected cash disbursements during May.

Reference no: EM132785643

Questions Cloud

Calculate the amortization expense of the entity : The entity paid $100,000 for paving the land. It was ready for its intended use on May 31, 2000. Calculate the amortization expense of the entity
What the share premium account is credited for : What the share premium account is credited for? On June 26, 2019. Rosada Corp. issues a 30% share dividend on its 200,000 shares of Pio par value
How much must Charlie save annually : Using an interest rate of 10%, how much must Charlie save annually during year end in order to have his retirement annuity 30 years from now
Determine the amount of the impairment loss : Cantika corp is a cosmetics industry. Determine the amount of the impairment loss that needs to be recognized by December 31, 2021.
Prepare schedule of projected monthly cash receipts : Cash Receipts Budget - Prepare schedule of projected monthly cash receipts for the last quarter of the current year
What date can the machinery be reclassified as non-current : What date can the machinery be reclassified as non-current assets held for sale? Limited corp owns a machine which is used to produce herbal medicine.
What total transaction price allocated to the planners : What Total transaction price allocated to the planners? Sales of coffee were 20,000 cups with a total price of P18,000,000 while the number of planners
What amount of earned income credit is : Ariana has an AGI of $38,000 (all from earned income) and two qualifying children and is filing as a head of household. What amount of earned income credit is
Compute the equivalent units of production for materials : Compute the equivalent units of production for materials and conversion costs for the month of September. Compute the unit costs for materials and conversion

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Calculate the investing cash flows of azure company

New equipment for $66,000, land for $100,000, and raw materials to be used in production for $41,000. Calculate the investing cash flows of Azure Company.

  What are the steps necessary for success of nations

What are the steps necessary for success of nations? Support your argument with examples where possible.

  Compute for march the equivalent units of production

Compute for March 2019 the equivalent units of production for conversion costs. (Round answer to the nearest whole number of units)

  Design a balanced scorecard for pioneer company

Design a Balanced Scorecard for Pioneer Company and consider the following:  Using the information that you have gleaned from the interviews, suggest two possible strategies that could be employed by Pioneer Company.

  Journalize the entries for these transactions

Seamus Industries Inc. buys and sells investments as part of its ongoing cash management. Journalize the entries for these transactions

  Calculate the operating income for each options

Calculate the operating income for each options? A second option would be to reduce the selling price. Blake believes a 15% decrease in the price will result

  Explain the differences between a prime and conversion cost

Prepare Schedule of Cost of Goods Manufactured for 2019 and Cost of Goods Sold Report, for 2019.Explain the differences between a prime and conversion cost.

  What the applied manufacturing overhead for job aa is

Manufacturing overhead for year is $100,000. The actual direct labor hours for Job AA was 120 hours. The applied manufacturing overhead for Job AA is

  Marion chemicals produces a chemical used

Marion Chemicals produces a chemical used as a base in paints.

  Find the weighted average unit contribution margin

Determine the weighted average unit contribution margin.Sixty per cent of the sales in units are B and annual fixed expenses are $45,000.

  What is net cash received over life of the bond investment

Demonstrate What is the net cash received over the life of the bond investment? (all money received minus all money paid, round to nearest whole dollar)

  What e by m codes are in the medicine service

What E/M codes are in the 90,000 Medicine services and procedures code range instead of the 99,000 code range. If possible, could provide a link to any resource

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd