Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 2,000,000 units. Quarterly sales are 21%, 27%, 23%, and 29%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 15% higher than the budgeted sales for the first quarter of 2020. Production. Management desires to maintain the ending finished goods inventories at 20% of the next quarters budgeted sales volume. Direct materials. Each unit requires 2 pounds of raw materials at a cost of $11 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 2021 are 510,000 pounds. Prepare the sales, production, and direct materials budgets by quarters for 2020.

PARGO COMPANY Direct Materials Budget choose the accounting period December 31, 2020For the Year Ending December 31, 2020For the Quarter Ending December 31, 2020

Quarter
1 2 3 4 Year

select an opening direct materials budget item Total Pounds Required for ProductionTotal Materials RequiredDirect Materials Per UnitTotal Required Direct Labor HoursUnits to be ProducedDirect Labor Time Per UnitCost Per PoundBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesTotal Direct Labor CostDirect Labor Cost Per HourDirect Materials PurchasesDesired Ending Direct Materials (Pounds)

enter a number of units

enter a number of units

enter a number of units

enter a number of units

select an item Direct Materials PurchasesTotal Pounds Required for ProductionTotal Direct Labor CostTotal Materials RequiredTotal Cost of Direct Materials PurchasesDirect Labor Cost Per HourDesired Ending Direct Materials (Pounds)Beginning Direct Materials (Pounds)Units to be ProducedDirect Labor Time Per UnitTotal Required Direct Labor HoursCost Per PoundDirect Materials Per Unit

enter the amount of pounds enter the amount of pounds enter the amount of pounds enter the amount of pounds

select a summarizing line for the first part Direct Labor Time Per UnitTotal Required Direct Labor HoursDirect Materials Per UnitTotal Direct Labor CostCost Per PoundBeginning Direct Materials (Pounds)Units to be ProducedDesired Ending Direct Materials (Pounds)Direct Labor Cost Per HourTotal Cost of Direct Materials PurchasesTotal Materials RequiredTotal Pounds Required for ProductionDirect Materials Purchases

enter a total amount of pounds for the first part

enter a total amount of pounds for the first part

enter a total amount of pounds for the first part

enter ae total amount of pounds for the first part

select between addition and deduction AddLess: select an item Total Required Direct Labor HoursTotal Direct Labor CostTotal Pounds Required for ProductionDesired Ending Direct Materials (Pounds)Direct Labor Cost Per HourTotal Materials RequiredDirect Materials Per UnitTotal Cost of Direct Materials PurchasesDirect Labor Time Per UnitCost Per PoundBeginning Direct Materials (Pounds)Direct Materials PurchasesUnits to be Produced

enter the amount of pounds enter the amount of pounds enter the amount of pounds enter the amount of pounds

select a summarizing line for the second part Direct Labor Cost Per HourTotal Pounds Required for ProductionDesired Ending Direct Materials (Pounds)Cost Per PoundTotal Direct Labor CostDirect Labor Time Per UnitDirect Materials PurchasesTotal Materials RequiredTotal Required Direct Labor HoursBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesUnits to be ProducedDirect Materials Per Unit

enter a total amount of pounds for the second part

enter a total amount of pounds for the second part

enter a total amount of pounds for the second part

enter a total amount of pounds for the second part

select between addition and deduction AddLess: select an item Direct Materials PurchasesDirect Materials Per UnitDirect Labor Time Per UnitDirect Labor Cost Per HourTotal Required Direct Labor HoursTotal Materials RequiredBeginning Direct Materials (Pounds)Total Direct Labor CostTotal Pounds Required for ProductionUnits to be ProducedCost Per PoundTotal Cost of Direct Materials PurchasesDesired Ending Direct Materials (Pounds)

enter the amount of pounds enter the amount of pounds enter the amount of pounds enter the amount of pounds

select a summarizing line for the third part Units to be ProducedDirect Labor Time Per UnitTotal Materials RequiredDirect Labor Cost Per HourDirect Materials PurchasesTotal Direct Labor CostTotal Pounds Required for ProductionTotal Cost of Direct Materials PurchasesCost Per PoundDirect Materials Per UnitBeginning Direct Materials (Pounds)Desired Ending Direct Materials (Pounds)Total Required Direct Labor Hours

enter a total amount of pounds for the third part

enter a total amount of pounds for the third part

enter a total amount of pounds for the third part

enter a total amount of pounds for the third part

select an item Direct Labor Time Per UnitDirect Materials PurchasesDesired Ending Direct Materials (Pounds)Total Direct Labor CostBeginning Direct Materials (Pounds)Total Pounds Required for ProductionTotal Cost of Direct Materials PurchasesUnits to be ProducedTotal Required Direct Labor HoursDirect Materials Per UnitDirect Labor Cost Per HourTotal Materials RequiredCost Per Pound

$enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount

select a closing direct materials budget item Total Materials RequiredDirect Labor Cost Per HourDesired Ending Direct Materials (Pounds)Beginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesTotal Required Direct Labor HoursTotal Pounds Required for ProductionDirect Materials Per UnitTotal Direct Labor CostDirect Materials PurchasesCost Per PoundDirect Labor Time Per UnitUnits 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction Safety Auditing Made Easy A Checklist Approach To OSHA Compliance

Authors: Kathleen Hess

1st Edition

0865876355, 978-0865876354

More Books

Students also viewed these Accounting questions