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): Units 52,000 32,000 Price $ 220 320 Product Light coil Heavy coil • Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 30,000 lb. 27,000 lb. 5,200 units Desired Inventories, December 31, 20x0 34,000 lb. 30,000 lb. 6,200 units Anticipated Purchase Price $ 14 Raw Material Sheet metal Copper wire Platform 8 • Use of raw material: Light Coil 5 lb. 3 lb. Amount Used per Unit Нeavy Coil 6 lb. 4 lb. 2 unit Raw Material Sheet metal Copper wire Platform • Direct-labor requirements and rates: Product Hours per Unit Light coil Нeavy coil Rate per Hour $ 10 15 7

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
**Vista Electronics, Inc. Coil Manufacturing Data**

Vista Electronics, Inc. produces two types of coils used in electric motors. The following data was compiled by Erica Becker, the controller, for the fall of the current year.

### Sales Forecast for 20x0
(All units to be shipped in 20x0)

- **Product: Light coil**
  - Units: 52,000
  - Price: $220

- **Product: Heavy coil**
  - Units: 32,000
  - Price: $320

### Raw-Material Prices and Inventory Levels

- **Expected Inventories as of January 1, 20x0:**
  - Sheet Metal: 30,000 lb
  - Copper Wire: 27,000 lb
  - Platform: 5,200 units

- **Desired Inventories by December 31, 20x0:**
  - Sheet Metal: 34,000 lb
  - Copper Wire: 30,000 lb
  - Platform: 6,200 units

- **Anticipated Purchase Prices:**
  - Sheet Metal: $14 per lb
  - Copper Wire: $8 per lb
  - Platform: $4 per unit

### Use of Raw Material
(Amount Used per Unit)

- **Light Coil:**
  - Sheet Metal: 5 lb
  - Copper Wire: 3 lb
  - Platform: 2 units

- **Heavy Coil:**
  - Sheet Metal: 6 lb
  - Copper Wire: 4 lb
  - Platform: 2 units

### Direct-Labor Requirements and Rates

- **Light Coil:**
  - Hours per Unit: 5
  - Rate per Hour: $10

- **Heavy Coil:**
  - Hours per Unit: 7
  - Rate per Hour: $15

### Finished-Goods Inventories (in units)

- **Expected Inventory as of January 1, 20x0:**
  - Light Coil: 17,000
  - Heavy Coil: 9,500

- **Desired Inventory by December 31, 20x0:**
  - Light Coil: 22,000
  - Heavy Coil: 10,500

This data provides a comprehensive overview of the production, raw material needs, and labor requirements needed for the upcoming year, aiding in planning and forecasting for Vista Electronics,
Transcribed Image Text:**Vista Electronics, Inc. Coil Manufacturing Data** Vista Electronics, Inc. produces two types of coils used in electric motors. The following data was compiled by Erica Becker, the controller, for the fall of the current year. ### Sales Forecast for 20x0 (All units to be shipped in 20x0) - **Product: Light coil** - Units: 52,000 - Price: $220 - **Product: Heavy coil** - Units: 32,000 - Price: $320 ### Raw-Material Prices and Inventory Levels - **Expected Inventories as of January 1, 20x0:** - Sheet Metal: 30,000 lb - Copper Wire: 27,000 lb - Platform: 5,200 units - **Desired Inventories by December 31, 20x0:** - Sheet Metal: 34,000 lb - Copper Wire: 30,000 lb - Platform: 6,200 units - **Anticipated Purchase Prices:** - Sheet Metal: $14 per lb - Copper Wire: $8 per lb - Platform: $4 per unit ### Use of Raw Material (Amount Used per Unit) - **Light Coil:** - Sheet Metal: 5 lb - Copper Wire: 3 lb - Platform: 2 units - **Heavy Coil:** - Sheet Metal: 6 lb - Copper Wire: 4 lb - Platform: 2 units ### Direct-Labor Requirements and Rates - **Light Coil:** - Hours per Unit: 5 - Rate per Hour: $10 - **Heavy Coil:** - Hours per Unit: 7 - Rate per Hour: $15 ### Finished-Goods Inventories (in units) - **Expected Inventory as of January 1, 20x0:** - Light Coil: 17,000 - Heavy Coil: 9,500 - **Desired Inventory by December 31, 20x0:** - Light Coil: 22,000 - Heavy Coil: 10,500 This data provides a comprehensive overview of the production, raw material needs, and labor requirements needed for the upcoming year, aiding in planning and forecasting for Vista Electronics,
### Finished-Goods Inventories (in units):
- **Product**  
  - **Light Coil**
    - **Expected (January 1, 20x0):** 17,000
    - **Desired (December 31, 20x0):** 22,000
  - **Heavy Coil**
    - **Expected (January 1, 20x0):** 9,500
    - **Desired (December 31, 20x0):** 10,500

### Production Overhead:
- **Overhead Cost Item**
  - **Purchasing and Material Handling:** $0.80 per pound of sheet metal and copper wire purchased
  - **Depreciation, Utilities, and Inspection:** $7.00 per coil produced (either type)
  - **Shipping:** $1.00 per coil shipped (either type)
  - **General Production Overhead:** $5.00 per direct-labor hour
  
### Problem 9-39 Part 5

5. **Prepare the Direct-Labor Budget (in dollars) for 20x0.**

#### Direct-Labor Budget for 20x0:
- **Projected Production (units)**
  - Light Coils: [Data to be added]
  - Heavy Coils: [Data to be added]
  
- **Hours per Unit**
  - Light Coils: [Data to be added]
  - Heavy Coils: [Data to be added]
  
- **Total Hours**
  - Light Coils: [Data to be added]
  - Heavy Coils: [Data to be added]
  
- **Rate**: [Data to be added]

- **Total Cost**  
  - Overall Total: $0
Transcribed Image Text:### Finished-Goods Inventories (in units): - **Product** - **Light Coil** - **Expected (January 1, 20x0):** 17,000 - **Desired (December 31, 20x0):** 22,000 - **Heavy Coil** - **Expected (January 1, 20x0):** 9,500 - **Desired (December 31, 20x0):** 10,500 ### Production Overhead: - **Overhead Cost Item** - **Purchasing and Material Handling:** $0.80 per pound of sheet metal and copper wire purchased - **Depreciation, Utilities, and Inspection:** $7.00 per coil produced (either type) - **Shipping:** $1.00 per coil shipped (either type) - **General Production Overhead:** $5.00 per direct-labor hour ### Problem 9-39 Part 5 5. **Prepare the Direct-Labor Budget (in dollars) for 20x0.** #### Direct-Labor Budget for 20x0: - **Projected Production (units)** - Light Coils: [Data to be added] - Heavy Coils: [Data to be added] - **Hours per Unit** - Light Coils: [Data to be added] - Heavy Coils: [Data to be added] - **Total Hours** - Light Coils: [Data to be added] - Heavy Coils: [Data to be added] - **Rate**: [Data to be added] - **Total Cost** - Overall Total: $0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Cost Sheet
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education