Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with Requirement 10. Thanks Slides, Inc., manufactures and sells snowboards. Slides manufactures a single model, the Pipex. In late 2020, Slides's management

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I need help with Requirement 10. Thanks

Slides, Inc., manufactures and sells snowboards. Slides manufactures a single model, the Pipex. In late 2020, Slides's management accountant gathered the following data to prepare budgets for January 2021: (Click the icon to view the materials and labor requirements) (Click the icon to view the additional information.) (Click the icon to view the direct materials inventories) (Click the icon to view the additional information.) Other data include: (Click the icon to view the other data.) The inventoriable unit cost for ending finished goods inventory on December 31, 2020, is $225.00. Assume Slides uses a FIFO inventory method for both direct materials and finished goods, Ignore work in process in your calculations Read the requirements. Requirement 1. Prepare the January 2021 revenues budget (in dollars). Revenue Budget For January 2021 Units Selling price Total revenues 3,900 $ 1,350 $ 5,265,000 Snowboards Requirement 2. Prepare the January 2021 production budget (in units). Production Budget For January 2021 Budgeted units sales 3,900 900 Add target ending finished goods Inventory Total required units 4,800 600 Deduct beginning finished goods inventory 4,200 Units of finished goods to be produced Diamant ? Dans the Himat material on An hos hunt for lonan, 974 Requirement 3. Prepare the direct material usage and purchases budgets for January 2021. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Direct Material Usage Budget in Quantity and Dollars For January 2021 Material Wood Fiberglass Total Physical Units Budget Direct materials required for 67,200 Snowboards b.f. 58,800 yds Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) Wood $ 77,330 14,170 Fiberglass To be purchased this period To be purchased this period Wood 2,539,290 Fiberglass 807,940 $ 2,616,620 $ 822,110 3,438,730 Direct materials to be used this period Now prepare the direct material purchases budget for January 2021. Direct Materials Purchases Budget For January 2021 Materials Wood Fiberglass Total Physical Units Budget To be used in production 58,800 yards 67,200 b.f. 1,590 b.f. 2,090 yards Add target ending inventory Total requirement 68,790 b.f. 60,890 yards Deduct beginning inventory 2,090 b.f. 1,090 yards Deduct beginning inventory 2,090 b.f. 1,090 yards 59,800 yards 66,700 Purchases to be made b.f. Cost Budget $2,601,300 $ 837,200 $3,438,500 Purchases Requirement 4. Prepare a direct manufacturing labor budget for January 2021. (Abbreviation used: DMLH = Direct manufacturing labor hours.) Direct Manufacturing Labor Costs Budget For January 2021 Output Units DMLH Total Hourly Produced Hours Wage Rate 4,200 9 37,800 $ 34 per Unit Total Snowboards $ 1,285,200 Requirement 5. Prepare a manufacturing overhead budget for January 2021. Begin the manufacturing overhead cost budgets by first determining the formula, then calculate the variable manufacturing overhead costs. (Abbreviation used: Manuf. = Manufacturing.) Variable manufacturing overhead rate Total labor hours = Variable manufacturing overhead costs $ 718,200 19 37,800 = Now prepare the manufacturing overhead cost budgets. Manufacturing Overhead Budget For January 2021 Variable manufacturing overhead costs 718,200 75,600 Fixed manufacturing overhead costs $ 793,800 Total Requirement 6. What is the budgeted manufacturing overhead rate for January 2021? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead rate for January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead rate to the nearest cent.) Total manufacturing overhead . Total labor hours = Budgeted manufacturing overhead rate $ 793,800 37,800 = 21.00 Requirement 7. What is the budgeted manufacturing overhead cost per output unit in January 2021? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead cost per output unit in January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead cost per output unit to the nearest cent.) = Budgeted manufacturing overhead Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead cost per output unit in January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead cost per output unit to the nearest cent.) Budgeted manufacturing overhead cost per output unit Output units produced Total manufacturing overhead $ 793,800 + 4,200 = $ 189.00 Requirement 8. Calculate the cost of a snowboard manufactured in January 2021. (Round your answers to the nearest whole dollar.) Unit Costs of Manufacturing Finished Goods For January 2021 Input per Cost per unit unit of input of output Total Direct materials Wood 39 16 b.f. 624 Fiberglass 14 14 yds. 196 Direct manufacturing labor 34 9 hrs. 306 189 Direct manufacturing labor 34 9 hrs. 306 189 Budgeted manufacturing overhead cost 1,315 Total Requirement 9. Prepare an ending inventory budget for both direct materials and finished goods for January 2021. (Round your answers to the nearest whole dollar.) Ending Inventories Budget For January 2021 Quantity Cost per unit Total Direct materials Wood 1,590 39 62,010 29,260 Fiberglass 2,090 14 Finished goods Snowboard 900 $ 1,315 1,183,500 1,274,770 Total ending inventory Finished goods Snowboard 900 1,315 1,183,500 $ 1,274,770 Total ending inventory Requirement 10. Prepare a cost of goods sold budget for January 2021. Cost of Goods Sold Budget For January 2021 Beginning finished goods inventory, January 1 135,000 Direct materials used 3444000 1,285,200 793,800 Direct manufacturing labor Manufacturing overhead Cost of goods manufactured Cost of goods available for sale 5523000 5658000 Deduct ending finished goods inventory, January 31 1,183,500 4474500 Cost of goods sold - X Data table Data table Slides, Inc., managemer (Click t (Click (Click 1: ssume cess in your 2021 Unit Price Wood $ (Click til Direct Materials Inventories Beginning Inventory Ending Inventory January January 1, 2021 31, 2021 2.090 b.t. 1,590 bt 1.090 yards 2,090 yards 2020 Unit Price 37.00 per b.f. 13.00 per yard 33.00 per hour $ S $ $ 39.00 per b.f. 14.00 per yard 34.00 per hour Fiberglass Direct manufacturing labor Wood $ $ Fiberglass Finished go X Snowbd Data table Total ending Print Done Requireme Materials and Labor Requirements Direct materials -X X More info Wood Fiberglass Direct manufacturing labor 16 board feet (b.f.) per snowboard 14 yards per snowboard 9 hours per snowboard Variable manufacturing overtread is $19 per direct manufacturing labor-hour. There are also $75,500 in fixed manufacturing overhead costs budgeted for January 2021. Slides combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $340 per sales visit. The marketing plan calls for 43 sales visite during January 2021. Finally, there are $40,000 in fixed operating (nonmanufacturing) costs budgeted for January 2021, More info Slides's CEO expects to sell 3,900 snowboards during January 2021 at an estimated retail price of $1,350 per board. Further, the CEO expects 2021 beginning inventory of 600 snowboards and would like to end January 2021 with 900 snowboards in stock. Print Done Print Done TICIPTIC SUIVO LICAL Pages OCENTOT Tierp Slides, Inc., manufactures and sells snowboards. Slides manufactures a single model, the Pipex. In late 2020, Slides's management accountant gathered the following data to prepare budgets for January 2021: (Click the icon to view the materials and labor requirements) (Click the icon to view the additional information.) (Click the icon to view the direct materials inventories) (Click the icon to view the additional information.) Other data include: (Click the icon to view the other data.) The inventoriable unit cost for ending finished goods inventory on December 31, 2020, is $225.00. Assume Slides uses a FIFO inventory method for both direct materials and finished goods, Ignore work in process in your calculations Read the requirements. Requirement 1. Prepare the January 2021 revenues budget (in dollars). Revenue Budget For January 2021 Units Selling price Total revenues 3,900 $ 1,350 $ 5,265,000 Snowboards Requirement 2. Prepare the January 2021 production budget (in units). Production Budget For January 2021 Budgeted units sales 3,900 900 Add target ending finished goods Inventory Total required units 4,800 600 Deduct beginning finished goods inventory 4,200 Units of finished goods to be produced Diamant ? Dans the Himat material on An hos hunt for lonan, 974 Requirement 3. Prepare the direct material usage and purchases budgets for January 2021. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Direct Material Usage Budget in Quantity and Dollars For January 2021 Material Wood Fiberglass Total Physical Units Budget Direct materials required for 67,200 Snowboards b.f. 58,800 yds Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) Wood $ 77,330 14,170 Fiberglass To be purchased this period To be purchased this period Wood 2,539,290 Fiberglass 807,940 $ 2,616,620 $ 822,110 3,438,730 Direct materials to be used this period Now prepare the direct material purchases budget for January 2021. Direct Materials Purchases Budget For January 2021 Materials Wood Fiberglass Total Physical Units Budget To be used in production 58,800 yards 67,200 b.f. 1,590 b.f. 2,090 yards Add target ending inventory Total requirement 68,790 b.f. 60,890 yards Deduct beginning inventory 2,090 b.f. 1,090 yards Deduct beginning inventory 2,090 b.f. 1,090 yards 59,800 yards 66,700 Purchases to be made b.f. Cost Budget $2,601,300 $ 837,200 $3,438,500 Purchases Requirement 4. Prepare a direct manufacturing labor budget for January 2021. (Abbreviation used: DMLH = Direct manufacturing labor hours.) Direct Manufacturing Labor Costs Budget For January 2021 Output Units DMLH Total Hourly Produced Hours Wage Rate 4,200 9 37,800 $ 34 per Unit Total Snowboards $ 1,285,200 Requirement 5. Prepare a manufacturing overhead budget for January 2021. Begin the manufacturing overhead cost budgets by first determining the formula, then calculate the variable manufacturing overhead costs. (Abbreviation used: Manuf. = Manufacturing.) Variable manufacturing overhead rate Total labor hours = Variable manufacturing overhead costs $ 718,200 19 37,800 = Now prepare the manufacturing overhead cost budgets. Manufacturing Overhead Budget For January 2021 Variable manufacturing overhead costs 718,200 75,600 Fixed manufacturing overhead costs $ 793,800 Total Requirement 6. What is the budgeted manufacturing overhead rate for January 2021? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead rate for January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead rate to the nearest cent.) Total manufacturing overhead . Total labor hours = Budgeted manufacturing overhead rate $ 793,800 37,800 = 21.00 Requirement 7. What is the budgeted manufacturing overhead cost per output unit in January 2021? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead cost per output unit in January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead cost per output unit to the nearest cent.) = Budgeted manufacturing overhead Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead cost per output unit in January 2021. (Abbreviation used: Manuf. = Manufacturing. Round the overhead cost per output unit to the nearest cent.) Budgeted manufacturing overhead cost per output unit Output units produced Total manufacturing overhead $ 793,800 + 4,200 = $ 189.00 Requirement 8. Calculate the cost of a snowboard manufactured in January 2021. (Round your answers to the nearest whole dollar.) Unit Costs of Manufacturing Finished Goods For January 2021 Input per Cost per unit unit of input of output Total Direct materials Wood 39 16 b.f. 624 Fiberglass 14 14 yds. 196 Direct manufacturing labor 34 9 hrs. 306 189 Direct manufacturing labor 34 9 hrs. 306 189 Budgeted manufacturing overhead cost 1,315 Total Requirement 9. Prepare an ending inventory budget for both direct materials and finished goods for January 2021. (Round your answers to the nearest whole dollar.) Ending Inventories Budget For January 2021 Quantity Cost per unit Total Direct materials Wood 1,590 39 62,010 29,260 Fiberglass 2,090 14 Finished goods Snowboard 900 $ 1,315 1,183,500 1,274,770 Total ending inventory Finished goods Snowboard 900 1,315 1,183,500 $ 1,274,770 Total ending inventory Requirement 10. Prepare a cost of goods sold budget for January 2021. Cost of Goods Sold Budget For January 2021 Beginning finished goods inventory, January 1 135,000 Direct materials used 3444000 1,285,200 793,800 Direct manufacturing labor Manufacturing overhead Cost of goods manufactured Cost of goods available for sale 5523000 5658000 Deduct ending finished goods inventory, January 31 1,183,500 4474500 Cost of goods sold - X Data table Data table Slides, Inc., managemer (Click t (Click (Click 1: ssume cess in your 2021 Unit Price Wood $ (Click til Direct Materials Inventories Beginning Inventory Ending Inventory January January 1, 2021 31, 2021 2.090 b.t. 1,590 bt 1.090 yards 2,090 yards 2020 Unit Price 37.00 per b.f. 13.00 per yard 33.00 per hour $ S $ $ 39.00 per b.f. 14.00 per yard 34.00 per hour Fiberglass Direct manufacturing labor Wood $ $ Fiberglass Finished go X Snowbd Data table Total ending Print Done Requireme Materials and Labor Requirements Direct materials -X X More info Wood Fiberglass Direct manufacturing labor 16 board feet (b.f.) per snowboard 14 yards per snowboard 9 hours per snowboard Variable manufacturing overtread is $19 per direct manufacturing labor-hour. There are also $75,500 in fixed manufacturing overhead costs budgeted for January 2021. Slides combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $340 per sales visit. The marketing plan calls for 43 sales visite during January 2021. Finally, there are $40,000 in fixed operating (nonmanufacturing) costs budgeted for January 2021, More info Slides's CEO expects to sell 3,900 snowboards during January 2021 at an estimated retail price of $1,350 per board. Further, the CEO expects 2021 beginning inventory of 600 snowboards and would like to end January 2021 with 900 snowboards in stock. Print Done Print Done TICIPTIC SUIVO LICAL Pages OCENTOT Tierp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting an introduction to concepts, methods and uses

Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis

13th Edition

978-0538776080, 324651147, 538776080, 9780324651140, 978-0324789003

More Books

Students also viewed these Accounting questions