Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,000,000 units. Quarterly sales are 18%, 23%, 23%, and 36%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales for the first quarter of 2017. 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 $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 2018 are 490,000 pounds. Prepare the sales, production, and direct materials budgets by quarters for 2017.

PARGO COMPANY Sales Budget December 31, 2017For the Quarter Ending December 31, 2017For the Year Ending December 31, 2017

Quarter

1

2

3

4

Year

Expected unit sales

Unit selling price

$

$

$

$

Total sales

$

$

$

$

$

PARGO COMPANY Production Budget For the Year Ending December 31, 2017December 31, 2017For the Quarter Ending December 31, 2017

Quarter

1

2

3

4

Year

Desired Ending Direct MaterialsBeginning Direct MaterialsExpected Unit SalesBeginning Finished Goods InventoryRequired Production UnitsTotal Materials RequiredDirect Materials Per UnitDesired Ending Finished Goods InventoryDirect Materials PurchasesTotal Required Units

AddLess: Direct Materials PurchasesBeginning Finished Goods InventoryBeginning Direct MaterialsTotal Required UnitsRequired Production UnitsDesired Ending Finished Goods InventoryExpected Unit SalesDirect Materials Per UnitTotal Materials RequiredDesired Ending Direct Materials

Beginning Direct MaterialsRequired Production UnitsDesired Ending Direct MaterialsTotal Materials RequiredExpected Unit SalesBeginning Finished Goods InventoryDirect Materials Per UnitDirect Materials PurchasesDesired Ending Finished Goods InventoryTotal Required Units

AddLess: Required Production UnitsBeginning Direct MaterialsBeginning Finished Goods InventoryDesired Ending Finished Goods InventoryExpected Unit SalesTotal Required UnitsTotal Materials RequiredDirect Materials Per UnitDesired Ending Direct MaterialsDirect Materials Purchases

Direct Materials PurchasesExpected Unit SalesDirect Materials Per UnitDesired Ending Finished Goods InventoryTotal Materials RequiredTotal Required UnitsBeginning Direct MaterialsDesired Ending Direct MaterialsBeginning Finished Goods InventoryRequired Production Units

PARGO COMPANY Direct Materials Budget For the Year Ending December 31, 2017For the Quarter Ending December 31, 2017December 31, 2017

Quarter
1 2 3 4 Year

Desired Ending Direct MaterialsUnits to be ProducedTotal Required Direct Labor HoursTotal Pounds Required for ProductionDirect Materials Per UnitTotal Cost of Direct Materials PurchasesCost Per PoundDirect Materials PurchasesDirect Labor Cost Per HourTotal Direct Labor CostTotal Materials RequiredDirect Labor Time Per UnitBeginning Direct Materials

Total Cost of Direct Materials PurchasesTotal Direct Labor CostDirect Labor Cost Per HourBeginning Direct MaterialsTotal Materials RequiredTotal Pounds Required for ProductionDirect Labor Time Per UnitDirect Materials PurchasesTotal Required Direct Labor HoursCost Per PoundDirect Materials Per UnitDesired Ending Direct MaterialsUnits to be Produced

Beginning Direct MaterialsDirect Materials PurchasesDirect Materials Per UnitTotal Pounds Required for ProductionCost Per PoundUnits to be ProducedTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredDirect Labor Time Per UnitDirect Labor Cost Per HourDesired Ending Direct MaterialsTotal Required Direct Labor Hours

AddLess: Direct Materials PurchasesUnits to be ProducedTotal Direct Labor CostTotal Materials RequiredCost Per PoundDirect Labor Cost Per HourTotal Pounds Required for ProductionTotal Cost of Direct Materials PurchasesDirect Materials Per UnitDesired Ending Direct MaterialsBeginning Direct MaterialsDirect Labor Time Per UnitTotal Required Direct Labor Hours

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

Employment, Hours, And Earnings 2010 States And Areas

Authors: Sarah E. Baltic

5th Edition

1598884190, 9781598884197

More Books

Students also viewed these Accounting questions

Question

Explain free cash flow and its importance to a business

Answered: 1 week ago

Question

write about your research methods.

Answered: 1 week ago