Question
Sheridan Company is preparing its manufacturing overhead budget for 2022. Relevant data consist of the following. Units to be produced (by quarters): 11,400, 13,680, 15,960,
Sheridan Company is preparing its manufacturing overhead budget for 2022. Relevant data consist of the following.
Units to be produced (by quarters): 11,400, 13,680, 15,960, 18,240. |
Direct labor: Time is 0.75 hours per unit. |
Variable overhead costs per direct labor hour: indirect materials $0.40; indirect labor $0.60; and maintenance $0.50. |
Fixed overhead costs per quarter: supervisory salaries $47,025; depreciation $17,100; and maintenance $13,680. |
Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.)
SHERIDAN COMPANY Manufacturing Overhead Budget choose the accounting period For the Quarter Ending December 31, 2022For the Year Ending December 31, 2022December 31, 2022 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
Quarter | ||||||||||
1 | 2 | 3 | 4 | Year | ||||||
select an opening name for section one Total Materials RequiredVariable CostsDesired Ending MaterialsDirect Materials Per UnitTotal Pounds Needed for ProductionMaintenanceTotal Variable CostsDirect Materials PurchasesUnits to be ProducedTotal Manufacturing OverheadSupervisory SalariesBeginning Direct MaterialsTotal Fixed CostsIndirect LaborFixed CostsDepreciationIndirect Materials | ||||||||||
select an item Total Variable CostsBeginning Direct MaterialsVariable CostsFixed CostsTotal Fixed CostsDesired Ending MaterialsDirect Materials PurchasesUnits to be ProducedDepreciationTotal Materials RequiredTotal Pounds Needed for ProductionIndirect LaborTotal Manufacturing OverheadDirect Materials Per UnitMaintenanceIndirect MaterialsSupervisory Salaries | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||||
select an item Total Fixed CostsTotal Manufacturing OverheadIndirect LaborFixed CostsVariable CostsIndirect MaterialsMaintenanceDesired Ending MaterialsSupervisory SalariesDirect Materials Per UnitTotal Materials RequiredTotal Pounds Needed for ProductionDirect Materials PurchasesDepreciationTotal Variable CostsBeginning Direct MaterialsUnits to be Produced | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||||
select an item Supervisory SalariesDirect Materials Per UnitMaintenanceTotal Variable CostsBeginning Direct MaterialsTotal Fixed CostsIndirect LaborTotal Pounds Needed for ProductionTotal Manufacturing OverheadDepreciationDesired Ending MaterialsIndirect MaterialsUnits to be ProducedFixed CostsVariable CostsTotal Materials RequiredDirect Materials Purchases | 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 Beginning Direct MaterialsMaintenanceTotal Variable CostsDirect Materials Per UnitTotal Pounds Needed for ProductionTotal Manufacturing OverheadDepreciationFixed CostsIndirect LaborDesired Ending MaterialsTotal Materials RequiredIndirect MaterialsSupervisory SalariesDirect Materials PurchasesVariable CostsUnits to be ProducedTotal Fixed Costs | 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 | |||||
select an opening name for section two Indirect MaterialsDesired Ending MaterialsVariable CostsTotal Fixed CostsTotal Manufacturing OverheadBeginning Direct MaterialsIndirect LaborTotal Materials RequiredMaintenanceDepreciationTotal Variable CostsDirect Materials Per UnitSupervisory SalariesDirect Materials PurchasesFixed CostsUnits to be ProducedTotal Pounds Needed for Production | ||||||||||
select an item Desired Ending MaterialsBeginning Direct MaterialsDirect Materials PurchasesMaintenanceTotal Materials RequiredIndirect LaborTotal Manufacturing OverheadVariable CostsTotal Pounds Needed for ProductionDepreciationIndirect MaterialsTotal Variable CostsUnits to be ProducedSupervisory SalariesDirect Materials Per UnitTotal Fixed CostsFixed 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 Materials Per UnitVariable CostsDirect Materials PurchasesBeginning Direct MaterialsUnits to be ProducedIndirect MaterialsDepreciationTotal Fixed CostsIndirect LaborFixed CostsMaintenanceTotal Pounds Needed for ProductionDesired Ending MaterialsTotal Manufacturing OverheadSupervisory SalariesTotal Materials RequiredTotal Variable Costs | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | |||||
select an item DepreciationTotal Manufacturing OverheadFixed CostsDesired Ending MaterialsIndirect LaborTotal Fixed CostsDirect Materials Per UnitUnits to be ProducedIndirect MaterialsDirect Materials PurchasesSupervisory SalariesTotal Pounds Needed for ProductionTotal Variable CostsTotal Materials RequiredBeginning Direct MaterialsVariable CostsMaintenance | 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 Indirect LaborMaintenanceIndirect MaterialsDirect Materials PurchasesTotal Fixed CostsBeginning Direct MaterialsFixed CostsDepreciationVariable CostsUnits to be ProducedSupervisory SalariesTotal Manufacturing OverheadDirect Materials Per UnitTotal Materials RequiredTotal Pounds Needed for ProductionTotal Variable CostsDesired Ending Materials | 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 DepreciationTotal Pounds Needed for ProductionBeginning Direct MaterialsFixed CostsTotal Variable CostsUnits to be ProducedDirect Materials Per UnitIndirect LaborVariable CostsTotal Materials RequiredDirect Materials PurchasesTotal Manufacturing OverheadMaintenanceTotal Fixed CostsDesired Ending MaterialsSupervisory SalariesIndirect Materials | $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 | |||||
| ||||||||||
Direct labor hours | 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 | |||||
Manufacturing overhead rate per direct labor hour |
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