Prepare budget for ballarat furniture company

Assignment Help Managerial Accounting
Reference no: EM131288

PART 1: Consider the following data in preparing Ballarat Furniture Company's budget for 2013:

Product specification for each table for 2013

 

 

Direct Materials

 

 

     Particle Board (PB)

9 board feet (bf)per table

 

     Red Oak       (RO)

10 board feet (bf) per table

 

 

 

 

Direct Manufacturing Labour

 

 

    Laminating labour

0.25 hours per table

 

    Machining labour

3.75 hours per table

 

 

 

 

Inventory information for 2013

Beginning Inventory

TargetEnding Inventory

PB

20,000 bf

18,000bf

RO

25,000 bf

22,000 bf

 

 

 

Finished goods - tables (units)

5,000

3,000

 

 

 

Sales forecast for 2013

 

 

Sales volume

52,000 tables

 

Sales price

$392 per table

 

 

 

 

Cost information:

2012

2013

PB per board feet

$3.90

$4.00

RO per board feet

$5.80

$6.00

Laminating labour per hour

$24.00

$25.00

Machining labour per hour

$29.00

$30.00

 

 

 

Variable manufacturing overhead costs

 

$1,900,000

Fixed manufacturing overhead costs

 

$1,600,000

Manufacturing overhead application base

 

Expected Direct Labour hours

Inventoriable (manufacturing) cost per table

$275

 

In addition to the above, the following selling and administrative expenses are expected for 2013:

Salaries of Sales personnel

$555,760

Marketing

$1, 920,720

Distribution

$729,600

Customer service

$504,992

Administrative

$440,768

Required:

Prepare an annual budget for Ballarat Furniture Company for 2013. Assume an income tax rate of 40 percent. Include the following schedules:

a. Sales budget

b. Production budget (in units)

c. Direct materials usage budget (in units  and in dollars)

d. Direct labour budget

e. Budgeted income statement.

PART 2

Three readings on Budgeting posted on Moodle.

Critically review the above.  Do you agree, partly agree or disagree with the issues raised in the above? Give your views on the issues that are raised in a, b and c.

Reference no: EM131288

Questions Cloud

Pharmacy designating database : Pharmacy systems today are more efficient and user friendly when compared to the systems 20 years ago.
Calculating and displaying loan in balance sheet : Show the loan in the balance sheet of the company
Show the deatils of an emplyoee - c programming : Show the deatils of an emplyoee in a neat format.
Case studies using excel spreadsheet : Case studies using excel spreadsheet
Prepare budget for ballarat furniture company : Prepare budget for Ballarat Furniture Company
Rc circuits: capacitor is completely discharged : Assume that capacitor is completely discharged when t
Explain the difference in a technical performance measure : good understanding of Mil-Std-499 and Mil-Std-499A
Prepare a project summary : Overview of the project's objectives and scope
Design a bridge : Design a bridge that will withstand 4 fully loaded semi-trailers

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Discuss the ethical issues

Discuss the ethical issues

  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.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Management accounting:-reconcile the absorption costing

Mistry Company manufactures a line of electric garden tools that are sold in general hardware stores.

  Compute the pool rates for the different activities

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

  Prepare a retained earnings statement

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

  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.

  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.

  Prepare Company financial statements

Prepare Company financial statements

  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.

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  What is the profitability of unfocused book

What is the profitability of Unfocused Books' three departments and what recommendations would you make to the owners?

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