Please answer in Excel and provide how you solved the answer.
View the step-by-step solution to:

Question

M3_IND4 Question.PNG

Please answer in Excel and provide how you

solved the answer.

M3_IND4 Question.PNG

Top Answer

View the full answer
s01.jpg

Given that in
profit = Revenue - out sourcecost
- MFq Cast ton
Revenue = 650 x 13. 75 + 500+ 12.50+
450 x 1606 +550 x 18.50
=
$ 32867.5
Now ,
<Production cost of Gear A / Unit
+
teeming time a...

s02.jpg

product cost of Gear c / unit
0. 45 x 9 .50 + 0 31 x 0 . 75 + 0 . 42 x
790 =
$ 10:305 5
product cost of Gear D / unit
0.52 x 9.50 + 0:40 X8 .75 + 0. 30 / 7.90
= $ 10. 968
Dound
Cost
Cont
Make...

s03.jpg

317. 46 2317 Gees
Greas
of each type
Can Debuted
40 0 .
0.40 +0. 37+ 0.42+ 0.32
.= 264. 90 7 265 Genes
considery Complete process of meas
HFg
we see that
total 265 glams can mannyfarful
of cach...

s04.jpg

- 4 32967.5 - $ 21754
todal profit = $ 11213:5
By In ceasing I hows in debuzzing
departiment since it is having
the maze operation time do to
Which outhues . Two department will
fence,
Debuting...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question