Complete part d please and thank you & October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expectssales to increase at the rate of 20 percent per month. Prepare a sales budget.& The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale.Prepare a schedule of cash receipts.c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent ofthe next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchasesare made on account. Prepare an inventory purchases budget.d. The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month.Prepare a cash payments budget for inventory purchases.e. Budgeted selling and administrative expenses per month follow:Salary expense (fixed)Sales commissionsSupplies expenseUtilitien (fixed)Depreciation on store fixtures (fixed)*Rent (fixed)Miscellaneous (fixed)"The capital expenditures budget indicates that Munoz will spend $146,600 on October 1 for store fixtures, which are expected tohave a $29,000 salvage value and a two-year (24-month) useful life.Use this information to prepare a selling and administrative expenses budget.Required A£. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which theyare incurred. Prepare a cash payments budget for selling and administrative expenses.Munoz borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in anyamount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cashon the last day of the month. To be prudent, the company desires to maintain a $21,000 cash balance. Prepare a cash budget.Required B$ 18,900Complete this question by entering your answers in the tabs below.$ 2,300$ 4,900$ 5,700$ 2,100Required DRequired CSchedule of Cash Payments Budget for InventoryPurchasesPayment of current month's accounts payablePayment for prior month's accounts payableTotal budgeted payment for inventory$The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the followingmonth. Prepare a cash payments budget for inventory purchases.Note: Round your final answers to the nearest whole dollar amounts.Required EOctober$ 206.584of Sales< Required C0206.584Required F$NovemberRequired GDecember0 $Required E >

Budget means the expected value for future. Budget is prepared for future and actual value is…

Required A Required B Required The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. Prepare a cash payments budget for inventory purchases. Note: Round your final answers to the nearest whole dollar amounts. Schedule of Cash Payments Budget for Inventory Purchases Payment of current month's accounts payable Payment for prior month's accounts payable Total budgeted payment for inventory October S 206.584 S Required C 0 206,584 November $ December 0 $ Required E >

Required A Required B Required The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. Prepare a cash payments budget for inventory purchases. Note: Round your final answers to the nearest whole dollar amounts. Schedule of Cash Payments Budget for Inventory Purchases Payment of current month's accounts payable Payment for prior month's accounts payable Total budgeted payment for inventory October S 206.584 S Required C 0 206,584 November $ December 0 $ Required E >

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 19E: Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28....

See similar textbooks

Similar questions

Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: Depreciation, insurance, and property taxes represent 9,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.
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.
Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?