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?

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter4: Preparing And Using Financial Statements

Section: Chapter Questions

Problem 3EP

See similar textbooks

Similar questions

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
Trumbull Co. plans to produce 100,000 toy cars during September. Planned production for October is 125,000 cars. Sales are forecasted at 90,000 toy cars for September and 120,000 toy cars for October. Each toy car requires four wheels. Trumbulls policy is to maintain 10 percent of the next months production in inventory at the end of a month. How many wheels should Tram bull purchase during September? a. 195,000 b. 112,500 c. 102,500 d. 410,000
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Total Pops data show the following information: New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next months requirements. Direct material requires 2 pounds per unit at a cost of $3 per pound. The ending inventory required for direct materials is 15% of the next months needs. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.
Macom Manufacturing has total contribution margin of $61,250 and net income of $24,500 for the month of June. Marcus expects sales volume to increase by 10% in July. What are the degree of operating leverage and the expected percent change in income for Macom Manufacturing? 0.4 and 10% 2.5 and 10% 2.5 and 25% 5.0 and 50%
Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
Caribbean Hammocks currently sells 75.000 units at $50 per unit. Its expenses are: Management believes it can increase sales by 5,000 units for every $5 decrease in sales price. It also believes the additional sales will allow a decrease in direct material of $1 for each additional 5,000 units. Prepare a flexible budgeted income statement for 75,000-, 80,000-, and 85,000-unit sales.