Lacob Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and the extended physical. The charge for the basic physical is $105, while the charge for the extended physical is $155. Lacob expects to perform 205 basic physicals and 190 extended physicals in July, 255 basic and 200 extended in August, and 75 basic and 110 extended in September. Prepare the sales budget for the service revenue expected from the physical exams performed for the second quarter (July through September), with a column for each month and for the quarter in total. Complete the sales budget one step at a time. Number of exams performed (basic) Multiply by: Price per exam Service revenue (basic) Lacob Sports Medicine, Inc. Service Revenue Budget For the Months of July through September July August September I Quarter

Lacob Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and the extended physical. The charge for the basic physical is $105, while the charge for the extended physical is $155. Lacob expects to perform 205 basic physicals and 190 extended physicals in July, 255 basic and 200 extended in August, and 75 basic and 110 extended in September. Prepare the sales budget for the service revenue expected from the physical exams performed for the second quarter (July through September), with a column for each month and for the quarter in total. Complete the sales budget one step at a time. Number of exams performed (basic) Multiply by: Price per exam Service revenue (basic) Lacob Sports Medicine, Inc. Service Revenue Budget For the Months of July through September July August September I Quarter

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

The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. Past experience shows that30% of a month’s sales are collected in the month of sale, 60% in the month followingsale, and 8% in the second month following sale. The other 2% represents bad debts that are never collected. Budgeted sales and expenses for the…
Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 50 percent of their fees in the month the service is provided. In the month following service, Paul collects 40 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 85 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: ⚫ June 1 cash balance $16,000. ⚫ June 1 supplies on hand $4,400. ⚫ June 1 accounts receivable $9,100. • June 1 accounts payable $4,300. • Estimated sales for June, July, and August are $27,300, $41,000, and $43,900,…
In the coming year, Concord, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive- motion injuries. The brace will be sold for $13.00 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30% in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales units 29,000 41,000 57,000 77,000 Prepare Concord, Inc's cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Round "Budgeted sale price" and "Cash Receipts Budgets" answers to 2 decimal places, eg. 52.75 and all other answers to 0 decimal places, e.g. 5,275.)
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…
Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Munoz expects sales in January year 1 to total $270,000 and to increase 15 percent per month in February and March. All sales are on account. Munoz expects to collect 69 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 7 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Munoz will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the amount of accounts receivable as of March 31, year 1. (Do not…
Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 16,800 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,000 nozzles. Total uses of the nozzle are expected to be 14,700 in September and 15,540 in October. Nozzles are purchased at a wholesale price of $8. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 21,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September.
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 50 percent of their fees in the month the service is provided. In the month following service, Paul collects 40 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 85 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul’s busiest months: June 1 cash balance $16,000. June 1 supplies on hand $4,400. June 1 accounts receivable $9,100. June 1 accounts payable $4,300. Estimated sales for June, July, and August are $27,300, $41,000, and $43,900, respectively.…
Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 40 percent of their fees in the month the service is provided. In the month following service, Paul collects 50 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 70 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: June 1 cash balance $16,700. June 1 supplies on hand $4,500. June 1 accounts receivable $9,400. • June 1 accounts payable $4,400. • Estimated sales for June, July, and August are $28,200, $42,300, and $45,000,…
CIA Review, Inc. provides review courses twice each year for students studying to take the CIA exam. The cost of textbooks is included in the registration fee. Text material requires constant updating and is useful for only one course. To minimize printing costs and ensure the availability of books on the first day of class, CIA Review has books printed and delivered to its offices two weeks in advance of the first class. To ensure that enough books are available, CIA Review normally orders 10 percent more than expected enrollment. Usually, there is an oversupply, and books are thrown away. However, demand occasionally exceeds expectations by more than 10 percent and there are too few books available for student use CIA Review has been forced to turn away students because of a lack of textbooks. CIA Review expects to enroll approximately 200 students per course. The tuition fee is $810 per student. The cost of teachers is $22,000 per course, textbooks cost $59 each, and other operating…
Gibson is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions and utilities, which are paid in the month following their incurrence. July is the first month of operations, so there are no beginning account balances. Salary expense Sales commissions (4 percent of sales) Supplies expense Utilities Depreciation on store equipment Rent Miscellaneous Total S&A expenses before interest Required a. Prepare a schedule of cash payments for selling and administrative expenses. b. Determine the amount of utilities payable as of September 30. c. Determine the amount of sales commissions payable as of September 30. Complete this question by entering your answers in the tabs below. Req A Req B and C July $18,300 August September $18,300 $18,300 2,800 2,800 2,800 290 320 350 2,500 2,500 2,500 2,700 2,700 2,700 5,700 5,700 5,700 790 790 790 $33,080 $33,110 $33, 140…
The president of the retailer Prime Products has just approached the company's bank with a request for a $93,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $36,000. Accounts receivable on April 1 will total $179,200, of which $153,600 will be collected during April and $20,480 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…
Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 4,600 client-visits, but its actual level of activity was 4,580 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for January: Data used in budgeting: Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses Total expenses Actual results for January: Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses Fixed element Variable element per month $0 $ 28,600 1,500 10,500 7,600 $ 48,200 $ 130,000 $ 70,020 $ 21,012 $ 13,190 $ 7,440 per client-visit $36.60 $ 12.60 6.60 1.00 0.20 $ 20.40 The overall revenue and spending variance (i.e., the variance for net operating income in the revenue and spending variance column on the flexible budget performance report) for January would be closest to: