90.2K

Verified Solution

Link Copied!

CoursHeroTranscribedText: Excel Master Budget Project SnowBird Snowboards, Inc., manufactures and sells snowboards. SnowBird manufactures a single model, the Pipex. In late 2020, SnowBird's management accountant gathered the following data to prepare budgets for January 2021: Materials and Labor Requirements Direct materials Wood 9 board feet (b.f.) per snowboard Fiberglass 10 yards per snowboard Direct manufacturing labor 5 hours per snowboard SnowBird's CEO expects to sell 2,900 snowboards during January 2021 at an estimated retail price of $650 per board. Further, the CEO expects a 2021 beginning inventory of 500 snowboards and would like to end January 2021 with 200 snowboards in stock. Direct Materials Inventories Beginning Inventory, Ending Inventory, January 1, 2021 January 31, 2021 Wood 2,040 b.f. 1,540 b.f. Fiberglass 1,040 yards 2,040 yards Variable manufacturing overhead is $7 per direct manufacturing labor-hour. There are also $81,000 in fixed manufacturing overhead costs budgeted for January 2021. SnowBird 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 $250 per sales visit. The marketing plan calls for 38 sales visits during January 2021.Finally, there are $35,000 in fixed operating (nonmanufacturing) costs budgeted for January 2021. Other data include the following: 2020 2021 Unit Price Unit Price Wood $32.00 per b.f. $34.00 per b.f. Fiberglass $ 8.00 per yard $ 9.00 per yard Direct manufacturing labor $28.00 per hour $29.00 per hour The inventoriable unit cost for ending finished-goods inventory on December 31, 2020, is $374.80. Assume SnowBird uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations. Required 1. Prepare the January 2021 revenues budget (in dollars). 2. Prepare the January 2021 production budget (in units). 3. Prepare the direct material usage and purchases budgets for January 2021. 4. Prepare a direct manufacturing labor costs budget for January 2021. 5. Prepare a manufacturing overhead costs budget for January 2021. 6. What is the budgeted manufacturing overhead rate for January 2021? 7. What is the budgeted manufacturing overhead cost per output unit in January 2021? 8. Calculate the cost of a snowboard manufactured in January 2021

Answer & Explanation Solved by verified expert

See Answer