Complete the selling expense budget

Assignment Help Financial Accounting

Reference no: EM131203020

You are a manager for Peyton Approved, a pet supplies manufacturer. This responsibility requires you to create budgets, make pricing decisions, and analyze the results of operations to determine if changes need to be made to make the company more efficient.

You will be preparing a budget for the quarter July through September 2015. You are provided the following information. The budgeted balance sheet on June 30, 2015, is:

Sales were 20,000 units in June 2015.

Forecasted sales in units are as follows: July, 18,000; August, 22,000; September, 20,000; October, 24,000. The product selling price is $18.00 per unit and its total product cost is $14.35per unit.

2. The June 30 finished goods inventory is 16,800 units.

3.Going forward, company policy calls for a given months ending finished goods inventory to equal 70% of the next month’s expected unit sale.

4. The June 30 raw materials inventory is 4,600units. The budgeted September 30 raw materials inventory is 1,980 units. Raw materials cost $7.75perunit. Each finished unit requires 0.50 units of raw materials. Company policy calls for a given month’s ending raw materials inventory to equal 20% of the next month’s materials requirements.

5. Each finished unit requires 0.50 hours of direct labor at a rate of $16 per hour.

6. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $1.35 per unit produced. Depreciation of $20,000 per month is treated as fixed factory overhead.

7. Monthly general and administrative expenses include $12,000 administrative salaries and 0.9% monthly interest on the long-term note payable.

8. Sales representatives ‘commissions are 12% of sales and are paid in the month of the sales. The sales manager’s monthly salary is $3,750 per month.

Questions

Prepare a Sales Budget

Complete the Sales Budget on the Budgets tab below by using the information found in the budgeted balance sheet above.

Consider assumption 1 when completing this critical element: Sales were 20,000 units in June 2015. Forecasted sales in units are as follows: July, 18,000; August, 22,000; September, 20,000; October, 24,000. The product’s selling price is $18.00 per unit and its total product cost is $14.35 per unit.

Prepare a Production Budget

Complete the Production Budget on the Budgets tab below by using the information found in the budgeted balance sheet above.

Consider assumption 1 while completing this critical element: Sales were 20,000 units in June 2015. Forecasted sales in units are as follows: July, 18,000; August, 22,000; September, 20,000; October, 24,000. The product’s selling price is $18.00 per unit and its total product cost is $14.35 per unit.

Consider assumption 2 while completing this critical element: The June 30 finished goods inventory is 16,800 units.

Consider assumption 3 while completing this critical element: Going forward, company policy calls for a given month’s ending finished goods inventory to equal 70% of the next month’s expected unit sales.

Prepare a Manufacturing Budget

Complete the Manufacturing Budget on the Budgets tab below by using the information found in the budgeted balance sheet above. The manufacturing budget consists of three parts: the Raw Materials Budget, the Direct Labor Budget, and the Factory Overhead Budget.

Raw Material Budget:

Consider assumption 4 while completing this critical element: The June 30 raw materials inventory is 4,600 units. The budgeted September 30 raw materials inventory is 1,980 units. Raw materials cost $7.75 per unit. Each finished unit requires 0.50 units of raw materials. Company policy calls for a given month’s ending raw materials inventory to equal 20% of the next month’s materials requirements.

Consider units to be produced found in the production budget while completing this critical element.

Direct Labor Budget:

Consider assumption 5 while completing this critical element: Each finished unit requires 0.50 hours of direct labor at a rate of $16 per hour.

Consider units to be produced found in the production budget while completing this critical element.

Factory Overhead Budget:

Consider assumption 6 while completing this critical element: Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $1.35 per unit produced. Depreciation of $20,000 per month is treated as fixed factory overhead.

Consider units to be produced found in the production budget while completing this critical element.

Prepare a Selling Budget

Complete the Selling Expense Budget.

Consider assumption 8 while completing this critical element: 8. Sales representatives’ commissions are 12% of sales and are paid in the month of the sales. The sales manager’s monthly salary is $3,750 per month.

General and Administrative Expense Budget

Complete the General and Administrative Expense Budget.

Consider assumption 7 while completing this critical element: 7. Monthly general and administrative expenses include $12,000 administrative salaries and 0.9% monthly interest on the long-term note payable.

The actual quantity of material used was 31,000 with an actual cost of $7.75 per unit. The actual labor hours were 33,000 with an actual rate per hour of $15.

Reference no: EM131203020

Questions Cloud

First-out method is used to cost inventories : If Department H had 528 units, 52% completed, in process at the beginning of the period, 5,251 units were completed during the period, and 582 units were 32% completed at the end of the period, what was the number of equivalent units of production fo..

Why do you think you had never questioned these beliefs : In other words, using the theoretical perspectives as a guide, critically interrogate your own beliefs about sex and gender. Where do they come from? Had you ever thought to challenge your beliefs about sex and gender? If so, what triggered thi..

Determine the initial current through the 100 ? resistor : Referring to Fig. 1.25d, a µF capacitor is charged to 12 V and then connected across a resistor of 100 Ω.

Advise the company of the tax treatment : Advise RIP Pty Ltd when income is derived (i) generally, and (ii) when it derives its income from funeral services and related activities - Does the Arthur Murray principle apply to the company's accounting treatment of amounts in Easy Funeral Plan..

Complete the selling expense budget : Consider assumption 1 when completing this critical element: Sales were 20,000 units in June 2015. Forecasted sales in units are as follows: July, 18,000; August, 22,000; September, 20,000; October, 24,000. The product’s selling price is $18.00 per u..

Find the current in the circuit : Find the total heat produced in the resistors when the current in the inductor decreases from its initial value i0 to 0.

Analyze the development of t2d in the u.s. : Analyze the development of T2D in the U.S., and compare its development to developing countries in general. Using T2D statistics, compare the rates in the U.S. to the rates in your home state.

Annual report to include internal control report : Section 404 of SOX requires a public company's annual report to include an internal control report. What are the two required components of management's report on internal control? What obligation does a public company's independent auditor have rela..

Advise rebecca on given scenario : BUS107 Commercial Law Assignment. Two friends, Rebecca and Michelle, attended a performance called 'An Evening with Oprah' with Oprah Winfrey. A ticketing issue at the box office caused the performance to be delayed by one hour so Rebecca and Mic..

User Account

All Pages