Answered step by step
Verified Expert Solution
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 and on how to do this on excel.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started