Question: need help with the formulas please AL Function, SUM Formu Multiply. Subtract;Cell Referencing Function: IF, SUM: Formula: Multiply. Subtract: Cell Referencing 2 Student Work Area
AL Function, SUM Formu Multiply. Subtract;Cell Referencing Function: IF, SUM: Formula: Multiply. Subtract: Cell Referencing 2 Student Work Area Required: Provide input into ces shaded in yellow in this template Use mathematical formulas with ces references to the Problem area or work area as indicated Type the cumber-zero in any field in the Make of Boy columns for which there is no cost Prepare an analysis using Excels IF fundion showing the total cost saving, if any, Marton will realize by buying the part 10 3 Using Excel to Assess a Make or Buy Decision 4 PROBLEM Manson Industries makes an assembly part for its finished 6 product A supplier has offered to produce the assembly part 7 Information concerning the assembly part follows Unt cost to make produd Variable $ 500 31 Fired 3.00 Offer by supplier to produce 13 Per unit 600 14 Number of units 10.000 the offer is accepted, Marison will save all variable costs but 12 no fixed costs 1 19 20 Net Income Increase (Decrease) T2 Mike Buy Vanable manufacturing costs 16 Fixed manufacturing costs Purchase price Total Decision to be made 22 34
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
