FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Lindor Enterprises projects sales for the first three months of the year to be: $10,400 in January, $12,500 in February, and $13,100 in March. Cash receipts are expected to be: $8,580 in January, $11,820 in February, and $12,700 in March.
They anticipate the following cash payments:
Also, Lindor Enterprises beginning cash balance is $3,100 and they desire to maintain a minimum ending cash balance of $3,100. Lindor Enterprises borrows cash as needed at the beginning of each month in increments of $900 and repays the amounts borrowed in increments of $900 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 5% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.
Complete aCash Budget for Lindor Enterprises.
Lindor EnterprisesCash BudgetFor the Quarter Ending March 31
They anticipate the following cash payments:
Lindor Enterprises | January | February | March |
---|---|---|---|
Direct materials purchased | $3,600 | $4,200 | $4,700 |
Direct labor costs | $3,300 | $4,000 | $3,500 |
$570 | $570 | $570 | |
Utilities for plant | $650 | $650 | $650 |
Property taxes on plant | $170 | $170 | $170 |
Depreciation on office | $580 | $580 | $580 |
Utilities for office | $350 | $350 | $350 |
Property taxes on office | $180 | $180 | $180 |
Office salaries | $3,000 | $3,000 | $3,000 |
All costs are paid in the month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1.
Also, Lindor Enterprises beginning cash balance is $3,100 and they desire to maintain a minimum ending cash balance of $3,100. Lindor Enterprises borrows cash as needed at the beginning of each month in increments of $900 and repays the amounts borrowed in increments of $900 at the beginning of months when excess cash is available. The interest rate on borrowed amounts is 5% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.
Complete a
Lindor EnterprisesCash BudgetFor the Quarter Ending March 31
January | February | March | Total | |
---|---|---|---|---|
Beginning cash balance | ||||
Cash receipts | ||||
Cash available | ||||
Cash payments: | ||||
Purchases of direct materials | ||||
Direct labor | ||||
Manufacturing |
||||
Selling and administrative expenses | ||||
Interest expense | ||||
Total cash payments | ||||
Ending cash balance before financing | ||||
Minimum cash balance desired | ||||
Projected cash excess (deficiency) | ||||
Financing: | ||||
Borrowing | ||||
Principal repayments | ||||
Total effects of financing | ||||
Ending cash balance |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Lindor Enterprises projects sales for the first three months of the year to be: $10,100 in January, $12,400 in February, and $12,900 in March. Cash receipts are expected to be: $8,450 in January, $11,770 in February, and $12,810 in March.They anticipate the following cash payments: Lindor Enterprises January February March Direct materials purchased $3,500 $4,000 $4,900 Direct labor costs $3,000 $4,100 $3,600 Depreciation on plant $510 $510 $510 Utilities for plant $650 $650 $650 Property taxes on plant $140 $140 $140 Depreciation on office $560 $560 $560 Utilities for office $370 $370 $370 Property taxes on office $170 $170 $170 Office salaries $2,900 $2,900 $2,900 All costs are paid in the month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a…arrow_forwardCurrent Attempt in Progress Sheridan Construction Company determines that 58000 pounds of direct materials are needed for production in July. There are 4200 pounds of direct materials on hand at July 1 and the desired ending inventory is 3000 pounds. If the cost per unit of direct materials is $5, what is the budgeted total cost of direct materials purchases for the month? ○ $296000. ○ $156000. O $284000. ○ $192000. Save for Later Attempts: 0 of 1 used Submit Answerarrow_forwardFillmore, Inc., expects sales of its housing for electric motors to be $82,000, $72,000, and $89,000 for January, February, and March, respectively. Its variable selling and administrative expenses are 11 percent of sales, and fixed selling and administrative expenses are $14,000 per month. Compute Fillmore's selling and administrative expense budget for January, February, and March. Budgeted selling and administrative expenses January February Marcharrow_forward
- Sydney Corporation, a provider of cable television, projects the following revenues: August September October $205,000 220,000 238,000 250,000 290,000 November December Total expenses are equal to 35 percent of the current month's revenues. Of this amount, $12,000 represents depreciation. Sixty percent of all accounts payable for expenses are paid for in the month incurred, with the remainder being paid in the following month. Compute the budgeted cash disbursements during November: $arrow_forwardSchedule of Cash Payments Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $184,900 April 172,000 May 156,500 Depreciation, insurance, and property taxes represent $39,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taves for the year will be paid in November. 71% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, Apri, and May. Enter all amounts as positive numbers. TADPOLE LEARNING SYSTEMS INC. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March Apr May March expenses Paid in March Paid in April Apri expenses Paidin April Pad in May May expenses Prepare a…arrow_forwardBlue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %arrow_forward
- S ABC Company's raw materials purchases for June, July, and August are budgeted at $39,000, $29,000, and $54,000, respectively. Based on past experience, ABC expects that 70% of a month's raw material purchases will be paid in the month of purchase and 30% in the month following the purchase. Required: Prepare an analysis of cash disbursements from raw materials purchases for ABC Company for August. Budgeted raw material purchases August cash payments: Current month's purchases Prior month's purchases Total cash payments June July August $ 0arrow_forwardSchedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.arrow_forwardSchedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…arrow_forward
- Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March April May Depreciation, insurance, and property taxes represent $19,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 61% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. $88,600 82,400 75,000 Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments Mayarrow_forwardThe Simmons Company finished their sales projections for the coming year. The company produces one product. Part of next year's sales projections are as follows. Projected Sales in Units July 125,000 August 145,000 September 139,000 October 155,000 November 180,000 The budget committee has also completed the following information on inventories. Raw Materials Ending Balance, June, 50,000 lbs Desired ending levels (monthly 10% of next month's production needs) Work-In-Progress None Finished Goods Inventory Ending Balance, June, 22,000 units Desired ending levels: 20% of next month's sales The Engineering Department has developed the following standards upon which the production budgets will be developed. Item Standard Material usage 3 pounds per unit Material price per pound $2.00 per pound Labor usage 0.5 hours per unit Labor rate $40 per hour Machine hours 2 machine hours per unit The Simmons Company uses a modified allocation method for…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education