Answered step by step
Verified Expert Solution
Question
1 Approved Answer
plz answer all the parts Deny Manulacturing is preparing its master budgen for the fint quarter of the upcoming year The following data pertain to
plz answer all the parts
Deny Manulacturing is preparing its master budgen for the fint quarter of the upcoming year The following data pertain to Derfy Manulacturing's operations Click the icon to view the datie ) (1) (Click the icon to vien adkitionat datia) More info a. Actual sales in December were 570,000 . Seling price per unit ia projected to reemain stable at 510 per unit throughoit the budget period Sales for the first flive months of the upcoming year are budgetid to be as follows b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the salle. c. Derry Manufacturing has a policy that states that each montis ending inventory of Finished goods should be 25% of the following month's sales (in units) d.Of each month's direct material purchase9, 20%, are paid for in the month of purchase while the remainder is paid for in the month following purchase. Two pounds of direct materiat is needed per unit at $2.00 per poand Ending itiventory of direct materials should be 10% of next month's production needs. e. Most of the labor at the manufacturing facility is indiect, but there is some direct labor incurred the direct labor hours per: unit is 0.01. The diect labor rate per hour is 512 per hour. All direct labor is paid for in the menth in which the work is performed The direct labor total cost for each of the upcoming three months is as follows: f. Monthly manufacturing overiead costs are $5,000 for factory rent, $3,000 for other foxed manufacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these flgures. Als mxpenses are paid in the month in which they are incurred. 9. Computer equipment loe the administrative otfices wilt be purchased in the upcorning quater in January, Derry Manufacturing will purchase equipment for $5,000 (cash), while February's cash expenoture will bo $12,000 and March's cash expendture will be $16,000 h.Operating expenses are budgeted to be $1.00 per unit sold plus fixed operating expenses of $1.000 per month. All operating expenses are paid in the month in which they are incurred. No depreciation is included in these figures 1. Depreciation on the buiding and equipment for the general and administrative ottices is budgated to be $4,400 foc the entire quarter, which includes depreciation on new acquisitions. 5. Derry Manufacturing has a policy that the ending cath balance in each month must be at loast 54,000 . th has a line of credit with a local bank. The company can bortow in increments of $1.000 at the beginaing of each month, up to a total outstanding loan balance of 5120.000 The interest rate on these loans is 1% per month simple interest (not) 1ollowing month's sales (in units). d. Of each month's direct matetial purchases, 20\% are paid for in the month of purchase. While the remainder is paid for in the month following purchase. Two pounds of direct material is needed per unit at $2.00 per pound. Ending inventory of direct materials should be 10% of next month's production needs. e. Most of the labor at the manufacturing facilizy is indirect but there is some direct laber incurred The diect labor hours per unit is 0.01. The direct labor rate per hour is $12 per hour. Al direct labor b pald for in the month in which the work is performed. The direct labor total cost for each of the upcoming three months is as follows: 1. Monthly manufacturing overhead costs Wo $5,000 for factory rent, $3,000 for other fixed manulacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these fgures All expenses are paid in the month in which they are incurred. 9. Computer equipment for the administrative offices will be purchased in the upcoming quarter in January. Derry Manufacturing will parchase equipment for $5,000 (cash), whille February's cash expenditure will be $12,000 and March's cash expenditure will be $16,000. h.Operating expenses are budgoted to be $1.00 per unit sold plus ficed operating expenses of $1,000 per month. All operating expenses are paid in the month in which they are incurred No depreciation is included in these figures i. Depreciation on the building and equipment for the general and administrative oflices is budgeted to be $4,400 for the entire quarter, which includes depreciation on new acquisitions: j. Derry Manufncturing has a policy that the ending cash balance in each month must be at least \$4.000. it has a line of credit with a local bank. The company can borrow in incroments of $1.000 at the beginning of each month, up to a total outstanding loan balance of 5120,000 . The interest rate on these loans is 19 per month simple linterest (not compounded). The company would pay down on the line of credt balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed during the quarter. k. The company's income tax rate is projectod to be 30% of oparating income less interest expense The company pays 510,000 cash at the end of February in estimated taxes, Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manulacturing's operations: (Click the icon to view the datai) 3. Cllick the iconto vigu adalilocial datar) Read the requirements. Data table Lass: Begining inventory Units ta produce Requirement 3. Prepare a c Requirements 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total 2. Prepare a production budget. (Hint: Unit sales = Siles in dallars / Selling price per unit) 3. Prepare a direct materials budget 4. Prepare a cash payments budget for the direct material purchases from Requiremont 3 . (Use the accounts payable balance at December 31 of prior year for the prior month payment in Janvary) 5. Propare a cash payments budget for direct labor. 6. Prepare a cash payments budgot for manufacturing ovechead costs 7. Prepare a cash payments budget for operating expenses 8. Prepare a combined cash budget 9. Calculate the budgeted manufactuting cost per unit (assume that fixed manufacturing overhead is budgeted to be $0.70 per unit for the year). 10. Prepare a budgeted income statoment for the quarter ending March 31 . (Hint Cost of goods sold = Budgeted cost of manulacturing one unit x Number of units sold.) Derry Manufacturing is preparing its master budget for the first puarter of the upcoming year. The following data pertain to Derry Manufacturing's operations (Click the icon to view the data.) (Click the icon to view additonal data.) Read the cequirements Requirement 1. Prepare a schedule of cash collections tor January, tebruary, and March, and tor the quarter in total Derry Manulacturing Cash Collections Budget For the Quarter Ended March 31 Requirement 2. Prepare a production budget. (Hint: Unit sales = Sales in dollars - Selling price per unit) Derry Manufacturing Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar) Derry Manufacturing Derry Manufacturing is preparing its master budget for the fiest quarter of the upcoming year The following data pertain to Derty Manufacturing's operations: (Click the ion to viow the data.) (Click the sisontowing aditionis data) Read the reguinments Requirement 4. Prepare a cash payments budgat for the direct material purchases from Requirement 3. (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answnm to the nearest whole dollar.) (Click the icon to view the data.) (Click the icon fo viav a doitional data) Read the requiroments. Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3 . (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answers to the nearest whole dollar: Derry Manufacturing Cash Payments for Direct Materials Budget Requirement 5. Prepare a cash payments budget for direct labor Derry Manufacturing Cash Payments for Direct Labor Budget For the Quarter Ended March 31 Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. (Round your answers to the noarest whole dollar) Derry Manufacturing Cash Payments for Manufecturing Overhead Budget . For the Quarter Ended March 31 Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manufacturing's operations: (Click the icon to view the data.) (i) (Click the icon to view additional dafa.) Read the requirements Kequirement 6. Hrepare a cash payments budget tor manutacturing overhead costs. (Round your answers to the nearest whole dollar.) Derry Manufacturing Cash Payments for Manufacturing Overhead Budget Requirement 7. Prepare a cash payments budget for operating expenses. (Round your answers to the nearest whole dollar) Derry Manufacturing Cash Payments for Operating Expenses Budget 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 parentheses or a minus sign for negative cash balances and financing payments.) Derry Manufacturing Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manufacturing's operations: (Cllck the icon to view the data) (Click the icon to view additionat data) Read the reguirements. Requirement 3. 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 parentheses or a minus sign for negative cash balances and financing payments.) Requirement 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufiacturing overhead is budgeted to be $0.70 per uni for the year). (Round your answer to the netarest cant) Requirement 10. Prepare a budgeted income statement for the quarter ending March 31 . (Hint. Cost of goods sold = Budgeted cost of manufacturing one unit * Number of units sold.) (Round your answers to the nearest whote dollar.) Requirement 10. Prepare a budgeted income statement for the quarter onding March 31 . (Hint: Cont of goods nold = Budgoted cost of manufacturing one unit Number of units sold.) (Round your answors to the riegrest whole dallar) Deny Manulacturing is preparing its master budgen for the fint quarter of the upcoming year The following data pertain to Derfy Manulacturing's operations Click the icon to view the datie ) (1) (Click the icon to vien adkitionat datia) More info a. Actual sales in December were 570,000 . Seling price per unit ia projected to reemain stable at 510 per unit throughoit the budget period Sales for the first flive months of the upcoming year are budgetid to be as follows b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the salle. c. Derry Manufacturing has a policy that states that each montis ending inventory of Finished goods should be 25% of the following month's sales (in units) d.Of each month's direct material purchase9, 20%, are paid for in the month of purchase while the remainder is paid for in the month following purchase. Two pounds of direct materiat is needed per unit at $2.00 per poand Ending itiventory of direct materials should be 10% of next month's production needs. e. Most of the labor at the manufacturing facility is indiect, but there is some direct labor incurred the direct labor hours per: unit is 0.01. The diect labor rate per hour is 512 per hour. All direct labor is paid for in the menth in which the work is performed The direct labor total cost for each of the upcoming three months is as follows: f. Monthly manufacturing overiead costs are $5,000 for factory rent, $3,000 for other foxed manufacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these flgures. Als mxpenses are paid in the month in which they are incurred. 9. Computer equipment loe the administrative otfices wilt be purchased in the upcorning quater in January, Derry Manufacturing will purchase equipment for $5,000 (cash), while February's cash expenoture will bo $12,000 and March's cash expendture will be $16,000 h.Operating expenses are budgeted to be $1.00 per unit sold plus fixed operating expenses of $1.000 per month. All operating expenses are paid in the month in which they are incurred. No depreciation is included in these figures 1. Depreciation on the buiding and equipment for the general and administrative ottices is budgated to be $4,400 foc the entire quarter, which includes depreciation on new acquisitions. 5. Derry Manufacturing has a policy that the ending cath balance in each month must be at loast 54,000 . th has a line of credit with a local bank. The company can bortow in increments of $1.000 at the beginaing of each month, up to a total outstanding loan balance of 5120.000 The interest rate on these loans is 1% per month simple interest (not) 1ollowing month's sales (in units). d. Of each month's direct matetial purchases, 20\% are paid for in the month of purchase. While the remainder is paid for in the month following purchase. Two pounds of direct material is needed per unit at $2.00 per pound. Ending inventory of direct materials should be 10% of next month's production needs. e. Most of the labor at the manufacturing facilizy is indirect but there is some direct laber incurred The diect labor hours per unit is 0.01. The direct labor rate per hour is $12 per hour. Al direct labor b pald for in the month in which the work is performed. The direct labor total cost for each of the upcoming three months is as follows: 1. Monthly manufacturing overhead costs Wo $5,000 for factory rent, $3,000 for other fixed manulacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these fgures All expenses are paid in the month in which they are incurred. 9. Computer equipment for the administrative offices will be purchased in the upcoming quarter in January. Derry Manufacturing will parchase equipment for $5,000 (cash), whille February's cash expenditure will be $12,000 and March's cash expenditure will be $16,000. h.Operating expenses are budgoted to be $1.00 per unit sold plus ficed operating expenses of $1,000 per month. All operating expenses are paid in the month in which they are incurred No depreciation is included in these figures i. Depreciation on the building and equipment for the general and administrative oflices is budgeted to be $4,400 for the entire quarter, which includes depreciation on new acquisitions: j. Derry Manufncturing has a policy that the ending cash balance in each month must be at least \$4.000. it has a line of credit with a local bank. The company can borrow in incroments of $1.000 at the beginning of each month, up to a total outstanding loan balance of 5120,000 . The interest rate on these loans is 19 per month simple linterest (not compounded). The company would pay down on the line of credt balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed during the quarter. k. The company's income tax rate is projectod to be 30% of oparating income less interest expense The company pays 510,000 cash at the end of February in estimated taxes, Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manulacturing's operations: (Click the icon to view the datai) 3. Cllick the iconto vigu adalilocial datar) Read the requirements. Data table Lass: Begining inventory Units ta produce Requirement 3. Prepare a c Requirements 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total 2. Prepare a production budget. (Hint: Unit sales = Siles in dallars / Selling price per unit) 3. Prepare a direct materials budget 4. Prepare a cash payments budget for the direct material purchases from Requiremont 3 . (Use the accounts payable balance at December 31 of prior year for the prior month payment in Janvary) 5. Propare a cash payments budget for direct labor. 6. Prepare a cash payments budgot for manufacturing ovechead costs 7. Prepare a cash payments budget for operating expenses 8. Prepare a combined cash budget 9. Calculate the budgeted manufactuting cost per unit (assume that fixed manufacturing overhead is budgeted to be $0.70 per unit for the year). 10. Prepare a budgeted income statoment for the quarter ending March 31 . (Hint Cost of goods sold = Budgeted cost of manulacturing one unit x Number of units sold.) Derry Manufacturing is preparing its master budget for the first puarter of the upcoming year. The following data pertain to Derry Manufacturing's operations (Click the icon to view the data.) (Click the icon to view additonal data.) Read the cequirements Requirement 1. Prepare a schedule of cash collections tor January, tebruary, and March, and tor the quarter in total Derry Manulacturing Cash Collections Budget For the Quarter Ended March 31 Requirement 2. Prepare a production budget. (Hint: Unit sales = Sales in dollars - Selling price per unit) Derry Manufacturing Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar) Derry Manufacturing Derry Manufacturing is preparing its master budget for the fiest quarter of the upcoming year The following data pertain to Derty Manufacturing's operations: (Click the ion to viow the data.) (Click the sisontowing aditionis data) Read the reguinments Requirement 4. Prepare a cash payments budgat for the direct material purchases from Requirement 3. (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answnm to the nearest whole dollar.) (Click the icon to view the data.) (Click the icon fo viav a doitional data) Read the requiroments. Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3 . (Use the accounts payable balance at December 31 of prior year for the prior month payment in January) (Round your answers to the nearest whole dollar: Derry Manufacturing Cash Payments for Direct Materials Budget Requirement 5. Prepare a cash payments budget for direct labor Derry Manufacturing Cash Payments for Direct Labor Budget For the Quarter Ended March 31 Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. (Round your answers to the noarest whole dollar) Derry Manufacturing Cash Payments for Manufecturing Overhead Budget . For the Quarter Ended March 31 Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manufacturing's operations: (Click the icon to view the data.) (i) (Click the icon to view additional dafa.) Read the requirements Kequirement 6. Hrepare a cash payments budget tor manutacturing overhead costs. (Round your answers to the nearest whole dollar.) Derry Manufacturing Cash Payments for Manufacturing Overhead Budget Requirement 7. Prepare a cash payments budget for operating expenses. (Round your answers to the nearest whole dollar) Derry Manufacturing Cash Payments for Operating Expenses Budget 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 parentheses or a minus sign for negative cash balances and financing payments.) Derry Manufacturing Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manufacturing's operations: (Cllck the icon to view the data) (Click the icon to view additionat data) Read the reguirements. Requirement 3. 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 parentheses or a minus sign for negative cash balances and financing payments.) Requirement 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufiacturing overhead is budgeted to be $0.70 per uni for the year). (Round your answer to the netarest cant) Requirement 10. Prepare a budgeted income statement for the quarter ending March 31 . (Hint. Cost of goods sold = Budgeted cost of manufacturing one unit * Number of units sold.) (Round your answers to the nearest whote dollar.) Requirement 10. Prepare a budgeted income statement for the quarter onding March 31 . (Hint: Cont of goods nold = Budgoted cost of manufacturing one unit Number of units sold.) (Round your answors to the riegrest whole dallar) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started