Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide a link for the Excel sheet. thank you Company Profit An automobile parts supplier produces four different parts: pistons, brake shoes, crankshaft pulleys,

image text in transcribed
Please provide a link for the Excel sheet. thank you
Company Profit An automobile parts supplier produces four different parts: pistons, brake shoes, crankshaft pulleys, and exhaust valves. The company has determined that the costs per part are as follows: Labor Costs $4, $3, $5, and $9 respectively, Materials $5, $3, $7, and S8 respectively, Maintenance (for machine) $5, $2, $6, and $10 respectively, and Engineering $8, $11, $4, and $13 respectively. The sum of these four costs is the manufacturing cost per part. The company has estimated that the overhead (the cost of insurance, lighting, rent on building, etc.) is equal to 20% of the manufacturing cost. The sum of the manufacturing cost and the overhead cost is the total cost of making the part. The company wants their profit to be equal to 22% of the total cost. The sum of the total cost and the profit is the selling price of the part. Use Microsoft Excel for the following: 1. Develop a spreadsheet which shows the following costs: labor, materials, maintenance, engineering, the manufacturing cost, the overhead, the total cost, and the selling price for each product. 2. Develop a bar graph that shows all of the information on your spreadsheet in an easy to read format. Include labeling as appropriate. 3. If the company makes 150 pistons, 300 brake shoes, 200 crankshaft pulleys, and 130 exhaust valves per day and sells them all that day, what would be their total profit that day? Determine the percent of total profit for each of the four products? Show these calculations on the spreadsheet. 4. Plot a graph (any kind of the percentage of total profit gained from each type of part

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

Personal Finance

Authors: Jeff Madura

3rd Edition

0321357973, 978-0321357977

More Books

Students also viewed these Finance questions

Question

Would giving rewards or administering punishments be

Answered: 1 week ago