QS 20-23 Budgeted loan activity LO P2 Santos Co. is preparing a cash budget for February. The company has $18,000 cash at the beginning of February and anticipates $69,000 in cash receipts and $109,000 in cash payments during February. What amount, if any, must the company borrow during February to maintain a $4,000 cash balance? The company has no loans outstanding on February 1. (Negative cash balances, if any, should be indicated with minus sign.) SANTOS CO. Cash Budget For Month Ended February 28 Beginning cash balance ES Total cash available Preliminary cash balance Ending cash balance
Q: Baldwin Enterprises has two service departments, Personnel and Legal, and two operating divisions,…
A: Lets understand the basics.In direct cost allocation, cost are directly allocated from the service…
Q: Flint Corporation produces microwave ovens. The following unit cost information is available: direct…
A: Given information, Direct materials = $33Direct labor = $29Variable manufacturing overhead =…
Q: 3. Please complete the journal entries for this St. Joseph’s Hospital began operations in December…
A: Dear student, here's a detailed breakdown and explanation of the journal entries you need to prepare…
Q: ABC Corporation uses customers served as its measure of activity. During February, the company…
A: Formulas:Revenue variance = Flexible budgeted revenue - Actual revenueSpending variance =…
Q: Top Sound International designs and sells high-end stereo equipment for auto and home use. Engineers…
A: Contingency should be recognized only if following criteria are met :The loss is probableThe amount…
Q: None
A: To calculate the requirements, we will be using the following formulas: Fraction to Allocate…
Q: (a) Compute the income increase or decrease from eliminating this segment. (b) Should the segment be…
A: Cost-Volume-Profit (CVP) analysis is a managerial accounting technique used to examine the…
Q: A first-year co-op student is trying to determine the amount of cash and cash equivalents that…
A: The objective of the question is to calculate the amount of cash and cash equivalents that should be…
Q: Prepare a flexible selling and administrative expenses budget for January 2016, for sales volumes of…
A: Part 1:Answer:Agent Blaze Flexible Selling and Administrative Expenses Budget For the Month Ending…
Q: K Use the 2021 marginal tax rates to compute the income tax owed by the following couple. Filing…
A: IIncome tax is a tax that central governments imposes on income generated by businesses and…
Q: Plij answer qvitium
A: The objective of the question is to calculate the machine setup overhead assigned to the order using…
Q: Company manufactures sells a single erating at capacity, the company can produce and sell 46,000…
A: The relevant cost is the cost which differs between the two alternatives and is avoidable. If the…
Q: The following data pertain to three divisions of Nevada Aggregates, Incorporated. The company's…
A: ROI means return on investment. It is the percentage return earned by the entity on the operating…
Q: None
A: Step 1:a) Incremental Analysis for the decision to make or buy bicycle seats. Make (a) Buy…
Q: i need answer step by step
A: Detailed explanation: To arrive at those answers, we comply with a sequence of steps to calculate…
Q: What are the total costs allocated to the surgery department from the supporting departments?
A: Cost allocation for the sponsoring organization's business activities will be divided as a…
Q: Super Speedy Delivery Services has the collected the following information about operating…
A: Detailed explanation:Formula : Fixed Cost = highest activity cost - (variable cost per unit x…
Q: based on the hours used. The cost of operating the accounting (acct), administration (admin), and…
A: In the reciprocal method of calculation of allocation of costs, there are three methods…
Q: Hardev
A:
Q: Variable and Absorption Costing The following data were adapted from a recent income statement of…
A: VARIABLE COSTINGVariable Costing is a Cost Managerial Accounting Method in which all variable cost…
Q: None
A: This topic sentence is unfocused because it introduces two distinct ideas without clearly connecting…
Q: am. 104.
A: The question is asking about the appropriate value of an asset under a finance lease that should be…
Q: None
A: Armed Forces Surplus Inventory ValuationWe can determine the cost of goods sold (COGS) and ending…
Q: how much income will be allocated to Roberto?
A: Reagan holds 25-percent ownership or management of Bright Light Incorporated.Bright Light generated…
Q: Take me to the text Jaclyn earns a salary of $50,000 per year and is paid semi-monthly. The current…
A: The objective of the question is to calculate Jaclyn's net pay for each semi-monthly pay period…
Q: Hardev
A: The objective of the question is to calculate the flexible budget amounts of fixed and variable…
Q: Cox Electric makes electronic components and has estimated the following for a new design of one of…
A: Dear student, below is an answer to your assignment on constructing a spreadsheet model for Cox…
Q: Select an "x" in the column that corresponds to the type of activity - level referred to in each…
A: Activity-based costing:Activity-based costing is one of the types of cost accounting methods which…
Q: Required Information [The following information applies to the questions displayed below.] Hemming…
A: The objective of the question is to calculate the cost of goods sold (COGS) and ending inventory…
Q: A company cannot be increasing its market share if its net sales are declining
A: The objective of the question is to understand whether a company can increase its market share even…
Q: The following information comes from the 2024 Annual Report to stockholders of Composition…
A: Treasury stock refers to common stock repurchased by a business from the stockholders that were…
Q: Vishnu
A: Step 1: Calculation of earning taxable for FUTA and SUTA.= First $7,000 - Gross pay= $7,000 -…
Q: Activity Capacity Management Uchdorf Manufacturing just completed a study of its purchasing activity…
A: Answer:- Variances indicate the differences between the budgeted and actual values. In this, if the…
Q: Particulars Amount Particulars Statutory reserve Amount 21,000 Interest on Fixed Deposits 240,000…
A: Answer:-Prepare the following for Dhofar Bank for the year ended 31st December 2023 based on the…
Q: Each of the three independent situations below describes a finance lease in which annual lease…
A: A lease is a legal agreement between a lessor (the owner of an asset) and a lessee (the user of the…
Q: Problem 3 A metal plating company on government contract is considering four different methods for…
A: The objective of the question is to determine the most economically viable method for recovering…
Q: None
A: To compute the target unit cost of the filter, we need to find the total cost that needs to be…
Q: Use the following information for the Exercises below. (Algo) [The following information applies to…
A: Step 1: Current Ratio is the ratio between current assets & current liabilities.Current Assets…
Q: Do not give solution in image
A: Step 1:We have to fill the new values column and then calculate the return on assets (ROA).ROA = NET…
Q: Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income…
A: Step 1:Answer 1.Computation of the overall contribution margin (CM) ratio for the company:Overall…
Q: 82. Use the following information (in thousands): Service Revenue Income from continuing operations…
A: Step 1: Understand the information. We are provided with a variety of financial information for the…
Q: A local chapter of the Society for Protection of the Environment benefited from the voluntary…
A: Here are the reasons one might agree with the notion that the Society should recognize revenues from…
Q: None
A: Rainy Days Umbrellas has faced a budget cut, reducing funding for the Product Development Group…
Q: The Josh Cutler Corporation provides restricted stock to certain executives. Under the plan, the…
A: Compensation Cost:The sum of money that a person who has suffered loss or injury seeks from the…
Q: Salsa Company is considering an investment in technology to improve its operations. The investment…
A: The objective of the question is to evaluate the financial feasibility of a proposed investment by…
Q: en Depot is a retailer that is preparing its budget for the upcoming fiscal year budgeted cash…
A: The cash budget is prepared to record the cash receipts and cash disbursements during the period.…
Q: Match the term with its definition. Allowance Method Cash Factoring Net Realizable Value…
A: The objective of the question is to match the accounting terms with their respective definitions.
Q: please don't provide han writing solution
A: Step 1: Step 2: Step 3:
Q: Munabhai
A: The objective of the question is to allocate the service department costs to the production…
Q: Cupola Fan Corporation issued 10%, $600,000, 10-year bonds for $570000 on June 30, 2024. Debt issue…
A: Bonds : Bonds are source of finance from Public.There are various types of bonds issued to…
Step by step
Solved in 2 steps
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March 2016: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lbs. Batting helmet........ 40 units at 25 per unit Foam lining 80 lbs. Football helmet....... 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic50 lbs. Batting helmet......... 50 units at 25 per unit Foam lining65 lbs. Football helmet........ 220 units at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lbs. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lbs. per unit of product Foam lining 1.50 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventor) of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department 1.80 hrs. at 14 per hr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2,300 h. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expense-selling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.
- Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 2016: At the end of December 2016, the following unit sales data were reported for the year: For the year ending December 31 , 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 3. Prepare a sales budget for the year ending December 31, 2017.