Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer all parts with work. thank you! Budgeted information for Northern Illinois is based on the following information: The following standard cost card is

please answer all parts with work. thank you!
image text in transcribed
image text in transcribed
image text in transcribed
Budgeted information for Northern Illinois is based on the following information: The following standard cost card is for the variable manufacturing for one unit of production: During the year, the company purchased and used 2,772,000 pounds of material. The company worked 302,790 hours at a rate of $18 per hour. The company's minimum return is 10%. This assignment requires several items to be completed using an Excel spreadsheet. Please prepare the items in the order given with the number of the requirement or your Excel spreadsheet. 1. Prepare the flexible budget performance report for last year. (See exhibit 9-6) 2. Determine the material price and quantity variances. Northern Illinois Manufacturing reported the following results from last year's operations: Total operating assets at the end of the year are $20,900,000. The total operating assets at the end of last year was $19,100,000. The company tracks its internal business process performance and reports the following data for this year: The following standard cost card is for the variable manufacturing for one unit of production: During the year, the company purchased and used 2,772,000 pounds of material. The company worked 302,790 hours at a rate of $18 per hour. The company's minimum return is 10%. This assignment requires several items to be completed using an Excel spreadsheet. Please prepare the items in the order given with the number of the requirement or your Excel spreadsheet. 1. Prepare the flexible budget performance report for last year. (See exhibit 9-6) 2. Determine the material price and quantity variances. 3. Determine the direct labor price and quantity variances. 4. Determine the variable overhead spending and efficiency variances. 5. Determine the ROI and RI for last year. 6. Determine last year's throughput time, MCE, and delivery cycle time

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

Accounting For Investments Equities Futures And Options Volume 1

Authors: R. Venkata Subramani

1st Edition

047082431X, 978-0470824313

More Books

Students also viewed these Accounting questions