Please do not give solution in image format thanku Beginning cash balanceCollections from salesTotal cash available to spendLess: DisbursementsManufacturing overheadPayments for direct materialsDirect laborSelling & administrative expensesLand and Equipment purchasesIncome taxesIncome taxesTotal cash disbursementsCash excess (deficiency)Minimum cash balanceLV EnglisCash excess (needed)FinancingBorrowingsRepaymentsInterestTotal financingEnding cash balance:$$January$$FebruaryRight after the March column, there is the Quarter column, it just did not fit in the screenshotMarch00000000$ Chris Anderson, Sheffield & Daniel Fabricators' budget director, has received budget information from several managers and ispreparing the company's cash budget.January477,20080,505Collections from salesPayments for direct materialsPayments for direct labor98,640Payments for manufacturing overheads78,490Payments for Selling & administrative expenses 111,400●February560,860253,125103,68078,980116,440March637,720280,730116,64080,240123,160In addition to the information he received from these managers, Chris knows the following:Quarter1,675,780614,360318,960237,710351,000Sheffield & Daniel plans to have $32,400 in its cash account on January 1.Sheffield & Daniel plans to purchase and pay cash for a piece of land in January at a cost of $90,000.Sheffield & Daniel plans to make a cash purchase of equipment in March at a cost of $30,000.Sheffield & Daniel's income taxes from last quarter totaling $26,400 will be paid in January.

Cash budget is one of the important budget being prepared in business. It shows all cash inflows and…

Chris Anderson, Sheffield & Daniel Fabricators' budget director, has received budget information from several managers and is preparing the company's cash budget. Collections from sales Payments for direct materials Payments for direct labor 98,640 Payments for manufacturing overheads 78,490 Payments for Selling & administrative expenses 111,400 January 477,200 ● 80,505 Shoffok February March 637,720 560,860 253,125 103,680 78,980 116,440 280,730 116,640 80,240 In addition to the information he received from these managers, Chris knows the following: 123,160 Quarter 1,675,780 $26.400will be paid in lanuon 614,360 318,960 237,710 Sheffield & Daniel plans to have $32,400 in its cash account on January 1. Sheffield & Daniel plans to purchase and pay cash for a piece of land in January at a cost of $90,000. Sheffield & Daniel plans to make a cash purchase of equipment in March at a cost of $30,000. 351,000

Chris Anderson, Sheffield & Daniel Fabricators' budget director, has received budget information from several managers and is preparing the company's cash budget. Collections from sales Payments for direct materials Payments for direct labor 98,640 Payments for manufacturing overheads 78,490 Payments for Selling & administrative expenses 111,400 January 477,200 ● 80,505 Shoffok February March 637,720 560,860 253,125 103,680 78,980 116,440 280,730 116,640 80,240 In addition to the information he received from these managers, Chris knows the following: 123,160 Quarter 1,675,780 $26.400will be paid in lanuon 614,360 318,960 237,710 Sheffield & Daniel plans to have $32,400 in its cash account on January 1. Sheffield & Daniel plans to purchase and pay cash for a piece of land in January at a cost of $90,000. Sheffield & Daniel plans to make a cash purchase of equipment in March at a cost of $30,000. 351,000

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 7P: Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level...

See similar textbooks

Similar questions

Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a budgeted income statement for the year ended December 31, 2016.
Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: Estimated sales for March: Estimated inventories at March 1: Desired inventories at March 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for March: Estimated operating expenses for March: Estimated other revenue and expense for March: Estimated tax rate: 30% Instructions Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement for March.
Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.
Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Professional labor cost budget Based on the data in Exercise 13-5 and assuming that the average compensation per hour for staff is $36 and for partners is $300. prepare a professional labor cost budget for Day & Spieth, CPAs, for the year ending March 31. 20Y6. Use the following column headings:
Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a direct labor cost budget for May.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a production budget for May.
Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: Estimated sales of King and Prince chairs for February by sales territory: Estimated inventories at February 1: Desired inventories at February 28: Direct materials used in production: Anticipated purchase price for direct materials: Direct labor requirements: Instructions Prepare a sales budget for February. Prepare a production budget for February. Prepare a direct materials purchases budget for February. Prepare a direct labor cost budget for February.
At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: During January, the costs incurred in the Consumer Products Division were as follows: Instructions 1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. 2. For which costs might the director be expected to request supplemental reports?