ueer of the upcoming year. The flowing data pertain to Datong pati Click the loon 30 view Durton Macturing preparing its master budget for the (the on th Read the More info Requirement 1. Prepare a schedule of cash cons for January February and March, and for N Daton Manufacturing Cash Collections Bod For the Quarter Ended March 31 Aces in December $70,000. Seting price per project man 10 per unt throughout the budge period Sam tr the bett of the upcoming year aged to be tokowe 12.000 $99.000 Cedis Apr May March Quarter Total cash corectione Requirement 2. Papare a production budget, pre Untes Saes in dus Saling price p Dalton Manufacturing Production Budget For the Quarter Ended March 311 Plus: Dested enting my olal needed 000 6.Dan Manufacturing has a poxy that with sending entry of net goods should be 20% of the Most of the labor at the manufachung city is dut, but there some det 001 The dredabor rate per hour is $12 per hour per punt Enting inventory of direct Grect labor hours per unt med. The Mony manting January February March Quarter sare $1.000 or twynt, $3,000 for other fed manufacturing expenses, and $120 p No ciaon is cluded in these figures Al expenses are paid in the month in Compute one for the wit off wurde sont r $5000 cash whis we just in the upcoming an January, Dan Manding Fatan's cash one wil be 112.000 and March cash mondture w MacBook Pin Print Done ditional data.) Data table Quarter Current Assets as of December 31 (prior year): Cash $ 4,500 Accounts receivable, net $ 48,000 Inventory $ 15,500 Property, plant, and equipment, net 121,500 Accounts payable $ 42,400 Capital stock $ 125,500 Retained earnings $ 23,400 Print Done - Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalton Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total cash collections Requirement 2. Prepare a production budget. (Hint: Unit sales Sales in dollars + Selling price per unit.) Dalton Manufacturing Production Budget For the Quarter Ended March 31 Unit sales Plus: Desired ending inventory Total needed Month January February March Quarter Units to be produced For the Quarter Ended March 31 Month January February March Quarter Mutiply by: Qanity pounds) of DM newed per un Quantity (pounds) needed for production Plus Desired anding-ventory of D Total arty pounds needed Less Beginning inventory of OM. Quanity (pounds) to purchase Mutiply by Cat per pound Total cost of DM purchases Requirement & Prepare a cash payments budget for the direct material purchases from Requirement 3 (Use the accounts payable bancs at December 31 of per year for the prior menth payment in January) (Round your we nearest whole dola) Dation Manufacturing Cash Payments for Direct Materiais Budget For the Quarter Ended March 31 Month January February March Quarter Upcomi Dalton Manufacturing is preparing its master budget for the first quarter of Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Dalton Manufacturing Cash Payments for Direct Materials Budget For the Quarter Ended March 31 Month January February March Quarter 20% of current month DM purchases 80% of last month's DM purchases Total cash payments Requirement 5. Prepare a cash payments budget for direct labor. Dalton Manufacturing Cash Payments for Direct Labor Budget For the Quarter Ended March 31 Month January February March Quarter Total cost of direct labor Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. (Round your answers to the nearest Dalton Manufacturing Cash Payments for Manufacturing Overhead Budget Cash Payments for Manufacturing Overhead Budget For the Quarter Ended March 31 Month: January February March Quarter Variable manufacturing overhead costs Rent (fixed) Other fixed MOH Cash payments for manufacturing overhead Requirement 7. Prepare a cash payments budget for operating expenses. (Round your answers to the nearest whole dollar.) Dalton Manufacturing Cash Payments for Operating Expenses Budget For the Quarter Ended March 31 Variable operating expenses Fixed operating expenses Month January February March Quarter Cash payments for operating expenses Requirement 8. Prepare a combined cash budget. (If an input field is not used in the table leave the input field empty; do not enter a zero. Use parenthese Dalton Manufacturing Combined Cash Budget For the Quarter Ended March 31 Beginning cash balance Plus: Cash collections Total cash available Less: cash payments: Direct material purchases Direct labor Manufacturing overhead costs Operating expenses Tax payment Equipment purchases Total cash payments Ending cash balance before financing Financing: Plus: New borrowings Less: Debt repayments January February March Quarter Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements Dalton Manufacturing Budgeted Manufacturing Cost per Unit For the Quarter Ended March 31 Direct materials cost per unit Direct labor cost per unit Variable manufacturing overhead costs per unit Fixed manufacturing overhead costs per unit Budgeted cost of manufacturing one unit Requirement 10. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold Budgeted cost of manufacturing one unit x Number off Dalton Manufacturing Budgeted Income Statement For the Quarter Ended March 31 Sales revenue Less: Cost of goods sold Gross profit Less: Operating expenses Less Depreciation expense Operating income Less: Interest expense