edokcesShadee Corporation expects to sell 530 sun shades in May and 330 in June. Each shades sells for $12. Shadee's beginning andending finished goods inventories for May are 70 and 60 shades, respectively. Ending finished goods inventory for June will be 60shades.It expects the following unit sales for the third quarter:JulyAugustSeptember545470460Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 37 percent is collectedduring the following month, and 11 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.Total Cash ReceiptsAugustSeptember

Sales forecasting involves predicting future sales based on historical data and market trends. It…

Answered: Shadee Corporation expects to sell 530…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Shadee Corporation expects to sell 500 sun shades in May and 440 in June. Each shades sells for $19. Shadee's beginning and ending finished goods inventories for May are 75 and 45 shades, respectively. Ending finished goods inventory for June will be 70 shades. It expects the following unit sales for the third quarter: July August September 575 460 450 Sixty percent of Shadee's sales are cash. Of the credit sales, 54 percent is collected in the month of the sale, 39 percent is collected during the following month, and 7 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. Total Cash Receipts August September
Shadee Corporation expects to sell 600 sun shades in May and 450 in June. Each shades sells for $11. Shadee's beginning and ending finished goods inventories for May are 70 and 40 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter: July August 545 480 September460 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 36 percent is collected during the following month, and 12 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. Total Cash Receipts August September
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
Shadee Corp. expects to sell 570 sun visors in May and 310 in June. Each visor sells for $15. Shadee's beginning and ending finished goods inventories for May are 60 and 40 units, respectively. Ending finished goods inventoryfor June will be 65 units. It expects the following unit sales for the third quarter. July: 575 August: 440 September: 420 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 39 percent is collected during the following month, and 9 percent is never collected. Calculate Shadee's total cash receipots for August and September?
es Shadee Corporation expects to sell 560 sun shades in May and 410 in June. Each shades sells for $19. Shadee's beginning and ending finished goods inventories for May are 70 and 50 shades, respectively. Ending finished goods inventory for June will be 50 shades. It expects the following unit sales for the third quarter: July August September 575 470 450 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 36 percent is collected during the following month, and 12 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. Total Cash Receipts August September

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS