Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE RESPOND TO ALL 10 REQUIREMENTS Devon Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data

image text in transcribed

PLEASE RESPOND TO ALL 10 REQUIREMENTS

Devon Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations: Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total, Devon Manufacturing Data table -: Requirements 1. Propors o schoduie of cash ool losions tor Jonusry, Fibruay, and Wharch, and tor tie qiatio hn wial. 2. Propars a poducjen tuegat. oHht: Unit sakes = Baks in dollars J Bat ing proe cer unt.l 3. Prepsese a drect mster als budger- 4. Propare a cash paymons tudgst sor the droct mater al purchaces fom Roquirmen: 3: (Use the scoounis poystle ba avce st Desembe 31 of prior year lor the prior month poyment in sanusy.: 5. Ppesen s rash poyments bucget br ares later. 9. Propare a combined oosh tucgst. 9. Cacuax the budpetad msnufacturing ocet per unt (aseume that laed manutsctue ng onemeas is eucgeted to oe sugo per unk for the pesr? gidpwid ocat of ma ulseirifs ene u'k x Nartior at ufity sold. More info a. Actuai ealee in December were $71,000. Seling price per unit is projected oa remain stable at $12 per unit throuphout the b. eres are sts casn ane ob\% credl. Al credi salas are collected h the manth sollowing the sele c. Oevan Manufacturing has a policy that states that each manth's endrg irweriory of finished goods shauld te 10% af the folowing month's salas in unisl. d, Or esch month's dfrect manerial purctia6es, 209 are peic for in the month of purchase, while the remainder is paid for in the manth folowing purchase. Three pounds of drect material is needed per urit at $2.00 per pound. Encing inveniary of direct misler iais shculd be 20% of nexi monith's procuction needs. e. Mast af the laber at the manufacturing factity is inciredt, tut there is some cirect labar incurred. The direst labar haurs par unit is [1,05. The direct labor rate par hour is 59 per hour. All dinect labor is paic tar in the month in which the wark is pertamed. The diect laber totel coet for eacti of the upcening thee montho is as folons: T. Monthly marsfacturing overhead caete are 55,500 for facsory rent. 32,500 for other fixed namufacharhg expenses, and 51,10 per ui. for wariable manufacturing overhead. No depreciasoo is induced in theee licures. Al expenses are paid in the month in which they arn incures. g. Compiter aquipment for the adminiseratue otticea wili be purcheced in the Lecaming cuarter, In deruary, Devon Marutacturing wil purchase equioment lar $5,000 fegshy, atile Februsry's cash expendiare wil be $12,200 and Morchis eash experdinure will be S1b, 600 . h. Cperening expenses are budgeted to be 31.25 per anit sold plus fixad operesing expenses of 51,800 per mench. All cpereting expenses sre paid in the morit in atich they are nourred. Ro cepreciation is incuded in these figures. 1. Deprecistion an the building and nquipment for the gereral and acmiristrathe offices is budgeted ta be $5, 160 far the evlie quatser. which indudes deprecietion an nei gcouisitionis. j. Devon Menutacturing has a policy thet the encing cash balance in each month must be at least S4, JuO. It has a line ot credit with a loal bank. The company can tomow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of 5110,000 . The interest rate on these loans is 1% der month simple interest (not compounded). The company would aay down an the ine of creditbalance n increments of $1,000 if it has cxccos fumds at the chd of the quarter. The company would also pay the accumulatec interest at the end of the quarter on the tuncs oorrowec cturing the quarter. k. I he company's income tex rate is projected to be 30% of operating income less interest expense. 1 he company peys $10,300 cash at tha end of February in astimated taxes. Devon Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations: Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total, Devon Manufacturing Data table -: Requirements 1. Propors o schoduie of cash ool losions tor Jonusry, Fibruay, and Wharch, and tor tie qiatio hn wial. 2. Propars a poducjen tuegat. oHht: Unit sakes = Baks in dollars J Bat ing proe cer unt.l 3. Prepsese a drect mster als budger- 4. Propare a cash paymons tudgst sor the droct mater al purchaces fom Roquirmen: 3: (Use the scoounis poystle ba avce st Desembe 31 of prior year lor the prior month poyment in sanusy.: 5. Ppesen s rash poyments bucget br ares later. 9. Propare a combined oosh tucgst. 9. Cacuax the budpetad msnufacturing ocet per unt (aseume that laed manutsctue ng onemeas is eucgeted to oe sugo per unk for the pesr? gidpwid ocat of ma ulseirifs ene u'k x Nartior at ufity sold. More info a. Actuai ealee in December were $71,000. Seling price per unit is projected oa remain stable at $12 per unit throuphout the b. eres are sts casn ane ob\% credl. Al credi salas are collected h the manth sollowing the sele c. Oevan Manufacturing has a policy that states that each manth's endrg irweriory of finished goods shauld te 10% af the folowing month's salas in unisl. d, Or esch month's dfrect manerial purctia6es, 209 are peic for in the month of purchase, while the remainder is paid for in the manth folowing purchase. Three pounds of drect material is needed per urit at $2.00 per pound. Encing inveniary of direct misler iais shculd be 20% of nexi monith's procuction needs. e. Mast af the laber at the manufacturing factity is inciredt, tut there is some cirect labar incurred. The direst labar haurs par unit is [1,05. The direct labor rate par hour is 59 per hour. All dinect labor is paic tar in the month in which the wark is pertamed. The diect laber totel coet for eacti of the upcening thee montho is as folons: T. Monthly marsfacturing overhead caete are 55,500 for facsory rent. 32,500 for other fixed namufacharhg expenses, and 51,10 per ui. for wariable manufacturing overhead. No depreciasoo is induced in theee licures. Al expenses are paid in the month in which they arn incures. g. Compiter aquipment for the adminiseratue otticea wili be purcheced in the Lecaming cuarter, In deruary, Devon Marutacturing wil purchase equioment lar $5,000 fegshy, atile Februsry's cash expendiare wil be $12,200 and Morchis eash experdinure will be S1b, 600 . h. Cperening expenses are budgeted to be 31.25 per anit sold plus fixad operesing expenses of 51,800 per mench. All cpereting expenses sre paid in the morit in atich they are nourred. Ro cepreciation is incuded in these figures. 1. Deprecistion an the building and nquipment for the gereral and acmiristrathe offices is budgeted ta be $5, 160 far the evlie quatser. which indudes deprecietion an nei gcouisitionis. j. Devon Menutacturing has a policy thet the encing cash balance in each month must be at least S4, JuO. It has a line ot credit with a loal bank. The company can tomow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of 5110,000 . The interest rate on these loans is 1% der month simple interest (not compounded). The company would aay down an the ine of creditbalance n increments of $1,000 if it has cxccos fumds at the chd of the quarter. The company would also pay the accumulatec interest at the end of the quarter on the tuncs oorrowec cturing the quarter. k. I he company's income tex rate is projected to be 30% of operating income less interest expense. 1 he company peys $10,300 cash at tha end of February in astimated taxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing An IT Organization Through Governance Risk Management And Audit Internal Audit And IT Audit

Authors: Ken E. Sigler, III Rainey

1st Edition

0367658658, 978-0367658656

More Books

Students also viewed these Accounting questions