The budget director of Jupiter Helmets 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 May: a. Estimated sales for May: Bicycle helmet 9,500 units at $24 per unit Motorcycle helmet 6,000 units at $180 per unit b. Estimated inventories at May 1: Direct materials:         Finished products:        Plastic   1,480  lbs.      Bicycle helmet   200 units at $15 per unit    Foam lining   520  lbs.      Motorcycle helmet   100 units at $90 per unit   c. Desired inventories at May 31: Direct materials:         Finished products:        Plastic   2,000  lbs.      Bicycle helmet   400 units at $15 per unit    Foam lining   800  lbs.      Motorcycle helmet   300 units at $100 per unit   d. Direct materials used in production: In manufacture of bicycle helmet:    Plastic   0.90 lb. per unit of product    Foam lining   0.20 lb. per unit of product In manufacture of motorcycle helmet:    Plastic   3.50 lbs. per unit of product    Foam lining   1.40 lbs. per unit of product   e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic   $4.40 per lb. Foam lining   $0.90 per lb.   f. Direct labor requirements: Bicycle helmet:    Molding Department   0.30 hr. at $15 per hr.    Assembly Department   0.10 hr. at $14 per hr. Motorcycle helmet:    Molding Department   0.50 hr. at $15 per hr.    Assembly Department   0.40 hr. at $14 per hr.   g. Estimated factory overhead costs for May: Indirect factory wages   $125,000     Power and light   $23,000 Depreciation of plant and equipment   45,000     Insurance and property tax   11,000   h. Estimated operating expenses for May: Sales salaries expense   $175,000 Advertising expense   120,000 Office salaries expense   92,000 Depreciation expense—office equipment   6,000 Miscellaneous expense—selling   5,000 Utilities expense—administrative   3,000 Travel expense—selling   50,000 Office supplies expense   2,500 Miscellaneous administrative expense   1,500   i. Estimated other income and expense for May: Interest revenue   $14,560 Interest expense   3,000   j. Estimated tax rate: 25% Required: 1.  Prepare a sales budget for May.

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
100%

The budget director of Jupiter Helmets 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 May:

a. Estimated sales for May:

Bicycle helmet 9,500 units at $24 per unit
Motorcycle helmet 6,000 units at $180 per unit

b. Estimated inventories at May 1:

Direct materials:         Finished products:    
   Plastic   1,480  lbs.      Bicycle helmet   200 units at $15 per unit
   Foam lining   520  lbs.      Motorcycle helmet   100 units at $90 per unit

 

c. Desired inventories at May 31:

Direct materials:         Finished products:    
   Plastic   2,000  lbs.      Bicycle helmet   400 units at $15 per unit
   Foam lining   800  lbs.      Motorcycle helmet   300 units at $100 per unit

 

d. Direct materials used in production:

In manufacture of bicycle helmet:
   Plastic   0.90 lb. per unit of product
   Foam lining   0.20 lb. per unit of product
In manufacture of motorcycle helmet:
   Plastic   3.50 lbs. per unit of product
   Foam lining   1.40 lbs. per unit of product

 

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

Plastic   $4.40 per lb.
Foam lining   $0.90 per lb.

 

f. Direct labor requirements:

Bicycle helmet:
   Molding Department   0.30 hr. at $15 per hr.
   Assembly Department   0.10 hr. at $14 per hr.
Motorcycle helmet:
   Molding Department   0.50 hr. at $15 per hr.
   Assembly Department   0.40 hr. at $14 per hr.

 

g. Estimated factory overhead costs for May:

Indirect factory wages   $125,000     Power and light   $23,000
Depreciation of plant and equipment   45,000     Insurance and property tax   11,000

 

h. Estimated operating expenses for May:

Sales salaries expense   $175,000
Advertising expense   120,000
Office salaries expense   92,000
Depreciation expense—office equipment   6,000
Miscellaneous expense—selling   5,000
Utilities expense—administrative   3,000
Travel expense—selling   50,000
Office supplies expense   2,500
Miscellaneous administrative expense   1,500

 

i. Estimated other income and expense for May:

Interest revenue   $14,560
Interest expense   3,000

 

j. Estimated tax rate: 25%

Required:

1.  Prepare a sales budget for May.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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