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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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