Question

LO 4 Joshua Studios expects the following sales in March, April, and May: Cash Sales Credit...

LO 4 Joshua Studios expects the following sales in March, April, and May:

Cash Sales

Credit Sales

March

$55,000

$240,000

April

50,000

250,000

May

75,000

300,000

The controller has determined that the company collects credit 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% uncollectible. How much cash will be collected from customers in May?(a)

$ 75,000

(b)

$239,000

(c)

$290,000

(d)

$314,000

LO 4 Sleep Systems, Inc. budgeted the following selling and administrative expenses for July:

Utilities

$8,500

Advertising

675

Office equipment depreciation

1,230

Supplies

530

Bad debts

1,920

How much will Sleep Systems, Inc. show on its July cash budget for selling and administrative expenses?(a)

$12,855

(b)

$11,625

(c)

$9,705

(d)

$3,150

  

LO 4 Marvin's Garden Supply is preparing its cash budget for the fourth quarter. The inventory manager has provided the following budgeted materials purchases amounts: October—$58,000, November—$80,000, December—$74,000. Historically, Marvin's has paid for 20% of its purchases in the month of purchase, 70% in the month following the purchase, and 10% in the second month after the purchase. What is Marvin's budgeted cash payments for purchases in December?

(a)

$80,000

(b)

$76,600

(c)

$74,000

(d)

$56,000

Homework Answers

Answer #1
1
May
Cash Sales 75000
Credit sales:
From March sales 24000 =240000*10%
From April sales 125000 =250000*50%
From May sales 90000 =300000*30%
Cash collected from customers in May 314000
Option D is correct
2
Utilities 8500
Advertising 675
Supplies 530
Amount of Cash for selling and administrative expenses 9705
Option C is correct
Note: Office equipment depreciation and Bad debts is non cash expense
3
December
For October purchases 5800 =58000*10%
For November purchases 56000 =80000*70%
For December purchases 14800 =74000*20%
Budgeted cash payments for purchases in December 76600
Option B is correct
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales...
4. The Khaki Company has the following budgeted sales data: January February March April Credit Sales $350,000 $320,000 $400,000 $360,000 Cash Sales $70,000 $90,000 $80,000 $70,000 The regular pattern of collection of credit sales is 30% in the month of sales, 25% in the month following sales, and the remainder in the second month following the month of sale. There are no bad debts. Required: a. Determine budgeted cash receipts for April. b. Determine budgeted accounts receivable balance on March...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 Use the following information to prepare the...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $72,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can...
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June...
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June 101,000 Prior experience has shown that 64 percent of a month’s sales are collected in the month of sale, 20 percent are collected in the month following sale, and the remaining 16 percent are collected in the second month following sale. February and March sales were $82,200 and $110,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June 113,000 Prior experience has shown that 61 percent of a month’s sales are collected in the month of sale, 18 percent are collected in the month following sale, and the remaining 21 percent are collected in the second month following sale. February and March sales were $82,200 and $107,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
The following credit sales are budgeted by ELO Company: January $51,000   February   $75,000   March $105,000 April...
The following credit sales are budgeted by ELO Company: January $51,000   February   $75,000   March $105,000 April $90,000   The company’s past experience indicates that 70% of the accounts receivable are collected in the month of sale, 20% in the month following the sale, and 8% in the second month following the sale. The anticipated cash inflow for the month of April is: $84,000.   $90,000.   $88,200. $92,580.  
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
Cash budget-Basic. Grenoble Enterprises had sales of $50,000 in March and $60,400 in April. Forecast sales...
Cash budget-Basic. Grenoble Enterprises had sales of $50,000 in March and $60,400 in April. Forecast sales for​ May, June, and July are $69,900​, $79,600​, and ​$100,300, respectively. The firm has a cash balance of $4,500 on May 1 and wishes to maintain a minimum cash balance of $4,500. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July. ​ (1) The firm makes 18% of sales for​ cash, 62% are collected in...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit Sales May $59,000 $283,000 June $43,000 $236,000 July $33,000 $205,000 August $47,000 $268,000 September $46,000 $197,000 Additional information to be used determining the expected cash collections each month that will be used in preparing the cash budget: Collections on Credit sales: 50% in month of sale 20% in month following sale 30% in second month following sale The Accounts Receivable balance on May 1...