Requirements Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Requirements Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for Januarv. February, and March, and for the quarter in total. - More info - 1. 2. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Prepare a production budget. (Hint: Unit sales = Sales in dollars / Selling price per unit.) 3. Prepare a direct materials budget. 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.) 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 5698o 7. Prepare a cash payments budget for operating expenses. 8. Prepare a combined cash budget. 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufacturing overhead is budgeted to be $0.70 per unit for the year). 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 of units sold.) Print Done a. Actual sales in December were $70,000. Selling price per unit is projected to remain stable at $10 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows: January $ 80,000 February $ 92,000 March.. $ 99,000 April May.. $ 97,000 $ 85,000 b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale. c. Devon Manufacturing has a policy that states that each month's ending inventory of finished goods should be 25% of the following month's sales (in units). d. Of each month's direct material 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 facility is indirect, but there is some direct labor incurred. The direct labor hours per unit is 0.01. The direct labor rate per hour is $12 per hour. All direct labor is paid 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: January February March..... $ 996 $ 1,125 $ 1,182 Current Assets as of December 31 (prior year): Cash $ 4,500 Accounts receivable, net $ 47,000 Inventory $ Property, plant, and equipment, net $ 15,500 120,000 Accounts payable.. $ 42,400 Capital stock.. $ 124,000 Help me solve th Retained earnings. $ 23,000 f. Monthly manufacturing overhead costs are $5,000 for factory rent, $3,000 for other fixed manufacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred. g. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, Devon Manufacturing will purchase equipment for $5,000 (cash), while February's cash expenditure will be $12,000 and March's cash expenditure 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. i. Depreciation on the building and equipment for the general and administrative offices is budgeted to be $4,500 for the entire quarter, which includes depreciation on new acquisitions. j. Devon Manufacturing 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 increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $130,000. The interest rate on these loans is 1% per month simple interest (not compounded). The company would pay down on the line of credit 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 projected to be 30% of operating income less interest expense. The company pays $10,000 cash at the end of February Requirements Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for Januarv. February, and March, and for the quarter in total. - More info - 1. 2. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Prepare a production budget. (Hint: Unit sales = Sales in dollars / Selling price per unit.) 3. Prepare a direct materials budget. 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.) 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 5698o 7. Prepare a cash payments budget for operating expenses. 8. Prepare a combined cash budget. 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufacturing overhead is budgeted to be $0.70 per unit for the year). 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 of units sold.) Print Done a. Actual sales in December were $70,000. Selling price per unit is projected to remain stable at $10 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows: January $ 80,000 February $ 92,000 March.. $ 99,000 April May.. $ 97,000 $ 85,000 b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale. c. Devon Manufacturing has a policy that states that each month's ending inventory of finished goods should be 25% of the following month's sales (in units). d. Of each month's direct material 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 facility is indirect, but there is some direct labor incurred. The direct labor hours per unit is 0.01. The direct labor rate per hour is $12 per hour. All direct labor is paid 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: January February March..... $ 996 $ 1,125 $ 1,182 Current Assets as of December 31 (prior year): Cash $ 4,500 Accounts receivable, net $ 47,000 Inventory $ Property, plant, and equipment, net $ 15,500 120,000 Accounts payable.. $ 42,400 Capital stock.. $ 124,000 Help me solve th Retained earnings. $ 23,000 f. Monthly manufacturing overhead costs are $5,000 for factory rent, $3,000 for other fixed manufacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred. g. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, Devon Manufacturing will purchase equipment for $5,000 (cash), while February's cash expenditure will be $12,000 and March's cash expenditure 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. i. Depreciation on the building and equipment for the general and administrative offices is budgeted to be $4,500 for the entire quarter, which includes depreciation on new acquisitions. j. Devon Manufacturing 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 increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $130,000. The interest rate on these loans is 1% per month simple interest (not compounded). The company would pay down on the line of credit 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 projected to be 30% of operating income less interest expense. The company pays $10,000 cash at the end of February
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Bond premium, entries for bonds payable transactions Rodgers Corporation produces and sells football equipment. On July 1, 2011, Rodgers issued $32,600,000 of 10-year, 14% bonds at a market...
-
Damon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior...
-
Presidio Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Presidio Manufacturing's operations: Current assets as of December 31...
-
A quality control manager at a manufacturing facility has taken four samples with four observations each of the diameter of a part. (a) Compute the mean of each sample. (b) Compute an estimate of the...
-
Listed below are the costs (in dollars) of flights from New York (JFK) to San Francisco for US Air, Continental, Delta, United, American, Alaska, and Northwest. Use a 0.01 significance level to test...
-
Assume X is normally distributed with a mean of 10 and a standard deviation of 2. Determine the value for x that solves each of the following: (a) P(X > x) = 0.5 (b) P(X > x) = 0.95 (c) P(x < X < 10)...
-
What are the two basic requirements to support the declaration of a cash dividend? What are the effects of a cash dividend on assets and shareholders equity?
-
Your tax clients, Jack and Diane a married couple filing a joint return, fell in love with a new construction house for sale in their small Illinois hometown. The builder offers two options on the...
-
Exercise 5 - 1 0 Schedules of Cost of Goods Manufactured and Cost of Goods Sold [ LO 6 ] The following data from the just - completed year are taken from the accounting records of Eccles Company:...
-
Examine the life table on the previous page, and look at the age range of 85-86. Out of 100,000 randomly selected people, 38,565 survive to age 85, and the probability of dying between age 85 and age...
-
Eva is meeting with the bank on July 10, 2021. She is looking to buy a home and knows that the bank will be running numbers to determine her ability in meeting loan repayments. Item Value or amounts...
-
1. Two Towers Communications Inc. pays annual dividends of $8.50 with no possibility of it changing in the next several years. If the firm's stock is currently selling at $65.38, what is the required...
-
SS is evaluating a project that might help the firm to increase its presence in the "green" industry by propelling the company into the leadership role in the country's quest to clean up and protect...
-
You want to leave a small amount for two of your children, Kira, aged 68 and Fred, aged 63. Kira will retire at 70 (t = 2), as will Fred (t = 7). You want each to have $500,000 per year for the rest...
-
OMD Manufacturing reported the following budgeted and actual figures for one of its products: Standard overhead cost per unit (1 hour at $2.50 per hour) $2.50 Actual overhead costs $4,850 Budgeted...
-
9. The estimation of cash flows Consider the case of The Dairy Company (TDC): The Dairy Company (TDC) currently earns annual revenues of $1,250,000 and incurs total operating expenses (excluding...
-
Is it ethical to provide safety training in English to immigrant workers who speak little English, in order to reduce costs?
-
Prepare a flexible budget for planning (Learning Objective 1) Lasting Bubbles produces multicolored bubble solution used for weddings and other events. The companys static budget income statement for...
-
Comprehensive flexible budget, standards, and variances problem (Learning Objectives 2, 3,4, 5) One System assembles PCs and uses flexible budgeting and a standard cost system. One System allocates...
-
Work backward through labor variances (Learning Objective 4) Amandas Music manufactures harmonicas. Amanda uses standard costs to judge performance. Recently, a clerk mistakenly threw away some of...
Study smarter with the SolutionInn App