In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the months of October, November, and December based on the given information: Month Sales Purchases August (actual) P3,000,000.00 P3,500,000.00 September (actual) P4,500,000.00 P2,000,000.00 October (forecast) P1,000,000.00 P500,000.00 November (forecast) P1,500,000.00 P750,000.00 December (forecast) P2,000,000.00 P1,000,000.00 (a) The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. (b) Interest income of P50,000 on marketable securities will be received in December. How much is the total cash receipts in November? A P3,900,000 P2,400,000 P1,850,000 D) P1,300,000

In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the months of October, November, and December based on the given information: Month Sales Purchases August (actual) P3,000,000.00 P3,500,000.00 September (actual) P4,500,000.00 P2,000,000.00 October (forecast) P1,000,000.00 P500,000.00 November (forecast) P1,500,000.00 P750,000.00 December (forecast) P2,000,000.00 P1,000,000.00 (a) The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. (b) Interest income of P50,000 on marketable securities will be received in December. How much is the total cash receipts in November? A P3,900,000 P2,400,000 P1,850,000 D) P1,300,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? $ b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? $ d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing…
In September 2019, the budget committee of Jason Company assembles the following data: 1. 2 Expected Sales 4. October November December Cost of goods sold is expected to be 60% of sales. 3. Desired ending merchandise inventory is 20% of the next month's cost of goods sold. The beginning inventory at October 1 will be the desired amount. $1,800,000 1,700,000 V 1,600,000 Prepare the budgeted income statement for October through gross profit on sales, including a cost of goods sold schedule. V M JASON COMPANY Budgeted Income Statement For the Month Ended October 31, 2019 $ $
Required: Prepare Shadee's budgeted income statement for the months of May and June. Note: Do not round your intermediate calculations. Round your answers to 2 decimal places. Budgeted Gross Margin SHADEE CORPORATION Budgeted Income Statement Budgeted Net Operating Income May June
The selling and administrative expense budget of Garney Corporation is based on the number of units sold, which are budgeted to be 4,500 units in October. The variable selling and administrative expense is $6.50 per unit. The budgeted fixed selling and administrative expense is $28,080 per month, which includes depreciation of $11,520. The remainder of the fixed selling and administrative expense represents current cash flows. Required: Prepare the selling and administrative expense budget for October. Note: Do not round your intermediate calculations. Round your final answers to the nearest whole number. Fixed selling and administrative expense Total selling and administrative expense Cash disbursements for selling and administrative expenses October S 0 0
Assume a company's sales budget for July estimates 17,000 units sold. The variable selling and administrative expense used for budgeting purposes is $4.00 per unit sold. The total budgeted cash disbursements for selling and administrative expenses in July is $139,000. The total fixed selling and administrative expenses included in the selling and administrative expense budget for July is $100,000. What is the amount of depreciation included in the selling and administrative expense budget for July? Multiple Choice O OOO $14,000 $32,000 $29,000 $47,000
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units February, 95 units March, 102 units April, 107 units May, 114 units June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units March, 102 units April, 102 units May, 104 units June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units April, 102 units May, 99 units June, 117 units In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units May, 94 units June, 107 units In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units June, 102 units In May of the current year, sales for June were…
Prepare a budgeted balance sheet at March 31 using the following information from Zimmer Company. a. The cash budget for March shows an ending loan balance of $20,000 and an ending cash balance of $75,000. b. The sales budget for March shows sales of $140,000. Accounts receivable at the end of March are budgeted to be 60% of March sales. c. The merchandise purchases budget shows that $91,000 in merchandise will be purchased on credit in March. Purchases on credit are paid 100% in the month following the purchase. d. Ending merchandise inventory for March is budgeted to be 800 units at a cost of $35 each. e. Income taxes payable of $28,000 are budgeted at the end of March. f. Accounting records at the end of March show budgeted equipment of $82,000 with accumulated depreciation of $35,000. g. Common stock of $35,000 and retained earnings of $60,000 are budgeted at the end of March. ZIMMER COMPANY Budgeted Balance Sheet As of March 31 $ 0 0 0
i need answer step by step
In May 2022, the budget committee of Crane Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $400,000, July $480,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CRANE STORES Merchandise Purchases Budget $ $
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $41,000. b. Actual sales for May and June and expected sales for July are as follows: May $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 June July Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected In the second month following sale. The remaining 2% is uncollectible. C. Purchases of inventory will total $376,000 for July. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $174,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $452,000 for July. Of this amount, $63,500 is for depreciation. e. A new web server for the Marketing Department costing $86,500 will be…
Use the following information to prepare the September cash budget for PTO Company. Ignore the "Loan activity" section of the budget. a. Beginning cash balance, September 1, $43,000. b. Budgeted cash receipts from September sales, $259,000. c. Direct materials are purchased on credit. Purchase amounts are August (actual), $77,000, and September (budgeted), $104,000. Payments for direct materials follow: 65% in the month of purchase and 35% in the first month after purchase. d. Budgeted cash payments for direct labor in September, $35,000. e. Budgeted depreciation expense for September, $3,200. 1. Budgeted cash payment for dividends In September, $55,000. g. Budgeted cash payment for Income taxes in September, $10,900. h. Budgeted cash payment for loan Interest in September, $1,600. PTO COMPANY Cash Budget Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash payments for Direct materials Direct labor Dividends Income taxes Interest on loan Total cash…