Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is long, sorry! Still, it is one question! Thank you so much in advance! I will make sure to rate this answer, especially if
This is long, sorry! Still, it is one question! Thank you so much in advance! I will make sure to rate this answer, especially if it's answered before midnight!
Required information [The following information applies to the questions displayed below.] Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data. Sales forecast for 20x0 (all units to be shipped in 20x0): Product Light coil Heavy coil Units 50,000 30,000 Price $ 200 300 Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 28,000 lb. 25,000 lb. 5,000 units Raw Material Sheet metal Copper wire Platform Desired Inventories, December 31, 20x0 32,000 lb. 28,000 lb. 6,000 units Anticipated P urchase Price $ 17 Use of raw material: Raw Material Sheet metal Copper wire Platform Amount Used per Unit Light Coil Heavy Coil 3 lb. 4 lb. 1 lb. 2 lb. 2 unit Direct-labor requirements and rates: Hours per Unit Product Light coil Heavy coil Rate per Hour $ 10 Finished-goods inventories (in units): Product Light coil Heavy coil Expected JanuaryDesired December 1, 20x0 31, 20x0 15,000 20,000 8,500 9,500 Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.60 per pound of sheet metal and copper wire purchased $5.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour Required: 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales $ 2. Prepare the production budget (in units) for 20x0. Production Budget (in units) for 20x0 Light Coils Heavy Coils Projected sales Total requirements Production required (units) 3. Prepare the raw material purchases budget (in quantities) for 20x0. Platform Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Light coils Heavy coils Production requirements Total requirements Purchase requirements (units) 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Hours Total Production (units) per Unit Hours Rate Total Cost Light coils Heavy coils Total 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Budgeted Cost 1b. Production Overhead Budget for 20x0 Cost Driver Cost Driver Quantity Rate Purchasing and material handling Depreciation, utilities, and inspection coils Shipping General production overhead Total production overhead Required information [The following information applies to the questions displayed below.] Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data. Sales forecast for 20x0 (all units to be shipped in 20x0): Product Light coil Heavy coil Units 50,000 30,000 Price $ 200 300 Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 28,000 lb. 25,000 lb. 5,000 units Raw Material Sheet metal Copper wire Platform Desired Inventories, December 31, 20x0 32,000 lb. 28,000 lb. 6,000 units Anticipated P urchase Price $ 17 Use of raw material: Raw Material Sheet metal Copper wire Platform Amount Used per Unit Light Coil Heavy Coil 3 lb. 4 lb. 1 lb. 2 lb. 2 unit Direct-labor requirements and rates: Hours per Unit Product Light coil Heavy coil Rate per Hour $ 10 Finished-goods inventories (in units): Product Light coil Heavy coil Expected JanuaryDesired December 1, 20x0 31, 20x0 15,000 20,000 8,500 9,500 Production overhead: Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.60 per pound of sheet metal and copper wire purchased $5.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct-labor hour Required: 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales $ 2. Prepare the production budget (in units) for 20x0. Production Budget (in units) for 20x0 Light Coils Heavy Coils Projected sales Total requirements Production required (units) 3. Prepare the raw material purchases budget (in quantities) for 20x0. Platform Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Light coils Heavy coils Production requirements Total requirements Purchase requirements (units) 5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Hours Total Production (units) per Unit Hours Rate Total Cost Light coils Heavy coils Total 6. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.) Budgeted Cost 1b. Production Overhead Budget for 20x0 Cost Driver Cost Driver Quantity Rate Purchasing and material handling Depreciation, utilities, and inspection coils Shipping General production overhead Total production overheadStep 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