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

Mechanical Engineering
1.2K views

An ideal diesel engine uses air as the working fluid and operates with a thermal efficiency...

Advance Math
1.2K views

Determine the eigenvalues and eigenfunctions of the following operator (assume ?(x) ? 1): L(u) = u''?2u...

Geometry
1.2K views

Identify and describe concave polygon Analyze the relationship between angle in a triangle and other...

Basic Math
1.2K views

Determine one positive and one negative coterminal angle for the angle given.60 15'Choose the correct...

Statistics
1.2K views

Question 3 3 If F1 1 N x1 1 m F2 2 Newton and x2...

Calculus
1.2K views

ll in the blank with an appropriate word or phrase sample that consists of a...

Accounting
1.2K views

Your boss has asked you to look into optimizing the van ownership strategy...

Accounting
1.2K views

Exercise 5-15 Operating Leverage [LO5-1, LO5-8] Magic Realm, Inc., has developed a new fantasy board...

Accounting
1.2K views

Cary Company manufactures two models of industrial componentsa Standard model and an Advanced Model. It...

Accounting
1.2K views

The LIFO inventory method requires that a. the cost of the first items purchased be...

Accounting
1.2K views

On January 1, Wok 'n' Roll, Inc. issued $50,000 worth of 8%, 20-year bonds for...

Accounting
1.2K views

Which of the following part-time employee is able to participate in employer plans based on...