Budgeted sales in Acer Corporation over the next four months are given below: September $120,000 October November December Budgeted sales $140,000 $180,000 $160,000 Thirty percent of the company's sales are for cash and 70% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 20% are collected in the second month following sale, Given these data, cash collections for December should be:
Q: Budgeted sales for January $200,000 and February $100,000. Collections for sales are 60% in…
A: Budgeted cash collection: =Beginning accounts receivable+ (Budgeted level of sales *Collections for…
Q: Valentina Company will begin operations on January 1st. The company has provided the following…
A: Calculation of cash receipts from customers for the first 6 months:: The collection policy of the…
Q: Bright Minds Toy Company prepared the following sales budget for the second quarter Projected sales…
A: The cash budget is prepared by the management to identify the future available cash and it helps to…
Q: Music World reports the following budgeted sales: August, $190,000; and September, $250,000. Cash…
A: Lets understand the basics. Cash receipt and cash payment schedule is prepared by the management to…
Q: Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of…
A: Sales Budget is prepared by the Business Entities to estimate the sales required to achieve the…
Q: Budgeted sales in sabrina corporation over the next four months are given below: Twenty-five…
A: Cash collected and sale revenue both are having different meaning. Sale revenue is recognised in…
Q: Wells Company reports the following budgeted sales: September, $58,00O; October, $71,000; and…
A: All the sales are on credit and collection starts from the next month. Therefore, the collection…
Q: Parlee Company's sales are 30% in cash and 70% on credit. Sixty percent of the credit sales are…
A: Formula: Cash sales value = Total sales x Cash sale Percentage Multiplying total sales with cash…
Q: Roberts Enterprises has budgeted sales in units for the next five months as follows: June…
A: The production budget is one of the vital budgets which calculates how much units is to be…
Q: The Cash Sales for the next three months (January to March) been estimated as $ 40,000, $ 50,000,…
A: Cash budget is a statement showing estimated cash inflows and cash outflows over the period of…
Q: Diaz Co. predicts sales of $80,000 for January and $90,000 for February. Seventy percent of Diaz’s…
A:
Q: CC expects sales for January, February, and March to be $420,000, $480,000, and $500,000,…
A: Budget means the expected value of future. Budget is not affected by the actual value as it is…
Q: Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here…
A: Budgets are the statements that show the estimated income and revenues over a specific future period…
Q: Parlee Company's sales are 30% in cash and 70% on credit. Sixty percent of the credit sales are…
A: Formula: Cash collected = Credit Sales amount x cash collection percentage.
Q: Bridgeport Inc. has budgeted sales for the second quarter of $340,000 for April; $505,000 for May;…
A: Cash budget is used in forecasting to determine supplier payment, receipts from customers which in…
Q: Tyler Corp has the following budgeted sales for the first 4 months of next year: January $80,000…
A: Amount collected from December sales in the month of January = $132,000 × 30%40% = $99,000
Q: Budgeted sales at Ikkea Manfacturing over the next four months are given below: September…
A: Expected cash receipts are the receipts which the seller expects from the buyers when the goods are…
Q: Skullduggery, Inc. reports the following information from its sales budget: Budgeted sales…
A: Amounts receivable is amount still not received from customers.
Q: Budgeted sales at Ikk Eaa Limited over the next four months are given below: September $150,000…
A: Cash collected has been calculated in the next step.
Q: Music World reports the following budgeted sales: August, $120,000; and September, $250,000. Cash…
A: Collection of prior period sales = August sales x 50% = $120000 x 50% = $60000
Q: The sales on account have been budgeted for last seven month as follow: Budgeted unit sales…
A: Sales revenue is described as the amount which is collected from the customers on account of goods…
Q: Brady, Inc. is in the process of budgeting cash inflows for the next three months. Cash sales are 10…
A: Cash Budget: A cash budget represents an organization's expected future cash flow over a set period…
Q: The Cambridge Company has budgeted sales revenues as follows.…
A: Cash budget is the estimated cash receipts and payments and also shows opening and closing cash…
Q: Thornton, Inc. has budgeted sales for the months of September and October at $300,000 and $270,000,…
A: A cash budget is an estimation of expected cash receipts and disbursements on the basis of past…
Q: Gargalicana Company is preparing its cash budget for next year. Budgeted sales for four months are…
A: Cash flows are the cash generated from the operation of the business organisation. In other words,…
Q: Frame Manufacturing Corporation has provided the following sales budget information: July August…
A: Cash budget is prepared to estimate the total cash received and total cash disbursement. It is…
Q: Your Company's sales are 20% in cash and the rest on credit. Forty-five percent of the credit sales…
A: Working Note: Credit sales % = 100 - cash sales % = 100% - 20% = 80%
Q: twenty percent of Sharp Company's sales are for cash and 80% are on account. Fifty percent of the…
A: You have posted four different questions. Since you have asked multiple question, we will solve the…
Q: The budget committee of Clipboard Office Supply has assembled the following data. Sales in April are…
A: Sales budget; The sales budget is prepared to estimate or project the sales in dollars and units for…
Q: A store has the following budgeted sales for the next three months. Cash sales are 25% of total…
A:
Q: Farmerlands Enterprises has budgeted sales for the months of September and October at $300,000 and…
A: Total Sales = Cash Sales +Credit Sales
Q: Budgeted sales for the first six months are listed below: JANUARY FEBRUARY MARCH APRIL MAY 8,000…
A: Closing inventory of May = Opening Inventory of June = 40% of June sales = 40% x 4,000 = 1,600
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: Castor Incorporated is preparing its master budget. Budgeted sales and cash payments for merchandise…
A: The cash budget is prepared to record cash receipts and cash payments made during the period.
Q: Budgeted sales for January$206,000 and February $109,000. times Collections for sales are50% in…
A: $16,350
Q: Whispering Winds Company has budgeted sales revenue as follows for the next 4 months: February…
A: The cash receipts schedule includes the total cash collection during the period.
Q: Getty Company expects sales for the first three months of next year to be $185,000, $235,000 and…
A: Schedule of cash receipts shows total amount of cash received in the period on account of cash sales…
Q: The budgeted credit sales are as follows: December last year January February March Collection:…
A: A cash budget is an estimate of a corporation's cash flows for a given time span. A cash budget is…
Q: Peak sales for General Products, Inc. occur in September. The company's sales budget for the third…
A: The cash collection schedule is prepared to record the estimated cash collections to be made during…
Q: Brady, Inc. is in the process of budgeting cash inflows for the next three months. Cash sales are 10…
A: >Budgeted cash collection is required for preparation of Cash Budget.>Budgeted sales can be in…
Q: Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales…
A: The amount which is not received till july 31 is written as uncollected. Given that, Total sales in…
Q: Roberts Enterprises has budgeted sales in units for the next five months as follows: June 4,560…
A: The production budget is prepared by the management to find out the units to be produced. It can be…
Q: Thirty percent of Sharp Company's sales are for cash and 70% are on account. Sixty percent of the…
A: Budgeting is a tool which is used on the process of planning and controlling the operational…
Q: Kingston budgets total sales for June and July of $470,000 and $348,000, respectively. Cash sales…
A: Cash sales = Total sales x cash sales % Credit sales = Total sales - Cash sales
Q: Budgeted sales in Allen Company over the next four months are : September $100,00, October $160,000,…
A: A budget is regarded as a plan that is prepared by an individual or by a group of people in order to…
Q: Roberts Enterprises has budgeted sales in units for the next five months as follows: 4,540 units…
A: Units Produced=Sales+Ending Inventory-Beginning inventory
Q: Forty percent of Soft Company’s sales are for cash and 60% are on account. Fifty percent of the…
A: The cash receipt includes the cash received by the sale of the asset and it does not include the…
Q: Your Company's sales are 40% in cash and the rest on credit. Fifty percent of the credit sales are…
A: Sales budget is a financial plan about how the resources should be used to obtain forecasted sales.
Q: Budgeted sales at Ikkeep Corporation over the next four months are given below: September…
A: Cash receipts will be calculated as follows: Cash Receipt = Current month cash sales + 50% of…
Q: The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three…
A: Budgeting is an important part of the business process. Without budgeting a business cannot track…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000Cash 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.Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?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.Pasadena Candle Inc. budgeted production of 785,000 candles for January. Wax is required to produce a candle. Assume 10 ounces of wax is required for each candle. The estimated January 1 wax inventory is 16,000 pounds. The desired January 31 wax inventory is 12,500 pounds. If candle wax costs 1.24 per pound, determine the direct materials purchases budget for January.
- 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.Budgeted income statement and supporting budgets The budget director of Birds of a Feather 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 January: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof product Plastic . . 0.50 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 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.Pasadena Candle Inc. projected sales of 800,000 candles for January. The estimated January 1 inventory is 35,000 units, and the desired January 31 inventory is 20,000 units. What is the budgeted production (in units) for January?