Question

In: Accounting

Trevor Inc. manufactures model airplane kits and projects production at 150, 530, 300, and 750 kits...

Trevor Inc. manufactures model airplane kits and projects production at 150, 530, 300, and 750 kits for the next four quarters.

Manufacturing Information: Direct materials are 4 ounces of plastic per kit and the plastic costs $2 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 900 ounces, and the company desires to end each quarter with 30% of the materials needed for the next quarter's production. trevor desires a balance of 260 ounces in Raw Materials Inventory at the end of the fourth quarter. Each kit requires0.50hours of direct labor at an average cost of $30 per hour. Manufacturing overhead is allocated using direct labor hours as the allocation base. Variable overhead is $0.25 per-kit, and fixed overhead is $150 per quarter.

Prepare Trevor 's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number.

Begin by preparing Trevor 's direct materials budget.

Trevor, Inc.

Direct Materials Budget

For the Year Ended December 31

First

Second

Third

Fourth

Quarter

Quarter

Quarter

Quarter

Total

Budgeted kits to be produced

Direct materials (ounces) per kit

Direct materials needed for production

Plus:

Desired direct materials in ending inventory

Total direct materials needed

Less:

Direct materials in beginning inventory

Budgeted purchases of direct materials

Direct materials cost per ounce

Budgeted cost of direct materials purchases

Prepare the direct labor budget. (Enter any hours as a decimal to two places, X.XX, and round all other amounts to the nearest whole number.)

Trevor, Inc.

Direct Labor Budget

For the Year Ended December 31

First

Second

Third

Fourth

Quarter

Quarter

Quarter

Quarter

Total

Budgeted kits to be produced

Direct labor hours per unit

Direct labor hours needed for production

Direct labor cost per hour

Budgeted direct labor cost

Prepare the manufacturing overhead budget. (Enter all costs and hours as a decimal to two places, X.XX. Abbreviations used: VOH = variable manufacturing overhead; FOH = fixed manufacturing overhead.)

Trevor, Inc.

Manufacturing Overhead Budget

For the Year Ended December 31

First

Second

Third

Fourth

Quarter

Quarter

Quarter

Quarter

Total

Budgeted kits to be produced

VOH cost per kit

Budgeted VOH

Budgeted FOH

Budgeted manufacturing overhead costs

Direct labor hours

Budgeted manufacturing overhead costs

Predetermined overhead allocation rate

Solutions

Expert Solution

Trevor Inc
Direct Materials, Budget
For the Year Ended December 31
First Second Third Fourth
Quarter Quarter Quarter Quarter Total
Budgeted Kits to be produced 150 530 300 750 1730
Direct Materials (ounces) per kit 4 4 4 4 4
Direct Materials needed for production 600 2120 1200 3000 6920
Add Desired Direct Materials in Ending Inventory 636 360 900 260 260
Total Direct Materials needed 1236 2480 2100 3260 7180
Less Direct Materials in Beginning Inventory 900 636 360 900 900
Budgeted purchases of direct materials 336 1844 1740 2360 6280
Direct materials cost per ounce 2 2 2 2 2
Budgeted cost of direct material purchases 672 3688 3480 4720 12560
Trevor, Inc.
Direct Labor Budget
For the Year Ended December 31
First Second Third Fourth
Quarter Quarter Quarter Quarter Total
Budgeted kits to be produced 150 530 300 750 1730
Direct labor hours per unit 0.5 0.5 0.5 0.5 0.5
Direct labor hours needed for production 75 265 150 375 865
Direct labor cost per hour 30 30 30 30 30
Budgeted direct labor cost 2250 7950 4500 11250 25950
Trevor, Inc.
Manufacturing Overhead Budget
For the Year Ended December 31
First Second Third Fourth
Quarter Quarter Quarter Quarter Total
Budgeted kits to be produced 150 530 300 750 1730
VOH cost per kit 0.25 0.25 0.25 0.25 0.25
Budgeted VOH 37.5 132.5 75 187.5 432.5
Budgeted FOH 150 150 150 150 600
Budgeted manufacturing overhead costs 187.5 282.5 225 337.5 1032.5
Direct labor hours 2250 7950 4500 11250 25950
Budgeted manufacturing overhead costs 187.5 282.5 225 337.5 1032.5
Predetermined overhead allocation rate 0.083 0.036 0.050 0.030 0.040

Related Solutions

Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The manufacturing...
Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The manufacturing process consists of two principal departments: production and assembly. The production department has 58 skilled workers, each of whom works 7 hours per day. The assembly department has 25 workers, who also work 7-hour shifts. On an average, to produce a G1 model, Zen Inc. requires 3.5 labor hours for production and 2 labor hours for assembly. The T1 model requires 4 labor hours...
12). Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The...
12). Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The manufacturing process consists of two principal departments: production and assembly. The production department has 58 skilled workers, each of whom works 7 hours per day. The assembly department has 25 workers, who also work 7-hour shifts. On an average, to produce a G1 model, Zen Inc. requires 3.5 labor hours for production and 2 labor hours for assembly. The T1 model requires 4 labor...
20.) Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The...
20.) Zen Inc. manufactures two types of products, the G1 and the T1 model airplane. The manufacturing process consists of two principal departments: production and assembly. The production department has 58 skilled workers, each of whom works 7 hours per day. The assembly department has 25 workers, who also work 7-hour shifts. On an average, to produce a G1 model, Zen Inc. requires 3.5 labor hours for production and 2 labor hours for assembly. The T1 model requires 4 labor...
Laser Cast, Inc., manufactures color laser printers. Model J20 presently sells for $150 and has a...
Laser Cast, Inc., manufactures color laser printers. Model J20 presently sells for $150 and has a total product cost of $120, as follows: Direct materials $90 Direct labor 20 Factory overhead 10 Total $120 It is estimated that the competitive selling price for color laser printers of this type will drop to $140 next year. Laser Cast has established a target cost to maintain its historical markup percentage on product cost. Engineers have provided the following cost reduction ideas: Purchase...
Air Travel Inc. manufactures a wide variety of parts for commercial aircraft, including airplane engines. The...
Air Travel Inc. manufactures a wide variety of parts for commercial aircraft, including airplane engines. The component is purchased by OEM (Original Equipment Manufacturers) such as Boeing, for use in the larger and more powerful outboards. The units sell for $10,000, and sales volume averages 2,000 units per year. Recently, Air Travel’s major competitor lowered the price of the equivalent part of $9,500. The market was very competitive, and AirTravel realized it had to meet the new price or lose...
Carleton Closures, Inc., manufactures clamps used in the overhead bin latches of several leading airplane models....
Carleton Closures, Inc., manufactures clamps used in the overhead bin latches of several leading airplane models. Greg Poole, president of Carleton Closures, Inc., has gathered the following cost information from the company’s accounting records for the latest month of operations. Advertising $25,000 Fire insurance premium for the factory building $6,250 Sales office utilities $2,500 Air filters for the buffing machines used to produce the clamps $1,875 Aluminum used to produce the clamps $37,500 Rent on the factory building $10,000 Freight...
Barclay Enterprises manufactures and sells three distinct styles of bicycles: the Youth model sells for $300...
Barclay Enterprises manufactures and sells three distinct styles of bicycles: the Youth model sells for $300 and has a unit contribution margin of $105; the Adult model sells for $850 and has a unit contribution margin of $450; and the Recreational model sells for $1,000 and has a unit contribution margin of $500. The company's sales mix includes: 5 Youth models; 9 Adult models; and 6 Recreational models. If the firm's annual fixed costs total $6,500,000, calculate the firm's break-even...
VanManufacturing Inc. produces smart pizza oven. In the current period, 750 ovens were assembled.The current production...
VanManufacturing Inc. produces smart pizza oven. In the current period, 750 ovens were assembled.The current production run required 1500 machine hours. The production machines require four "set-ups" for recalibration. Quality checks required 100 hours of final inspection activity. Overhead is estimated at $40 per machine hour, plus $1,000 per "set-up," and $50 per inspection hour. Direct materials and direct labor total $500 per oven. (a) Apply activity-based costing and determine the amount assigned to an oven. (b) For GAAP purposes,...
Gordon, Inc. makes toys and projects production to be 6100, 5900, 6000, and 5500 for the...
Gordon, Inc. makes toys and projects production to be 6100, 5900, 6000, and 5500 for the next four quarters. Direct materials are $8 per kit. Beginning Raw Material Inventory is $20,000 and the company desires to end each quarter with 25% of the material needed for the next two quarter's production. Direct Materials needed for production in the First Quarter of the following year is $45,000. Gordon desires a balance of $25,000 in Raw Materials Inventory at the end of...
Com-Tel Inc. manufactures and assembles two models of smartphones—the Tiger Model and the Lion Model. The...
Com-Tel Inc. manufactures and assembles two models of smartphones—the Tiger Model and the Lion Model. The process consists of a lean cell for each product. The data that follow concern only the Lion Model lean cell. For the year, Com-Tel Inc. budgeted these costs for the Lion Model production cell: Conversion Cost Categories Budget Labor $113,300 Supplies 42,900 Utilities 15,400    Total $171,600 Com-Tel plans 2,200 hours of production for the Lion Model cell for the year. The materials cost is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT