Concept explainers
Preparing a financial budget—schedule of cash payments Learning Objective 4 Mar. total cash pmts. $11,500
Marcel Company has the following projected costs for manufacturing and selling and administrative expenses:
January | February | March | |
Direct materials purchases | $3,100 | $ 3,500 | $ 4,800 |
Direct labor costs | 3,300 | 3,500 | 3,600 |
550 | 550 | 550 | |
Utilities for plant | 550 | 650 | 650 |
Property taxes on plant | 200 | 200 | 200 |
Depreciation on office | 550 | 550 | 550 |
Utilities for office | 250 | 250 | 250 |
Property taxes on office | 170 | 170 | 170 |
Office salaries | 3,500 | 3,500 | 3,500 |
All costs are paid in 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. Prepare a schedule of cash payments for Marcel for January. February and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31.
Note: Exercises E22-26 and E22-27must be completed before attempting Exercise E22-28.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Accounting: The Managerial Chapters (12th Edition) (loose Leaf Version)
- BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…arrow_forward6. Question Content Area Administrative Expense Budget Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $10,000 Insurance 2,100 Depreciation 3,900 Accounting services 800 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $fill in the blank 532c4bfc1f8bfa8_1 $fill in the blank 532c4bfc1f8bfa8_2 $fill in the blank 532c4bfc1f8bfa8_3 $fill in the blank 532c4bfc1f8bfa8_4 Insurance fill in the blank 532c4bfc1f8bfa8_5 fill in the blank 532c4bfc1f8bfa8_6 fill in…arrow_forwardInstruction: I want you to prepare a production budget of Learning is Fun Company with the provided information below. Learning is Fun Company forecasts sales in units for January to May as follows: Jan Feb Mar Apr 2,800 May 3,000 Units 2,000 2,200 2,500 Additional Information: • The Company would like to maintain 100 units in its ending inventory at the end of each month. • Beginning inventory at the start of January amounts to 50 units.arrow_forward
- Learning Objective 5 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 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 $9,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 $48,000, marketable securities of $68,000, and accounts receivable of $139,000 ($30,000 from July sales and $109,000 from August sales). Sales on account for July and August were $100,000 and $109,000, respectively. Current liabilities as of September 1…arrow_forwardSELF-DEVELOPMENT E-LIBRARY ZAIN HANDBOOKS Morgan Manufacturing is preparing its cash budget for the second quarter. The following amounts are budgeted for materials purchases: April $62.880 May $44,960 June $47.360 Morgan pays for 20% of its purchases in the month of purchase, 60% in the month following purchase, and 20% in the second month after purchase. What are Morgan's budgeted cash payments for purchases in June? O a. $93,120 Ob. $9,472 Oc. $39,552 O d. $49.024 Help Navt nan 10:06 AM РОСОРНONЕ 11/3/202 SHOT ON POCOPHONE F1arrow_forwardLearning Objective 4 Wiki Wiki Company has determined that the variable overhead rate is $4.50 per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is 10,000 hours for the month. Fixed costs are budgeted at $60,000 for the month. a. Prepare a monthly factory overhead flexible budget for 9,000, 10,000, and 11,000 hours of production. Enter all amounts as positive numbers. Wiki Wiki Company Monthly Factory Overhead Cost Budget-Fabrication Department Direct labor hours Variable factory overhead cost Fixed factory overhead cost Total factory overhead cost 9,000 $ $ 10,000 $ $ 11,000 b. How much overhead would be applied to production if 9,000 hours were used in the department during the month? If required, round your calculations to two decimal places and your final answer to the nearest dollar.arrow_forward
- R LTE Learning Objective 6 Appendix 22A Jun, purchases $67,000 21:14 1-22.docx E22A-32 Preparing an operating budget Tremont, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2014, follows: Quarter Ended Nine-Month Total March 31 June 30 September 30 Cash sales, 20% $ 24,000 $ 34,000 $ 29,000 $ 87,000 Credit sales, 80% 96,000 136,000 116,000 348,000 Total sales $ 120,000 $170,000 $145,000 $435,000 In the past, cost of goods sold has been 40% of total sales. The director of mar- keting and the financial vice president agree that each quarter's ending inventory should not be below $20,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of $220,000 during the fourth quarter. The January 1 inventory was $32,000. Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period. Prepare an operating budgetarrow_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,295 120,832 Direct labor 75,210 73,298 Manufacturing overhead 25,400 25,400 Selling and administrative expenses 33,600 33,400 Depreciation included in selling and administrative 1,600 900 Collections from customers 215,393 240,156 Cash payments for purchases 114,295 119,254 Additional data:Capital assets were sold in January for $9,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quartersarrow_forwardeBook Show Me How Print Item Question Content Area Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland CompanyBudget Performance Report—Vice President, ProductionFor the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $2,300,000 $2,287,900 $(12,100) Central Region 3,000,000 2,988,400 (11,600) Western Region (g) (h) (i) $(j) $(k) $(l) $(23,700) Garland CompanyBudget Performance Report—Manager, Western Region PlantFor the Month Ended November 30 Department Budget Actual Over Budget Under Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 700,000 703,200 3,200 Final Assembly 525,000 516,600 $(8,400) $(d) $(e) $(f) $(8,400) Garland CompanyBudget Performance Report—Supervisor, Chip FabricationFor the Month Ended…arrow_forward
- Prepare Hilton goods sold computations. 2. Prepare a combined cash budget similar to exhibits in the chapter. If no financing ac- P9-61A Cash budgets (Learning Objective 3) and cash disbursements: are as follows: Budgeted Sales Revenue $62,000 January $70,000 February. b. Actual purchases of direct materials in December were $24,500. The companye purchases of direct materials in January are budgeted to be $24,000 and $26.000 i February. All purchases are paid 40% in the month of purchase and 60% the follow month. c. Salaries and sales commissions are also paid half in the month earned and half the next month. Actual salaries were $8,000 in December. Budgeted salaries in Janu- ary are $9,000 and February budgeted salaries are $10,500. Sales commissions each month are 8% of that month's sales. d. Rent expense is $3,500 per month. e. Depreciation is $2,100 per month. f. Estimated income tax payments are made at the end of January. The estimated tax payment is projected to be $12,500. g.…arrow_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,300 120,832 Direct labor 75,205 73,298 Manufacturing overhead 25,300 25,400 Selling and administrative expenses 33,400 33,500 Depreciation included in selling and administrative 1,500 900 Collections from customers 215,392 240,154 Cash payments for purchases 114,290 119,254 Additional data:Capital assets were sold in January for $10,000 and $4,400 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $Beginning Cash Balance $Beginning Cash Balance Add: Cash Receipts Collections from Customers…arrow_forwardb. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub