Budgeted Income Statement and Supporting Budgets The budget director of Feathered Friends 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 December: Estimated sales for December: Bird house 3,200 units at $50 per unit Bird feeder 3,000 units at $70 per unit Estimated inventories at December 1: Direct materials: Wood 200 ft. Plastic 240 lbs. Finished products: Bird house 320 units at $27 per unit Bird feeder 270 units at $40 per unit Desired inventories at December 31: Direct materials: Wood 220 ft. Plastic 200 lbs. Finished products: Bird house 290 units at $27 per unit Bird feeder 250 units at $41 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 $7.00 per ft. Plastic $1.00 per lb. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at $16 per hr. Assembly Department 0.30 hr. at $12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at $16 per hr. Assembly Department 0.35 hr. at $12 per hr. Estimated factory overhead costs for December: Indirect factory wages $75,000 Depreciation of plant and equipment 23,000 Power and light 6,000 Insurance and property tax 5,000 Estimated operating expenses for December: Sales salaries expense $70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expense—office equipment 600 Telephone expense—selling 550 Telephone expense—administrative 250 Travel expense—selling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 Estimated other income and expense for December: Interest revenue $200 Interest expense 122 Estimated tax rate: 30%   Required: 1.  Prepare a sales budget for December.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Budgeted Income Statement and Supporting Budgets

The budget director of Feathered Friends 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 December:

  1. Estimated sales for December:
    Bird house 3,200 units at $50 per unit
    Bird feeder 3,000 units at $70 per unit
  2. Estimated inventories at December 1:
    Direct materials:
    Wood 200 ft.
    Plastic 240 lbs.
    Finished products:
    Bird house 320 units at $27 per unit
    Bird feeder 270 units at $40 per unit
  3. Desired inventories at December 31:
    Direct materials:
    Wood 220 ft.
    Plastic 200 lbs.
    Finished products:
    Bird house 290 units at $27 per unit
    Bird feeder 250 units at $41 per unit
  4. 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
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
    Wood $7.00 per ft.
    Plastic $1.00 per lb.
  6. Direct labor requirements:
    Bird House:
    Fabrication Department 0.20 hr. at $16 per hr.
    Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
    Fabrication Department 0.40 hr. at $16 per hr.
    Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for December:
    Indirect factory wages $75,000
    Depreciation of plant and equipment 23,000
    Power and light 6,000
    Insurance and property tax 5,000
  8. Estimated operating expenses for December:
    Sales salaries expense $70,000
    Advertising expense 18,000
    Office salaries expense 21,000
    Depreciation expense—office equipment 600
    Telephone expense—selling 550
    Telephone expense—administrative 250
    Travel expense—selling 4,000
    Office supplies expense 200
    Miscellaneous administrative expense 400
  9. Estimated other income and expense for December:
    Interest revenue $200
    Interest expense 122
  10. Estimated tax rate: 30%

 

Required:

1.  Prepare a sales budget for December.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education