Question
Skulas, Inc., manufactures and sells Skulas manufactures a single model, the Pipex. In late 2017, Skulas's management accountant gathered the following data to prepare budgets
Skulas, Inc., manufactures and sells Skulas manufactures a single model, the Pipex. In late 2017, Skulas's management accountant gathered the following data to prepare budgets for January 2018:
Data Table
Materials and Labor Requirements | ||
Direct materials | ||
Wood | 9 | board feet (b.f.) per snowboard |
Fiberglass | 7 | yards per snowboard |
Direct manufacturing labor | 8 | hours per snowboard |
Skulas's CEO expects to sell 1 comma 300 snowboards during January 2018 at an estimated retail price of $ 650 per board.Further, the CEO expects 2018 beginning inventory of 600 snowboards and would like to end January 2018 with 600 snowboards in stock.
Direct Materials Inventories | ||||
Beginning Inventory 1/1/2018 | Ending Inventory 1/31/2018 | |||
Wood | 2,020 | b.f. | 1,520 | b.f. |
Fiberglass | 1,020 | yards | 2,020 | yards |
Variable manufacturing overhead is $ 8 per direct manufacturinglabor-hour. There are also $ 20 comma 800 in fixed manufacturing overhead costs budgeted for January 2018. Skulas 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 $ 270 per sales visit. The marketing plan calls for 36 sales visits during January 2018. Finally, there are $ 33 comma 000 in fixed nonmanufacturing costs budgeted for January 2018.
Other data include:
Data Table
2017 Unit Price | 2018 Unit Price | |||
Wood | $30.00 | per b.f. | $32.00 | per b.f. |
Fiberglass | $6.00 | per yard | $7.00 | per yard |
Direct manufacturing labor | $26.00 | per hour | $27.00 | per hour |
The inventoriable unit cost for ending finished goods inventory on December 31, 2017, is $250.00. Assume Skulas uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations.
1.Prepare the January 2018 revenues budget (in dollars). 2.Prepare the January 2018 production budget (in units). 3.Prepare the direct material usage and purchases budgets for January 2018. 4.Prepare a direct manufacturing labor costs budget for January 2018. 5.Prepare a manufacturing overhead costs budget for January 2018. 6.What is the budgeted manufacturing overhead rate for January 2018? 7.What is the budgeted manufacturing overhead cost per output unit in January 2018? 8.Calculate the cost of a snowboard manufactured in January 2018. 9.Prepare an ending inventory budget for both direct materials and finished goods for January 2018. 10.Prepare a cost of goods sold budget for January 2018. 11.Prepare the budgeted income statement for Skulas, Inc., for January 2018. 12.What questions might the CEO ask the management team when reviewing the budget? Should the CEO set stretch targets? Explain briefly. 13.How does preparing the budget help Skulas's management team better manage the company?
plz do all the requirement, and use computer writing not hand writing, thanks so much
Requirement 1. Prepare the January 2018 revenues budget (in dollars). Revenue Budget For January 2018 Units Selling price Total revenues Snowboards Requirement 2. Prepare the January 2018 production budget (in units). Production Budget For January 2018 Budgeted units sales 1,300 600 Add target ending finished goods inventory Total required units 109 600 Deduct beginning finished goods inventory Units of finished goods to be produced Requirement 3. Prepare the direct material usage and purchases budgets for January 2018. 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 2018 Material Wood Fiberglass Total Physical Units Budget Direct materials required for Snowboards b.f. yds Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) Wood Fiberglass To be purchased this period Wood Fiberglass To be purchased this period Wood Fiberglass Direct materials to be used this period Now prepare the direct material purchases budget for January 2018. Direct Materials Purchases Budget For January 2018 Materials Wood Fiberglass Total Physical Units Budget To be used in production b.f. 1,520 b.f. yards 2,020 yards Add target ending inventory Total requirement b.f. yards Deduct beginning inventory 2,020 b.f. 1,020 yards Purchases to be made b.f. yards Cost Budget Purchases Requirement 4. Prepare a direct manufacturing labor budget for January 2018. (Abbreviation used: DMLH = Direct manufacturing labor hours.) Direct Manufacturing Labor Costs Budget For January 2018 Output Units DMLH Total Hourly Produced per Unit Hours Wage Rate Total Snowboards 8 Requirement 5. Prepare a manufacturing overhead budget for January 2018. 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 costs Now prepare the manufacturing overhead cost budgets. Manufacturing Overhead Budget For January 2018 Variable manufacturing overhead costs Fixed manufacturing overhead costs Total Requirement 6. What is the budgeted manufacturing overhead rate for January 2018? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead rate for January 2018. (Abbreviation used: Manuf. = Manufacturing. Round the overhead rate to the nearest cent.) = Budgeted manufacturing overhead rate = Requirement 7. What is the budgeted manufacturing overhead cost per output unit in January 2018? Begin by determining the formula, then enter the appropriate amounts to calculate the budgeted manufacturing overhead cost per output unit in January 2018. (Abbreviation used: Manuf. = Manufacturing. Round the overhead cost per out to the nearest whole dollar.) Budgeted manufacturing overhead cost per output unit II Requirement 8. Calculate the cost of a snowboard manufactured in January 2018. Unit Costs of Manufacturing Finished Goods For January 2018 Cost per Input per unit unit of input of output Total Direct materials Wood 9 b.f. 7 yds. Fiberglass Direct manufacturing labor 8 hrs. Budgeted manufacturing overhead cost Total Requirement 9. Prepare an ending inventory budget for both direct materials and finished goods for January 2018. Ending Inventories Budget For January 2018 Quantity Cost per unit Total Direct materials Wood 1,520 Fiberglass 2,020 Finished goods Snowboard 600 Total ending inventory Requirement 10. Prepare a cost of goods sold budget for January 2018. Cost of Goods Sold Budget For January 2018 Beginning finished goods inventory, January 1 Direct materials used Direct manufacturing labor Manufacturing overhead Cost of goods manufactured Cost of goods available for sale Deduct ending finished goods inventory, January 31 Cost of goods sold Requirement 11. Prepare the budgeted income statement for Skulas, Inc., for January 2018. Budgeted Income Statement For January 2018 Revenues Cost of goods sold Gross margin Operating (nonmanufacturing) costs Operating income Requirement 12. What questions might the CEO ask the management team when reviewing the budget? Should the CEO set stretch targets? Explain briefly. First, select the questions that the CEO might ask the marketing manager. (Select all that apply.) Now, select the questions that the CEO might ask the production manager. (Select all that apply.) Should the CEO set stretch targets? Explain briefly. The CEO because: (Select all that apply.) Requirement 13. How does preparing the budget help Skulas' management team better manage the company? Preparing a budget helps Skulas, Inc.: (Select all that apply.)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started