The production department of Hareston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 1st Quarter 8,200 2nd Quarter 9,200 3rd Quarter 7,200 Total needs (kilograms) In addition, the beginning raw materials inventory for the first quarter is budgeted to be 2,000 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,540. 4th Quarter 6,200 Each unit requires 3.2 kilograms of raw material that costs $2.60 per kilogram Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 2,400 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $20.0 per hour. Required: 1. Prepare the company's direct materials budget. (Round your answer to the nearest whole dollar amount.) HARESTON COMPANY Direct Materials Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

The production department of Hareston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 1st Quarter 8,200 2nd Quarter 9,200 3rd Quarter 7,200 Total needs (kilograms) In addition, the beginning raw materials inventory for the first quarter is budgeted to be 2,000 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,540. 4th Quarter 6,200 Each unit requires 3.2 kilograms of raw material that costs $2.60 per kilogram Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 2,400 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $20.0 per hour. Required: 1. Prepare the company's direct materials budget. (Round your answer to the nearest whole dollar amount.) HARESTON COMPANY Direct Materials Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 1E: The sales department of Macro Manufacturing Co. has forecast sales for its single product to be...

See similar textbooks

Similar questions

The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: It also has this additional information related to its expenses: Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.
The sales department of F. Pollard Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Materials used in production: Prepare the following: a. A production budget for March (in units). b. A direct materials budget for the month (in units and dollars).
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.
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.
The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
The production department of Hareston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year:1st Quarter 2nd Quarter 3rd Quarter 4th QuarterUnits to be produced ........................... 7,000 8,000 6,000 5,000In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,400 pounds andthe beginning accounts payable for the first quarter is budgeted to be $2,940.Each unit requires 2 pounds of raw material that costs $1.40 per pound. Management desires to endeach quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs.The desired ending inventory for the fourth quarter is 1,500 pounds. Management plans to pay for 80%of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires0.60 direct labor-hours and direct labor-hour workers are paid $14.00 per hour.Required:1. Prepare the company’s direct materials budget and…
The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th G Quarter Units to be produced 7,000 8,000 6,000 5.000 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,400 kilograms and the beginning accounts payable for the first quarter are budgeted to be $2,940. Each unit requires two kilograms of raw material that costs $1.40 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 1, 500 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.60 direct labour - hours, and direct labour - hour workers are paid $14 per hour. Required: 1. Prepare the company's direct materials budget…
The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,100 9,100 7,100 6,100 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,950 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,490. Each unit requires 3.1 kg of raw material that costs $2.50 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth quarter is 2,325 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $19.5 per hour. Required: 1-a. Prepare the company's direct…
The production department of ABC Company has submitted the following forecasts of units to be produced by quarter for the upcoming fiscal year: 10 quarter 2-1 quarter 3. quarter 40 quarter Units to be 6,000 7,000 8,000 5,000 produced In addition, the beginning mw materials inventory for the first quarter is budgeted to be 3600 pounds and the beginning accounts payable for the 1° quarter is budgeted to be $11,775. Each unit requires three pounds of raw materials that costs $2.5 per pound. Management desires to end each quarter with an inventory of raw materials equal to 20% of the following quarter's production needs of raw materials. The desired ending inventory for the fourth quarter is 3700 pounds. Management plans to pay for 70% of raw material purchases in the quarter acquired and 30% in the following quarter. Each unit requires 0.50 direct labor hours and direct labor workers are paid $12 per hour. Required 1. Prepare the Company's Direct Materials Purchase Budget by quarter and…
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 1st Quarter 5,600 2nd 3rd 4th Quarter Quarter Quarter 8,600 7,600 6,600 In addition, 6,600 grams of raw materials Inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,480. Each unit requires 8.60 grams of raw material that costs $1.20 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter's production needs. The desired ending Inventory for the 4th quarter is 8,600 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter. Each unit requires 0.20 direct labour-hours and direct labourers are paid $10.30 per hour. Required: 1. Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for…
The production budget for Manner Company shows units to be produced as follows: July, 620; August, 680; and September, 540. Each unit produced requires two hours of direct labor. The direct labor rate is currently $20 per hour but is predicted to be $21 per hour in September. Prepare a direct labor budget for the months July, August, and September.