Homework Help Question & Answers

For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 49,000 51,000 56,000 Production 53,000...

For the second quarter of the following year Cloaks Company has projected sales and production in units as follows:

Jan

Feb

Mar

Sales

49,000

51,000

56,000

Production

53,000

48,000

49,000

Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the next month. $95,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals $185,000, which will be paid in Feb.

All units are sold on account for $13 each. Cash collections from sales are budgeted at 55% in the month of sale, 25% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. On January 1 accounts receivable totaled $500,000 ($90,000 from November’s sales and the remaining from January).

Required:

1)     Prepare a schedule for each month showing budgeted cash disbursements for Cloaks Company.

2)     Prepare a schedule for each month showing budgeted cash receipts for Cloaks Company.

0 0
Next > < Previous
ReportAnswer #1

Febru March Janua Units sold 49,000 51,000 56,000 $ 13.00 $13.00 13.00 663,000 728,000 Selling price per unit $ 637,000 Total

Know the answer?
Add Answer of:
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 49,000 51,000 56,000 Production 53,000...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A merchandising firm by the name of Star Wars Enterprises, had an inventory of 42,000 units on March 31, and it had accounts receivable totaling $83,500. Sales, in units, have been budgeted as follows...

    A merchandising firm by the name of Star Wars Enterprises, had an inventory of 42,000 units on March 31, and it had accounts receivable totaling $83,500. Sales, in units, have been budgeted as follows for the next four months: April 55,000 May 65,000 June 81,000 July 79,000 To be enforced in April, Star Wars board of directors has established a policy that states that the inventory at the end of each month should contain 35% of the units required for...

  • Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year,...

    Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $480,000 $680,000 $260,000 $1,420,000 From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the...

  • Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. Units Dollars April (ac...

    Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,500 $ 525,000 May (actual) 2,400 360,000 June (budgeted) 5,500 825,000 July (budgeted) 4,500 824,000 August (budgeted) 4,400 660,000 All sales are on credit. Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 25% in the second month after the sale, and 5% proves to be uncollectible....

  • the company's sales budget for the second quarter given below: Budgeted sales (all on account) April...

    the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $360,000 May $560,000 June $220,000 Total $1,140,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $290,000, and March sales totaled...

  • May 735 pple Company provides the following data for the next three months. Feb 780 Jan...

    May 735 pple Company provides the following data for the next three months. Feb 780 Jan 685 Budgeted production units Beginning Raw Materials inventory-Ibs. Ending Finished Goods Inventory - units 705 160 Apple had decided that Raw Materials desired ending inventory shou month's production needs. Each unit of production takes four pounds w Materials desired ending inventory should be 40% of the next Each unit of production takes four pounds of raw materials. What is the quantity (lbs.) of Raw...

  • Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actu...

    Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,500 $ 560,000 May (actual) 2,600 416,000 June (budgeted) 5,500 880,000 July (budgeted) 4,500 879,000 August (budgeted) 4,100 656,000 All sales are on credit. Recent experience shows that 22% of credit sales is collected in the month of the sale, 48% in the month after the sale, 27% in the second month after the sale, and 3% proves to be uncollectible....

  • 1. Aloan Co. provides the following sales forecast for the next three months: January February March Sales unit...

    1. Aloan Co. provides the following sales forecast for the next three months: January February March Sales units 3,300 4,500 5,300 The company wants to end each month with ending finished goods inventory equal to 10% of the next month’s sales. Finished goods inventory on December 31 is 330 units. The budgeted production units for January are: Multiple Choice 3,300 units. 3,750 units. 33 units. 3,420 units. 3,180 units. 2. Frankie's Chocolate Co. reports the following information from its sales...

  • Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...

    Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...

  • Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...

    Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $257,000 $32,700 February 277,200 37,500 March 297,900 51,500 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale: 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

  • Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six m...

    Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six months 2019: Units sales per quarter and the selling price per unit are estimated as follows:                                                   Unit sales                      Price per unit January                                   2,500                                 $450 February                                 2,800                                 $450 March                                     2,750                                 $480 April                                       2,750                                 $480 May                                        2,800                                 $500          June                                        2,800                                 $500 July                                         3,000                                 $500 August                                    3,000                                 $500 Sales on November...

Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.