Prepare variance analysis based on the provided 2012 budget and the year-end trial balance Prepare variance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare variance analysis based on the provided 2012 budget and the year-end trial balance Prepare variance analysis based on a flexible budget for actual sales volume Prepare analysis of potential product changes using relevant information to see if change should be made Eagle's Nest, Inc. Actual results for 2012 Sales were 9,000 units for 2012 at an average selling price of $ 500 Direct material costs were $1.99 per lb. and the total pounds used were 909,000 Direct labor costs were $ 15.05 per hour and the total number of direct labor hours was 40,050 Variable overhead per unit was at the budgeted level Fixed overhead was at the budgeted amount There were no changes between beginning and ending inventory in units Eagle's Nest, Inc. Budget 2012 Sales 5,000,000 Direct Materials Direct labor 2,000,000 675,000 Payroll taxes (direct labor) Consumable supplies Benefits (direct labor) 101,250 100,000 168,750 Miscellaneous 25,000 Total varlable overhead 395,000 Production supervisor Payroll taxes (supervisor) Benefits (supervisor) Depreciation Utilities 45,000 4,000 5,000 125,000 25,000 Total Fixed overhead 204,000 Gross Profit 1,726,000 Salaries 750,000 100,000 80,000 Payroll taxes (salaries) Benefits (salaries) Computer costs Building maintenance Advertising 15,000 15,000 20,000 Miscellaneous 20,000 Total Selling, general & administrative 1,000,000 726,000 Operating Income (EBIT) 75,000 Interest 651,000 Earning before taxes 260,400 Income taxes 390,600 Net Income Budgeted sales were based on sales of 10,000 units at $500 per unit. Direct materials were based on 100 Ibs of material per unit at $2.00 per Ib. Direct labor was based on 4.5 hours of labor at $ 15.00 per hour per unit. Payroll taxes on direct labor were based on 15% of labor Consumable supplies were based on best estimate (2% of sales) Benefits were based on 25% of direct labor (.5% of sales) Miscellaneous variable expenses were based on best estimate Supervisor's salary was set at $ 45,000 Benefits were estimated for supervisor at $ 5,000 per year Payroll taxes were estimated at $ 4,000 for supervisor Depreciation on building and production equipment was estimated at $ 125,000 per year Utilities were based on previous year adjusted for changes in production volume. Selling, general and administrative expenses Salaries were estimated at $ 750,000 for the year Payroll taxes were estimated at 100,000 for the year Benefits were estimated at $ 80,000 for the year Computer costs were estimated at $15,000 for the year Building maintenance was estimated at $ 15,000 for the year Advertising was budgeted at $20,000 for the year Miscellaneous expenses were estimated at $ 20,000 for the year The direct labor estimate requires 25 direct labor personnel. This is based on 10,000 units times 4.5 hours per unit for a total of 45,000 direct labor hours. The 45,000 are divided by the average of 1800 hours worked per person to arrive at 25 hourly production employees. Prepare variance analysis based on the provided 2012 budget and the year-end trial balance Prepare variance analysis based on a flexible budget for actual sales volume Prepare analysis of potential product changes using relevant information to see if change should be made Eagle's Nest, Inc. Actual results for 2012 Sales were 9,000 units for 2012 at an average selling price of $ 500 Direct material costs were $1.99 per lb. and the total pounds used were 909,000 Direct labor costs were $ 15.05 per hour and the total number of direct labor hours was 40,050 Variable overhead per unit was at the budgeted level Fixed overhead was at the budgeted amount There were no changes between beginning and ending inventory in units Eagle's Nest, Inc. Budget 2012 Sales 5,000,000 Direct Materials Direct labor 2,000,000 675,000 Payroll taxes (direct labor) Consumable supplies Benefits (direct labor) 101,250 100,000 168,750 Miscellaneous 25,000 Total varlable overhead 395,000 Production supervisor Payroll taxes (supervisor) Benefits (supervisor) Depreciation Utilities 45,000 4,000 5,000 125,000 25,000 Total Fixed overhead 204,000 Gross Profit 1,726,000 Salaries 750,000 100,000 80,000 Payroll taxes (salaries) Benefits (salaries) Computer costs Building maintenance Advertising 15,000 15,000 20,000 Miscellaneous 20,000 Total Selling, general & administrative 1,000,000 726,000 Operating Income (EBIT) 75,000 Interest 651,000 Earning before taxes 260,400 Income taxes 390,600 Net Income Budgeted sales were based on sales of 10,000 units at $500 per unit. Direct materials were based on 100 Ibs of material per unit at $2.00 per Ib. Direct labor was based on 4.5 hours of labor at $ 15.00 per hour per unit. Payroll taxes on direct labor were based on 15% of labor Consumable supplies were based on best estimate (2% of sales) Benefits were based on 25% of direct labor (.5% of sales) Miscellaneous variable expenses were based on best estimate Supervisor's salary was set at $ 45,000 Benefits were estimated for supervisor at $ 5,000 per year Payroll taxes were estimated at $ 4,000 for supervisor Depreciation on building and production equipment was estimated at $ 125,000 per year Utilities were based on previous year adjusted for changes in production volume. Selling, general and administrative expenses Salaries were estimated at $ 750,000 for the year Payroll taxes were estimated at 100,000 for the year Benefits were estimated at $ 80,000 for the year Computer costs were estimated at $15,000 for the year Building maintenance was estimated at $ 15,000 for the year Advertising was budgeted at $20,000 for the year Miscellaneous expenses were estimated at $ 20,000 for the year The direct labor estimate requires 25 direct labor personnel. This is based on 10,000 units times 4.5 hours per unit for a total of 45,000 direct labor hours. The 45,000 are divided by the average of 1800 hours worked per person to arrive at 25 hourly production employees.
Expert Answer:
Answer rating: 100% (QA)
Variance Analysis Budgeted Flexible Variance Budgetedflexible Actual Variance Flexible Actual sales 5000000 4500000 500000 4500000 0 Direct Material 2... View the full answer
Related Book For
Retailing Management
ISBN: 978-1259573088
10th edition
Authors: Michael Levy, Barton Weitz, Dhruv Grewal
Posted Date:
Students also viewed these accounting questions
-
An extract of the year end trial balance is shown on the right. A new machine had been acquired for 180,000 on 1st September 2010. Machinery is depreciated at 10% of cost with proportionate...
-
Dell is selling 20,000 units in Europe at an average price of 1,700 per unit. Both the spot and forward exchange rates are $1.20/. The cost of each unit in dollars is $1,500 per unit. The elasticity...
-
Develop a statistical analysis based on the Case Study Scenarios and Speed X Payment Times. Include answers to the following: Case: Election Results. Use 0.10 as the significance level...
-
1. Which type contains a single character enclosed within single quotes? A. Character B. Numeric C. Floating point 2. The modulus operator uses, B. - B. < A. + 3. Every variable should be separated...
-
Suppose that X 1 , . . . , X n form a random sample from a normal distribution for which the mean is known and the variance is unknown. Construct an efficient estimator that is not identically equal...
-
Romi Filters produces two types of water filters. One attaches to the faucet and cleans all water that passes through the faucet; the other is a pitcher-cum-filter that only purifies water meant for...
-
List three examples of money-related opportunity costs you have faced in the last two months. Write a sentence explaining what decision you made for each one and why.
-
Sevilla Consulting offers environmental consulting services worldwide. The managers of branch offices are rewarded for superior performance with bonuses based on the economic value that the office...
-
please solve this question. thanks. QUESTION 3: [10 Marks! Fantasy Land Pty Ltd (FLPL) is a children's toy manufacturer. FLPL has factories across the country and its customer base includes...
-
Coca Cola (KO) price is $61/share. The company is expected to pay dividend of $1.7/share next year. (In reality, dividends are paid quarterly. In this question we will assume for simplicity that all...
-
(a) David Bank has a corporate borrower with $974million term loans. The exposure is guaranteed I by a Corporate Guarantee with AAA rating up to $500million. Assume the risk weight for the corporate...
-
1. It's been a long winter sitting at home during the pandemic. Steve already a successful entrepreneur has some great ideas to expand his existing wholesale grocery business into the retail food...
-
The figure below is meant to model a rectangular coil composed of 100 tightly packed turns of wire. The rectangular loops are all identical with dimensions 30.0 cm x 40.0 cm and a current of 1.20 A...
-
Coronado Company lends Wildhorse Company $9600 on April 1, accepting a four-month, 8% interest note. Coronado Company prepares financial statements on April 30. What adjusting entry should be made...
-
These videos introduce ideas that may or may not coincide with the week's learning objective or theme. Why do you think this video was chosen to be included in this course? Watch the following video:...
-
Consider an investor who is holding one share of a stock whose price is evolving according to a standard Brownian motion process, i.e. = S(u) S(0)+oW(u), u0, where > 0 is the volatility coefficient....
-
Adam Poche has the option to purchase or lease a five-axis horizontal machining center. Any revenues generated from the operation of the machine will be the same whether it is leased or purchased....
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
Calculate the GMROI and inventory turnover given annual sales of $20,000, average inventory (at cost) of $4,000 and a gross margin of 45 percent.
-
Using the same retailer that you chose in the previous question, how well have they integrated their operations across channels? How similar and different are their assortments and prices? Should...
-
Go to the website for the Electronic Privacy Information Center (www.epic.org) and review the issues raised by the organization. What does this watchdog organization feel are the most important...
-
Question: Cruise.com operated a Web site selling cruise vacations. It sent unsolicited e-mail advertisements-dubbed "E-deals"-to prospective customers. Eleven of these "E-deals" went to...
-
Question: Jerry Falwell was a nationally known Baptist minister. You can read about him on falwell.com. You can read about his views on homosexuality at fallwell.com-a site critical of his views....
-
Question: Timothy Vemor bought used (but original) versions of AutoCAD software at garage and office sales. Each time he tried to sell them on eBay, AutoDesk (the company that produced the software)...
Study smarter with the SolutionInn App