**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,500This 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 55. **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

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

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

See similar textbooks

Similar questions

A7
! Required information [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 560 sun shades in May and 330 in June. Each shade sells for $151. Shadee's beginning and ending finished goods inventories for May are 80 and 50 shades, respectively. Ending finished goods inventory for June will be 70 shades. Each shade requires a total of $55.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $14 per hour. Additionally, Shadee's fixed manufacturing overhead is $12,000 per month, and variable manufacturing overhead is $14 per unit produced. Additional information: Selling costs are expected to be 7 percent of sales. • Fixed administrative expenses per month total $1,700. Required:…
Net Steels is a steel manufacturing company. It currently orders 180 metric tons of raw material per order. It was observed that the company often faces stockout. To tackle this issue, the company incorporated a fixed-quantity system (FQS) and collected the following data. The lead time is 2 weeks. Demand Order Cost Item Cost Inventory-Holding Cost 10000 metric tons per year $17000 per order $38000 per year 20 percent per year Assuming there are 50 weeks a year, determine the reorder point. Only for non-integer results, round your answer UP to the nearest integer. For example, if your answer is 5.05, type 6; if your answer is 5, type 5. 2DCO Economic Order Quantity (EOQ), Q* = Cn Reorder point, r = demand rate x lead time Your Answer: Answer
Prepare the production budget (in units) for 20x0.
2. Lens Junction has required production of 15,400 units in January and 18,100 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound and 3 ounces of solution costing $3 per ounce. Desired inventory levels are: Jan. Feb. Mar. Beginning Inventory: Finished Goods (units) 4,500 4,900 5,000 DM - Silicon (pounds) 8,500 9,100 9,200 DM - Solution (ounces) 11,200 12,000 13,000 PLEASE NOTE: Units are rounded to whole numbers with commas as needed (i.e. 1,234) - no labels. All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345), except for any "per" amounts (units, pounds, ounces, or dollars), which are rounded to two decimal places and shown with "$" and commas as needed (i.e. $1,234.56) - no labels. Cost per Pound Desired Ending Inventory DM per Unit Ounces Needed for Production Required DM Ounces Pounds Needed for Production Units to be Produced Total Cost of DM Purchase Required DM Pounds…
Olympia Productions Incorporated makes award medallions that are attached to ribbons. Each medallion requires 18 inches of ribbon. The sales forecast for March is 2,000 medallions. Estimated beginning inventories and desired ending inventories for March are as follows: (Assume 18 inches = 0.5 yards) Estimated Beginning Medallions Ribbon (yards) Inventory 1,100 70 Desired Ending Inventory 750 23 Required: a. Calculate the number of medallions to be produced in March. b. Calculate the number of yards of ribbon to be purchased in March. a. Number of medallions produced b. Number of yards of ribbon purchased