Excel Assignment # $6$ Performance Measurement Summer Northern Illinois Manufacturing reported the following results from last years operations: Sales $(1,325,000$ units$)$ $ $15,900,000$Variable Expenses: Direct Materials$1,801,800$ Direct Labor$5,450,580$ Manufacturing OH$2,053,750$ S & A$2,112,000$ Total Variable $11,418,130$Contribution Margin $4,481,870$Fixed Expenses Manufacturing OH$757,700$ S & A$1,136,800$ Total Fixed $1,894,500$Net Operating Income $ $2,587,370$ Total operating assets at the end of the year are $$20,700,000.$ The total operating assets at the end of last year was $$19,800,000.$ The company tracks its internal business process performance and reports the following data for this year: Inspection time$0\mathrm{.}6$ daysWait time $($from order to start of production$)14\mathrm{.}5$ daysProcess time$3\mathrm{.}7$ daysMove time$1\mathrm{.}7$ daysQueue time$4\mathrm{.}3$ days Budgeted information for Northern Illinois is based on the following information: Sales Units$1,300,000$Sales Price$$12$ per unitDirect materials$$1\mathrm{.}50$ per unitDirect labor$$3\mathrm{.}60$ per unitVariable OH$$1\mathrm{.}50$ per unitVariable S & A$$1\mathrm{.}60$ per unitFixed OH$$750,000$Fixed S & A$$1,125,000$ The following standard cost card is for the variable manufacturing for one unit of production: Std QuantityStd PriceStd CostDirect materials$2\mathrm{.}00$ lbs$0\mathrm{.}75$ per pound$1\mathrm{.}50$Direct labor$0\mathrm{.}20$ hrs$18\mathrm{.}00$ per hour$3\mathrm{.}60$Variable OH $1\mathrm{.}50$ per unit$1\mathrm{.}50$ During the year, the company purchased and used $2,772,000$ pounds of material. The company worked $302,810$ hours at a rate of $$18$ per hour. The companys 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$ in the text$)2.$ Determine the material price and quantity variances$\mathrm{.}3.$ Determine the direct labor price and quantity variances$\mathrm{.}4.$ Determine the variable overhead spending and efficiency variances$\mathrm{.}5.$ Determine the ROI and RI for last year$\mathrm{.}6.$ Determine last years throughput time, MCE, and delivery cycle time.

Excel Assignment # $6-$ Performance Measurement

Summer

Northern Illinois Manufacturing reported the following results from last year's operations:

$\backslash$table$[[$Sales $(1,325,000$ units$),$$ $15,900,000,],[$Variable Expenses:,,$],[$Direct Materials,$1,801,800,],[$Direct Labor,$5,450,580,],[$Manufacturing OH$,2,053,750,],[$S & A$,2,112,000,],[$Total Variable,,$11,418,130$