P9-54A (similar to Dalt ng is preparing its ter budget for the irst quarter of the upcoming year. The folowing data pertan to Dalton anufacturing's operatian (click the icon to wew additional data. (Click the cen to view the data Read the requirements. 49,000 56,000 64,400 Data Table 73,000 83,600 Total cash colection Requirement 2. Prepare a production budget. Unit saless Sales in dollars/Selling price mber 31 (prior yeary Dalton Manufacturing Production Budget Accounts receivable, net For the Quarter Endod March Month and equipment, net Quarter February Accounts payable Unit sale3 9,200 Capital stock 2300 2425 Plus: Desired ending inventory Retained earnings Total needed 29,525 Less: Beginning 2.000 2,300 2.475 2.000 Print Done 9.850 Units to produce Roquiremer 3, Prepare a direct materiale budget. (Round your anewers lo the nearest whole do Dalton Manufacturing Direct Materials Budget For the Quarter Ended March 31 Units to be produced Multiply by: Quantity (pounda) of DM need per unit Quantity (pounds) needed for production Plus: Desired inventory of DM Total quantity (pounds) needed Less: Beginning inventory of DM Quantity (pounds) to purchase Multiply by Cost per pound Total ccet of DM purchases Enter any number in the edit fields and then click Check Answers 10 Clear 47,000 5.700 EQuestion Heb rojected to remain stable at $10 per untthroughout the budget Actual in December were $70,000. Selling price per uni period. Sales for the fist five months of the upcoming year budgeted to be January 80,000 February 92,000 March 99.000 97,000 85.000 b,Sales are 30% cash and 70% credit.AI credLeales are collected in the month follow the sale. Dalton Manufacharing a Policy that states that each month'sending inventory finished goods should be 25% of the in units). of each month's direct material purcha38 Bre paid the month of purchese. le the remainder is paid fo th following purchase. direct materi eeded per unit at$2.00 per pound. Ending inventory of direct materials should be 10% of next month's production needs. Most of the la at the manufactu facility is indirect, but there is irect labor inc d. Th rect labor hours per 0.01. The direct labor rate per hour ia S 2 per ho Al direct labor is paid for in the month in which the wor erformed. The direct labor total cost for each of the upcoming three months is as folows January 996 25 March f. Monthly manufacturing costs are $5.000 for factory rent, 3,000 for other fixed manufacturing expenses, and $1.20 per governuad ble manufacturing overhBad No depreciation is included inthese figure3. A expenses are paid in the month in which the Computer equipment for the administrative ofc88 will be purchBssd in the upcomi January Daton Menufacturing S5,000 (cash), while February expenditure will be$12,000 and March' h expenditure rchase equipme be $16, h operating exp udgeted to be 000 per unit sold plus ixed operatin a $1,000 pe nth. All operating expenses are paid in the month in which they are curred. ding and equipment for the general and administrative offices is budgeted to be $4.600 for the quarter, which incl ludes depreciation cn new acquisitions. JDahan Manufacturing be at least $4,000. It has ine of credit witn Policy that the ending cash bala a local bank. The compa ny can borrow in ncrements of $1,000 at the begi ng of each month, up to a lolal outstan loan balance of$110,000, The interest rate on these loa is 19 simple interest (not compounded The company would pay down on the in in S1,000 funds at th of the rler. The would Bisopay the accumulated interest atthe end cr the quarter on thB unda borrowed di g the quartet k.Th is projected to be 30% of operating The compan pays $10,000 cash at the end of February in estimated taxes. Print Done Check