Question

You are the owner of a new, BBQ and Patio Accessories Store in Calgary. You have...

You are the owner of a new, BBQ and Patio Accessories Store in Calgary.
You have budgeted the following information regarding next years operating results and cash flow patterns:
Sales Type % of Total Collection Pattern
     Credit card sales 55% 70% in the quarter of sale
30% in the quarter following sale
     Cash sales 25% 100% in the quarter of sale
     Sales on account 20% 65% in the quarter of sale
25% in the quarter following sale
10% in the 2nd quarter following sale
Total Budgeted Sales:
1st quarter 450,000
2nd quarter 365,000
3rd quarter 260,000
4th quarter 560,000
Required: Based on the above information prepare a schedule of budgeted cash
collections for the 3rd quarter.

Note- Introductory management accounting

Homework Answers

Answer #1

​​

Note:for calculation see working notes on page 2 and 3

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
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account, and recorded in Accounts Receivable): 1st quarter 2nd quarter 3rd quarter 4th quarter Budgeted unit sales 10,000 13,000 12,000 15,000 The selling price of the company's product is $15 per unit. Management expects to collect 60% of sales in the quarter in which the sales are made, 35% in the following quarter, and 5% of sales are expected...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
he marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
he marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,700 13,700 15,700 14,700 The selling price of the company’s product is $26 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
In the coming year, Bramble, Inc. will be introducing its first product, a wrist brace that...
In the coming year, Bramble, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $14 to retailers throughout the country. All sales will be made on account. An expected 64% of sales will be collected within the quarter of the sale, and another 31 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget...
In the coming year, Game Monster, Inc., will be introducing its first product, a wrist brace...
In the coming year, Game Monster, Inc., will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $17 to retailers throughout the country. All sales will be made on account. An expected 74 percent of sales will be collected within the quarter of the sale, and another 21 percent in the quarter following the sale. The remaining 5 percent of credit sales are expected to be uncollectible....
Problem 2 Scrubs and Beyond Incorporated is a retailer of brand name scrubs, shoes and nursing...
Problem 2 Scrubs and Beyond Incorporated is a retailer of brand name scrubs, shoes and nursing accessories for fashion forward medical professionals. The company is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $340,000 $670,000 $410,000 $470,000 Total cash disbursements $530,000 $450,000 $430,000 $$480,000 The company’s beginning cash balance for the upcoming fiscal year will be $50,000. The...
you are a manager of a local tractor distributor. you currently sell two versions basic and...
you are a manager of a local tractor distributor. you currently sell two versions basic and deluxe. the owner has provided you with the following information: Budgeted sales for each quarter: 1st quarter- $395000, 2nd quarter-$270000, 3rd quarter- $205000, 4th quarter-$320000 % of sales for each model: Basic- 60%, Deluxe- 40% cost of sales as a % of sales: Basic- 35%, deluxe- 15% Ending inventory as a % of the next quarters needs: Basic- 30%, Deluxe-55% required: based on the...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 260,000 $ 410,000 $ 290,000 $ 310,000 Total cash disbursements $ 316,000 $ 286,000 $ 276,000 $ 296,000 The company’s beginning cash balance for the upcoming fiscal year will be $36,000. The company requires a minimum cash balance of $10,000 and may...
1A) Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter...
1A) Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 15,000 16,000 14,000 13,000 The company’s variable selling and administrative expense per unit is $2.50. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $35,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,500 13,500 15,500 14,500 The selling price of the company’s product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...