Pletcher Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the master budget for the first 2 quarters of 2020. All that remains in this process is the cash budget. The following information has been collected from other portions of the master budget and elsewhere. Beginning cash balance Required minimum cash balance Payment of income taxes (2nd quarter) Professional salaries 1st quarter 2nd quarter Interest from investments (2nd quarter) Overhead costs 1st quarter 2nd quarter Selling and administrative costs, including $2.220 depreciation 1st quarter 2nd quarter Purchase of equipment (2nd quarter) Sale of equipment (1st quarter) Collections from clients 1st quarter 2nd quarter Interest payments (2nd quarter) $33,300 27.750 4,440 155.400 155,400 7,770 85.470 111.000 55.500 77,700 55,500 13.320 260,850 421,800 222 Prepare a cash budget for each of the first two quarters of 2020 PLETCHER DENTAL CLINIC Cash Budget 1 Quarter 2 Quarte

Pletcher Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the master budget for the first 2 quarters of 2020. All that remains in this process is the cash budget. The following information has been collected from other portions of the master budget and elsewhere. Beginning cash balance Required minimum cash balance Payment of income taxes (2nd quarter) Professional salaries 1st quarter 2nd quarter Interest from investments (2nd quarter) Overhead costs 1st quarter 2nd quarter Selling and administrative costs, including $2.220 depreciation 1st quarter 2nd quarter Purchase of equipment (2nd quarter) Sale of equipment (1st quarter) Collections from clients 1st quarter 2nd quarter Interest payments (2nd quarter) $33,300 27.750 4,440 155.400 155,400 7,770 85.470 111.000 55.500 77,700 55,500 13.320 260,850 421,800 222 Prepare a cash budget for each of the first two quarters of 2020 PLETCHER DENTAL CLINIC Cash Budget 1 Quarter 2 Quarte

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

Helen is working on her department's budgeted annual income statement. In the process, she needs to determine the budgeted amount for selling, general, and administrative (SG&A) expenses in order to complete her budget. Sales Variable SG&A cost 11500 units $0.20 per unit Advertising expense $6200 per year Depreciation on office equipment $8600 per year Other fixed SG&A costs $24800 On the basis of the given data, what are total budgeted selling, general, and administrative (SG&A) expenses of the department? ○ $35700 O $33300 O $17100 O $41900
Prepare direct materials budget and show all calculations. Include quarterly and yearly totals
What is the production budget including quarterly and yearly totals?
answer in text form please (without image
Gig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process: Budgeted unit sales Selling price per unit Cost per unit Variable selling and administrative expense (per unit) Fixed selling and administrative expense (per year) Interest expense for the year 680 $ 2,060 $ 1,680 $50 $ 200,000 $22,000 Required: Prepare the company's budgeted income statement for the year. Gig Harbor Boating Budgeted Income Statement < Prev 9 of 9 Next ........
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $9,060 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay fall semester tuition in September 4,900 Pay rent at the beginning of each month 440 Pay for food each month 250 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,120 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOYCash BudgetFor the Four Months Ending December 31…
Please do not give solution in image format
Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 690,000 $ 860,000 $ 570,000 $ 470,000 Cost of goods sold 483,000 602,000 399,000 329,000 Gross margin 207,000 258,000 171,000 141,000 Selling and administrative expenses: Selling expense 87,000 106,000 68,000 47,000 Administrative expense* 48,500 65,600 42,200 45,000 Total selling and administrative expenses 135,500 171,600 110,200 92,000 Net operating income $ 71,500 $ 86,400 $ 60,800 $ 49,000 *Includes $29,000 of depreciation each month. Sales are 20% for cash and 80% on account. Sales on account are…
At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,900 Purchase season football tickets in September 190 Additional entertainment for each month 290 Pay fall semester tuition in September 4,600 Pay rent at the beginning of each month 700 Pay for food each month 640 Pay apartment deposit on September 2 (to be returned December 15) 700 Part-time job earnings each month (net of taxes) 1,400 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. a. Prepare a cash budget for September, October, November, and December. Enter all amounts as…
Prepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,780 Purchase season football tickets in September Additional entertainment for each month Pay fall semester tuition in September 120 310 4,700 Pay rent at the beginning of each month 430 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,090 KATHERINE MALLOY Cash Budget a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. For the Four Months Ending December 31 September October Estimated…
Case Study for REX Company.Comprehensive operating budget. REX, Inc., manufactures and sells snowboards. REXmanufactures a single model, the Pipex. In the summer of 2018, REXS accountant gatheredthe following data to prepare budgets for 2019:Materials and labor requirementsDirect materials:Wood 5 board feet per snowboardFiberglass 6 yards per snowboardDirect manufacturing labor 5 hours per snowboardREX’ CEO expects to sell 1,000 snow boards during 2019 at an estimated retail price of$ 450 per board. Further, he expects 2019 beginning inventory of 100 boards, and would liketo end 2019 with 200 snowboards in stock.Direct materials inventories Beginning Inventory Ending Inventory1/1/2019 12/31/2019________________________________________________________Wood 2,000 1,500Fiberglass 1,000 2,000Variable manufacturing overhead is allocated is allocated at the rate $ 7 per directmanufacturing labor-hour. There are also $ 66,000 in fixed manufacturing overhead costsbudgeted for 2019.REX combines…