Question
Diane Buswell is preparing the 2022 budget for one of Current Designs ' rotomolded kayaks. Extensive meetings with members of the sales department and executive
Diane Buswell is preparing the 2022 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2022.
Quarter 1 | 1,300 | kayaks | |
Quarter 2 | 1,600 | kayaks | |
Quarter 3 | 1,150 | kayaks | |
Quarter 4 | 1,150 | kayaks |
Current Designs' policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's anticipated sales. Preliminary sales projections for 2023 are 1,100 units for the first quarter and 1,600 units for the second quarter. Ending inventory of finished goods at December 31, 2021, will be 390 rotomolded kayaks. Production of each kayak requires 42 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2021, is 21,800 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayaks costs $1.20 per pound, and the finishing kits cost $160 each. Production of a single kayak requires 3 hours of time by more experienced, type I employees and 4 hours of finishing time by type II employees. The type I employees are paid $12 per hour, and the type II employees are paid $9 per hour. Selling and administrative expenses for this line are expected to be $47 per unit sold plus $7,900 per quarter. Manufacturing overhead is assigned at 160% of labor costs.
(a)
Prepare the production budget for this product line by quarter and in total for 2022.
CURRENT DESIGNS Production Budget choose the accounting period December 31, 2022For the Month Ending December 31, 2022For the Year Ending December 31, 2022 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Q1 | Q2 | Q3 | Q4 | Total | |||||||
select an opening production budget item Total Materials RequiredDesired Ending Direct MaterialsExpected Unit SalesRequired Production UnitsDesired Ending Finished Goods UnitTotal Required UnitsDirect Materials Per UnitBeginning Direct MaterialsBeginning Finished Goods UnitDirect Materials Purchases | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | ||||||
select between addition and deduction AddLess: select a production budget item Total Materials RequiredExpected Unit SalesBeginning Finished Goods UnitBeginning Direct MaterialsDesired Ending Finished Goods UnitDirect Materials Per UnitRequired Production UnitsDesired Ending Direct MaterialsTotal Required UnitsDirect Materials Purchases | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | ||||||
select a summarizing line for the first part Beginning Direct MaterialsExpected Unit SalesTotal Materials RequiredRequired Production UnitsBeginning Finished Goods UnitDesired Ending Direct MaterialsTotal Required UnitsDirect Materials PurchasesDirect Materials Per UnitDesired Ending Finished Goods Unit | enter a total number of units for the first part | enter a total number of units for the first part | enter a total number of units for the first part | enter a total number of units for the first part | enter a total number of units for the first part | ||||||
select between addition and deduction AddLess: select a production budget item Beginning Finished Goods UnitDesired Ending Direct MaterialsTotal Materials RequiredDesired Ending Finished Goods UnitDirect Materials PurchasesExpected Unit SalesRequired Production UnitsDirect Materials Per UnitBeginning Direct MaterialsTotal Required Units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | ||||||
select a closing production budget item Desired Ending Finished Goods UnitTotal Required UnitsBeginning Direct MaterialsBeginning Finished Goods UnitExpected Unit SalesDirect Materials PurchasesRequired Production UnitsDirect Materials Per UnitTotal Materials RequiredDesired Ending Direct Materials | enter a total number of units | enter a total number of units | enter a total number of units | enter a total number of units | enter a total number of units |
eTextbook and Media
Assistance Used
Save for Later
Last saved 1 minute ago.
Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes.
Attempts: 0 of 3 used
Submit Answer
Using multiple attempts will impact your score.
10% score reduction after attempt 2
(b)
Prepare the direct materials budget for this product line by quarter and in total for 2022. (Round cost per pound to 2 decimal places, e.g. 1.25 and other answers to 0 decimal places, e.g. 125.)
CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder choose the accounting period December 31, 2022For the Month Ending December 31, 2022For the Year Ending December 31, 2022 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
Quarter | ||||||||||
Q1 | Q2 | Q3 | Q4 | Total | ||||||
select an opening name for this budget Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
select an item Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | |||||
select a summarizing line for the first part Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a total number of pounds for the first part | enter a total number of pounds for the first part | enter a total number of pounds for the first part | enter a total number of pounds for the first part | enter a total number of pounds for the first part | |||||
select between addition and deduction AddLess: select an item Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | |||||
select a summarizing line for the second part Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a total number of pounds for the second part | enter a total number of pounds for the second part | enter a total number of pounds for the second part | enter a total number of pounds for the second part | enter a total number of pounds for the second part | |||||
select between addition and deduction AddLess: select an item Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | enter a number of pounds | |||||
select a summarizing line for the third part Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a total number of pounds for the third part | enter a total number of pounds for the third part | enter a total number of pounds for the third part | enter a total number of pounds for the third part | enter a total number of pounds for the third part | |||||
select an item Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $enter a dollar amount rounded to 2 decimal places | $enter a dollar amount rounded to 2 decimal places | $enter a dollar amount rounded to 2 decimal places | $enter a dollar amount rounded to 2 decimal places | $enter a dollar amount rounded to 2 decimal places | |||||
select a summarizing line for the fourth part Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $enter a total amount for the fourth part | $enter a total amount for the fourth part | $enter a total amount for the fourth part | $enter a total amount for the fourth part | $enter a total amount for the fourth part | |||||
select an item Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||||
select a closing name for this budget Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget |
eTextbook and Media
Assistance Used
Save for Later
Last saved 1 minute ago.
Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes.
Attempts: 0 of 3 used
Submit Answer
Using multiple attempts will impact your score.
10% score reduction after attempt 2
(c)
Prepare the direct labor budget for this product line by quarter and in total for 2022.
CURRENT DESIGNS Direct labor Budget choose the accounting period December 31, 2022For the Month Ending December 31, 2022For the Year Ending December 31, 2022 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
More skilled labor | Q1 | Q2 | Q3 | Q4 | TOTAL | |||||
select an opening name for section one Total Direct Labor Cost for Less Skilled LaborTotal Pounds Required for ProductionDirect Materials Per UnitTotal Direct Labor CostCost Per PoundUnits to be ProducedTotal Cost of Direct Materials PurchasesDirect Labor Time (Hours) Per UnitBeginning Materials InventoryDesired Ending InventoryTotal Required Direct Labor HoursDirect Labor Cost Per HourTotal Direct Labor Cost for More Skilled LaborDirect Materials PurchasesTotal Materials Required | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
select a labor budget item Desired Ending InventoryTotal Cost of Direct Materials PurchasesDirect Materials PurchasesBeginning Materials InventoryTotal Direct Labor CostTotal Pounds Required for ProductionTotal Required Direct Labor HoursDirect Materials Per UnitTotal Materials RequiredTotal Direct Labor Cost for More Skilled LaborDirect Labor Cost Per HourTotal Direct Labor Cost for Less Skilled LaborDirect Labor Time (Hours) Per UnitUnits to be ProducedCost Per Pound | enter a number of hours | enter a number of hours | enter a number of hours | enter a number of hours | enter a number of hours | |||||
select a labor budget item Total Cost of Direct Materials PurchasesTotal Direct Labor Cost for More Skilled LaborBeginning Materials InventoryTotal Materials RequiredUnits to be ProducedDirect Labor Time (Hours) Per UnitTotal Direct Labor Cost for Less Skilled LaborCost Per PoundDirect Materials PurchasesTotal Required Direct Labor HoursTotal Direct Labor CostTotal Pounds Required for ProductionDesired Ending InventoryDirect Materials Per UnitDirect Labor Cost Per Hour | enter a total number of hours | enter a total number of hours | enter a total number of hours | enter a total number of hours | enter a total number of hours | |||||
select a labor budget item Cost Per PoundUnits to be ProducedTotal Required Direct Labor HoursDesired Ending InventoryBeginning Materials InventoryTotal Direct Labor Cost for More Skilled LaborTotal Pounds Required for ProductionDirect Materials PurchasesTotal Direct Labor CostDirect Labor Time (Hours) Per UnitTotal Materials RequiredDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesTotal Direct Labor Cost for Less Skilled LaborDirect Materials Per Unit | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||||
select a closing name for section one Direct Materials PurchasesDirect Labor Time (Hours) Per UnitTotal Direct Labor Cost for Less Skilled LaborBeginning Materials InventoryTotal Required Direct Labor HoursDirect Labor Cost Per HourTotal Direct Labor Cost for More Skilled LaborTotal Pounds Required for ProductionCost Per PoundTotal Cost of Direct Materials PurchasesTotal Materials RequiredDesired Ending InventoryDirect Materials Per UnitUnits to be ProducedTotal Direct Labor Cost | $enter a total amount for section one | $enter a total amount for section one | $enter a total amount for section one | $enter a total amount for section one | $enter a total amount for section one | |||||
Less skilled labor | ||||||||||
select an opening name for section two Direct Labor Time (Hours) Per UnitUnits to be ProducedDirect Materials Per UnitDesired Ending InventoryTotal Pounds Required for ProductionTotal Required Direct Labor HoursTotal Materials RequiredCost Per PoundTotal Direct Labor CostTotal Direct Labor Cost for Less Skilled LaborDirect Materials PurchasesTotal Cost of Direct Materials PurchasesBeginning Materials InventoryDirect Labor Cost Per HourTotal Direct Labor Cost for More Skilled Labor | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
select a labor budget item Beginning Materials InventoryUnits to be ProducedDirect Materials Per UnitTotal Required Direct Labor HoursDirect Materials PurchasesTotal Direct Labor Cost for More Skilled LaborTotal Cost of Direct Materials PurchasesCost Per PoundTotal Direct Labor CostDirect Labor Cost Per HourTotal Direct Labor Cost for Less Skilled LaborTotal Pounds Required for ProductionDesired Ending InventoryTotal Materials RequiredDirect Labor Time (Hours) Per Unit | enter a number of hours | enter a number of hours | enter a number of hours | enter a number of hours | enter a number of hours | |||||
select a labor budget item Desired Ending InventoryUnits to be ProducedTotal Pounds Required for ProductionTotal Materials RequiredTotal Direct Labor CostBeginning Materials InventoryTotal Direct Labor Cost for More Skilled LaborDirect Materials PurchasesTotal Required Direct Labor HoursDirect Materials Per UnitTotal Direct Labor Cost for Less Skilled LaborDirect Labor Cost Per HourCost Per PoundTotal Cost of Direct Materials PurchasesDirect Labor Time (Hours) Per Unit | enter a total number of hours | enter a total number of hours | enter a total number of hours | enter a total number of hours | enter a total number of hours | |||||
select a labor budget item Direct Materials Per UnitTotal Direct Labor CostTotal Pounds Required for ProductionTotal Direct Labor Cost for More Skilled LaborCost Per PoundUnits to be ProducedTotal Required Direct Labor HoursDirect Materials PurchasesTotal Direct Labor Cost for Less Skilled LaborDesired Ending InventoryBeginning Materials InventoryDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesDirect Labor Time (Hours) Per UnitTotal Materials Required | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||||
select a closing name for section two Direct Materials Per UnitTotal Materials RequiredTotal Direct Labor Cost for More Skilled LaborTotal Pounds Required for ProductionDirect Labor Time (Hours) Per UnitTotal Cost of Direct Materials PurchasesDesired Ending InventoryUnits to be ProducedDirect Materials PurchasesTotal Required Direct Labor HoursCost Per PoundBeginning Materials InventoryTotal Direct Labor Cost for Less Skilled LaborDirect Labor Cost Per HourTotal Direct Labor Cost | $enter a total amount for section two | $enter a total amount for section two | $enter a total amount for section two | $enter a total amount for section two | $enter a total amount for section two | |||||
select a closing name for this budget Total Direct Labor Cost for Less Skilled LaborBeginning Materials InventoryTotal Direct Labor Cost for More Skilled LaborUnits to be ProducedCost Per PoundTotal Required Direct Labor HoursTotal Materials RequiredTotal Pounds Required for ProductionTotal Cost of Direct Materials PurchasesDirect Labor Cost Per HourTotal Direct Labor CostDirect Materials Per UnitDesired Ending InventoryDirect Materials PurchasesDirect Labor Time (Hours) Per Unit | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget |
eTextbook and Media
Assistance Used
Save for Later
Last saved 1 minute ago.
Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes.
Attempts: 0 of 3 used
Submit Answer
Using multiple attempts will impact your score.
10% score reduction after attempt 2
(d)
Prepare the manufacturing overhead budget for this product line by quarter and in total for 2022.
CURRENT DESIGNS Manufacturing Overhead Budget choose the accounting period December 31, 2022For the Month Ending December 31, 2022For the Year Ending December 31, 2022 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Q1 | Q2 | Q3 | Q4 | TOTAL | |||||||||||
select an item Direct LaborDirect MaterialsFixed CostsManufacturing Overhead Rate Per Direct Labor DollarProduction UnitsSalesTotal Manufacturing OverheadVariable Costs | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | ||||||||||
select an item Direct LaborDirect MaterialsFixed CostsManufacturing Overhead Rate Per Direct Labor DollarProduction UnitsSalesTotal Manufacturing OverheadVariable Costs | enter percentages | % | enter percentages | % | enter percentages | % | enter percentages | % | enter percentages | % | |||||
select a closing name for this budget Direct LaborDirect MaterialsFixed CostsManufacturing Overhead Rate Per Direct Labor DollarProduction UnitsSalesTotal Manufacturing OverheadVariable Costs | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget | $enter a total amount for this budget |
eTextbook and Media
Assistance Used
Save for Later
Attempts: 0 of 3 used
Submit Answer
Using multiple attempts will impact your score.
10% score reduction after attempt 2
(e)
Prepare the selling and administrative expenses budget for this product line by quarter and in total for 2022.
CURRENT DESIGNS Selling and Administrative Expense Budget choose the accounting period December 31, 2022For the Month Ending December 31, 2022For the Year Ending December 31, 2022 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Q1 | Q2 | Q3 | Q4 | TOTAL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
select an opening name for this budget Direct LaborDirect MaterialsExpected Unit SalesFixed ExpensesProduction UnitsTotal Selling and Administrative ExpensesVariable Expenses | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
select an item Direct LaborDirect MaterialsExpected Unit SalesFixed ExpensesProduction UnitsTotal Selling and Administrative ExpensesVariable Expenses | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
select an item Direct LaborDirect MaterialsExpected Unit SalesFixed ExpensesProduction UnitsTotal Selling and Administrative ExpensesVariable Expenses | enter a dollar amount | Diane Buswell is preparing the 2022 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2022.
Current Designs' policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's anticipated sales. Preliminary sales projections for 2023 are 1,100 units for the first quarter and 1,600 units for the second quarter. Ending inventory of finished goods at December 31, 2021, will be 390 rotomolded kayaks. Production of each kayak requires 42 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2021, is 21,800 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayaks costs $1.20 per pound, and the finishing kits cost $160 each. Production of a single kayak requires 3 hours of time by more experienced, type I employees and 4 hours of finishing time by type II employees. The type I employees are paid $12 per hour, and the type II employees are paid $9 per hour. Selling and administrative expenses for this line are expected to be $47 per unit sold plus $7,900 per quarter. Manufacturing overhead is assigned at 160% of labor costs. (a) Prepare the production budget for this product line by quarter and in total for 2022.
eTextbook and Media Assistance Used Save for Later Last saved 1 minute ago. Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes. Attempts: 0 of 3 used Submit Answer Using multiple attempts will impact your score. 10% score reduction after attempt 2 (b) Prepare the direct materials budget for this product line by quarter and in total for 2022. (Round cost per pound to 2 decimal places, e.g. 1.25 and other answers to 0 decimal places, e.g. 125.)
eTextbook and Media Assistance Used Save for Later Last saved 1 minute ago. Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes. Attempts: 0 of 3 used Submit Answer Using multiple attempts will impact your score. 10% score reduction after attempt 2 (c) Prepare the direct labor budget for this product line by quarter and in total for 2022.
eTextbook and Media Assistance Used Save for Later Last saved 1 minute ago. Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes. Attempts: 0 of 3 used Submit Answer Using multiple attempts will impact your score. 10% score reduction after attempt 2 (d) Prepare the manufacturing overhead budget for this product line by quarter and in total for 2022.
eTextbook and Media Assistance Used Save for Later Attempts: 0 of 3 used Submit Answer Using multiple attempts will impact your score. 10% score reduction after attempt 2 (e) Prepare the selling and administrative expenses budget for this product line by quarter and in total for 2022.
eTextbook and Media | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
select a closing name for this budget Direct LaborDirect MaterialsExpected Unit SalesFixed ExpensesProduction UnitsTotal Selling and Administrative ExpensesVariable Expenses | $enter a total amount | $enter a total amount | $enter a total amount | $enter a total amount | $enter a total amount |
eTextbook and Media
ch.9 q14
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