Answered step by step
Verified Expert Solution
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
(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
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