Question

In: Accounting

Budget Practice Problem Bill's Bagels has budgeted the following sales through March (see below). Bill's sales...

Budget Practice Problem
Bill's Bagels has budgeted the following sales through March (see below). Bill's sales are expected as follows: cash 40% / credit (accounts receivable) 60% Sales on credit are expected to be collected 60% in following month and the other 40 % in the month after that. Bill will purchase food inventory at 30% of prior month's sales and desires to have $15,000 in cash available at all times. Other relevant information is provided below.
Required:
1. Calculate credit sales/cash sales through the end of March
2. Calculate the expected collection on receivables assuming no bad debt
3. Calculate budgeted cash disbursements through March
4. Calculate the available cash, borrowings or repayments, and the loan balance through March Bill's Bagels Cash Receipts, Cash Payments and Cash Budget SALES BUDGET: NOVEMBER DECEMBER JANUARY FEBRUARY MARCH SALES $ 30,000 $ 40,000 $ 40,000 $ 47,500 $ 60,000 CASH RECEIPTS BUDGET: CREDIT SALES 60% $ 18,000 $ 24,000 $ 24,000 CASH SALES 40% $ 12,000 $ 16,000 $ 16,000 COLLECTION OF RECEIVABLES: 1 MONTH AFTER SALE 60% $ 14,400 2 MONTHS AFTER SALE 40% $ 7,200 TOTAL BUDGETED CASH RECEIPTS $ 37,600 CASH PAYMENTS BUDGET Food Purchases 30%of prior month sales $ 12,000 Payroll Expense 20% $ 8,000 Selling&Admin 15% $ 6,000 Overhead (fixed) $ 10,000 Estimated Taxes (fixed) $ 5,000 TOTAL BUDGETED CASH DISBRUSEMENTS $ 41,000 CASH BUDGET JANUARY FEBRUARY MARCH Beginning Cash Balance $ 15,000 TOTAL BUDGETED CASH RECEIPTS $ 37,600 TOTAL BUDGETED CASH DISBURSEMENTS $ (41,000) Cash Available $ 11,600 Desired Ending Cash Balance $ 15,000 $ 15,000 $ 15,000 Expected Borrowing (or Repayment) $ 3,400 Ending Cash Balance $ 15,000 Loan Balance $ 3,400

Solutions

Expert Solution

Answer:


Related Solutions

Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
Below is budgeted production and sales information for Octofic Cans, Inc. for the month of March:...
Below is budgeted production and sales information for Octofic Cans, Inc. for the month of March:   Aluminum     Tin Estimated beginning inventory 12,000 units 6,000 units Desired ending inventory 15,000 units 4,000 units Region I, anticipated sales 380,000 units 85,000 units Region II, anticipated sales 125,000 units 25,000 units The unit selling price for aluminum cans is $0.15 and for tin cans is $0.20. Budgeted sales for the month are: a. $97,550. b. $82,750. c. $81,550. d. $123,000.
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December,...
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December, and $410,000 for January. Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget –...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget – production budget – direct materials budget – budgeted income statement Who would typically be responsible for the direct material quantity variance? -the production manager -the chief financial officer -the purchasing manager -the human resources manager Which of the following is not a component of the operating budget? -sales budget -selling and administrative budget -Budgeted balance sheet -raw materials purchases budget Top-down budgeting is: -when...
Budget Problem Part A The ABC company manufactures bookcases that sell for $400. Budgeted sales for...
Budget Problem Part A The ABC company manufactures bookcases that sell for $400. Budgeted sales for first months are as follows: Month Budgeted Sales (units) January 1000 February 1500 March 2500 April 2000 Required Calculate sales budget in $ for each monthand total the first quarter Part B Each bookcase requires 30 square feetof oak at a cost of $10 per sq foot.. the company wants to maintain an inventory of bookcases equal to 10% of the following month,s sales....
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the...
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the next six-month period: Month Unit Sales January 48,000 February 84,000 March 60,000 April 72,000 May 48,000 June 80,000 There were 69,000 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished products that equals 100% of the following month sales plus 25% of the second month sales. Two kilograms of raw materials are required for...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales for January $200,000 and February $107,000.         ∙       Collections for sales are 40% in the month of sale and 60% the next month.         ∙       Gross margin is 25% of sales.         ∙       Administrative costs are $11,000 each month.         ∙       Beginning accounts receivable is $26,000.         ∙       Beginning inventory is $15,000.         ∙       Beginning accounts payable is $68,000. (All from inventory purchases.)        ...
Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000...
Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
Garver Industries has budgeted the following unit sales: 2017 Units January 10,000 February 8,000 March 9,000...
Garver Industries has budgeted the following unit sales: 2017 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2016, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
Garver Industries has budgeted the following unit sales: 2017 Units January 10,000 February 8,000 March 9,000...
Garver Industries has budgeted the following unit sales: 2017 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2016, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT