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,250 units at $185 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 | ||||
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 |
Prepare a direct labor cost budget for May.
Jupiter Helmets Inc.Direct Labor Cost BudgetFor the Month Ending May 31
Molding Department | Assembly Department | Total | |
Hours required for production: | |||
Bicycle helmet | fill in the blank bfe82a0c7fd3ffb_1 | fill in the blank bfe82a0c7fd3ffb_2 | |
Motorcycle helmet | fill in the blank bfe82a0c7fd3ffb_3 | fill in the blank bfe82a0c7fd3ffb_4 | |
Total | fill in the blank bfe82a0c7fd3ffb_5 | fill in the blank bfe82a0c7fd3ffb_6 | |
Hourly rate | $fill in the blank bfe82a0c7fd3ffb_7 | $fill in the blank bfe82a0c7fd3ffb_8 | |
Total direct labor cost | $fill in the blank bfe82a0c7fd3ffb_9 | $fill in the blank bfe82a0c7fd3ffb_10 | $fill in the blank bfe82a0c7fd3ffb_11 |
Prepare a
Jupiter Helmets Inc.Factory Overhead Cost BudgetFor the Month Ending May 31
Indirect factory wages | $fill in the blank 163fa8f9f032004_1 |
Depreciation of plant and equipment | fill in the blank 163fa8f9f032004_2 |
Power and light | fill in the blank 163fa8f9f032004_3 |
Insurance and property tax | fill in the blank 163fa8f9f032004_4 |
Total | $fill in the blank 163fa8f9f032004_5 |
Trending nowThis is a popular solution!
Step by stepSolved in 6 steps with 9 images
- Cost of Goods Sold Budget The controller of MingWare Ceramics Inc. wishes to prepare a cost of goods sold budget for September. The controller assembled the following information for constructing the cost of goods sold budget: Direct materials: Enamel Paint Porcelain Total Total direct materials purchases budgeted for September $32,540 $6,830 $126,910 $166,280 Estimated inventory, September 1 1,560 3,740 6,240 11,540 Desired inventory, September 30 2,690 2,450 6,460 11,600 Direct labor cost: Kiln Department Decorating Department Total Total direct labor cost budgeted for September $51,100 $148,190 $199,290 Finished goods inventories: Dish Bowl Figurine Total Estimated inventory, September 1 $6,110 $3,480 $2,870 $12,460 Desired inventory, September 30 3,910 4,830 4,580 13,320 Work in process inventories: Estimated inventory, September 1 $3,730 Desired inventory, September 30…arrow_forwardBudgeted income statement and supporting budgets for three months Newport Inc. gathered the following data for use in developing the budgets for the first quarter (June, July, a. Estimated sales at $36 per unit: June 300,000 units July 400,000 units August 500,000 units September 500,000 units b. Estimated finished goods inventories: May 31 16,000 units 5% of next month's sales June 30 July 31 5% of next month's sales 5% of next month's sales c. Work in process inventories are estimated to be insignificant (zero). August 31 d. Estimated direct materials inventories: May 31 35,000 pounds June 30 40,000 pounds July 31 45,000 pounds August 31 50,000 pounds e. Manufacturing costs: Per Unit Direct materials (1.5 Ibs. per unit x $4 per Ib.) $ 6.00 Direct labor (0.4 hr. per unit x $25 per hr.) 10.00 Variable factory overhead ($4 per direct labor hour) 1.60 Fixed factory overhead ($1,200,000 per month allocated using 500,000 units) 2.40 Total per-unit manufacturing costs $20.00 f. Selling…arrow_forwardBudgeted 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…arrow_forward
- Subject- accountingarrow_forwardFlexible Budgeting At the beginning of the period, the Assembly Department budgeted direct labor of $64,800 and property tax of $36,000 for 3,600 hours of production. The department actually completed 4,300 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting. 120,400 X Feedback Check My Wirk Remember that a flexible budget is constructed by first identifying the relevant activity levels, secondly identifying the fixed and variable cost components of the costs being budgeted, and then preparing the budget for each activity level.arrow_forwardBudgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., 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 March: a. Estimated sales for March Batting helmet 1,200 units at $40 per unit Football Helmet 6,500 units at $160 per unit b. Estimated inventories at March 1: Direct materials Finished products: Plastic 90 lb Batting helmet 40 units at $25 per unit Foam lining 80 lb Football helmet 240 units at $77 per unit c. Desired inventories at March 31: Directmaterials: Finishedproducts: Plastic 50lb. Batting helmet 50 units at $25 per unit Foam lining 65lb. Football Helmet 220 its at $78 per unitd. Direct materials used inproduction: In manufacture ofbatting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture offootball helmet…arrow_forward
- part 3 of previous Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., 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 March: Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit Estimated inventories at March 1: Direct materials: Plastic 90 lb. Foam lining 80 lb. Finished products: Batting helmet 40 units at $25 per unit Football helmet 240 units at $77 per unit Desired inventories at March 31: Direct materials: Plastic 50 lb. Foam lining 65 lb. Finished products: Batting helmet 50 units at $25 per unit Football helmet 220 units at $78 per unit Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit…arrow_forwardanswer must be in table and written format or down vote will be givenarrow_forwardSales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows: Estimated sales for July by sales territory: Maine: Backyard Chef 310 units at $700 per unit Master Chef 150 units at $1,200 per unit Vermont: Backyard Chef 240 units at $750 per unit Master Chef 110 units at $1,300 per unit New Hampshire: Backyard Chef 360 units at $750 per unit Master Chef 180 units at $1,400 per unit Estimated inventories at July 1: Direct materials: Grates 290 units Stainless steel 1,500 lbs. Burner subassemblies 170 units Shelves 340 units Finished products: Backyard Chef 30 units Master Chef 32 units Desired inventories at July 31: Direct materials: Grates 340 units Stainless steel…arrow_forward
- please answer parts 5 and 6 from this practice problemarrow_forwardBudgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $105,900 Accounts Receivable 204,400 Finished Goods 42,900 Work in Process 28,600 Materials 47,000 Prepaid Expenses 3,500 Plant and Equipment 526,300 Accumulated Depreciation—Plant and Equipment $226,300 Accounts Payable 149,100 Common Stock, $10 par 350,000 Retained Earnings 233,200 $958,600 $958,600 Factory output and sales for 20Y9 are expected to total 26,000 units of product, which are to be sold at $90 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…arrow_forwardBudget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow:arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education