Sunland Company is preparing its master budget for 2022. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.

Sales. Sales for the year are expected to total 940,000 units. Quarterly sales are 22%, 27%, 24%, and 27%, respectively. The unit selling price is expected to be $42 for the first three quarters and $46 beginning in the fourth quarter. Sales in the first quarter of 2023 are expected to be 15% higher than the budgeted sales for the first quarter of 2022.

Production. Management desires to maintain the ending finished goods inventories at 25% of the next quarters budgeted sales volume.

Direct materials. Each unit requires 2 pounds of raw materials at a cost of $10 per pound. Management desires to maintain raw materials inventories at 10% of the next quarters production requirements. Assume the production requirements for first quarter of 2023 are 423,000 pounds.

Prepare the sales, production, and direct materials budgets by quarters for 2022.

		Quarter
		1		2		3		4		Year
select an opening direct materials budget item Total Materials RequiredDirect Materials PurchasesDirect Materials Per UnitDirect Labor Cost Per HourTotal Pounds Required for ProductionUnits to be ProducedTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursCost Per PoundBeginning Direct Materials (Pounds)Direct Labor Time Per UnitDesired Ending Direct Materials (Pounds)Total Direct Labor Cost		enter a number of units		enter a number of units		enter a number of units		enter a number of units
select an item Beginning Direct Materials (Pounds)Direct Materials PurchasesDesired Ending Direct Materials (Pounds)Direct Labor Cost Per HourTotal Cost of Direct Materials PurchasesUnits to be ProducedTotal Direct Labor CostTotal Pounds Required for ProductionTotal Required Direct Labor HoursCost Per PoundTotal Materials RequiredDirect Materials Per UnitDirect Labor Time Per Unit		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 Total Direct Labor CostTotal Materials RequiredDirect Materials PurchasesDirect Labor Cost Per HourDesired Ending Direct Materials (Pounds)Units to be ProducedCost Per PoundTotal Pounds Required for ProductionBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesTotal Required Direct Labor HoursDirect Materials Per UnitDirect Labor Time Per Unit		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 Direct Materials Per UnitDirect Labor Time Per UnitCost Per PoundDirect Labor Cost Per HourBeginning Direct Materials (Pounds)Total Required Direct Labor HoursTotal Cost of Direct Materials PurchasesDirect Materials PurchasesDesired Ending Direct Materials (Pounds)Total Pounds Required for ProductionTotal Materials RequiredTotal Direct Labor CostUnits to be Produced		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 Direct Labor Cost Per HourTotal Pounds Required for ProductionTotal Required Direct Labor HoursDirect Labor Time Per UnitBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesDesired Ending Direct Materials (Pounds)Units to be ProducedTotal Materials RequiredDirect Materials PurchasesTotal Direct Labor CostCost Per PoundDirect Materials Per Unit		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 dedudction AddLess: select an item Direct Labor Cost Per HourTotal Pounds Required for ProductionDirect Materials PurchasesTotal Required Direct Labor HoursDirect Materials Per UnitBeginning Direct Materials (Pounds)Cost Per PoundTotal Materials RequiredDirect Labor Time Per UnitDesired Ending Direct Materials (Pounds)Total Cost of Direct Materials PurchasesUnits to be ProducedTotal Direct Labor Cost		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 Direct Materials (Pounds)Direct Labor Time Per UnitDirect Materials Per UnitTotal Pounds Required for ProductionTotal Cost of Direct Materials PurchasesCost Per PoundDesired Ending Direct Materials (Pounds)Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredUnits to be ProducedDirect Labor Cost Per HourTotal 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
select an item Total Materials RequiredUnits to be ProducedCost Per PoundDesired Ending Direct Materials (Pounds)Total Required Direct Labor HoursDirect Labor Time Per UnitDirect Labor Cost Per HourBeginning Direct Materials (Pounds)Total Pounds Required for ProductionTotal Direct Labor CostTotal Cost of Direct Materials PurchasesDirect Materials Per UnitDirect Materials Purchases		$enter a dollar amount		$enter a dollar amount		$enter a dollar amount		$enter a dollar amount
select a closing direct materials budget item Total Direct Labor CostDirect Labor Time Per UnitDirect Materials PurchasesDirect Labor Cost Per HourDesired Ending Direct Materials (Pounds)Direct Materials Per UnitBeginning Direct Materials (Pounds)Total Required Direct Labor HoursCost Per PoundTotal Cost of Direct Materials PurchasesTotal Materials RequiredTotal Pounds Required for ProductionUnits to be Produced		$enter a total dollar amount		$enter a total dollar amount		$enter a total dollar amount		$enter a total dollar amount		$enter a total dollar amount

eTextbook and Media

Save for Later

Last saved 1 second ago.

Saved work will be auto-submitted on the due date. Auto-submission can take up to 10 minutes.