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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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