Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May $54,000 June 63,000 July 45,000 August $60,000 71,000 75,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 45 percent are collected in the month of sale, 35 percent are collected in the following month, and 10 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule February $ Sales Collections of current sales Collections of prior month's sales. Collections of sales 2 months earlier Total cash receipts January $ March - $ April $ $ $ May $ June $ $

Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May $54,000 June 63,000 July 45,000 August $60,000 71,000 75,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 45 percent are collected in the month of sale, 35 percent are collected in the following month, and 10 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule February $ Sales Collections of current sales Collections of prior month's sales. Collections of sales 2 months earlier Total cash receipts January $ March - $ April $ $ $ May $ June $ $

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Vishnu
All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or “safety” stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes. The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The company’s desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during…
4
Craig has projected sales to be $90,400 in April; $96,400 in May; $104,500 in June and $93,600 in July. The history of Craig’s sales indicates 20% cash and the remaining 80% on credit. The company’s collection history indicates that credit sales are collected as follows: 30% collected in the month of the sale 60% collected in the month after the sale 8% collected two months after the sale 2% of credit sales are never collected
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $524,000 for April, $534,000 for May, and $559,000 for June. Total sales for March are $307,500. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts 524,000 ***** 534,000 June 559,000
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts S S $ $ $ $ June
ABC Company manufactures and sells lighting fixtures. Estimated sales for the next three months are; September – $350,000 October – $500,000 November – $400,000 Sales for August were $400,000. All sales are on account, ABC Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for ABC Company.
Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 12,000 June $ 14,000 April 16,000 July 17,000 May 10,000 August 18,000 Sales in January and February were $13, 500 and $13,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a. Prepare a monthly cash receipts schedule for the firm for March through August. Ed's Waterbeds Cash Receipts Schedule January February March April May June July August Sales $ $ $ $ $ $ $ $ Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ $ $ $ $$b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? Amount…
MAXI Co. has the following information: *Projected sales for four (4) months are as follows: July-20,000 units; August -35,000 units ; September-25,000; October-30,000. Sales price per unit is $180 *Plans are to have a finished goods inventory end equal to 20% of the unit sales for next month. There was 4,000 units in beginning inventory on July 1. *Three (3) kilos of materials are required per unit produced. Every kilo of material is $20. Raw material inventory must be equal to 30% of the next month's needs . Desired ending inventory for September is 25,200 kilos and beginning inventory was 20,700 kilos. *Each unit requires 0.60 hours of direct labor and the average wage rate is $16 per hour. *Variable overhead rate is $3.50 per direct labor hour. There is also a fixed overhead of $22,000 per month. *The company pays 3% commission on sales. *Company has a monthly fixed and selling expenses as follows: Rent-$6,000 ; Utilities-$1,200 ; Advertising-$400: Office Salaries-$35,000.…
Pardee Company makes 30% of its sales for cash and 70% on account. 60% of the account sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month 1 2 3 4 Total sales $78,000 $80,000 $68,000 $48,000 Total cash receipts in Month 4 will be: A. 38,780 B.68,000 C.53,180 D.50,600
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 60 and 45 shades, respectively. Ending finished goods inventory for June will be 55 shades. It expects the following unit sales for the third quarter: July August September 545 500 470 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. August September Total Cash Receipts
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $516,000 for April, $526,000 for May, and $551,000 for June. Total sales for March are $299,000. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April May 516,000 526,000 June 551,000