Prepare the sales budget (in dollars) for 20x0.light coils, heavy coils and projected sales. **Vista Electronics, Incorporated: Production Data Overview**Vista Electronics, Incorporated, 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 - **Units:** 58,000 - **Price:** $280 - **Product:** Heavy Coil - **Units:** 38,000 - **Price:** $380- **Raw-Material Prices and Inventory Levels:** | Raw Material | Expected Inventories, January 1, 20x0 | Desired Inventories, December 31, 20x0 | Anticipated Purchase Price | |--------------|--------------------------------------|---------------------------------------|----------------------------| | Sheet Metal | 36,000 Pounds | 40,000 Pounds | $15 | | Copper Wire | 33,000 Pounds | 36,000 Pounds | $8 | | Platform | 5,800 Units | 6,800 Units | $4 |- **Use of Raw Material:** | Raw Material | Amount Used per Light Coil | Amount Used per Heavy Coil | |--------------|----------------------------|----------------------------| | Sheet Metal | 4 Pounds | 5 Pounds | | Copper Wire | 2 Pounds | 3 Pounds | | Platform | 2 Units | 2 Units |- **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, 20x0 | Desired December 31, 20x0 | |------------|--------------------------|---------------------------| | Light Coil | 23,000 | 28,000 | | Heavy Coil | 9,500 | 10,500 | ### Finished-Goods Inventories (in units)#### Product Inventory Projections- **Light Coil** - **Expected January 1, 20x0:** 23,000 units - **Desired December 31, 20x0:** 28,000 units- **Heavy Coil** - **Expected January 1, 20x0:** 9,500 units - **Desired December 31, 20x0:** 10,500 units### Production Overhead#### Overhead Costs and Activity-Based Budget Rates- **Overhead Cost Item:** 1. **Purchasing and Material Handling** - **Rate:** $0.80 per pound of sheet metal and copper wire purchased 2. **Depreciation, Utilities, and Inspection** - **Rate:** $7.00 per coil produced (either type) 3. **Shipping** - **Rate:** $2.00 per coil shipped (either type) 4. **General Production Overhead** - **Rate:** $5.00 per direct-labor hourThese details are part of budgeting and inventory planning in a manufacturing setting, indicating projected inventory levels and associated costs. The use of activity-based rates helps in assigning more accurate costs to production activities.

Name: Prepare the sales budget (in dollars) for 20x0.light coils, heavy coil
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Prepare the sales budget (in dollars) for 20x0.light coils, heavy coils and projected sales. **Vista Electronics, Incorporated: Production Data Overview**Vista Electronics, Incorporated, manufactures two different types of coils used in electric moto

Sales budget is a pre determined of sales unit and amount in future. It is a forecast of quantity of sale and revenue generated from such sale. It helps to management about the expected sale in future. Preparation of sale budget are as followsGiven, Forecast sale of light coil 58,000 units at $280 per units Forecast sale of heavy coil 38,000 units at $380 per units Sale budget = Units * sale priceSales budgetParticullarsLight coilHeavy coilTotalUnits58,000 units38,000 units96,000 unitsPrice per unit$280$380Sales budget (in $)$16,240,000$14,440,000$30,680,000

Business

Accounting

Vista Electronics, Incorporated, 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 58,000 38,000 Product Light coil Heavy coil • Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 36,000 Pound 33,000 Pound 5,800 units • Use of raw material: ● Raw Material Sheet metal Copper wire Platform . Price $ 280 380 Product Light coil Raw Material Sheet metal Copper wire Platform Direct-labor requirements and rates: Amount Used per Unit Light Coil 4 Pound 2 Pound Product Light coil Heavy coil Finished-goods inventories (in units): Hours per Unit 3 5 Desired Inventories, December 31, 20x0 40,000 Pound 36,000 Pound 6,800 units 20x0 23.000 Heavy Coil 5 Pound 3 Pound 2 unit Rate per Hour $15 20 Expected January 1, Desired December 31, 20x0 28.000 Anticipated Purchase Price $15 8 4

Vista Electronics, Incorporated, 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 58,000 38,000 Product Light coil Heavy coil • Raw-material prices and inventory levels: Expected Inventories, January 1, 20x0 36,000 Pound 33,000 Pound 5,800 units • Use of raw material: ● Raw Material Sheet metal Copper wire Platform . Price $ 280 380 Product Light coil Raw Material Sheet metal Copper wire Platform Direct-labor requirements and rates: Amount Used per Unit Light Coil 4 Pound 2 Pound Product Light coil Heavy coil Finished-goods inventories (in units): Hours per Unit 3 5 Desired Inventories, December 31, 20x0 40,000 Pound 36,000 Pound 6,800 units 20x0 23.000 Heavy Coil 5 Pound 3 Pound 2 unit Rate per Hour $15 20 Expected January 1, Desired December 31, 20x0 28.000 Anticipated Purchase Price $15 8 4

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

the budgeted direct labor cost per unit of Product T is closest to: 9.10 10.50 7.00 15.75
budget the labor expense for a forecasted sales level of $200,000 from the following data :historical sales level $100,000 Historical semi variable $30,000(tc $30,000=vc$25,000+$5,000)
Given the information, prepare a sales budget in dollars, a raw materials inventory purchase budget in units and cost, and a production budget in units and cost. Sales forecast 10,000 units of ASD-34 at $159 each Beginning raw materials inventory 1,000 units of UIO-89 at a cost of $12.00 each Ending raw materials inventory 2,000 units of UIO-89 Beginning finished goods inventory 3,000 units of ASD-34 Ending finished goods inventory 4,000 units of ASD-34 Each unit of ASD-34 produced requires: 2 units of UIO-89 2 direct labor hours at $25.00 per hour Manufacturing overhead at 150 percent of direct labor cost
Please do not give solution in image format
4. Prepare a cash budget by quarter and in total for next year.
Hi, please help :) Use the appropriate mixed cell references and relative references to reflect the percentages in range A22:B27 to determine the projected expenses for each of the Budgeted Selling and Budgeted Administrative Expenses for the year of 2022.
Part B is needed
Please help me with show all calculation thanku
If a company plans to sell 40000 units of product but sells 60000 units, the most appropriate comparison of the cost data associated with the sales will be by a budget based on O 60000 units of activity. O40000 units of activity. O the original planned level of activity. O 50000 units of activity.
Am. 308.
PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULASIn preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year. What is the budgeted inventory balance
B D. You will prepare a static master budget, budgeted financial statements and a flexible budget/variance analysis for Karry No Key, Inc. which will sell karaoke machines. 5 Assumptions: You plan to form Karry No Key on April 1 and expect the following: 6 1. Invest in exchange for stock 2. Purchase delivery truck with cash with $0 salvage value and expected useful life in years 9 3. Sales increase per month 100,000 60,000 8 10 2% Collections in month of sale 69% Collections of remainder in following month of sale 2 4. Desired ending inventory (% of next month's expected sales) Payments in month of purchase Payments of remainder in following month of purchase 5 5. Other operating expenses per month to be paid in month incurred 1 31% 20% 3 10% 4 90% 49,000 Requirement 1: Complete the Sales Budget and Cash Collections for April - June and the quarter in total using applicable assumptions above. Sales Budget April May June Total 1st Quarter April Sales in units 1960 Price per unit $ 98.00…