Prepare an annual budget for ballarat furniture company

Assignment Help Managerial Accounting
Reference no: EM13487023

o Part 1 - Technical

 

o Part 2 - Essay ( 1500 - 1800 word)

 

  • The assessment criteria are on p. 4.
  • Your work must comply with the University's General Guide for the Presentation of Academic Work.https://www.ballarat.edu.au/current-students/publications,-policies-and-forms/general-guide-for-the-presentation-of-academic-work
  • This is a group-assignment. Each group needs to have 2 to 3 members in it. Please organise yourselves into groups.
  • Please make sure that names and ID numbers of all members are stated on the cover sheet of your submission.
  • As this is a group assignment, each member of a group is awarded the same mark. Working in groups has its pros and cons. I am sure that you will hold constructive and energetic group discussions on the issues at hand. In case of any disagreements, you will be able to resolve them in a democratic and rational way. There will be times when you may have to agree to disagree with each other. Invariably different group members bring different skills to a project; it is up to you to make the best of it. I believe one can learn a lot by discussing the issues with one's colleagues.
  • If you happen to find your group members are "not pulling their weight" or there are problems with any member's commitment, then please try to resolve those issues amongst yourselves. Open and honest communication always helps. If you are unable to resolve these issues, you are most welcome to see me and we will try to sort out the problems together. Do this as soon as possible and certainly before the due date. [ Please adapt this to suit your group]

 

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

Target Ending Inventory

PB

20,000 bf

18,000 bf

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:

 

  1. Sales budget
  2. Production budget (in units)
  3. Direct materials usage budget (in units and in dollars)
  4. Direct labour budget
  5. Budgeted income statement.

Reference no: EM13487023

Questions Cloud

How much heat is removed from the outside air by heat pump : To keep a room at a comfortable 16.0?C , a Carnot heat pump does 310J of work and supplies it with 3840J of heat. How much heat is removed from the outside air by the heat pump
Upon entering piaget stage of concrete operations : 1.Upon entering Piaget's stage of concrete operations, children begin to master several concepts dealing with problem solving. Discuss these tasks, why they are important and give an example of explain.
Explain can the phase state be changed : IF the temperature remains constant but the pressure is changed, can the phase state be changed. Why or why not.
How much heat flows into or out of the gas : A cylinder contains 4.0 moles of a monatomic gas at an initial temperature of 27 ?C. The gas is compressed by doing 580J of work on it, How much heat flows into or out of the gas
Prepare an annual budget for ballarat furniture company : This is a group-assignment. Each group needs to have 2 to 3 members in it. Please organise yourselves into groups.
Explain how principles of capital budgeting : Develop a comprehensive analysis using NPV, Payback Method, and IRR to develop a recommendation on replacing the existing equipment with a new computerized version.
Determine the emf of the battery : a 90 ohm resistor has a current of .6A and is connect in series with a 150 ohm resistor. What is the emf of the battery to which the resistors are connected
Explain constitutional isomer of dimethylcyclohexane : Write a line angle formula of each constitutional isomer of dimethylcyclohexane. Write the IUPAC name of each isomer.
Explain the ph of solution of butylammonium chloride : The butylammonium ion, C4H9NH3^(+), has a Ka of 2.3x10^(-11) C4H9NH3^(+) + H2O > H3O^(+) + C4H9NH2 A. Calculate Kb for the conjugate base, C4H9NH2 B. What is the pH of a 0.015M solution of butylammonium chloride

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