Questions
1. Standard Product Cost Sana Rosa Furniture Company manufactures designer home furniture. Sana Rosa uses a...

1.

Standard Product Cost

Sana Rosa Furniture Company manufactures designer home furniture. Sana Rosa uses a standard cost system. The direct labor, direct materials, and factory overhead standards for an unfinished dining room table are as follows:

Direct labor: standard rate $24.00 per hr.
standard time per unit 4.00 hrs.
Direct materials (oak): standard price $11.50 per bd. ft.
standard quantity 17 bd. ft.
Variable factory overhead: standard rate $2.40 per direct labor hr.
Fixed factory overhead: standard rate $1.20 per direct labor hr.

a. Determine the standard cost per dining room table. If required, round your answer to two decimal places.
$ per dining room table

b. A standard cost system provides Rosa Furniture management a cost control tool using the principle of  . Using this principle,   cost deviations from standards can be investigated and corrected.

2.

Direct Materials and Direct Labor Variances

At the beginning of June, Kimber Toy Company budgeted 17,000 toy action figures to be manufactured in June at standard direct materials and direct labor costs as follows:

Direct materials $12,750
Direct labor 9,180
Total $21,930

The standard materials price is $0.50 per pound. The standard direct labor rate is $9.00 per hour. At the end of June, the actual direct materials and direct labor costs were as follows:

Actual direct materials $12,000
Actual direct labor 8,600
Total $20,600

There were no direct materials price or direct labor rate variances for June. In addition, assume no changes in the direct materials inventory balances in June. Kimber Toy Company actually produced 15,500 units during June.

Determine the direct materials quantity and direct labor time variances. Round your per unit computations to two decimal places, if required. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.

Direct materials quantity variance $
Direct labor time variance $

3.

Flexible Overhead Budget

Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 12,000 hours of productive capacity in the department:

Variable overhead cost:
   Indirect factory labor $100,800
   Power and light 3,600
   Indirect materials 31,200
      Total variable overhead cost $135,600
Fixed overhead cost:
   Supervisory salaries $47,460
   Depreciation of plant and equipment 29,830
   Insurance and property taxes 18,980
      Total fixed overhead cost 96,270
Total factory overhead cost $231,870

Assuming that the estimated costs for November are the same as for October, prepare a flexible factory overhead cost budget for the Press Department for November for 10,000, 12,000, and 14,000 hours of production. Round your interim computations to the nearest cent, if required. Enter all amounts as positive numbers.

Leno Manufacturing Company
Factory Overhead Cost Budget-Press Department
For the Month Ended November 30
Direct labor hours 10,000 12,000 14,000
Variable overhead cost:
Indirect factory labor $ $ $
Power and light
Indirect materials
Total variable factory overhead $ $ $
Fixed factory overhead cost:
Supervisory salaries $ $ $
Depreciation of plant and equipment
Insurance and property taxes
Total fixed factory overhead $ $ $
Total factory overhead cost $ $ $

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

a. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

b. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

c. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

d. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

e. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

f. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

g. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

h. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

  1. The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

    1. Estimated sales for January:
        Birdhouse 6,000 units at $55 per unit
        Bird feeder 4,500 units at $75 per unit
    2. Estimated inventories at January 1:
      Direct materials:
        Wood 220 ft.
        Plastic 250 lb.
      Finished products:
        Birdhouse 300 units at $23 per unit
        Bird feeder 240 units at $34 per unit
    3. Desired inventories at January 31:
      Direct materials:
        Wood 180 ft.
        Plastic 210 lb.
      Finished products:
        Birdhouse 340 units at $23 per unit
        Bird feeder 200 units at $34 per unit
    4. Direct materials used in production:
      In manufacture of BirdHouse:
        Wood 0.80 ft. per unit of product
        Plastic 0.50 lb. per unit of product
      In manufacture of Bird Feeder:
        Wood 1.20 ft. per unit of product
        Plastic 0.75 lb. per unit of product
    5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
        Wood $8.00 per ft.
        Plastic $1.20 per lb.
    6. Direct labor requirements:
      Birdhouse:
        Fabrication Department 0.20 hr. at $15 per hr.
        Assembly Department 0.30 hr. at $12 per hr.
      Bird Feeder:
        Fabrication Department 0.40 hr. at $15 per hr.
        Assembly Department 0.35 hr. at $12 per hr.
    7. Estimated factory overhead costs for January:
      Indirect factory wages $80,000
      Depreciation of plant and equipment 25,000
      Power and light 8,000
      Insurance and property tax 2,000
    8. Estimated operating expenses for January:
      Sales salaries expense $90,000
      Advertising expense 20,000
      Office salaries expense 18,000
      Depreciation expense—office equipment 800
      Telephone expense—selling 500
      Telephone expense—administrative 200
      Travel expense—selling 5,000
      Office supplies expense 250
      Miscellaneous administrative expense 450
    9. Estimated other income and expense for January:
      Interest revenue $300
      Interest expense 224
    10. Estimated tax rate: 30%

    Required:

    1. Prepare a sales budget for January.

    Birds of a Feather Inc.
    Sales Budget
    For the Month Ending January 31
    Unit Sales
    Volume
    Unit Selling
    Price
    Total Sales
    Birdhouse
    Bird feeder
    Total revenue from sales $

    2. Prepare a production budget for January.

    Birds of a Feather Inc.
    Production Budget
    For the Month Ending January 31
    Units
    Birdhouse Bird Feeder
    Expected units to be sold
    Plus desired inventory, January 31
      Total
    Less estimated inventory, January 1
    Total units to be produced

    3. Prepare a direct materials purchases budget for January.

    Birds of a Feather Inc.
    Direct Materials Purchases Budget
    For the Month Ending January 31
    Wood Plastic Total
    Required units for production:
      Birdhouse
      Bird feeder
    Plus desired units of inventory, January 31
    Total
    Less estimated units of inventory, January 1
    Total units to be purchased
    Unit price $ $
    Total direct materials to be purchased $ $ $

    4. Prepare a direct labor cost budget for January.

    Birds of a Feather Inc.
    Direct Labor Cost Budget
    For the Month Ending January 31
    Fabrication
    Department
    Assembly Department Total
    Hours required for production:
    Birdhouse
    Bird feeder
    Total
    Hourly rate $ $
    Total direct labor cost $ $ $

    5. Prepare a factory overhead cost budget for January.

    Birds of a Feather Inc.
    Factory Overhead Cost Budget
    For the Month Ending January 31
    Indirect factory wages
    Depreciation of plant and equipment
    Power and light
    Insurance and property tax
    Total $

    6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

    Birds of a Feather Inc.
    Cost of Goods Sold Budget
    For the Month Ending January 31
    Direct materials:
       
       
      Cost of direct materials available for use
       
      Cost of direct materials placed in production
    Total manufacturing costs
    Total work in process during the period
    Cost of goods manufactured
    Cost of finished goods available for sale
    Cost of goods sold $

    7. Prepare a selling and administrative expenses budget for January.

    Birds of a Feather Inc.
    Selling and Administrative Expenses Budget
    For the Month Ending January 31
    Selling expenses:
    Sales salaries expense
    Advertising expense
    Telephone expense—selling
    Travel expense—selling
    Total selling expenses
    Administrative expenses:
    Office salaries expense
    Depreciation expense—office equipment
    Telephone expense—administrative
    Office supplies expense
    Miscellaneous administrative expense
    Total administrative expenses
    Total operating expenses $

    8. Prepare a budgeted income statement for January.

    Birds of a Feather Inc.
    Budgeted Income Statement
    For the Month Ending January 31
    Selling and administrative expenses:
    Total selling and administrative expenses
    Other revenue:
    Other expenses:
    $

In: Accounting

Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...

Operating Budget, Comprehensive Analysis

Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below.

January 10,000
February 10,500
March 13,100
April 16,000
May 18,500

The following data pertain to production policies and manufacturing specifications followed by Ponderosa:

  1. Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month’s sales.
  2. The data on materials used are as follows:
    Direct Material Per-Unit Usage Unit Cost
    Part #K298 2    $4
    Part #C30 3    7

    Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the amount of material on hand on January 1.

  3. The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20.
  4. Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.)
    Fixed Cost
    Component
    Variable Cost
    Component
    Supplies $ — $1.00   
    Power —    0.20
    Maintenance 12,600 1.10
    Supervision 14,000
    Depreciation 45,000
    Taxes 4,300
    Other 86,000 1.60
  5. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold.)
    Fixed Costs Variable Costs
    Salaries $ 88,600 —     
    Commissions —    $1.40   
    Depreciation 25,000 —   
    Shipping 3.60   
    Other 137,000 1.60   
  6. The unit selling price of the wiring harness assembly is $110.
  7. In February, the company plans to purchase land for future expansion. The land costs $68,000.
  8. All sales and purchases are for cash. The cash balance on January 1 equals $62,700. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum.

Required:

Prepare a monthly operating budget for the first quarter with the following schedules:

2. Production budget

January February March Total
Unit sales 10,000 10,500 13,100 33,600
Desired ending inventory 2,100 3,200
Total needed 12,100
Less: Beginning inventory 900 2,100
Units produced 11,200

3. Direct materials purchases budget

January February March Total
Part K298 Part C30 Part K298 Part C30 Part K298 Part C30 Part K298 Part C30
Units produced 11200                     
Dir. mat. per unit 2 3 2 3 2 3 2 3
Production needs 22,400 33,600                  
Desired EI                        
Total needed                        
Less: BI                        
Dir. mat. to purchase                        
Cost per unit $ $ $ $ $ $ $ $
Total purchase cost $ $ $ $ $ $ $ $

4. Direct labor budget. Round your answers to two decimal places, if required.

January February March Total
Units to be produced            
Direct labor time per unit (hrs.)            
Total hours needed            
Wages per hour $ $ $ $
Total direct labor cost $ $ $ $
January February March Total
Budgeted direct labor hours            
Variable overhead rate            
Budgeted var. overhead $ $ $ $
Budgeted fixed overhead            
Total overhead cost $ $ $ $

6. Selling and administrative expense budget. Round your answers to the nearest cent, if required.

January February March Total
Planned sales            
Variable selling & administrative expense per unit $ $ $ $
Total variable expense $ $ $ $
Fixed selling & administrative expense:
Salaries $ $ $ $
Depreciation            
Other            
Total fixed expenses $ $ $ $
Total selling & administrative expenses $ $ $ $

7. Ending finished goods inventory budget. Round intermediate calculations to the nearest cent. Round your answers to the nearest cent, if required.

Unit cost computation:
Direct materials:
Part K298 $
Part C30   
Direct labor   
Overhead:
Variable   
Fixed
Total unit cost $
Number of units
Finished goods $

8. Cost of goods sold budget

Direct materials used
Part K298 $
Part C30    $
Direct labor used   
Overhead   
Budgeted manufacturing costs $
Add: Beginning finished goods   
Goods available for sale $
Less: Ending finished goods   
Budgeted cost of goods sold $

9. Budgeted income statement (ignore income taxes)

Sales $
Less: Cost of goods sold   
Gross margin $
Less: Selling and administrative expense   
Income before income taxes $

10. Cash budget
Enter a negative balance as a negative amount, and if an amount is zero enter "0".

January February March Total
Beginning balance $ $ $ $
Cash receipts            
Total cash available $ $ $ $
Disbursements:
Purchases $ $ $ $
DL payroll            
Overhead            
Marketing & admin            
Land      
Total disbursements $ $ $ $
Ending balance $ $ $ $
Financing:
Borrowed/repaid            
Interest paid            
Ending cash balance $ $ $ $

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

Estimated sales for January:

  Bird house 6,000 units at $55 per unit
  Bird feeder 4,500 units at $75 per unit

Estimated inventories at January 1:

Direct materials:
  Wood 220 ft.
  Plastic 250 lbs.
Finished products:
  Bird house 300 units at $23 per unit
  Bird feeder 240 units at $34 per unit

Desired inventories at January 31:

Direct materials:
  Wood 180 ft.
  Plastic 210 lbs.
Finished products:
  Bird house 340 units at $23 per unit
  Bird feeder 200 units at $34 per unit

Direct materials used in production:

In manufacture of Bird House:
  Wood 0.80 ft. per unit of product
  Plastic 0.50 lb. per unit of product
In manufacture of Bird Feeder:
  Wood 1.20 ft. per unit of product
  Plastic 0.75 lb. per unit of product

Anticipated cost of purchases and beginning and ending inventory of direct materials:

  Wood $8.00 per ft.
  Plastic $1.20 per lb.

Direct labor requirements:

Bird House:
  Fabrication Department 0.20 hr. at $15 per hr.
  Assembly Department 0.30 hr. at $12 per hr.
Bird Feeder:
  Fabrication Department 0.40 hr. at $15 per hr.
  Assembly Department 0.35 hr. at $12 per hr.

Estimated factory overhead costs for January:

Indirect factory wages $80,000
Depreciation of plant and equipment 25,000
Power and light $8,000
Insurance and property tax 2,000

Estimated operating expenses for January:

Sales salaries expense $90,000
Advertising expense 20,000
Office salaries expense 18,000
Depreciation expense—office equipment 800
Telephone expense—selling 500
Telephone expense—administrative 200
Travel expense—selling 5,000
Office supplies expense 250
Miscellaneous administrative expense 450

Estimated other income and expense for January:

Interest revenue $300
Interest expense 224

Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Bird house
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Bird House Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Bird house
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Bird house
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
  
  
  Cost of direct materials available for use
  
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Operating expenses:
Total operating expenses
Other income:
Other expenses:
$

In: Accounting

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer,...

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting