Question

In: Accounting

Condor Corporation manufactures two different types of coils used in electric motors. In the fall of...

Condor Corporation manufactures two different types of coils used in electric motors. In the fall of the current year, the controller compiled the following data. • Sales forecast for 20x3 (all units to be shipped in 20x3): Product Units Price Light coil 56,000 $ 260 Heavy coil 36,000 360 • Raw-material prices and inventory levels: Raw Material Expected Inventories January 1, 20x3 Desired Inventories, December 31, 20x3 Anticipated Purchase Price Sheet metal 34,000 lb. 38,000 lb. $ 15 Copper wire 31,000 lb. 34,000 lb. 8 Platform 5,600 units 6,600 units 4 • Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal 5 lb. 6 lb. Copper wire 3 lb. 4 lb. Platform 2 unit • Direct-labor requirements and rates: Product Hours per Unit Rate per Hour Light coil 3 $ 15 Heavy coil 5 20 • Finished-goods inventories (in units): Product Expected January 1, 20x3 Desired December 31, 20x3 Light coil 21,000 26,000 Heavy coil 8,500 9,500 • Production overhead: Overhead Cost Item Activity-Based Budget Rate Purchasing and material handling $ 0.60 per pound of sheet metal and copper wire purchased Depreciation, utilities, and inspection $ 5.00 per coil produced (either type) Shipping $ 1.00 per coil shipped (either type) General production overhead $ 3.00 per direct-labor hour 1. Prepare the sales budget (in dollars) for 20x3. 2. Prepare the production budget (in units) for 20x3. 3. Prepare the raw material purchases budget (in quantities) for 20x3. 4. Prepare the raw material purchases budget (in dollars) for 20x3.

Solutions

Expert Solution

Req 1: Sales budget
LIGHT COIL HEAVY COIL
Expected sales unit 56000 36000
Selling price per unit 260 360
Budgeted Sales in $ 14,560,000 12,960,000
Req: Production Budget
LIGHT COIL HEAVY COIL
Expected sales unit 56,000 36,000
Add: Desired ending Inventory 26000 9500
Less: Beginning Inventory 21000 8500
Production in Units 61000 37000
Req 3: Raw material Purchase budget in units
Sheet Metal Copper Wire Platform
Total requirement:
Sheet Metal (61,000 units@5 +37,000@6) 527000
Copper wire (61,000@3+37,000@4) 331000
Platform (37,000 units@2) 74000
Add: Desired ending inventory 38000 34000 6600
Less: Beginning Inventory 34000 31000 5600
Budgeted Purchases in Units 531,000 334,000 75,000
Req 4: Raw material purchase budget in $
Sheet Metal Copper Wire Platform
Budgeted Purchases in Units 531,000 334,000 75,000
Budgeted Purchase price per unit 15 8 4
Budgeted Purchase in $ 7,965,000 2,672,000 300,000

Related Solutions

Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall...
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 Units Price Light coil 60,000 $ 120 Heavy coil 40,000 170 Raw-material prices and inventory levels: Raw Material Expected Inventories, January 1, 20x0 Desired Inventories, December 31, 20x0 Anticipated Purchase Price Sheet metal 32,000 lb. 36,000 lb. $ 8 Copper...
1. Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
1. Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $420,000.00 2 Testing Department 1,200,000.00 Direct machine hours were estimated as follows: Assembly Department...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $330,000.00 2 Testing Department 1,200,000.00 3 Total $1,530,000.00 Direct machine hours were estimated as...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $360,000.00 2 Testing Department 900,000.00 3 Total $1,260,000.00 Direct machine hours were estimated as...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $360,000.00 2 Testing Department 900,000.00 3 Total $1,260,000.00 Direct machine hours were estimated as...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $240,000.00 2 Testing Department 750,000.00 3 Total $990,000.00 Direct machine hours were estimated as...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential...
Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: 1 Assembly Department $330,000.00 2 Testing Department 750,000.00 3 Total $1,080,000.00 Direct machine hours were estimated as...
Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at...
Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ orders. There are many other manufacturers who produce similar motors. Ridgecrest believes that continuously improving its manufacturing processes and having satisfied employees are critical to implementing its strategy in 2015. 1. Is Ridgecrest’s 2015 strategy one of product differentiation or cost leadership? Explain briefly. 2. Indicate a measure you would expect...
Morelli Electric Motor Corporation manufactures electric motors for commercial use. The company produces three models, designated...
Morelli Electric Motor Corporation manufactures electric motors for commercial use. The company produces three models, designated as standard, deluxe, and heavy-duty. The company uses a job-order cost-accounting system with manufacturing overhead applied on the basis of direct-labor hours. The system has been in place with little change for 25 years. Product costs and annual sales data are as follows:    Standard Model Deluxe Model Heavy-Duty Model Annual sales (units) 19,000 1,500 9,400 Product costs: Raw material $ 18 $ 33...
) Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021....
) Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead of $126,920,760 which has been allocated on each product’s inspection hours. The expected prime costs of two new types are as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT