Assignment10aFacultyLabVersion

# Assignment10aFacultyLabVersion - 200,000 52,500 UNFAV...

This preview shows page 1. Sign up to view the full content.

Pearson Interactive Computer Assignments (PICA) Assignment 10a: Registered User Yang Xu Student Number 307198650 Sept. Actual Sept. Budget Number of chequebooks 14,500 17,500 The entries in the "FAV or UNFAV" column require use of the IF function. Selling price per book \$23.50 \$22.00 Variable costs per book \$8.25 \$9.00 for that variance. Your formula for the "Variances" column in Requirement #1 Total fixed costs for the month \$200,000 \$147,500 should result in positive amounts for both favourable and unfavourable variances. REQUIREMENT #1: Prepare a Level 1 analysis of the September performance. Actual FAV or Static Results Variances UNFAV Budget Chequebooks sold 14,500 3,000 UNFAV 17,500 Revenue \$340,750 \$44,250 UNFAV \$385,000 Variable costs 119,625 37,875 FAV 157,500 Contribution margin 221,125 6,375 UNFAV 227,500 Fixed costs
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 200,000 52,500 UNFAV 147,500 Operating income \$21,125 \$58,875 FAV \$80,000 REQUIREMENT #2: Prepare a Level 2 analysis of the September performance. Your variance entries in the Level 2 analysis should result in positive amounts for favourable variances and negative amounts for unfavourable variances. Actual Flexible Budget Flexible Sales Volume Static Results Variances Budget Variances Budget Chequebooks sold 14,500 0 14,500 (3,000) 17,500 Revenue \$340,750 21,750 \$319,000 (66,000) \$385,000 Variable costs 119,625 10,875 130,500 27,000 157,500 Contribution margin 221,125 32,625 188,500 (39,000) 227,500 Fixed costs 200,000 (52,500) 147,500 0 147,500 Operating income \$21,125 (19,875) \$41,000 (39,000) \$80,000 Your IF statements should result in FAV or UNFAV as is appropriate Help Me Assess Me FAQs...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online