Masco Company. expects sales of $5,400, $6,100, $5,900, and $6,400 for the months of March through...

Masco Company. expects sales of $5,400, $6,100, $5,900, and $6,400 for the months of March through June, respectively. The company collects 50 percent of sales in the month of sale, 25 percent in the month following the month of sale, and 20 percent in the second month following the month of sale. The remaining 5 percent of sales is never collected. How much money does the company expect to collect in the month of June?

$4,975.00

$6,250.00

$5,300.00

$6,725.00

$5,895.00

Expert Solution

Solution :

The amount of money the company expects to collect in the month of June = $ 5,895

The solution is Option 5 = $ 5,895.00

Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.

jeff jeffy answered 3 months ago

a. Navigator sells GPS trackers for $55 each. It expects sales of 5,900 units in quarter...

a. Navigator sells GPS trackers for $55 each. It expects sales of 5,900 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year. Round final answers to nearest whole dollar. For the Year Ending Dec. 31, 20XX Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected Sales (Units) Sales Price per Unit Total Sales Revenue b. makes universal remote controls and expects to...

Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March...

Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March 240,000 180,000 April 250,000 210,000 May 300,000 225,000 The controller has determined that the company collects sales in the following pattern: 30% in the month of sale, 50% in the first month after sale, 10% in the second month after sale, and 10% uncollectable. Based on the agreed terms of trade with suppliers, 40% of purchases are expected to be paid in the month...

James Company expects the following sales in the next few months: Month &nb

James Company expects the following sales in the next few months: Month Units Selling Price July 50,000 $ 8.10 August 80,000 $ 8.10 September 40,000 $ 8.60 October 30,000 $ 8.60 James expects to collect 60 % of sales in the month of sale, 30 % in the following month, 5 % in the next month, with 5 % remaining uncollected. Required: Prepare a schedule of cash receipts for September and October.

Jane Company expects the following sales in the next few months: Month &nbs

Jane Company expects the following sales in the next few months: Month Units Selling Price July 50,000 $ 8.10 August 80,000 $ 8.10 September 40,000 $ 8.60 October 30,000 $ 8.60 Jane expects to collect 60 % of sales in the month of sale, 30 % in the following month, 5 % in the next month, with 5 % remaining uncollected. Prepare a schedule of cash receipts for September and October.

(i) D & F, Inc. expects sales of $620, $650, $730 and $780 for the months...

(i) D & F, Inc. expects sales of $620, $650, $730 and $780 for the months of April through July, respectively. The firm collects 20 percent of sales in the month of sale, 50 percent in the month following the month of sale and 28 percent in the second month following the month of sale. The remaining 2 percent of sales is never collected. How much money does the firm expect to collect in the month of July? (SHOW YOUR...

The Boswell Corporation forecasts its sales in units for the next four months as follows: March...

The Boswell Corporation forecasts its sales in units for the next four months as follows: March 16,000 April 18,000 May 15,500 June 14,000 Boswell maintains an ending inventory for each month in the amount of three times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $8 per unit and are paid for in the month after production. Labour cost is $12 per unit and is paid for in...

Braindead Pty Ltd expects sales of 40,000 units of Faytik101 in March. Faytik101 is its most...

Braindead Pty Ltd expects sales of 40,000 units of Faytik101 in March. Faytik101 is its most popular high performance desktop model. The sales manager is confident that between April and June, the total sales will have a 50% growth rate each month from the month before. Each unit of Faytik101 requires 50 units of a specific chip known as Slacker-2. This chip is purchased from an external supplier. The firm maintains 10% of the following month’s sales needs in inventory....

A company expects to sell 6,000 units in April and expects sales to increase 20% each...

A company expects to sell 6,000 units in April and expects sales to increase 20% each month after. The unit sales price of $8 is expected to remain constant. The company wants ending finished goods inventory to be 15% of the next month’s sales. What are budgeted sales revenues for the second quarter? How many units will be produced in the second quarter? Round answers to nearest whole number. The raw materials ending inventory should be 20% of the next...

Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...

Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 25,000 April 27,000 May 24,500 June 23,000 Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid...

The following represents the financial information for Domingo Corporation for two months. March April Sales revenue...

The following represents the financial information for Domingo Corporation for two months. March April Sales revenue $ 504,000 $ 468,000 Costs Process inspection $ 4,250 $ 4,480 Scrap 2,500 2,580 Quality training 22,400 15,600 Warranty repairs 8,200 8,700 Product testing equipment 8,300 8,300 Customer complaints 4,750 5,350 Rework 18,300 25,000 Preventive maintenance 16,100 12,100 Materials inspection 9,100 7,400 Field testing 12,000 15,000 Required: Construct a cost of quality report for March and April. (Input all amounts as positive values. Round...

Question