Prepare the manufacturing overhead cost budget

Assignment Help Managerial Accounting
Reference no: EM13317030

PART 1

Carlton Ltd operates at capacity and makes glass-topped dining tables and wooden chairs which are then typically sold as sets of four chairs with one table. However, some customers purchase replacement or extra chairs and others buy some chairs or a table only, so the sales mix is not exactly 4:1. The company is planning its annual budget for the financial year 2015. The following information has been compiled for the budgetary process:

Input prices

 

Direct materials

 

Wood

$6.40 per board metre

Glass

$12 per sheet

Direct manufacturing labour

$15 per direct manufacturing labour-hour

Input quantities per unit of output

Chairs

Tables

Direct materials

 

 

Wood

1.25 board metres

1.75 board metres

Glass

-

2 sheets

Direct manufacturing labour

4 hours

8 hours

Machine-hours (MH)

3 MH

5MH

Inventory information, direct materials

Wood

Glass

Beginning inventory

27,300 board metres

8,750 sheets

Target ending inventory

29,375 board metres

9,000 sheets

Cost of beginning inventory

$170,352

$109,375

Sales and inventory information, finished goods

Chairs

Tables

Expected sales in units

172,000

45,000

Selling price

$80

$900

Target ending inventory in units

8,500

2,250

Beginning inventory in units

8,000

2,100

Beginning inventory in dollars

$760,000

$477,000

  • Carlton Ltd accounts for direct materials using a FIFO cost flow. It also uses a FIFO cost flow assumption for finished goods inventory.
  • Chairs are manufactured in batches of 500, and tables are manufactured in batches of 50.
  • It takes three hours to set up for a batch of chairs, and two hours to set up for a batch of tables.

The company uses activity-based costing and has classified all overhead costs as shown in the table below:

Cost type

Budgeted variable

Budgeted fixed

Cost driver/allocation base

Manufacturing:

 

 

 

Materials handling

$342,840

$600,000

Number of board metres used

Set-up

97,000

300,740

Set-up hours

Processing

789,250

5,900,000

Machine hours

Non-manufacturing:

 

 

 

Marketing

2,011,200

4,500,000

Sales revenue

Distribution

54,000

380,000

Number of deliveries

Delivery trucks transport units sold in delivery sizes of 500 chairs or 500 tables.

Required:

For the year 2015:

a. Prepare the sales budget.

b. Prepare the production budget in units.

c. Prepare the direct material usage budget and the direct material purchases budget.

d. Prepare the direct manufacturing labour cost budget.

e. Prepare the manufacturing overhead cost budget.

f. Prepare the budgeted unit cost of ending finished goods inventory and ending inventories budget.

g. Prepare the non-manufacturing overhead costs budget.

h. Prepare a budgeted income statement (ignore income taxes).

i. Compare the budgeted unit cost of a chair to its budgeted selling price. Why might the company continue to sell the chairs for only $80?

PART 2

Please access the 6-papers on budgeting posted on your site. 

Required:

Write a critical review essay based on the above papers.

Reference no: EM13317030

Questions Cloud

What shear resistance is to be expected in direct shear test : Samples of a dry sand are to be tasted in a direct shear test and a triaxial test. In the triaxial test, the sample fails when the major and minor principal stresses are 140 psi and 40 psi, respectively.
Describe the use of arrays and subscripts : Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
How many pounds of coal must be burned to keep one bulb : how many pounds of coal must be burned to keep one 100 watt light bulb lit for one hour. Assume efficiency of the power plant is 35%, the transmission losses are 10% fo the delivered poer, and the heating value of coal is 12,000 BTU/lb
Find the angle of incidence : Total internal reflection will occur when the refraction angle is 90' degrees or more. find the angle of incidence at which total interanl refraction in water will occur
Prepare the manufacturing overhead cost budget : Prepare the direct material usage budget and the direct material purchases budget and prepare the direct manufacturing labour cost budget - prepare the manufacturing overhead cost budget.
Seated scribe represents-amarna period in ancient egypt : The Seated Scribe represents: During the Amarna Period in Ancient Egypt: warrior A from Riace represents: The Pont du Gard was built to be used as a (n):
Evaluate the rates of linear and angular deformation : Consider the pressure-driven flow between stationary parallel plates separated by distance 2b. Coordinate y is measured from the channel centerline. The velocity field is given by u=u max(1-(y/b)^2).
Derive the expressions for the concentration exiting a cstr : Derive the expressions for the concentration exiting a CSTR and a PFR for a zero order removal reaction. Which reactor design is more efficient in terms of volume and hydraulic retention times
Calculate the rate of removal and the rate constant : A toxic compound being is removed from solution in a CSTR at Steady State according to a first order reaction rate. The upstream concentration of the pollutant is 14 mg/L and the downstream concentration is 1.7 mg/L.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  How much of total sales revenue is expected to be paid

How much of the total sales revenue is expected to be paid with cash and how many customer transaction does the company expect in January?

  Understanding of cost reallocation

Explain the process of allocation of costs in this organization. Do you agree with the approach? Why or why not?. Identify those situations when common costs are allocated.

  Assumptions behind cost-volume-profit analysis

What are some of the critical assumptions behind Cost-Volume-Profit Analysis and why is CVP typically employed by organizations more often than time value money tools?

  Relevant costs-special sales order

Hull Motors, Inc. (HMI), produces small gasoline-powered motors for use in lawn mowers. The company has been growing steadily over the past five years and is operating at full capacity.

  The necessary jcumal dittoes to correct the errors

The necessary jcumal Dittoes to correct the errors and suspense Account duty balanced

  Discuss the changing role of management

Do you agree with the statement? Discuss the changing role of management accountants with reference to how it impacts on the current business environment.

  Should the brinkers accept this offer right away

Should the Brinkers accept this offer right away? What quantitative factors and what operational, qualitative or strategic factors should Five-speed and Wilbur take into account in making this decision?

  Three planned promotion displays

Home Auto has not yet purchased any of the promotion items for next week. Should management substitute the Armadillo car wax for one of the three planned promotion displays? If so, which one?

  Effects of inventory management on cash coversion and cog

Please discuss the effects of inventory management on cash conversion cycle and cost of goods for the firm.

  Nashville corporation-short term and long term use

Nashville Corporation allocates administrative costs on the basis of staff hours. Short-run monthly usage and long-run monthly usage of the staff hours for Operating Departments 1 and 2 follow.

  Compute total costs-flexible budget

A graph of a flexible budget formula reflects fixed costs of $30,000 and total costs of $90,000 at a volume of 6,000 units. Assuming the relevant range is 1,000 to 12,000 units, the graph would reflect total costs at 10,000 units of what dollar am..

  Evaluate net purchases at retail and net sales

Evaluate net purchases at retail and net sales for the month of September

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd