The budget director of Heather's Florist has prepared the following sales budget. The company had $50,000 in accounts receivableon July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale,Requireda. Complete the schedule of cash receipts by filling in the missing amounts.b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.Complete this question by entering your answers in the tabs below.Required A Required 8Complete the schedule of cash receipts by filling in the missing amounts.Sales BudgetCash salesSales on accountTotal budgeted salesSchedule of Cash ReceiptsCurrent cash salesPlus: Collections from accounts receivableTotal budgeted collections$$July40,000 $45,00085,000 $$ 90,000 $August September42,500 $54,00096,500 $87,500 $45,00064,800109,80099,000 The budget director of Heather's Florist has prepared the following sales budget. The company had $50,000 in accounts receivableon July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale.Requireda. Complete the schedule of cash receipts by filling in the missing amounts.b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.Complete this question by entering your answers in the tabs below.Required A Required BDetermine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.Accounts receivable

The budget director of Heather's Florist has prepared the following sales budget. The company had $50,000 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale, Required a. Complete the schedule of cash receipts by filling in the missing amounts. b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

The budget director of Heather's Florist has prepared the following sales budget. The company had $50,000 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale, Required a. Complete the schedule of cash receipts by filling in the missing amounts. b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

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

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 42,000 Accounts receivable 201,600 Inventory 58,050 Buildings and equipment (net) 352,000 Accounts payable $ 85,725 Common stock 500,000 Retained earnings 67,925 $ 653,650 $ 653,650 Actual sales for December and budgeted sales for the next four months are as follows: December(actual) $ 252,000 January $ 387,000 February $ 584,000 March $ 298,000 April $ 195,000 Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. The company’s gross margin is…
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 48,000 Accounts receivable 224,000 Inventory 60,000 Buildings and equipment (net) 370,000 Accounts payable $ 93,000 Common stock 500,000 Retained earnings 109,000 $ 702,000 $ 702,000 Actual sales for December and budgeted sales for the next four months are as follows: December(actual) $ 280,000 January $ 400,000 February $ 600,000 March $ 300,000 April $ 200,000 Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December…
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $83,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $ 53,000 $ 57,000 $ 63,000 Plus: Desired ending inventory 5,700 Inventory needed Less: Beginning inventory…
The budget director for Adams Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations; accordingly, there are no beginning account balances. Required a. Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. b. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. c. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the schedule of cash payments for S&A expenses by filling in the missing…
The treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Forty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining sixty percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $60,000. What is the amount to include in the Cash Budget for the month of March for the Merchandise Costs (which does include the beginning balance from February)? MARCH APRIL Merchandise costs $120,000 $132,000 Operating expenses 100,000 110,000
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech’s managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $410,000, $430,000, $420,000, and $440,000, respectively. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 30% of the cost of next month’s sales. The cost of goods sold is 70% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are…
Emerald Service anticipates the following sales revenue over a five-month period Its collection history indicates that credit sales are collected as follows E (Click the icon to view the sales data ) The company's sales are 40% cash and 60% credit O (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole dollar) Emerald Service Cash Collections Budget For the Months of January through March January Cash sales 6,080 Collection of credit sales 25% Month of sale 2,280 50% Month after 15% Two months after Total cash collections
Prepare Bates & Hill's cash receipts budget for the first quarter. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Laura Falk, Bates & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February March Quarter Budgeted revenue $525,000 $588,000 $672,000 $1,785,000 The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 72% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 2% of sales are uncollectible. The company expects to have a net accounts receivable balance of $98,200 on January 1, and this amount represents the remaining receivables from December's sales.
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $82,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January $ Budgeted cost of goods sold Plus: Desired beginning inventory Inventory needed Less: Desired beginning inventory Required purchases (on account) $…
s
The following information was taken from Trusted Care Company's cash budget for the month of April: Beginning cash balance Cash receipts Cash disbursements If the company has a policy of maintaining an end of the month minimum cash balance of $25,000, the amount the company would have to borrow is $10,000 $13,000 $11,000 $0 $27,000 62,000 75,000
The controller of Feinberg Company is gathering data to prepare the cash budget for July. Heplans 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 salescollected 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 salesare 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 actualsales, and the last 3 months are estimated sales.) SalesApril $ 450,000May 580,000June 900,000July 1,140,000August 1,200,000September 1,134,000d. The company sells all that it produces each month. The cost of raw materials equals 26%of each sales dollar.…