Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Corporation manufactures two different types of coils used in electric motors. In the fall of the current year, the controller compiled the following data.

A 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............................................................................

60,000

$130

Heavy coil .........................................................................

40,000

190

Raw-material purchase prices and inventory levels:

Expected Inventories Desired Inventories Forecasted Raw Material 1/1/20x3 12/31/20x3 Price

Sheet metal ...................................... 32,000 lb. 36,000 lb. $16

Copper wire...................................... 29,000 lb. 32,000 lb. 10

Platform .......................................... 6,000 units 7,000 units 6

Use of raw material:

Amount Used per Unit

Raw Material Light Coil Heavy Coil

Sheet metal ................................ 4 lb. 5 lb.

Copper wire ............................... 2 lb. 3 lb.

Platform .......................................... 1 unit

Direct-labor requirements and rates:

Product Hours/Unit Rate/Hour

Light coil ....................................... 4 $15

Heavy coil ..................................... 6 20

Finished goods inventories (in units):

Product

Expected 1/1/20x3

Desired 12/31/20x3

Light coil ...............................

20,000

25,000

Heavy coil ...............................

8,000

9,000

Manufacturing overhead:

Overhead Cost Item

Activity-Based Budget Rate

Purchasing and material handling ........

$.50 per pound of sheet metal and copper wire purchased

Depreciation, utilities and inspection ....

$8.00 per coil produced (either type)

Shipping .........................................

$2.00 per coil shipped (either type)

General manufacturing overhead .........

$6.00 per direct-labor hour

Instructions: Prepare the following budgets for 20x3.

1. Production budget (in units).

2. Raw material purchases budget (in quantities).

3. Raw material purchases budget (in dollars).

4. Direct-labor budget (in dollars).

5. Manufacturing-overhead budget (in dollars).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Blueprint For Lean Audit Lead Your Company To Higher Performance Levels

Authors: Maurice Washpun

1st Edition

B09R3DSLFF, 979-8408643707

More Books

Students also viewed these Accounting questions

Question

Define the term Working Capital Gap.

Answered: 1 week ago