Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. provided answers must be in excel formulas format

Provided answers must be in Excel Formulas Format and should go in the yellow and...

50.1K

Verified Solution

Question

Accounting

Provided answers must be in Excel Formulas Format and should go in the yellow and green cells.

image

image

016 Tracey Excel Standard Costs and Variances Name Yousif Al-Qaisieyh 1 2 4 The Tracey Company produces a karate robe. The company has established the following standards for the production of one robe 5 $18.20 3.60 1.20 $6.50 per yard $9.00 per hour $3.00 per hour 7 Direct material cost per robe 8 Direc labor cost per robe 9 Variable overhead cost per robe 10 11 During May, the company had the following actual results: 12 13 Actual number of robes produced 14 15 Direct materials puchased and used 16 Direct labor costs 17 Variable overhead costs 18 19 Required 20 Compute the following variances, indicating whether the variance is Unfavorable (type in U) or Favorable 21 (type in F). Variances should be shown as a positive number so use ABS() in your formulas for column D 22 For example, the formula for cell D31 should be ABS(E26-E27) 23 You may type in U or F in column G 24 2.8 yards @ 0.4hours 0.4 hours @ 2,000 robes $36,000.00 7,600.00 $3,800.00- 6,000 yards @ 760 hours@ 760 hours $6.00 per yard $10.00 per hour $5.00 per hour

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Over the last 50 years the financial reporting systems havedramatically changed and will continue...

Accounting
Q

The vapor pressure of an organic solvent is 50mmHg at 25 C and 200mmHg at 45...

Chemistry
Q

Much like the CO ligands, cyanide (CN-) ligands have IR stretching frequencies that are distinctive and...

Chemistry
Q

Which statement best describes DNA polymerase O It catalyzes addition of new nucleotides to the...

Biology
Q

At the summit of Mt. Everest, the altitude is 8848 m. At this altitude, the...

Biology
Q

Question 2 Points 2 Which of the following is true in the case of uniformly...

Biology
Q

ric Summary 3 points 1 m2CAB 1 m2DAB 1 conclusion reasoning A h 5 14...

Geometry
Q

Find the exact values of the six trigonometric functions for the following angle.30sin 30 =

Basic Math
Q

In Exercises 7 and 8, write a rule for g and then graph each function....

Basic Math
Q

The mathematics department of a college has 8 male professors, 12 female professors, 12 male...

Basic Math
Q

Morrow Enterprises inc. manufactures bathroom fixtures. The stockholders' equity accounts of Morrow Enterpises inc. with...

Accounting
Q

HELP! A company has a 13% WACC and is considering...

Finance