Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use excel and show formulas please A buyer has placed an order with a supplier for 50 pieces of a new item at a per-unit
use excel and show formulas please A buyer has placed an order with a supplier for 50 pieces of a new item at a per-unit price of $180 and has accumulated the following cost data: Material $70 Direct labor $ 40 (5 hours at $8 per hour) Overhead $ 40 (100% of direct labor) Total costs $150 Profit (20%) $ 30 (20% of total costs) Total per unit $180 The buyer now wants to place an order for an additional 350 pieces. Create an EXCEL spreadsheet that can provide answers to the following questions: a. What is the average labor hours for the entire combined order of 400 pieces assuming a 90% learning curve (10 pts) b. Calculate the hours required for the total combined order 400 units (10 pts) c. For the new order of 350 pieces calculate (20 pts) i. The labor hours required to complete this order ii. The total labor cost iii. The per unit labor cost iv. The expected per unit price
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