After leaving the Colonel's office, Terry prepared a comparative variable costing income statement for the last...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
After leaving the Colonel's office, Terry prepared a comparative variable costing income statement for the last two quarters. Amboy Specialty Foods Current Last Quarter Quarter Variance F/U 100,000 # of Cases Sold per Case 115,000 per Case Sales Revenue $26.90 $3,093,500 $26.00 $2,600,000 $ 493,500 F $1,800,000 $ (704,700) U Less: Var Cost of Goods Sold Direct Materials-Block Cheese Direct Materials--Oil etc Direct Materials--Packaging Direct Labor $21.78 $2,504,700 $18.00 $0.50 $ 57,500 $0.50 $ 50,000 $ (7,500) U $0.30 S 34,500 $0.30 $ 30,000 $ (4,500) U $1.83 210,450 $1.50 150,000 (60,450) U Variable OH $3.35 385,250 $3.00 300,000 (85,250) U Contribution Margin ($0.86) $ (98,900) $2.70 $ 270,000 $ (368,900) U Selling and Administrative Costs 165,000 150,000 (15,000) U Net Operating Income $ (263,900) $ 120,000 $ (383,900) U Terry also generated a report of input costs for the two quarters. Current Last Quarter Quarter Cost Inputs Direct Materials - Block Cheese Pounds of Cheese per Case 6.6 6.0 Pounds of Block Cheese Purchased & Used 759,000 600,000 Cost per Pound of Block Cheese $3.30 $3.00 Direct Materials - Other Oil, cheese powder, spices & preservatives per Case Packaging per Case $0.50 $0.50 $0.30 $0.30 Direct Labor Hours per Case 0.12 0.10 Direct Labor Rate per Hour $15.25 $15.00 Variable Manufacturing Overhead per Case $3.35 $3.00 Selling and General Administration $165,000 $150,000 Variance Analysis Table Method # of Cases Sales Revenue Direct Materials-Block Cheese 2,600,000 1,800,000 $ 50,000 $ Direct Materials-Oil etc $390,000 (270,000) (7,500) (4,500) (22,500) (45,000) Direct Materials-Packaging 30,000 $ Direct Labor $ 150,000 $ Variable OH $ 300,000 $ 150,000 $ SG & A $ Net Operating Income $ 120,000 1. Complete the Flexible Budget using Standard Costs from the case 2. Find the Volume Variance for Direct Materials (Cheese) and Direct Labor 3. Find the Spending Variance for Direct Materials (Cheese) and Direct Labor 4. Using the Spending Variance, separate into: (a) Price and Quantity Variances for Direct Materials (b) Rate and Efficiency Variances for Direct Labor Direct Materials SP = SQ = AP = AQ= Direct Labor SR= SH= AR = AH = Last Quarter 100,000 $ $ $ $ 690,000 Volume Variance Flexible Budget 115,000 $2,990,000 $ $2,070,000 $57,500 $34,500 $172,500 $345,000 $150,000 Price (SP-AP) X AQ Rate (SR-AR) X AH Spending Variance Actual Results Total Variance 115,000 3,093,500 $ 2,504,700 $ 57,500 $ 34,500 $ 210,450 $ 385,250 $ 493,500 F (704,700) U (7,500) U (4,500) U (60,450) U (85,250) U (15,000) U 165,000 $ $ (263,900) $ (383,900) Usage (SQ-AQ) X SP Efficiency (SH - AH) X SR 103,500 $ ($434,700) $ $0 Ś $0 $ ($37,950) $ ($40,250) $ ($15,000) $ Direct Materials. Spending ($434,700) Direct Labor Spending standard cost card - materials (cheese) amount cost Standard cost card-labor amount cost 6 pounds per case 3 per pound $18.00 per case 0.1 hours per case $15.00 per hour $1.50 per case After leaving the Colonel's office, Terry prepared a comparative variable costing income statement for the last two quarters. Amboy Specialty Foods Current Last Quarter Quarter Variance F/U 100,000 # of Cases Sold per Case 115,000 per Case Sales Revenue $26.90 $3,093,500 $26.00 $2,600,000 $ 493,500 F $1,800,000 $ (704,700) U Less: Var Cost of Goods Sold Direct Materials-Block Cheese Direct Materials--Oil etc Direct Materials--Packaging Direct Labor $21.78 $2,504,700 $18.00 $0.50 $ 57,500 $0.50 $ 50,000 $ (7,500) U $0.30 S 34,500 $0.30 $ 30,000 $ (4,500) U $1.83 210,450 $1.50 150,000 (60,450) U Variable OH $3.35 385,250 $3.00 300,000 (85,250) U Contribution Margin ($0.86) $ (98,900) $2.70 $ 270,000 $ (368,900) U Selling and Administrative Costs 165,000 150,000 (15,000) U Net Operating Income $ (263,900) $ 120,000 $ (383,900) U Terry also generated a report of input costs for the two quarters. Current Last Quarter Quarter Cost Inputs Direct Materials - Block Cheese Pounds of Cheese per Case 6.6 6.0 Pounds of Block Cheese Purchased & Used 759,000 600,000 Cost per Pound of Block Cheese $3.30 $3.00 Direct Materials - Other Oil, cheese powder, spices & preservatives per Case Packaging per Case $0.50 $0.50 $0.30 $0.30 Direct Labor Hours per Case 0.12 0.10 Direct Labor Rate per Hour $15.25 $15.00 Variable Manufacturing Overhead per Case $3.35 $3.00 Selling and General Administration $165,000 $150,000 Variance Analysis Table Method # of Cases Sales Revenue Direct Materials-Block Cheese 2,600,000 1,800,000 $ 50,000 $ Direct Materials-Oil etc $390,000 (270,000) (7,500) (4,500) (22,500) (45,000) Direct Materials-Packaging 30,000 $ Direct Labor $ 150,000 $ Variable OH $ 300,000 $ 150,000 $ SG & A $ Net Operating Income $ 120,000 1. Complete the Flexible Budget using Standard Costs from the case 2. Find the Volume Variance for Direct Materials (Cheese) and Direct Labor 3. Find the Spending Variance for Direct Materials (Cheese) and Direct Labor 4. Using the Spending Variance, separate into: (a) Price and Quantity Variances for Direct Materials (b) Rate and Efficiency Variances for Direct Labor Direct Materials SP = SQ = AP = AQ= Direct Labor SR= SH= AR = AH = Last Quarter 100,000 $ $ $ $ 690,000 Volume Variance Flexible Budget 115,000 $2,990,000 $ $2,070,000 $57,500 $34,500 $172,500 $345,000 $150,000 Price (SP-AP) X AQ Rate (SR-AR) X AH Spending Variance Actual Results Total Variance 115,000 3,093,500 $ 2,504,700 $ 57,500 $ 34,500 $ 210,450 $ 385,250 $ 493,500 F (704,700) U (7,500) U (4,500) U (60,450) U (85,250) U (15,000) U 165,000 $ $ (263,900) $ (383,900) Usage (SQ-AQ) X SP Efficiency (SH - AH) X SR 103,500 $ ($434,700) $ $0 Ś $0 $ ($37,950) $ ($40,250) $ ($15,000) $ Direct Materials. Spending ($434,700) Direct Labor Spending standard cost card - materials (cheese) amount cost Standard cost card-labor amount cost 6 pounds per case 3 per pound $18.00 per case 0.1 hours per case $15.00 per hour $1.50 per case
Expert Answer:
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date:
Students also viewed these accounting questions
-
Diaz Company reports the following variable costing income statement for its single product. This company's sales totaled 50,000 units, but its production was 80.000 units. It had no beginning...
-
Duif Company's absorption costing income statement for the last year of operations is presented below: Sales.........................................................$70,000 Less cost of goods sold:...
-
The Tilots Corporations segmented absorption costing income statement for the last quarter for its three metropolitan stores is given below: Management is very concerned about the Downtown Stores...
-
What does the following code fragment print? String \(s=\) "He11o World"; s. toUpperCase(); s. substring (6, 11); StdOut.println(s);
-
In the investigation of a criminal or civil matter, how does the forensic accountant obtain the necessary information? Discuss the use of all investigative tools, including the subpoena, the grand...
-
Cutler Education Corporation developed a software product to help children under age 12 learn mathematics. The software contains two separate parts: Basic Level (Level I) and Intermediate Level...
-
Briefly explain the difference between accounting, finance, and engineering economics. Try to put the concepts in your own (or your team's) words and compare the concepts where appropriate.
-
Procter Company owns 90% of the outstanding stock of Silex Company. On January 1, 2011, Silex Company sold land to Procter Company for $350,000. Silex had originally purchased the land on June 30,...
-
An financial institution has 2 kinds of assets: 50% in T-bill and 50% in consumer loan. If the assets in the portfolio need to be liquidated at short notice, the T-bill is sold at $97 even though its...
-
The purpose of this individual accounting cycle problem is to review key principles of the Accounting Cycle that we have been learning this semester, while also improving your critical thinking,...
-
advertising its services by the function The total annual revenue R of a certain resort hotel is related to the amount of money x the hotel spends on R(x) = -0.004x +2.1x + 4x + 9,500 (0 x 400)...
-
Why might China be keen to encourage the growth of its green bond market?
-
Let \(\left\{f_{n}(x)ight\}_{n=1}^{\infty}\) and \(\left\{g_{n}(x)ight\}_{n=1}^{\infty}\) be sequences of real valued functions that converge uniformly on \(\mathbb{R}\) to the real functions \(f\)...
-
What are the costs and benefits of having more stringent standards and requirements on use of proceeds and disclosure in order to secure green bond labelling or certification?
-
A particle carries a charge of \(10 \mu \mathrm{C}\). Calculate the electric flux through single face if the charge is placed at the geometric center of (a) an octahedron (b) a dodecahedron.
-
An aluminum tube of length \(8 \mathrm{~m}\) has been uniformly charged with \(10 \mu \mathrm{C}\) of charge. Considering symmetry, estimate the electric field at the geometric center of the tube...
-
Discussion Explain at least two similarities and two differences between predictive and persuasive writing Examine which aspect of legal writing you found most interesting and which one was more...
-
For all of the following words, if you move the first letter to the end of the word, and then spell the result backwards, you will get the original word: banana dresser grammar potato revive uneven...
-
Management accounting should not fit the straitjacket of financial accounting. Explain and give an example.
-
The Penguins play in the North American Ice Hockey League. The Penguins play in the Downtown Arena (owned and managed by the City of Downtown), which has a capacity of 15,000 seats (5,000 lower-tier...
-
Aunt Mollys Old Fashioned Cookies bakes cookies for a chain of retail stores. The companys best-selling cookie is Chocolate Nut Supreme, which is marketed as a gourmet cookie and regularly sells for...
-
Someone says: Our firm focuses on maintaining long-term relationships with our customers. We dont have to do any prospecting. Evaluate this statement.
-
Give some examples of how CRM-enabled sales analytics can provide valuable insights at each of these stages of the customer journey: prospect (lead), initial customer contact, engagement with the...
-
Why do some salespeople not immediately embrace the use of the newest technologies? What are some ways in which a salesperson who is reluctant to adopt new technologies might be influenced to do so?
Study smarter with the SolutionInn App