Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

whats function should be in J9? Is it not =SUMPRODUCT(F9:I9,$F$5:$I$5)? where did I do wrong? 1 Exp:Fifth Avenue Industries(Make-buy) 2 3 S B1 B2 SO

image text in transcribedimage text in transcribedwhats function should be in J9? Is it not =SUMPRODUCT(F9:I9,$F$5:$I$5)? where did I do wrong?

image text in transcribed

1 Exp:Fifth Avenue Industries(Make-buy) 2 3 S B1 B2 SO PO B10 B20 All silk All poly Blendi Blend2 All silk All poly Blend1 Blend2 4 to make to make to make to make to buy to buy to buy to buy 5 Number of Units 7000 13625 13100 8500 0 0 0 0 6 Selling price $6.70 $3.55 $4.31 $4.81 $6.70 $3.55 $4.31 $4.81 $192,614.75 7 Labor cost $0.75 $0.75 $0.75 $0.75 $31,668.75 8 Material cost 2.5 0.48 0.75 0.81 $40,750.00 9 outsourcing cost 4.25 2 2.5 2.2 $0.00 ??? 10 Profit $3.45 $2.32 $2.81 $3.25 $2.45 $1.55 $1.81 $2.61 $120,196.00 11 Constraints: 12 Yards of silk 0.125 875

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

978-1259307416

Students also viewed these Finance questions