Question

In: Accounting

Rosewood Guitar, Inc. is preparing it cash receipts schedule for the 1stquarter ending 20x1.  In doing so,...

Rosewood Guitar, Inc. is preparing it cash receipts schedule for the 1stquarter ending 20x1.  In doing so, its budget director prepared the following budgeted sales schedule:

Rosewood Guitar Company

Sales Budget

For the Quarter Ending March 31, 20x1

January

February

March

Budgeted sales

$185,000

$195,000

$225,000

Addition Information:

  • Sales for the prior November and December 200x0 were $150,000 and $165,000, respectively.
  • 55% of sales are for cash, the remaining 45% are credit sales.
    • Credit sales are collected as follows:
      • 15% in the month of sale
      • 65% in the month following the sale, and the remaining
      • 15% in the second month following the sale.
  • The company estimates that the remainder of credit sales will be uncollectible.

Required

  1. Prepare a cash receipts schedule for the first quarter of 20x1. (Please show your detailed schedule)
  2. What is the total amount of uncollected accounts receivable for the 3-month period, January, February and March?
  3. Briefly, provide the definition for the term “budgetary slack.”  Why does, budgetary slack occur?
  4. What is the primary indication that “budgetary slack” is occurring?

Solutions

Expert Solution

Answer is given below with working notes


Related Solutions

1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which...
1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which of the following items should be included? I.Borrowing funds from a bank on a note payable taken out in August Year 4 and agreeing co pay the principal and interest in July Year 5 II.Dividends declared in October Year 4 co be paid in January Year 5 co shareholders of record as of December Year 4 (A)I only, (B)II only ,(C)Both I and II,...
Use the schedule for cash receipts and the schedule for cash payments provided to complete a...
Use the schedule for cash receipts and the schedule for cash payments provided to complete a cash budget for M.K.H.M., Inc. Additional Information: M.K.H.M.’s beginning cash balance is $5,000 and M.K.H.M. desires to maintain a minimum ending cash balance of $5,000. M.K.H.M. borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rates on amounts...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8:...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8: Cash receipts: From customers $348,000 From issuance of bonds payable 162,000 From sale of delivery truck 9,000 Cash payments: For purchase of equipment $ 70,800 To employees and suppliers 246,000 For interest expense 17,400 To shareholders for dividends 74,400 For purchase of treasury stock 14,400 For income taxes 21,600 Required: What is the cash flow from operations for Yellowstone, Inc. for 20X8?
MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics...
MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics Company Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing...
Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing Store. Del Spencer's has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month...
Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing...
Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing Store. Del Spencer's has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month...
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December...
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December 31, 2021, including the following schedules: Sales Budget (ALREADY DONE) & Schedule of Cash Receipts (NEED HELP WITH THIS) Pepsi Company Sales Budget For Year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted Sales in units 4,500 16,500 6,000 3,000 30,000 Selling Price per unit $290 $290.00 $290.00 $290.00 $290 Total budgeted sales $1,305,000 $4,785,000.00 $1,740,000.00 $870,000.00 $8,700,000 Relevant Info Dougs sales forecast...
Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an...
Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.60 per check; the amount per check averages $90. “Bad” checks that Rosita cannot collect make up 2 percent of check revenue. During a typical month, Rosita's has sales of $46,000. About 80 percent are cash sales. Estimated sales for the next three months are...
Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an...
Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.50 per check; the amount per check averages $75. “Bad” checks that Rosita cannot collect make up 3 percent of check revenue. During a typical month, Rosita's has sales of $45,000. About 80 percent are cash sales. Estimated sales for the next three months are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT