Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Diagram #1) Making One Unit (One Backpack) Cost of Material Luxury Backpack Return on Investment Sale Price Labor Overhead Total Cost Cost Per (Rent, S

image text in transcribedimage text in transcribed

(Diagram #1) Making One Unit (One Backpack) Cost of Material Luxury Backpack Return on Investment Sale Price Labor Overhead Total Cost Cost Per (Rent, S Hour (10 hours @ $15) $ 100 $ Electricity, etc) 150 $ 50 $ 400 Net Margin Profit (Gross Revenue (Always %) (Always $) Revenue) (After deducting costs) S 600 $ 200 33% $ 200 Assignment: In your workbook, create a tab, working sequentially towards the right, titled: Lesson 1. Duplicate Diagram 1. But change the costs and sales revenue to create a margin of 15%. Make sure you are using basic math formulas in Excel. Something like these: Costs =SUM(B6:F6), the margin, =H5/G5, etc. Basically, you should not be doing any addition in your head or with a calculator, just use the Excel formulas. If you get stuck, google for a solution, try to contact your pal or your tutor, try to contact me with a text message. :)

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

The Mining Valuation Handbook Mining And Energy Valuation For Investors And Management

Authors: Victor Rudenno

4th Edition

0730377075, 978-0730377078

More Books

Students also viewed these Finance questions

Question

Does it use a maximum of two typefaces or fonts?

Answered: 1 week ago