How do prepare the manufacturing overhead budget for the quarter ended March 31, 20X1? Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed thefollowing sales forecast for the months of January through March 20X1 for its only two products.50,000 units of J to be sold at $90 each and 30.000 units of K to be sold at $70 each. The desiredunit inventories at March 31, 20X1, are 10% of the next quarter's unit sales forecast, which are60,000 units of J and 30,000 units of K. The January 1, 20X1, unit inventories were 5,000 units ofJ and 2,000 units of K.Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture; Krequires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchasecost of B is $5 per pound. Materials A and B on hand at January 1, 20X1, were 19,000 pounds of Aand 7,000 pounds of B. Desired inventories at March 31, 20X1, are 14,000 pounds of A and 8,000pounds of B.Each unit of J requires 0.5 hours of direct labor in the factory; each unit of K requires 1.0 hourof direct labor. The average hourly rate for direct labor is $12 hour. Estimated manufacturingoverhead cost is $6 per direct labor hour plus $90.000 per month. Selling and administrative expensesare estimated to be 10% of sales revenue plus $180,000 per month.perCash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30%of the credit sales for the quarter ended March 31, 20X1, will occur in January, 30% in February,and 40% in March. Of credit sales (December through March), 40% will be collected as cash in themonth of sale and 55% will be collected in the following month. The remainder will be uncollectible.Cash collected in January 20X1 from December 20X0 sales will be $1,050,000.The January 1, 20X1, cash balance was $70,000. The minimum acceptable cash balance atthe end of each month is $60,000. Short-term borrowings (6-month term) are made in multiples of$10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interestpayment is made the month following the borrowing. Cash disbursements (excluding interest onshort-term borrowings) are estimated as follows:JanuaryFebruaryMarch$1,500,000$1,300,000$1,400,000Manufacturing costs....Selling and administrative expensesInterest expense.390,000410,000400,00090,00090,00090,000210,000Income tax payment....124,000110,00050,000Capital expenditures..300,000Cash dividends....

Manufacturing overhead cost: the manufacturing overhead is some other direct or indirect expenses…

Answered: How do prepare the manufacturing…

Business

Accounting

How do prepare the manufacturing overhead budget for the quarter ended March 31, 20X1?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Cleaning supplies Electricity Maintenance Wages and salaries. Depreciation Administrative expenses Rent Actual cars washed. Revenue Expenses: Lavage Rapide Income Statement For the Month Ended August 31 Cleaning supplies For example, electricity costs should be $1,200 per month plus $0.08 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $6.60 per car washed. The actual operating results for August are as follows: Electricity Maintenance Wages and salaries. Depreciation Rent Fixed Cost per Month $ 1,200 $ 4,800 $ 8,400 $ 1,900 $ 1,600 Administrative expenses Total expense Net operating income Cost per Car Washed $ 0.70 8,200 $ 55,560 $ 0.08 $ 0.10 $ 0.20 6,170 1,818 1,050 6,780 8,400 2,100 1,662 27,980 $ 27,580 $ 0.02 Required: Calculate the company's revenue and…
How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
The following information is available for Brownstone Products Company for the month of July: Master Actual Budget 4, eee $ 60,000 16, e00 Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses 3,8ee $ 53,600 19,400 14,300 8,100 9,see 13, 30e 8, e00 9,400 Required: 1. What was the master budget varidnce for July? Was this variance favorable or unfavorable? 2. Compute the July sales volume variance and the flexible-budget variance for the month, both in terms of contribution margin and in terms of operating income. 4. Prepare pro-forma budgets for activities within its relevant range of operations. Prepare a flexible budiget for each of the following two output levels: a. 3,790 units. b. 4,190 units. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 4 .. Next
Lens Junction sells lenses for $43 each and is estimating sales of 15,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $14 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,300 4,900 4,900 Direct materials: silicon 8,400 9,100 9,300 Direct materials: solution 11,000 11,800 12,900
Please do not give image format
Required: Prepare Shadee's budgeted income statement for the months of May and June. Note: Do not round your intermediate calculations. Round your answers to 2 decimal places. Budgeted Gross Margin SHADEE CORPORATION Budgeted Income Statement Budgeted Net Operating Income May June
Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12 components per unit. The company is now planning raw material needs for the second quarter. Sales of the All Weather are the highest in the second quarter of each year as customers prepare for the summer season. The company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 16,400 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,700 units. b. The raw materials inventory on hand at the end of each month must be equal to 20% of the following month's production needs for raw materials. The raw materials inventory on March 31 for XL 12 is budgeted to be 98,800 components. c. The company maintains no work in process inventories. A sales budget for the All Weather speaker is as follows: April May June July…
Consider Derek's budget information: materials to be used, $63,300; direct labor, $199,200; factory overhead, $397,400; work in process inventory on January 1, $189,300; and work in progress inventory on December 31, $194,100. What is the budgeted cost of goods manufactured for the year? a.$655,100 b.$849,200 c.$659,900 d.$194,100
A7
Preparing an Overhead Budget Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are: January 13,140 February 12,300 March 15,075 The variable overhead rate is $0.60 per direct labor hour. Fixed overhead is budgeted at $2,580 per month. Required: Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Round total variable overhead and total overhead to the nearest dollar. Patrick Inc. Overhead Budget For the Coming First Quarter Overhead: January February March Total Total direct labor hrs Variable overhead rate Total variable overhead $4 Add: Fixed overhead Total overhead
Prepare a production budget for the months of April, May, and June.
Part #6: H Company’s Direct Labor Budget indicates the number of direct labor hours to be used in July, August, and September are 21,000 and 18,900 and 23,000 respectively. Variable overhead is expected to be $0.90 per direct labor hour. Fixed overhead per month is expected to be $8,200. Prepare an Overhead Budget with columns for July, August, September, and Total 3rd Quarter.