%24 Flint, Inc. provided the following information: July August Projected sales $236,000 $250,000 Projected merchandise purchases $144,000 $176,000 Flint estimates that it will collect 40% of its sales in the month of sale, 35% in the month after the sale, and 22% in the second month following the sale. Three percent of all sales are estimated to be bad debts. Flint pays for 30% of merchandise purchases in the month purchased and 70% in the following month. General operating expenses are budgeted to be $20,500 per month, including depreciation of $1,900. Flint pays operating expenses in the month incurred. Flint makes loan payments of $3,500 per month of which $600 is interest and the remainder is principal. Calculate Flint's budgeted cash disbursements for August. Budgeted Cash Disbursements $. eTextbook and Media Save for Later Attempts: 0 of 3 used Submitswer f4 f5 f12 64 prt s 91 23. %3D 5. 8.

%24 Flint, Inc. provided the following information: July August Projected sales $236,000 $250,000 Projected merchandise purchases $144,000 $176,000 Flint estimates that it will collect 40% of its sales in the month of sale, 35% in the month after the sale, and 22% in the second month following the sale. Three percent of all sales are estimated to be bad debts. Flint pays for 30% of merchandise purchases in the month purchased and 70% in the following month. General operating expenses are budgeted to be $20,500 per month, including depreciation of $1,900. Flint pays operating expenses in the month incurred. Flint makes loan payments of $3,500 per month of which $600 is interest and the remainder is principal. Calculate Flint's budgeted cash disbursements for August. Budgeted Cash Disbursements $. eTextbook and Media Save for Later Attempts: 0 of 3 used Submitswer f4 f5 f12 64 prt s 91 23. %3D 5. 8.

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

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.
Sarasota, Inc. provided the following information: July August Projected sales $234,000 $260,000 Projected merchandise purchases $144,000 $172,000 • Sarasota estimates that it will collect 40% of its sales in the month of sale, 35% in the month after the sale, and 22% in the second month following the sale. Three percent of all sales are estimated to be bad debts. • Sarasota pays for 30% of merchandise purchases in the month purchased and 70% in the following month. • General operating expenses are budgeted to be $22,500 per month, including depreciation of $2,000. Sarasota pays operating expenses in the month incurred. • Sarasota makes loan payments of $3,000 per month of which $450 is interest and the remainder is principal. Calculate Sarasota's budgeted cash disbursements for August. Budgeted Cash Disbursements Enter the budgeted cash disbursements in dollars
Mahoney, Inc. provided the following information: June July Projected sales $220,000 $260,000 Projected merchandise purchases $150,000 $180,000 Mahoney estimates that it will collect 40% of its sales in the month of sale, 35% in the month after the sale, and 22% in the second month following the sale. Three percent of all sales are estimated to be bad debts. Mahoney pays 30% of merchandise purchases in the month purchased and 70% in the following month. General operating expenses are budgeted to be $20,000 per month of which depreciation is $2,000 of this amount. Mahoney pays operating expenses in the month incurred. Mahoney makes loan payments of $3,000 per month of which $400 is interest and the remainder is principal. Instructions Calculate Mahoney's budgeted cash disbursements for July.
Ellis Sport Shop projects the following sales: April May June $75,000 $95,000 $110,000 Ninety percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $60,000 and March sales were $70,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. Prepare a monthly schedule of cash receipts for April-June. (Can you show the excel formulas used so then I can do it myself please.) What is the balance of Receivables at the end of June? (Can you show the excel formulas used so then I can do it myself please.)
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 96,000 $ 125,000 $ 78,000 Credit sales 288,000 450,000 234,000 Total sales $ 384,000 $ 575,000 $ 312,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 30% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling prices.Budgeted cash payments in November for November inventory purchases by Yekstop Corp. are:
Alpha Company makes all its sales on account. Accounts receivable payment experience is as follows: Percent paid in the month of sale 35% Percent paid in the month after the sale 54% Percent paid in the second month after the sale 6% Alpha provided information on sales as follows: Мay $150,000 June $125,000 July $136,000 August (expected) $142,000 How much of May's sales are expected to be uncollectible?
Information pertaining to Collection Corporation's sales revenue is presented below: November December January Cash sales $ 97,000 $ 126,000 $ 79,000 Credit sales 289,000 451,000 235,000 Total sales $ 386,000 $ 577,000 $ 314,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 70% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices. Budgeted cash payments in November for November inventory purchases by Collection Corporation are:
Information pertaining to Collection Corporation's sales revenue is presented below: November December January Cash sales $ 99,000 $ 128,000 $ 81,000 Credit sales 291,000 453,000 237,000 Total sales $ 390,000 $ 581,000 $ 318,000 Management estimates that 3% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices.Budgeted cash payments in December for November inventory purchases by Collection Corporation are: Multiple Choice $42,075. $53,325. $78,000. $156,000. $213,300. Please don't provide answer…
omework (required) Anderson Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Anderson Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 18% received two months after the sale 7% of the credit sales are never received Cash sales Collections on credit sales: 25% Month of sale 50% Month after 18% Two months after Total cash collections Anderson Corporation Cash Collections Budget For the Months of January through March January February $ $ 33,000 Part 2 of 4 33,000 50,000 12,960 128,960 Points: 0.2 of 2 January sales.. February sales March sales. November sales for last year were $90,000, while December sales were $125,000. Projected sales for the next three months are as follows: Save $ 165,000 $ 130,000 $ 200,000 Requirement Prepare a cash collections budget for the first quarter, with a column for each month…
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
Besoluck company has sales of P480,000 and P450,000 for September and October respectively. Of the total Sales, 1% is returned. 75% of the total sales account for credit sales and 20% of credit sales avail of the discount of 2%. The company is able to collect 40% of credit sales in the month of sales and 60% is collected in the following month. During October, the company has written off P20,000 of worthless accounts but had collected P13,000 from an account previously written off. The company uses, 10% percent of receivables for estimating doubtful accounts. What amount is debited to doubtful accounts expense if the balance of the allowance for doubtful accounts on Oct 1 is P7,350.50?
Assume Laksko's has credit sales of $462,400 in March, $507,500 in April, and $550,200 in May. Also assume that 64 percent of sales are collected in the month of sale, 35 percent are collected in the following month, and the remainder are never collected. Credit purchases are $224,600 in March, $236,700 in April, and $252,700 in May. Credit purchases are paid in 30 days. Interest is $12,400 a month, wages and other expenses are $64,400 a month. Fixed assets purchases of $119,500 are scheduled for April with additional purchases of $56,400 in May. The April 1 cash balance was $321,060 and taxes of $180,000 must be paid on April 15. What is the cash balance at the end of May?