Consider the following information pertaining to Ellawill Company: A) Ellawill Company is in the business of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following information pertaining to Ellawill Company: A) Ellawill Company is in the business of manufacturing and selling surf boards, their only product. B) The surf boards are made entirely out of fibre glass and no other material. C) The company uses the Traditional Costing Method to allocate all manufacturing overhead to the surf boards produced. Direct labour hours has been chosen as the allocation base. You are the lead manager responsible for preparing the Operating Budget(s) portion of the overall Master Budget of the company for 2021. To assist you in the preparation of all necessary budgets a junior accounting employee has gathered of the information that you have requested. The following information has been provided: 1. Desired level of inventory of fibre glass at December 31, 2021 2. Cost of fibre glass expected for 2021 (per contract with supplier) 3. Number of surf boards in inventory on December 31, 2022 4. Quantity of fibre glass required to make each surf board 5. Forecasted number of surf boards to be sold in 2021 6. Direct labour time required to make each surf board 7. Inventory of fibre glass at January 1, 2021 8. Established selling price for one surf board in 2021 9. Desired level of inventory of surf boards at December 31, 2021 10. Hourly wage rate negotiated for 2021 30,000 kilograms $2 per kilogram 10,000 6.5 kilograms 120,000 1.2 hours 19,000 kilograms $ 32 6,000 $ 7.50 per hour Additional Information Provided: The Manufacturing Overhead Budget has already been prepared and compiled by a team of managers responsible for these cost areas. The total budgeted manufacturing overhead cost for 2021 appearing on this budget is $279,600. The following data was provided to enable Selling and Administrative Expenses to be budgeted for 2021. (a) Total sales staff compensation expense is a mixed cost which includes a fixed cost element of $80,000 and a variable cost element of $0.50 per unit sold. (b) Advertising expense for 2021 is budgeted to increase by 10% over total advertising incurred during 2022 (last year) which was $40,000. (c) Office supplies expense is expected to be incurred at a rate of $0.80 per unit sold. (d) Executive salaries expense for 2022 (last year) related to 3 managers, each of whom received salary of $60,000. No raises in these salaries are expected for 2021. However, one of the managers retired at the end of 2022 and her replacement for 2021 will be paid a salary only two-thirds of the salary amount that the other managers will be paid. Required: Your work must be clearly labelled and neatly presented. PART A: Prepare the following for 2021: 1.) Sales Budget 2.) Production Budget 3.) Direct Materials Budget 4.) Direct Labour Budget PART B: Calculate the following for 2021: 1.) Predetermined manufacturing overhead allocation rate for 2021 2.) Budgeted cost to manufacture one surf board for 2021 3.) Budgeted Total Cost of Goods Sold for 2021 PART C: Prepare the following for 2021: 1.) Selling and Administrative Expense Budget Note: It is not necessary to present the variable costs separately from the fixed costs. 2.) Budgeted Income Statement (in good form, ie. proper titles and wording) for 2021. (Ignore income taxes) Consider the following information pertaining to Ellawill Company: A) Ellawill Company is in the business of manufacturing and selling surf boards, their only product. B) The surf boards are made entirely out of fibre glass and no other material. C) The company uses the Traditional Costing Method to allocate all manufacturing overhead to the surf boards produced. Direct labour hours has been chosen as the allocation base. You are the lead manager responsible for preparing the Operating Budget(s) portion of the overall Master Budget of the company for 2021. To assist you in the preparation of all necessary budgets a junior accounting employee has gathered of the information that you have requested. The following information has been provided: 1. Desired level of inventory of fibre glass at December 31, 2021 2. Cost of fibre glass expected for 2021 (per contract with supplier) 3. Number of surf boards in inventory on December 31, 2022 4. Quantity of fibre glass required to make each surf board 5. Forecasted number of surf boards to be sold in 2021 6. Direct labour time required to make each surf board 7. Inventory of fibre glass at January 1, 2021 8. Established selling price for one surf board in 2021 9. Desired level of inventory of surf boards at December 31, 2021 10. Hourly wage rate negotiated for 2021 30,000 kilograms $2 per kilogram 10,000 6.5 kilograms 120,000 1.2 hours 19,000 kilograms $ 32 6,000 $ 7.50 per hour Additional Information Provided: The Manufacturing Overhead Budget has already been prepared and compiled by a team of managers responsible for these cost areas. The total budgeted manufacturing overhead cost for 2021 appearing on this budget is $279,600. The following data was provided to enable Selling and Administrative Expenses to be budgeted for 2021. (a) Total sales staff compensation expense is a mixed cost which includes a fixed cost element of $80,000 and a variable cost element of $0.50 per unit sold. (b) Advertising expense for 2021 is budgeted to increase by 10% over total advertising incurred during 2022 (last year) which was $40,000. (c) Office supplies expense is expected to be incurred at a rate of $0.80 per unit sold. (d) Executive salaries expense for 2022 (last year) related to 3 managers, each of whom received salary of $60,000. No raises in these salaries are expected for 2021. However, one of the managers retired at the end of 2022 and her replacement for 2021 will be paid a salary only two-thirds of the salary amount that the other managers will be paid. Required: Your work must be clearly labelled and neatly presented. PART A: Prepare the following for 2021: 1.) Sales Budget 2.) Production Budget 3.) Direct Materials Budget 4.) Direct Labour Budget PART B: Calculate the following for 2021: 1.) Predetermined manufacturing overhead allocation rate for 2021 2.) Budgeted cost to manufacture one surf board for 2021 3.) Budgeted Total Cost of Goods Sold for 2021 PART C: Prepare the following for 2021: 1.) Selling and Administrative Expense Budget Note: It is not necessary to present the variable costs separately from the fixed costs. 2.) Budgeted Income Statement (in good form, ie. proper titles and wording) for 2021. (Ignore income taxes)
Expert Answer:
Answer rating: 100% (QA)
Answers and Explanation PART A 1 Sales Budget Forecasted number of surf boards to be sold in 2021 120000 Established selling price for one surf board in 2021 32 Total Sales Budget 120000 x 32 3840000 ... View the full answer
Related Book For
Financial and Managerial Accounting the basis for business decisions
ISBN: 978-0078111044
16th edition
Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello
Posted Date:
Students also viewed these accounting questions
-
Consider the following information pertaining to a years operations of Youngstown Manufacturing: Units sold 1,400 Units produced 1,600 Direct labor $4,200 Direct materials used 3,500 Fixed...
-
The company ABC, Inc. is in the business of manufacturing and marketing home appliances. The division that markets its Mixer-Blender has developed three new improved version or prototypes. It is at a...
-
Consider the following information reported by Fonterra Cooperative Group Limited for the year ended May 31, 2007; all figures are in millions of New Zealand dollars ($). Fonterra is the largest...
-
1. Based on a simple, constant context, you will arrive at a stationary state for a unregulated, and then a regulated system. Assume that air resistance and friction for a car increase in the power...
-
Is certification under the ISO standards in this chapter necessary for competing in the modern market? What should companies consider when deciding whether or not to become certified?
-
Energizer is gaining market share against competitor Duracell and its profit is rising despite the sharp rise in the price of zinc, a key battery ingredient. The market for AAA and AA batteries has...
-
For the real battery shown in Figure P23.55, calculate the power dissipated by a resistor \(R\) connected to the battery when (a) \(R=0.25 \Omega\), (b) \(R=0.50 \Omega\), (c) \(R=1.0 \Omega\), (d)...
-
Classify the following as direct materials, direct labor, factory overhead, or selling and administrative expense. a. Steel used in an overhead door plant. b. Cloth used in a shirt factory. c....
-
Harris Fabrics computes its plantwide predetermined overhead rate annually based on direct labor-hours. At the beginning of the year, it estimated 34,000 direct labor-hours would be required for the...
-
A string of length 0.80 m is fixed at both ends. The diagram shows a standing wave formed on the string. P and Q are two particles on the string. 0.8 The variation with time t of the displacement of...
-
It is important for supervisors to actively support their direct support staff for each of the following reasons except: a) staff have very little, if any, prior experience. b) the job responsibility...
-
4. The Daily Planet has printed the pictures of 10 gurgling babies. The publisher has secretly judged their cuteness, ranking the babies first through tenth. A substantial prize will be given to any...
-
What is the runtime complexity (T(N), the number of operations performed) of the following algorithm for an input of size N? i = n - 1; sum = 0; while (i>=0) { } sum = sum + a[i]; 1--;
-
In late-March and April, the prices for hand sanitizer dramatically increased. For example, on Amazon, a 2-ounce bottle of Purell was listed at $40; the pre-COVID price was about $2. Amazon delisted...
-
How do ethical leaders navigate complex ethical dilemmas, considering the interests of multiple stakeholders while upholding principles of integrity and social responsibility?
-
How does a company calculate its net income?
-
The firm has the following information; Sales of $225,750 Cost of goods sold of $75,000 Inventory is $18,560 The operating income (EBIT) is $50,000 The net income is 5,889 The tax rate is 27% There...
-
Time Solutions, Inc. is an employment services firm that places both temporary and permanent workers with a variety of clients. Temporary placements account for 70% of Time Solutions' revenue;...
-
The following table summarizes the facts of five independent cases (labeled a through e) of U.S. companies engaging in credit transactions with foreign corporations while the foreign exchange rate is...
-
What are restructuring charges? How are they presented in financial statements?
-
Johnston, Inc., engaged in the following transactions involving treasury stock: Feb. 10 Purchased for cash 17,000 shares of treasury stock at a price of $25 per share. June 4 Reissued 6,000 shares of...
-
Consider a strictly risk averse agent endowed with initial wealth \(w_{0}\) and with a strictly increasing and twice differentiable utility function. Let \(r_{f}\) and \(\tilde{r}\) denote the return...
-
Consider a quadratic utility function \(u(x)=x-\frac{b}{2} x^{2}\), an initial wealth \(w_{0}=100\), a risk free rate \(r_{f}=1.1\) and a risky asset with expected return...
-
Consider the optimal portfolio choice problem in the presence of \(N\) risky assets with returns \(\left(\tilde{r}_{1}, \ldots, \tilde{r}_{N} ight)\) and of a risk free asset with return \(r_{f}>0\)....
Study smarter with the SolutionInn App