Question

In: Finance

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

Solutions

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.


Related Solutions

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.
Getty Company expects sales for the first three months of next year to be $195,000, $265,000...
Getty Company expects sales for the first three months of next year to be $195,000, $265,000 and $315,000, respectively. Getty expects 50 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty’s cash receipts for the months of February and March.
(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....
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT