nattpn Manuiaclunng is preparing its rnaster budgetinr the nrsiquarier drihe upcsrning year The islluwing data penain la Dalton inanuiadunng's pperatipns Cllck the icun to View the data l o (Cllck the rcurl in View addrtlc nal data ) Read the grunemerns Requirement 1. Prepare a schedule at cash callectians lur January, Feiinrary and March, and tor the quartet in total Dalian Manufactu linti Cash Collections Budget 0 Dim Tame Ful ure Quarter Ended March 3| rtianui J"""\"'Y \"WW "\"5\" mm\" current Assets as pmeceniber 31 (ptipryear) K335" EH'E Cash 4,5ut) CI'EI'IILE SHIEE ADCOUIIIS receivable net 53,0l) Total cash cullecunns : : : : 'HVEMOIY 15.3\"" P I t I1 I t , Red uirenrentz. Prepare a Diptlumnlt budget mm mm sales : sales in dollars isellinci price per unit) mm." a a" ' a" \"mum\" "6 Accuums payable cap'nal 510w, Retained eaniings naltdn Manulactulinn Plpdtlclion Bunnet Fur nie Quarter Ended March 31 124mm 42,4I1I) 127.0uu 23.0w Intentli Jan uaiy Felinrary marsh Quarter Pm" Done unit sales Flus' Daren endlng inventory Total needed Less: Eeglnning lnuentnrv Units tn prudupe Rea uireirientct. Prepare a direct materials budget (Rd und ynur answers tp the nearest whale dollar) nalten Manulactulinu Direct materials Budget Ful Ille Quarter Eimeu riiarcn 31 iiipnth January February March Quarter Enter any number in the edil fields and then curlnue lo the next quesIlon, itsln he. nnrdrieen o More Infn - a.Ac1ualsales in December were 570.000. selling Once per unit is protected ti: remain stable anti] per unit throughout the budget Denad sates tor the rst ve nicrrtlrs attire upcoming year are budgeted In be as trilltrws. January , s moon Fehmaly , sznun March , ileum) April , prune May , pinup b.3ales are aim ash and 70% credu All credit sales are sullecied ln the mimtll icltplrnnti the sale c.Daturn Manuiaciunng has a Wliw that states that each months ending memory at nished treads should be 25% attire fullnwlng munm's sales (ln unitst unreal-h muntn's direct material pulcnases, 209s are paid for in the mum in purchase, while the rernalnder is paid rur in the rnamh inllewrng purchase Two puunds in direct inaienal ls needed per unit at :2 up per puund, Ending lllvemaly or direct rnate nais shuuld be 10% ur next rnurnri's praducnun needs e.Mastu1 the labor at the manuiacturing facility is lndirect, but there is same direct labor 'rmured The direct labbr hburs perunlt is (Lot The direct latiur rate per hbur is st 2 per ha ur All direct labur is pald iur in the mend. ln which the limits is penarrned The direct laburtdtal cast for each atthe upeurning three munttls is as iulluws: January , 3 996 February , s \"25 March , s um I. Monthly manuiaiziunng uverheait costs are 5511th iurtactury rem. $3.000 iirr inner fixed manuiaeiunug expenses. and 51.20 per unn tor variable rnanuiacruring avemead uu depreciation is included in these ngures itii expenses are paid in the rnbnlih in which they are inpurred, g.curnputerequiprnem iur the administrative urnces will be purchased in the upcoming guaner In January, paubn Manuiacurnng will purchase equipment lur peptic (rash), while Febmaiy's cash npenailure w be 3t 2pm and Marcus cash expendiurre will be at spot: h.0perating expenses are budgeted tb be 31 do per unit said plus fixed uperattng npenies (ll-31,900 per rnunth All bperating expenses are paid in the niarnh it which they are lncuned Mn dEnleclaurl is inclided in these gures Depreclatibn an the building and equipment tur tile general and adrninlstratilre ginses is budgeted tu tie 54,900 tur the entire uuarten which includes depreciatiun on new acuu'elubns j. Daltun Manulaclunng has a policy that the ending cash balance ln each mbrnh rnust be at least upon it has a line biuedlt wllh a least bank The company can bnnuw in inaemems Di$l,l]l) at the beginning in eaui mpmh, up to a urtal uutstanding lnan balance at 512mm) The interest rate (in mm tpans is I96 per mpmrt simple interesttnpt mmpnunded) The com pauy wdutd pair dawn an the line drawn balance ln increments msmati in has exness nrnds at the end pftne uuaner The opinpanv vnlutd alsu pair tile accumulated interest attire end unite uuaner en tire [units bummed during the uuaner. mne company's income tax rate ls protected to he 30% at uperatlng incdnie less interest expense The company pays stimuli cash at the end iii Fepruaiy ii estimated taxes. Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar.) Dalton Manufacturing Direct Materials Budget Fertile Quarter Ended March 31 Month January February March Quarter Units to be produced H H lytultiply by: Quantity [pounds] of DM needed per unit Quantity (pounds) needed for production Plus: Desired ending inventory of DM H II Total quantity {pounds} needed Less: Beginning inventory of DM H H Quantity (pounds) to purchase Multiply by: Cost per pound TotalcostofDM purchases Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. [Round your answers to the nearest whole dollar.) 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 I I ll Totalcash payments Requirement 5. Prepare a cash payments budget for direct labor. Requirement 5. Prepare a cash payments budget for direct labor. Dalton Manufacturing Cash Payments for Direct Labor Budget Fertile Quarter Ended March 31 Total cost of direct labor January Month February March Quarter m || fl Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. {Bound your answers to the nearest whole dollar.) Dalton Manufacturing Cash Payments for Manufacturing Overhead Budget For the Quarter Ended March 31 Month 1I.I'ariab|e manufacturing overhead costs Rent [xed] Other xed MOH Cash payments for manufacturing overhead I January February March Quarter :: : Requirement 1". Prepare a cash payments budget for operating expenses. {Round your answers to the nearest whole dollar.) Dalton Manufacturing Cash Payments for Operating Expenses Budget Forthe Quarter Ended March 31 1I.I'ariab|e operating expenses Fixed operating expenses Cash payments for operating expenses January Month February March Quarter Requirement 8. Prepare a combined cash budget. (lfa box is not used in the table leave the box empty; do not enter a zero. Use parentheses or a minus sign for negative cash balances and nancing payments.) Dalton Manufacturing Cumbined Cash Budget Fortne Quarter Ended March 31 January February March Quarter Beginning cash balance Plus: Cash collectlons Tptal DES n availa D ll! Less: cash payments: Direct material purchases Direct labor Manufacturing overhead costs Operating expenses Tax payment Equipment purchases Total cash payments Ending cash balance before nanclng Finan cing' Plus: New borrowings Less: Debt repayments Less' Interest payments Total nancing Ending cash balance Dnm.immnni n harm-lam um hummiml mnnll'nhlrinn run} my Imil {unrulmn'hr vnd mam-ran'nn mmrhn-ul i.- hummmd in In. en nn nnrlln rm um \"mm rum-mi unl .r vlrlr'uinr In rim \"\\an mmi \\ Requirement 9. calculate the budgeted manufactunng cost per unit {assume that fixed manufacturing overhead is budgeted to be $0.90 per unit for the year). [Round your answer to the nearest ce nt.) Dalton Manufacturing Budgeted Manufacturing Cost per Unrt Fortne Quarter Ended March 31 Direcl rnaten'ais Cost per unit Direct labor cost per unit Variable manutacturing overhead costs per unrt Fixed manufacturing overhead costs per unrt Budgeted cnsl of manufacturing one unil Requirement 10. Prepare a budgeted income statement for the quarter ending March 31, (Hirrt 0051 of goods sDid = Budgeted cost of manufacturing one unit x Number III units Enid] (Round your answers In the nearesl whole dollar ) Dalton Manutactunng Budgeted Income Statement For the Quarter Ended March 31 Sales revenue Less: Cast oi goods soid Gross profit Less: Operating expenses Less: DepreCiation expense Operating in come Less: Inleresl expense Less: Income tax expense Net income Enter any number in the edit elds and then continue to the next