The following information pertains to Monroe Company: Month Sales Purchases January $68,000 $35,000 February $87,000 $46,000 March $106,000 $58,000 Cash is collected from customers in the following manner: Month of sale 30% Month following the 70% sale 45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 20% of sales. Other operating costs are $32,000 per month (including $8,000 of depreciation). Both of these are paid in the month incurred. The cash balance on March 1 is $8,900. A minimum cash balance of $6,000 is required at the end of the month. Money can be borrowed in multiples of $1,000. What is the ending cash balance for March? O $5,000 $6,000 $5,200 O $8,900

The following information pertains to Monroe Company: Month Sales Purchases January $68,000 $35,000 February $87,000 $46,000 March $106,000 $58,000 Cash is collected from customers in the following manner: Month of sale 30% Month following the 70% sale 45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 20% of sales. Other operating costs are $32,000 per month (including $8,000 of depreciation). Both of these are paid in the month incurred. The cash balance on March 1 is $8,900. A minimum cash balance of $6,000 is required at the end of the month. Money can be borrowed in multiples of $1,000. What is the ending cash balance for March? O $5,000 $6,000 $5,200 O $8,900

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 12EB: Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the...

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.
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.
Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Alard Manufacturing Company has a billing department staffed by four billing clerks. Each clerk is paid 32,000 per year and is able to process 8,000 bills. Last year, 27,360 bills were processed by the four agents. Calculate the unused capacity in terms of number of bills. a. 27,360 b. 4,640 c. 8,000 d. 32,000
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
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.
Use the following information for Brief Exercise: Morning Smiles Coffee Company manufactures Stoneware French Press coffee makers and sold 8,000 coffee makers during the month of March at a total cost of 612,500. Each coffee maker sold at a price of 100. Morning Smiles also incurred two types of selling costs: commissions equal to 5% of the sales price and other selling expense of 45,000. Administrative expense totaled 47,500. 2-33 Income Statement Percentages Refer to the information for Morning Smiles Coffee Company on the previous page. Required: Prepare an income statement for Morning Smiles for the month of March and calculate the percentage of sales revenue represented by each line of the income statement. (Note: Round answers to one decimal place.)
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?
Johnson Corporation had beginning inventory of 20,000 at cost and 35,000 at retail. During the year, it made net purchases of 180,000 at cost and 322,000 at retail. Johnson nude sales of 300,000. Assuming a price index of 100 at the beginning of the year and 110 at the end of the year, compute Johnsons ending inventory at cost using the dollar-value LIFO retail method.
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.