Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below:Budgeted sales (all on account)April$300,000May$500,000June$200,000Total$1,000,000The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month followingsale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. Februarysales totaled $230,000, and March sales totaled $260,000.Required:1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.2. What is the accounts receivable balance on June 30th?Complete this question by entering your answers in the tabs below.Required 1 Required 2Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.Schedule of Expected Cash CollectionsFebruary salesMarch salesApril salesMay salesJune salesTotal cash collectionsAprilMayJuneTotal

To solve this problem, we need to calculate the expected cash collections from sales for each month…

Answered: Silver Company makes a product with…

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

Cypress Inc. has the following budgeted sales for the next quarter.Month: 1 2 3Units: 10,000 11,000 12,000Inventory of finished goods on hand at the beginning of the quarter is 7,000 units. The company desires to maintain ending inventory equal to beginning inventory plus 5,000 units every month.Calculate the total quantity to be produced during the quarter.
Bloom Corp. produces one product that sells at $20 per unit and sells best on Valentine's Day and Mother’s Day. As a result peak sales occur in February and May of each year. Budgeted sales in units for the first six months of the coming year are: Month Units January 12,000 February 32,000 March 18,000 April 34,000 May 30,000 June 15,000 25% of all sales are cash sales and the rest are on account. Past experience shows that the company collects 25% of a month’s credit sales in the month of sale. Another 65% of credit sales are collected in the month following the sale, and the remaining 10% of credit sales are collected in the second month following the sale. Bad debts are negligible and can be ignored. To ensure that sales volumes can be met, the company requires that ending inventory for a particular month reflect 15% of next month's sales. Ending inventory on June 30th will be 1,500…
Lexi Company budgets unit sales of 1,200,000 in April, 1,290,000 in May, 470,000 in June, and 1,520,000 in July. Beginning inventory on April 1 is 360,000 units, and the company wants to have 30% of next month’s unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June.
Angelo Limited is preparing its budget for the next year. It produces and sells a single product. The expected sales for the first 4 months of next year are: Month January February March April Production units 10,500 12,700 14,200 16,100 The product requires 2.5 kg of Material A1 per unit. It is the company’s policy to hold in inventory at the end of a month 20% of the material requirement for the following month. Calculate the material purchases for the month of February based on the information provided. Production cost is: The total overhead cost incurred in producing products. The total of the direct costs and the production overhead cost incurred. The total of the direct costs incurred in production. The cost of direct material, direct labour and indirect labour incurred in production.
Apollo Corporation produces and sells a single product, sewing machines, for $100 per unit. Budgeted sales for the next three months are given below: Unit Sales June 76,000 July 80,000 August 85,000 All sales are on credit and are collected in the following pattern: 30% in the month of sales and the remaining 70% in the month following the sale. 1. What is the amount of sales revenue reported on the company’s budgeted income statement for July? multiple choice 1 a)$8,000,000 b)$7,600,000 c)$8,500,000 d)$7,720,000 2. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s unit sales. How many units are required to be produced in July? multiple choice 2 a)82,400 units b)81,000 units c)86,400 units d)80,000 units 3. In July, how much cash the company can collect from sales? multiple choice 3 a)$7,600,000 b)$8,000,000 c)$8,680,000 d)$7,720,000 4. In the company’s balance sheet dated…
Sanjay
ABC Company's actual unit sales in the current year for January, February, and March were 16,500, 13,500, and 19,500 units, respectively. Current year selling price is $20. An analysis of general economic trends and specific initiatives at ABC forecasts increases for the coming budget year: sales volume by 10% and sales price by 5%. Required: Prepare ABC Company's budgeted unit sales and total sales volume for the first quarter of the coming year. Current sales (units) Budgeted volume increase Budgeted sales (units) Budgeted selling price Budgeted total sales January $ 0 % February $ 0 % $ March 0 % $ Total 0 %
tes 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 $ 410,000 Required 1 Required 2 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15 % are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $340,000, and March sales totaled $370,000. Complete this question by entering your answers in the tabs below. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? February sales March sales May $ 610,000 April sales May sales June sales Total cash collections. Prepare a schedule of expected cash…
X Corp has budgeted sales (in units) for the upcoming quarter as follows: Jan is 15,000; Feb is 18,000 and March is 16,500 units. The ending FG inventory for each month equals 50% of the next months budgeted sales. Additionally, 3 pounds of DM (Direct Materials) are required to produce each FG (Finished Goods) unit processed. The ending DM inventory for each month equals 200% of next month's production requirements. If DM cost P4.00 per kilos and must be paid for in the month of purchased, the budgeted DM purchases (in pesos) for January are? choices: 96,584 102,346 98,182 None of the above
Vishnu
Majan company has budgeted sales in units for the next five months as follows: June 5,400 units July 6,500 units August 7,000 units September 8,200 units October 4,800 units Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on May 31 is 400 units. The company needs to prepare a Production Budget for the next five months. The total number of units to be produced in August is a. 7,120 units b. 7,420 units c. 7,170 units d. 8,520 units W P
Folgerty Enterprises prepared the following sales budget: Month Budgeted Sales March $6,000 April $13,000 May $12,000 June $14,000 The expected gross profit rate is 30% and the inventory at the end of February was $10,000. Desired finished goods inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired beginning finished goods inventory on June 1 (in dollars)? Select one: a. $1,960 b. $840 c. $1,680 d. $9,800 e. $1,860

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS