PROBLEM 7-H CASH DISBURSEMENTS BUDGET A 2016 cash budget is being prepared for the purchase of TOBI, a merchandise item. Budgeted data are: Cost of goods sold for 2016 P300,000 Accounts payable 1/1/16 P20,000 Inventory-1/1/16 P30,000 \12/31/16 P42,000. Purchases will be made in twelve equal monthly amounts and paid for in the following month. Required: How much is the 2003 budgeted cash payment for purchases of TOBI?
Q: PROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a…
A: Budgets is the expected amount that is based on expected sales amount. In this question, the desired…
Q: Preparing a financial budget—schedule of cash payments Jefferson Company has budgeted purchases of…
A: Schedule of cash payments Particulars January February Paid for Purchase in January…
Q: PRODUCTION BUDGET PRODUCTION BUDGET Flower Horn, Inc. reported the following information for 2015:…
A: The budget is prepared to estimate the requirements for the future period.
Q: Question 1 View Policies Current Attempt in Progress Heaters, Inc. provided the following budgeted…
A: Budgeted net income has to determined by deducting projected expenses and cost of goods sold from…
Q: PROBLEM 7-H CASH DISBURSEMENTS BUDGET A 2016 cash budget is being prepared for the purchase of TOBI,…
A: In simple terms, budgets are the estimations of revenues and expenses for the future period.…
Q: Part B: Cash Budgets You have been asked to prepare a cash budget for June and July 2022 for Dragon…
A: Cash Budget: - Cash Budget is the budget prepared by the business which contains all cash receipts…
Q: Activity 4: Cash Budget All the purchases of Finnigan Company are made on account. Seventy percent o…
A: The budgets are prepared to estimated the cash requirements for the period.
Q: Q8) Prepare a cash budget for the first quarter for Shamz Logistics Inc., given the following data.…
A: Cash Budget is a statement of forecast to estimate the receipts and disbursement of cash for an…
Q: PROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales…
A: Cash budget:- A cash budget is considered as the estimation of cash inflows and outflows of a…
Q: PROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a…
A: Given: A merchandising company with Budgeted Sales (at retail): January - P300,000; February -…
Q: Problem #7: Operating Budgets Marker Products, Inc. sells all of its products on credit. The…
A: The budget is prepared to record the cash collection made during the period.
Q: P4-12 Cash budget: Advanced The Green PLC has projected following unit sales for Janu- ary 2019 to…
A: The question is based on the concept of preparation of cash receipt and disbursement for a company.…
Q: 4. CASH BUDGET Five-0 Corporation requires a minimum $15,000 cash balance. Loans taken to meet this…
A: The cash budget is prepared to record the cash receipts and cash disbursement during the period and…
Q: 138 Exercise 4-25 A sales budget for the first five months of 2021 is given on a certain product…
A: NOTE : As per BARTLEBY guidelines, when multiple questions are given then first question is to be…
Q: CASH BUDGET Richard LT Corporation is preparing its cash budget for the year 2015. Richard's…
A: Cash budget is one of the important budget that is being prepared by the business to analyse…
Q: Exercise I (Schedule of Expected Cash Collections) Peak sales for Mideast Products, Inc.., occur in…
A: The first step to making a schedule of expected money collections is determining however sales…
Q: Required: prepare budget of purchase for each of the first three months of 2011 prepare separate…
A: The details of budget for the year 2011 are given. Required prepare budget of purchase for each…
Q: P4-10 Cash budget: Basic Farmers Delight Corporation reported sales of $350,000 in June, $380,000 in…
A: From the given information we have to prepare the cash budget for the month of September , October…
Q: Question 9 View Policies Current Attempt in Progress The following information was taken from…
A: Cash budget shows the expected cash inflows and cash outflows for a budgeted period. Cash budget…
Q: PROBLEM 7-G COLLECTIONS BUDGET Marga Corporation has the following historical pattern of credit…
A: The answer is as fallows
Q: Cathy’s Cookies produces cookies for resale at local grocery stores. The company is currently in the…
A: Sales (units) for the quarter = Prior year quarterly sales + 20% increase
Q: A 2016 cash budget is being prepared for the purchase of TOBI, a merchandise item. Budgeted data…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: PR 7-4A Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly…
A: A Cash Budget represents the cash receipts and cash payments for the period. It helps the company to…
Q: Advent used their historic collection percentages to budget for sales revenue for the first quarter…
A: January February March Total sales (a) $100,000 $175,000 $250,000 x credit sales % 80% 80%…
Q: PROBLEM 7-G COLLECTIONS BUDGET Marga Corporation has the following historical pattern of credit…
A: Cash budget means expected cash receipts and expected cash payment with opening and closing cash…
Q: PROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales…
A: Budget is a written statement for a concerned period that is prepared on the basis of past…
Q: -/1 View Policies Current Attempt in Progress Scan Design provided the following budgeted…
A: The cash disbursement needs to be computed by taking all cash payments. Depreciation is a non-cash…
Q: ong & Short Company developed the following data for the preparation December 2021 budget: Expected…
A: calculations are as follows
Q: If you were the financial manager of Stars and Stripes Clothing, what would you do with the excess…
A: The company has surplus cash when the cash receipts are more than capital expenses
Q: Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has…
A: A cash budget is a budget prepared at the beginning of the period that includes the cash to be spent…
Q: QUESTION 4: CASH BUDGET JL is preparing its cash budget for the next three quarters of the 2019…
A: The cash budget is prepared to estimate the cash balance in hand in the business.
Q: CASH BUDGET 3. EEVEE CORP. prepared cash estimates for the next four months. developed for certain…
A: Cash budget is a plan of cash inflows and cash outflows of a business during a specified time…
Q: Your projected sales for the first 3 months of next year are as follows:January, $15,000; February,…
A: Given: Sales in January = $ 15,000 Sales in February = $ 20,000 Sales in March = $ 25,000 Sales in…
Q: e. Required: Using the new assumptions described above, complete the following requirements: 1.
A: Disclaimer: “Since you have posted a question with multiple sub-parts, we will solve first three…
Q: PROBLEM 7-G COLLECTIONS BUDGET Marga Corporation has the following historical pattern of credit…
A: Sales can be made on Cash or on Account. When Cash Sales is made , Cash is debited & on account…
Q: % in the month of sale and 40% in the month following the sale. 3. The company pays for 50% of its…
A: A cash disbursement is a financial outflow made in exchange for goods or services. To reimburse a…
Q: Accounts Receivable Collections Budget Example 1 Accounts Receivable Collections Budget $ December…
A: Budgeting - Budgeting is the process of estimating future operations based on past performance. %…
Q: PROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a…
A: Inventory refers to a stock or goods that are held in business for resale or are not sold yet.…
Q: Cash collections. ABC makes collections on sales as follows: 20% in the month of sale, 50% in the…
A: Cash Collection in June = (April sales x 30%) + (May sales x 50%) + (June sales x 20%)
Q: Sales Budgeting SALES BUDGET + Chloe Timbang reported the following information for 2015: Budgeted…
A: Sales budget is the estimation of the future sales of the company. It is used by the company to set…
Q: Cash Budget Daybook Inc. collects 30% of its sales on account in the month of the sale and 70% in…
A: Cash budget estimates the cash flows for a given period. Cash budget includes budgeted cash receipts…
Q: Budgeted Cash Collection (10 points) West Company budgeted the following credit sales during the…
A: November Cash received from sale in November (90000*10%)*(1-0.02) $8,820 Cash received from…
Q: Question 8 View Policies Current Attempt in Progress Waterway Industries reported the following…
A: Budgeted cash receipts are the cash inflows expected for a budgeted period.
Step by step
Solved in 2 steps
- 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.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 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.
- 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.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.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.