Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nike produces golf carts. BUDGETED: Budgeted Volume: 1,000 carts Raw Materials Rubber: 2 kg per cart @ $2.40 per kg Metal: 3 sheets per cart

image text in transcribed
Nike produces golf carts. BUDGETED: Budgeted Volume: 1,000 carts Raw Materials Rubber: 2 kg per cart @ \$2.40 per kg Metal: 3 sheets per cart @\$1.50 per sheet Direct Labour 0.10 hours per cart @ $15.00 per hour Overhead $4.00 variable per hour plus $5,000 fixed overhead. ACTUAL: Actual Output: 980 carts Purchases Rubber: 2,500 kg @ \$2.50 per kg Metal: 4,000 sheets @ \$1.40 per sheet REQUIRED: Create an excel spreadsheet that will compute all material, labour and overhead variances (12 in total) when the above numbers are entered. Use cell references rather than numbers in all your formulas. I should be able to change input numbers to get new correct variances. Make sure you test your results (with numbers for which you know the answers). MPV-Rubber (2), MPV Metal (2), MEV-Rubber, MEV-Metal

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 Concepts For A Changing Environment

Authors: Larry E. Rittenberg, Bradley J. Schwieger

5th Edition

0324223102, 978-0324223101

More Books

Students also viewed these Accounting questions