Prepare the direct materials budget in given problem

Assignment Help Accounting Basics

Reference no: EM131904931

Question: 1. Royal Company is preparing budgets for the quarter ending June 30".

Budgeted sales for the next six months are:

Jan 20,000 units

Feb 50,000 units

Mar 30,000 units

Apr 25,000 units

May 15,000 units

June 32,000 units

The selling price is $10 per unit.

2. All sales are on account.

• Royal's collection pattern is:

70% collected in the month of sale,

25% collected in the month following sale, 5% uncollectible.

• In April, the March 31st accounts receivable balance of $30,000 will be collected in full.

3. The management at Royal Company wants ending inventory to be equal to 20%* of the following month's budgeted sales in units.

• On March 31s1. 4,000 units were on hand. Let's prepare the production budget.

* this meets customer service level of 98% order shipment in 2 days

4. At Royal Company, five pounds of material are required per unit of product.

• Management wants materials on hand at the end of each month equal to 10% of the following month's production.

• On March 31, 13,000 pounds of material are on hand. Material cost is $0.40 per pound.

Let's prepare the direct materials budget.

5. Royal pays SO 40 per pound for its materials.

• One-half of a month's purchases is paid for in the month of purchase; the other half is paid in the following month.

• The March 31 accounts payable balance relating to materials is $12,000.

Let's calculate expected cash disbursements.

6. At Royal, each unit of product requires 0.05 hours (3 minutes) of direct labor

• The Company has a "no layoff' policy so all employees will be paid for 40 hours of work each week.

• For purposes of our illustration assume that Royal has a "no layoff" policy, workers are paid at the rate of $10 per hour regardless of the hours worked.

• For the next three months, the direct labor workforce will be paid for a minimum of 1,500 hours per month.

Let's prepare the direct labor budget.

7. At Royal, manufacturing overhead is applied to units of product on the basis of direct labor hours.

• The variable manufacturing overhead rate is $20 per direct labor hour.

• Fixed manufacturing overhead is $50,000 per month, which includes S20.000 of noncash costs (primarily depreciation of plant assets).

Let's prepare the manufacturing overhead budget.

8. At Royal, the selling and administrative expense budget is divided into variable and fixed components.

• The variable selling and administrative expenses are $0.50 per unit sold.

• Fixed selling and administrative expenses are $70,000 per month.

• The fixed selling and administrative expenses include 510,000 in costs - primarily depreciation - that are not cash outflows of the current month.

Let's prepare the company's selling and administrative expense budget.

9. Royal reported the following account balances prior to preparing its budgeted financial statements:

• Land - $50,000

• Common stock - $200.000

• Retained earnings - $86575 (April 1)

• Equipment - 5125.000

Information related to above question is enclosed below:

Attachment:- 81554_1407744_Ch.8ExcelwithHWCanvas.rar

Reference no: EM131904931

Questions Cloud

What would happen if performance evaluations were not used : Do you think performance evaluations for paralegals are beneficial? What would happen if performance evaluations were not used?

Calculate ending inventory and cost of goods sold : During the year, Wright Company sells 470 remote-control airplan Calculate ending inventory and cost of goods sold for the year, assuming the company uses LIFO.

Who should be considered about the devices and why : The three types of cash theft are skimming, cash larceny, and fraudulent disbursements. Skimming and cash larceny involves the theft of cash receipts.

Are administrative rules enforceable : Where is the ICJ located? Can US companies such as Microsoft, or Google bypass American courts and go right to the ICJ if they want?

Prepare the direct materials budget in given problem : At Royal Company, five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 10%.

Discuss about the computer-related forensics procedures : After establishing probable cause, your company, AB Investigative Services (ABIS), has been contacted by a prominent state law enforcement agency.

How the structures facilitates the function of communication : Describe how the structures facilitates the function of Communication, Control, Roles, Authority, and Operating performance on a construction project

What affirmative defenses can johnny raise : Are the elements of embezzlement present in this fact pattern? What affirmative defenses can Johnny raise?

What are the basic objectives of monetary policy : What are the basic objectives of monetary policy? Comment on the cause-effect chain through which monetary policy is made effective.

User Account

All Pages