Question

In: Accounting

[The following information applies to the questions displayed below.] Vista Electronics, Inc. manufactures two different types...

[The following information applies to the questions displayed below.]

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 65,000 $ 350
Heavy coil 45,000 450

Raw-material prices and inventory levels:

Raw Material Expected Inventories, January 1, 20x0 Desired Inventories, December 31, 20x0 Anticipated Purchase Price
Sheet metal 43,000 lb. 47,000 lb. $ 13
Copper wire 40,000 lb. 43,000 lb. 8
Platform 6,500 units 7,500 units 4

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 per Unit Rate per Hour
Light coil 6 $ 10
Heavy coil 8 15

Finished-goods inventories (in units):

Product Expected January 1, 20x0 Desired December 31, 20x0
Light coil 30,000 35,000
Heavy coil 9,000 10,000

Production overhead:

Overhead Cost Item Activity-Based Budget Rate
Purchasing and material handling $ 0.90 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 production overhead $ 6.00 per direct-labor hour

A. Prepare the sales budget (in dollars) for 20x0.

Sales Budget for 20x0
Total
Light coils
Heavy coils
Projected sales $0

B. Prepare the production budget (in units) for 20x0.

Production Budget (in units) for 20x0
Light Coils Heavy Coils
Projected sales
Total requirements
Production required (units)

C. Prepare the raw material purchases budget (in quantities) for 20x0.

Raw Material Purchases Budget (in Quantities) for 20x0
Raw Material
Sheet Metal Copper Wire Platform
Light coils
Heavy coils
Production requirements
Total requirements
Purchase requirements (units)

D. Prepare the raw material purchases budget (in dollars) for 20x0.

Raw Material Purchases Budget for 20x0
Raw Material Raw Material Required (units) Anticipated Purchase Price Total
Sheet metal
Copper wire
Platforms
Total

E. Prepare the direct-labor budget (in dollars) for 20x0.

Direct-Labor Budget for 20x0
Projected Production (units) Hours per Unit Total Hours Rate Total Cost
Light coils
Heavy coils
Total

F. Prepare the production-overhead budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal places.)

Production Overhead Budget for 20x0
Cost Driver Quantity Cost Driver Rate Budgeted Cost
Purchasing and material handling lb.
Depreciation, utilities, and inspection coils
Shipping coils
General production overhead hr.
Total production overhead

Solutions

Expert Solution


Related Solutions

[The following information applies to the questions displayed below.] Vista Electronics, Inc. manufactures two different types...
[The following information applies to the questions displayed below.] 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 58,000 $ 280 Heavy coil 38,000 380 Raw-material prices and inventory levels: Raw Material Expected Inventories, January 1, 20x0 Desired Inventories, December 31, 20x0 Anticipated Purchase Price...
Required information [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types...
Required information [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.40 per pound) 35 pounds 75 pounds Corrugating medium ($0.20 per pound) 25 pounds 35 pounds Direct labor required per 100...
Required information [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types...
Required information [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.32 per pound) 50 pounds 90 pounds Corrugating medium ($0.16 per pound) 40 pounds 50 pounds Direct labor required per 100...
[The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard...
[The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.28 per pound) 50 pounds 90 pounds Corrugating medium ($0.14 per pound) 40 pounds 50 pounds Direct labor required per 100 boxes ($14.00...
[The following information applies to the questions displayed below.] QualCo manufactures a single product in two...
[The following information applies to the questions displayed below.] QualCo manufactures a single product in two departments: Cutting and Assembly. During May, the Cutting department completed a number of units of a product and transferred them to Assembly. Of these transferred units, 39,400 were in process in the Cutting department at the beginning of May and 169,500 were started and completed in May. May’s Cutting department beginning inventory units were 60% complete with respect to materials and 40% complete with...
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...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $12 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending direct materials inventory should be 30 percent of next month’s...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo, which costs $3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $11 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending direct materials inventory should be 30 percent of next month’s...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending direct materials inventory should be 30 percent of next month’s...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture...
Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending direct materials inventory should be 30 percent of next month’s...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT