Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Analysis For Financial Management

Authors: Robert Higgins

7th Edition

0072863641, 9780072863642

More Books

Students also viewed these Finance questions

Question

What are the primary purposes of appraising employees?

Answered: 1 week ago

Question

Explain how SIHRM is linked to different global business strategies

Answered: 1 week ago