Purchase Solution

Sales, production, direct materials, direct labor budgets

Not what you're looking for?

Ask Custom Question

The budget director of Royal Furniture Company requests estimates of sales, production and other operating data from various administrative units every month. Selected information concerning sales and production for July 2006 is summarized as follows: (See attachment)
a) Estimated sales of King and Prince chairs for July by sales territory:
b) Estimated inventories at July 1:
c) Desired inventories at July 31:
d) Direct materials used in production:
e) Anticipated purchase price for direct materials:
f) Direct labor requirements:

Instructions:
1) Prepare a sales budget for July.
2) Prepare a production budget for July.
3) Prepare a direct materials budget for July.
4) Prepare a direct labor cost budget for July.

Purchase this Solution

Solution Summary

Prepare a sales budget, a production budget, a direct materials budget and a direct labor cost budget.

Solution Preview

see attached file

1)
Sales Budget:

King:
Total Northern Domestic Southern Domestic International
Projected Sales (units) 10,400 5,700 3,600 1,100
Unit Price $600 $620 $700
Total projected Sales ($) $6,422,000 $3,420,000 $2,232,000 $770,000

Prince
Total Northern Domestic Southern Domestic International
Projected Sales (units) 12,200 6,900 4,000 1,300
Unit Price $450 $460 $500
Total projected Sales ($) $5,595,000 $3,105,000 $1,840,000 $650,000

Total Projected Sales
(King and Prince) $12,017,000

2) Production Budget:

King Prince
Projected Sales (Units) 10,400 12,200
Projected Ending inventory 700 300
Total projected need 11,100 12,500
Less Beginning inventory 840 280
Projected Production 10,260 12,220

3) Direct material purchase budget:

1) Fabric (in sq yds)
Total King Prince
Projected Production ...

Purchase this Solution


Free BrainMass Quizzes
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.