I have provided the excel sheet that i need filled in. i have provudes the financial information needed to complete the document.

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 Last Quarter Current Quarter 108,000 124.200 Cases Sold Selling Price per Case 26.00 S 26.25 $ Cow Inputs Pounds of Cheese Per Case Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Direct Labor Hours Per Case Direct Labor Rate Per Case Variable Manufacturing Per Case Selling and General Administration 5.95 642.600 3.00 $ 0.10 15.00 $ 3.00 $ 150,000 $ 6.35 813.510 3.30 0.12 15.30 3.36 $ $ 165.000 whe Fa THE Heral tariah - f show w as takara | in lature here we are aari det DRE HILL (Att 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 Last Quarter Current Quarter 108,000 124.200 Cases Sold Selling Price per Case 26.00 S 26.25 $ Cow Inputs Pounds of Cheese Per Case Pounds of Block Cheese Purchased & Used Cost per Pound Block Cheese Direct Labor Hours Per Case Direct Labor Rate Per Case Variable Manufacturing Per Case Selling and General Administration 5.95 642.600 3.00 $ 0.10 15.00 $ 3.00 $ 150,000 $ 6.35 813.510 3.30 0.12 15.30 3.36 $ $ 165.000 whe Fa THE Heral tariah - f show w as takara | in lature here we are aari det DRE HILL (Att