Given the condensed Cash Budget table below: Beginning cash balance............. .50,000 Collections from customers.......303,000 Total cash available.. Total cash disbursements... Ending cash balance...... .353,000 .324,000 .28,600 Milo Company's fixed selling and administrative expense doubled from 2,000 to 4,000 dollars, WHAT WOULD THE ENDING CASH BALANCE BE?
Q: Your Corporation makes and sells a single product. The company is in the process of preparing its…
A: Budgeted cash disbursements for selling and administrative expenses = Variable Cost Per Unit X No.…
Q: Below is budget information for next year for NGG Inc. Quarter 1 Quarter 2 Quarter 3 Quarter 4…
A: Budget: Budget is an effective tool to achieve the financial and operational goals of the business.…
Q: Create an internal cash budget based on the following information: Sales = $50,000 Rent = $20,000…
A: Budget is the estimation of revenue and expense prior to start the operation. To manage the working…
Q: A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires…
A:
Q: Newman Medical Clinic has budgeted the following cash flows. January February March $109,000…
A: Cash budget is the budget that represents cash inflows and disbursements during a particular period…
Q: . The Finance officer of Your Natural Romance Co asked for a CASH BUDGET given the following data:…
A: Cash budget is very important budget that is being prepared in business which shows all expected…
Q: Thornton, Inc. has budgeted sales for the months of September and October at $305,000 and $283,000,…
A: The cash collection schedule is prepared to estimate the cash collected from the customers during…
Q: aborosa, Inc., a merchandising company, has provided the following budgeted amounts for the next…
A: Ending cash balance should be minimum $30,000. If cash balance is less than $30,000, deficiency will…
Q: Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has…
A: Cash Budgeting : A Cash Budget is an estimation of expected receipts of cash and also expected…
Q: Before the year began, JenCo developed the following static budget for the estimated sales of 37,000…
A: The contribution is calculated as the difference between the sales and variable costs. The net…
Q: 7,500 38,500 33,500 Rooney Medical had a cash balance of $14,500 on…
A: A cash budget is a projection of a company's cash flows over a specific time period. This could be a…
Q: Gibson Medical Clinic has budgeted the following cash flows. Cash receipts January $ 108,000…
A: Cash budgeting gives firms information about available finances for capital expenditures and other…
Q: Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash…
A: Computation of Collection from Customer Particulars September October November Collection for…
Q: The following information was taken from Southgate Industry’s cash budget for the month of July:…
A: The cash budget is prepared by the management to know the future cash availability of cash. It…
Q: Which is the correct answer? The following information was reported in a cash budget: Beginning…
A: Budget: A budget is an estimation to determine the income that will be earned and expenses that will…
Q: Alpha Company makes all its sales on account. The accounts receivable payment experience is as…
A: Budgeted cash collection is the expected cash is to be collected in a particular month for the…
Q: 2. The following information has been assembled to assist in preparing a cash budget for the…
A: Budgeting - Budgeting is the process of estimating future operations based on past performance. %…
Q: Gibson Medical Clinic has budgeted the following cash flows: January February March Cash…
A: A cash budget is a budget prepared by the company which shows the net cash of the company in the…
Q: Relevant data from the operating budget of The Framers are: quarter 1 quarter 2 Sales $35,000…
A: The cash budget is prepared to record the cash receipts and collection during the period. It helps…
Q: 2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignmentS... A…
A: GROW INC.Schedule of Cash Payments for Selling and Administrative ExpensesFor the Three Months…
Q: Cash receipts budget Scottsdale Co. has actual sales for July and August and forecast sales for…
A: Cash receipts are the amounts in cash which is received by the company on account of credit sales.
Q: The following information is budgeted for McCracken Plumbing Supply Company for next quarter: April…
A: A cash budget is the estimation of the cash flows for a business over a specified period of time.
Q: Your Corporation makes and sells a single product. The company is in the process of preparing its…
A: The cash when is paid in the form of any expense or during purchase is known as cash disbursement.
Q: Use the following information a. Beginning cash balance on March 1, P72,000. b. Cash receipts from…
A: Cash budget was used by the entity to plan for expected cash receipts and cash payments for a given…
Q: Duffy Corp. has provided a part of its budget for the second quarter. Apr $40,000 Cash collections…
A: PARTICULARS APRIL ($) BEGINING BALANCE $13,000 CASH COLLECTION $40,000 LESS : CASH…
Q: Stuart Medical Clinic has budgeted the following cash flows: January February March Cash…
A: A cash budget is prepared to calculate the estimated cash receipts and cash payments. Cash budget is…
Q: b. C. e. f - h. PROBLEM 8-29 Completing a Master Budget LOB-2, LOB-4, LOB-7, LOB-B, LOB-S, LOB-10…
A: Budgeted Financial Statement: Budgeted financial statements offer information about a company's…
Q: Newman Medical Clinic has budgeted the following cash flows. January February March $11,000 $117,000…
A: Answer - Cash Budget - A cash budget is a company's estimation of cash inflows and outflows over…
Q: nning Medical Clinic has budgeted the following cash flows. January $105,000 February $111,000 March…
A: Cash budget is the budget which represent cash inflows and disbursements during a particular period…
Q: Baird Medical Clinic has budgeted the following cash flows. February $108,000 March January $102,000…
A: Cash budget is prepared when one wants to asses whether there is sufficient amount of cash in hand…
Q: Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign.…
A: Cash budget refers to a budget which shows the estimated cash flows of the company during a specific…
Q: Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st…
A: GARDEN DEPOTCash Budget 1st Quarter2nd Quarter3rd Quarter4th QuarterYearBeginning cash…
Q: Arberg Company's controller prepared the following budgeted income statement for the coming year:…
A: ‘’Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: 3. Budji Corp. is preparing its budget for 19B. For 19A, the following were reported: Sales (100,000…
A: The net income is calculated as difference between sales and total costs incurred.
Q: Mohan Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning next…
A: CVP analysis is used as a decision-making tool that helps management to make strategies and take…
![Given the condensed Cash Budget table below:
Beginning cash balance..............50,000
Collections from customers.......303,000
Total cash available.….….….........
Total cash disbursements..
Ending cash balance..
353,000
.324,000
..28,600
If Milo Company's fixed selling and administrative expense doubled from 2,000 to 4,000 dollars,
WHAT WOULD THE ENDING CASH BALANCE BE?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0b41e07f-e39f-4bfb-9fc6-410ea6b6db34%2F7b918e01-90eb-4056-94ea-7b933ec18579%2F9guh3xq_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- f. PROBLEM 8-29 Completing a Master Budget LOB-2, LOB-4, LOB-7, LOB-B, LOB-9, LOB-10 The following data relate to the operations of Shilow Company, a wholesale distributor of con- sumer goods: g. h. b. Actual and budgeted sales data: a. The gross margin is 25% of sales. c. d. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets). Equipment costing $1.500 will be purchased for cash in April. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in…Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows:1st Quarter 2nd Quarter 3rd Quarter 4th QuarterTotal cash receipts .............................. $180,000 $330,000 $210,000 $230,000Total cash disbursements .................... $260,000 $230,000 $220,000 $240,000The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requiresa minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterlyinterest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repayits loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at thetime it is repaid. For simplicity, assume that interest is not compounded.Required:Prepare the company’s cash budget for the upcoming fiscal yearA cash budget, by quarters, is given below for a retail company (000 omitted). The company requires aminimum cash balance of at least $5,000 to start each quarter.Quarter1 2 3 4 YearCash balance, beginning ............................ $ 6 $ ? $ ? $ ? $ ?Add collections from customers ................. ? ? 96 ? 323Total cash available ................................... 71 ? ? ? ?Less disbursements:Purchase of inventory ............................. 35 45 ? 35 ?Operating expenses ................................ ? 30 30 ? 113Equipment purchases ............................. 8 8 10 ? 36Dividends ................................................ 2 2 2 2 ?Total disbursements .................................... ? 85 ? ? ?Excess (defi ciency) of cash availableover disbursements ................................. (2) ? 11 ? ?Financing:Borrowings .............................................. ? 15 — — ?Repayments (including interest)* ............ — — (?) (17) (?)Total fi nancing…
- Cash receipts budget Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows:Actual:July . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 98,000August . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105,000Forecast:September . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114,000October . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94,000November . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122,000December . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107,000Based on past experience, it is estimated that 30% of a month’s sales are collected in the month of sale, 55% are collected in the month following the sale, and 10% are collected in the second month following the sale.Required:Calculate the estimated cash receipts for September, October, and…Exercise 7 (Cash Budget Analysis) A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 2 3 4 Year Cash balance, beginning..................... P9 P? P? P? P? Add collections from customers….. ? ? 125 ? 391 Total cash available………………. 85 ? ? ? ? Less disbursements: Purchase of inventory….................. 40 58 ? 32 ? Operating expenses…………... ? 42 54 ? 180 Equipment purchases…................ 10 8 8 ? 36 Dividends…………………….. 2 2 2 2 ? Total disbursement………………..…Cash budget—comprehensive Following are the budgeted income statements for the second quarter of 2013 for SeaTech, Inc.:April May JuneSales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $140,000 $170,000 $190,000Cost of goods sold* . . . . . . . . . . . . . . . . . . . . . 96,000 114,000 126,000Gross profi t . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 44,000 $ 56,000 $ 64,000Operating expenses† . . . . . . . . . . . . . . . . . . . . 22,000 25,000 27,000Operating income . . . . . . . . . . . . . . . . . . . . . . . $ 22,000 $ 31,000 $ 37,000*Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead). †Includes all period costs (i.e., selling, general, and administrative expenses). The company expects about 30% of sales to be cash transactions. Of sales on account, 60% are expected to be collected in the first month after the sale is made, and 40% are expected to be collected in the second month after sale. Depreciation,…
- Use the following information a. Beginning cash balance on March 1, P72,000. b. Cash receipts from sales, P300,000. с. Budgeted cash disbursements for purchases, 140,000. d. Budgeted cash disbursements for salaries, 80,000. е. Other budgeted cash expenses, 45,000. f. Cash repayment of bank loan, 20,000. Prepare a cash budget for the month ended on March 31 for Mason Company. The budget should show expected cash receipts and cash disbursements for the month of March and the balance expected on March 31.Jaborosa, Inc., a merchandising company, has provided the following budgeted amounts for the next budget period. Beginning cash balance Cash collections Payments for: Purchases of merchandise inventory Selling and administrative expenses Capital expenditures $30,700 680,000 O A. $(17,700) OB. $710,700 OC. $290,900 O D. $32,300 349,300 70,500 308,600 A minimum cash balance of $30,000 is required to be maintained. The company can borrow in increments of $10,000 as and when required. Assume the company can borrow the needed funds at the end of the period. Calculate the ending cash balance for the budget period. C...Your Corporation makes and sells a single product. The company is in the process of preparing its Selling and Administrative Expense Budget for the last quarter of the year. The following budget data are available: Variable Cost Per Unit Sold Monthly Fixed Cost Sales commissions.................................. $2.10 Shipping................................................. $3.90 Advertising............................................. $7.40 $34,000 Executive salaries................................... $198,000 Depreciation on office equipment.......... $10,000 Other....................................................... $0.60 $38,000 All of these expenses (except depreciation) are paid in cash in the month they are incurred. The budgeted cash disbursements for selling and administrative expenses for October total $449,200. How many units does the company plan to sell in October? You…
- Your Corporation makes and sells a single product. The company is in the process of preparing its Selling and Administrative Expense Budget for the last quarter of the year. The following budget data are available: Variable Cost Per Unit Sold Monthly Fixed Cost Sales commissions.................................. $2.10 Shipping................................................. $3.90 Advertising............................................. $7.40 $34,000 Executive salaries................................... $198,000 Depreciation on office equipment.......... $10,000 Other....................................................... $0.60 $38,000 All of these expenses (except depreciation) are paid in cash in the month they are incurred. Thebudgeted cash disbursements for selling and administrative expenses for October total $462,000.How many units does the company plan to sell in October? You…Cash BudgetExercise 7 (Cash Budget Analysis) A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 2 3 4 Year Cashbalance,beginning.. P9 P ? P ? P? P? Add collectionsfromcustomers.... ? ? 125 ? 391 Totalcash available... 85 ? ? Less disbursements: Purchaseofinventory. 40 58 ? 32 Operatingexpenses. 42 54 ? 180 Equipmentpurchases.. 10 8 8 36 Dividends... 2 2 2 2 ? Totaldisbursement.. 110 ? ? ? Excess (deficiency) of cash available Ordisbursements.... (3) 30 ? ? Financing: Borrowings.. ? 20 Repayments (including interest)*.. (?) (7) (?) Total financing... ? ? (?) (?) Cash balance, ending.... P ? P ? P ? P ? P? *Interest will total P4, 000 for the year. Required: Fill in the missing amounts in the table above.