Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

here is the spreadsheet again Actual Cost of Good Total and Per Case Gris Sale Produced Last Our Per Cre Cuenta Per Cu Pounds or

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
here is the spreadsheet again
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Actual Cost of Good Total and Per Case Gris Sale Produced Last Our Per Cre Cuenta Per Cu Pounds or stock Cleese und Led prada che Tanul Cul Die Law Her Perce Claes Sold Produced Total Director Dieser Care Fuel Inner Latur Cam Tiumaurism Erathariah Murfacu Orrheart welch Amber Special Forch Comparative Operating laceme Student ke Luar Current Carter Sales Pwr Cau Vanille Cofada Per Car Contributie Morin Pwr Cau Selline & General Adminis Icon Sales mir and Pricing Sales Valun Variante Safran Bar Sales Price Varie Sales Prera Tore Sales El Chef Marie Pier & the Paris Block Chere Dist. Material Price Yarance Red Chemie Barlang San Tamil Black Chrom II Mar Ble China Christina Herlewer Thirum Do Re Farm Dany Bu |Hair Mr Karen Alalare MR A Minh Nh I san Bral sal JIMAT Me Aar Variable Me Do Sul - thar Here THAAN Case Questions 1. Create an operating income statement? 2. What is the impact of the increased sales volume and sales price changes on Amboy's operating income comparing the last quarter to the current quarter? 3. What is the impact of direct material price and usage (efficiency) variances comparing the last quarter to the current quarter ? 4. What is the impact of direct labor material rate and efficiency variances comparing the last quarter to the current quarter? 5. Calculate the variable manufacturing overhead spending variance and selling and general administration variances quarter over quarter. 6. Create an operating income reconciliation schedule detailing the differences between Amboy's operating income from the last quarter to the current quarter? Amboy Specialty Foods Cases Sold Last Quarter Current Quarter 108,000 124,200 S 26.00 $ 26.25 Selling Price per Case 5.95 6.55 Cost Inputs Pounds of Cheese Per Case Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Direct Labor Hours Per Case 642,600 3.00 $ 0.10 813,510 3.30 $ 0.12 Direct Labor Rate Per Case $ 15.00 $ 15.30 S 3.00 $ 3.36 Variable Manufacturing Per Case Selling and General Administration $ 150,000 $ 165,000 Actual Cost of Goods Total and Per Case Cases Sold/Produced Last Quarter Per Case Current Quarter Per Case Cheese Cast Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Total Cheese Costs Direct Labor Cost Direct Labor Hours Per Case Cases Sold/Produced Total Direct Labor Hours Direct Labor Rate Per Case Total Direct Labor Costs Variable Manufacturing Overhead Cost Total Variable Manufacturing Overhead Total Cost Direct Labor Rate (Price) & Efficiency Variances Direct Labor Rate Variance Direct Labor Rate Variance Direct Labor Efficiency Variance Direct Labor Efficiency Variance Total Direct Labor Variance Variable Manufacturing Overhead Spending Variance Variable Mfg Spending Variance 0 Amboy Specialty Foods Comparative Operating Income Statement Cases Sold 0 0 0 Last Quarter Current Quarter Difference Sales Per Case Variable Cost of Goods Sold Per Case Contribution Margin Per Case Selling & General Administration Operating Income Sales Volume and Price Variances Sales Volume Varianes Sales Volume Variance Sales Price Variance 0 Sales Price Variance Total Sales Variance Block Cheese (Direct Material) Price & Usage Variances Block Cheese (Direct Material) Price Variance Block Cheese Price Variance Block Cheese (Direct Material) Usage/Efficiency Variance Block Cheese Usage/Efficiency Variance Total Block Cheese Variance Selling & General Adminstration Variance Current Quarter Last Quarter Total Variance Selling & General Administration Amboy Specialty Foods Income Reconciliation Operating Income Last Quarter 0 0 Sales Volume Variance Sales Price Variance 0 Total Sales Variances 0 Manufacturing Variances Direct Material Price (Block Cheese) Direct Material Usage (Block Cheese) 0 0 0 Direct Labor Rate Direct Labor Efficiency 0 Variable Mfg Overhead Spending 0 Total Manufacturing Variances 0 SG&A Variance 0 Total Variances 0 Operating Income Current Quarter 0 Actual Cost of Good Total and Per Case Gris Sale Produced Last Our Per Cre Cuenta Per Cu Pounds or stock Cleese und Led prada che Tanul Cul Die Law Her Perce Claes Sold Produced Total Director Dieser Care Fuel Inner Latur Cam Tiumaurism Erathariah Murfacu Orrheart welch Amber Special Forch Comparative Operating laceme Student ke Luar Current Carter Sales Pwr Cau Vanille Cofada Per Car Contributie Morin Pwr Cau Selline & General Adminis Icon Sales mir and Pricing Sales Valun Variante Safran Bar Sales Price Varie Sales Prera Tore Sales El Chef Marie Pier & the Paris Block Chere Dist. Material Price Yarance Red Chemie Barlang San Tamil Black Chrom II Mar Ble China Christina Herlewer Thirum Do Re Farm Dany Bu |Hair Mr Karen Alalare MR A Minh Nh I san Bral sal JIMAT Me Aar Variable Me Do Sul - thar Here THAAN Case Questions 1. Create an operating income statement? 2. What is the impact of the increased sales volume and sales price changes on Amboy's operating income comparing the last quarter to the current quarter? 3. What is the impact of direct material price and usage (efficiency) variances comparing the last quarter to the current quarter ? 4. What is the impact of direct labor material rate and efficiency variances comparing the last quarter to the current quarter? 5. Calculate the variable manufacturing overhead spending variance and selling and general administration variances quarter over quarter. 6. Create an operating income reconciliation schedule detailing the differences between Amboy's operating income from the last quarter to the current quarter? Amboy Specialty Foods Cases Sold Last Quarter Current Quarter 108,000 124,200 S 26.00 $ 26.25 Selling Price per Case 5.95 6.55 Cost Inputs Pounds of Cheese Per Case Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Direct Labor Hours Per Case 642,600 3.00 $ 0.10 813,510 3.30 $ 0.12 Direct Labor Rate Per Case $ 15.00 $ 15.30 S 3.00 $ 3.36 Variable Manufacturing Per Case Selling and General Administration $ 150,000 $ 165,000 Actual Cost of Goods Total and Per Case Cases Sold/Produced Last Quarter Per Case Current Quarter Per Case Cheese Cast Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Total Cheese Costs Direct Labor Cost Direct Labor Hours Per Case Cases Sold/Produced Total Direct Labor Hours Direct Labor Rate Per Case Total Direct Labor Costs Variable Manufacturing Overhead Cost Total Variable Manufacturing Overhead Total Cost Direct Labor Rate (Price) & Efficiency Variances Direct Labor Rate Variance Direct Labor Rate Variance Direct Labor Efficiency Variance Direct Labor Efficiency Variance Total Direct Labor Variance Variable Manufacturing Overhead Spending Variance Variable Mfg Spending Variance 0 Amboy Specialty Foods Comparative Operating Income Statement Cases Sold 0 0 0 Last Quarter Current Quarter Difference Sales Per Case Variable Cost of Goods Sold Per Case Contribution Margin Per Case Selling & General Administration Operating Income Sales Volume and Price Variances Sales Volume Varianes Sales Volume Variance Sales Price Variance 0 Sales Price Variance Total Sales Variance Block Cheese (Direct Material) Price & Usage Variances Block Cheese (Direct Material) Price Variance Block Cheese Price Variance Block Cheese (Direct Material) Usage/Efficiency Variance Block Cheese Usage/Efficiency Variance Total Block Cheese Variance Selling & General Adminstration Variance Current Quarter Last Quarter Total Variance Selling & General Administration Amboy Specialty Foods Income Reconciliation Operating Income Last Quarter 0 0 Sales Volume Variance Sales Price Variance 0 Total Sales Variances 0 Manufacturing Variances Direct Material Price (Block Cheese) Direct Material Usage (Block Cheese) 0 0 0 Direct Labor Rate Direct Labor Efficiency 0 Variable Mfg Overhead Spending 0 Total Manufacturing Variances 0 SG&A Variance 0 Total Variances 0 Operating Income Current Quarter 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Timothy Louwers, Penelope Bagley, Allen Blay, Jerry Strawser, Jay Thibodeau

8th International Edition

1260570517, 978-1260570519

More Books

Students also viewed these Accounting questions