Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me solve question 3 , and 4 on how to do this on excel. questions regarding e production of a product Xnew. M

Please help me solve question 3, and 4 on how to do this on excel.
image text in transcribed

questions regarding e production of a product Xnew. M onth J anuary Februa March April May June J uly Augu st September October N ov emb er December Labor Hours 4,738 4,953 4,883 5,677 5,505 4,135 5,743 5,084 5,109 3,697 3,875 Mf . OH Costs s s s s s s s s s s s s 399,684 408,965 403,815 457,656 390,263 451,085 363,054 459,855 423,221 412,494 331,453 358,638 QI. Use the high low method to estimate the amount of variable overhead per labor hour. Place your answer in highlighted cell. Q2. Use the high low method to estimate the amount of fixed overhead per month. Place your answer in highlighted cell. Additional data about Xnew is ven below: Sales price per unit of Xnew Direct Labor costs per unit of Xnew Xnew uses 1/2 hour of labor per unit Direct Material costs per unit of Xnew Variable Sales and Administrative costs per unit of Xnew Fixed Sales and Administrative costs traceable to Xnew er month Q3. What is the estimated variable cost per unit of Xn ew? Q4. What is the estimated monthly fixed costs pertaining to Xnew? s s s s s 54.18 148,672.08 210.00 22.50 40.00 50.00 100,000

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

Advanced Accounting

Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith

11th Edition

978-0132568968, 9780132568968

Students also viewed these Finance questions